SQL 2008 November CTP

We’ll I’ve finely gotten around to installing the SQL 2008 November CTP.  While walking through the installer I have seen some excellent changes.  Not only is the option to change the paths of the data files no longer hidden, there are more than just two options.  There are at least 7 paths that you get […]

What’s up with the N in front of string values?

If you have looked at pretty much any Microsoft provided T/SQL code you have probably seen an N in front of a string value when setting a variable much like this. SELECT * FROM sys.databases WHERE name = N’master’ What this N does is tell the SQL Server that the data which is being passed […]