I want some Moore

Blog about stuff and things and stuff. Mostly about SQL server and .Net
posts - 218, comments - 2281, trackbacks - 33

My Links

Advertisement

News

Hi! My name is 
Mladen Prajdić  I'm from Slovenia and I'm currently working as a .Net (C#) and SQL Server developer.

I also speak at local user group meetings and conferences like SQLBits and NT Conference
Welcome to my blog.
SQL Server MVP

My Books

SQL Server MVP Deep Dives 2
The Red Gate Guide to SQL Server Team based Development Free e-book

My Blog Feed via Email
Follow MladenPrajdic on Twitter


Users Online: who's online

Article Categories

Archives

Post Categories

Cool software

Other Blogs

Other stuff

SQL stuff

April 2007 Blog Posts

S-Q-L or Sequel? A bit of trivia for the weekend...

This has been a debate for as long as i've known. How to pronounce SQL?  ess-cue-el or sequel? Each one has it's own supporters. But only one is correct. And the winner is (drum-roll here):   S-Q-L (ess-cue-el)   And how can i be so sure about that? It's ANSI declared.   Read more about SQL Pronounciation history here.   P.S. Most people don't care. That's why it's trivia. :))

posted @ Saturday, April 28, 2007 3:15 PM | Feedback (11) | Filed Under [ SQL Server ]

"Global variables" in SQL Server

There's no such thing as a global variable in SQL Server. So i had to do it differently.

More here

posted @ Monday, April 23, 2007 10:20 PM | Feedback (27) | Filed Under [ SQL Server ]

SQL Server: How to audit rollback-ed data in a trigger?

The most popular method of auditing data is with an AFTER DELETE, INSERT, UPDATE trigger. But what happens if you have a Rollback statement in your trigger if some condition is met?

More here

posted @ Friday, April 13, 2007 5:58 PM | Feedback (0) | Filed Under [ SQL Server ]

How to Override Non-Virtual Base Members in C#

This is something i assumed was common knowledge, but apparently it isn't. If you want to have a method in your derived class with the same name as the one in the base class and the base class one isn't marked as virtual you can use the NEW keyword. This is also the default behaviour and the compiler treats the child class method as new, however you get a warning for this.   Some code to illustrate this:   public class BaseClass { public BaseClass() { } public void IAmANonVirtualMethod() { Console.WriteLine("IAmANonVirtualMethod...

posted @ Monday, April 09, 2007 7:08 PM | Feedback (14) | Filed Under [ .Net ]

Multiple Active Result Sets

I've written an article about Multiple Active Result Sets (MARS) and it's published on SQLTeam.com Multiple Active Result Sets is a new SQL Server 2005 feature that, putting it simply, allows the user to run more than one SQL batch on an open connection at the same time. More here.

posted @ Tuesday, April 03, 2007 3:10 PM | Feedback (7) | Filed Under [ .Net SQL Server ]

Powered by:
Powered By Subtext Powered By ASP.NET