With the official release of Microsoft's latest database offering, let's see what was improved and what still needs some work ...

Now with SQL Server 2008, we are expected to download the samples from the codeplex.com web site. This makes sense to remove the dependency from the product. We don’t have to wait on a new product ...

Building on the DATETIMEFROMPARTS, DATETIME2FROMPARTS offers similar functionality, but yields more precise DateTime2 data type, containing fractions of a second to a specified precision. Naturally, ...

SQL Server has a long list of roles for server, database, and applications that outline things like permissions, data selection and modification, and disk management. Examine how roles play a part in ...