When I am teaching a class I always emphasize the importance of SQL Server Books Online. This Help system is, in my opinion, the best in the business. The proof is that even the experts use it on a ...

The Guru's Guide to SQL Server Architecture and Internals helps SQL Server power users manage their complex enterprise systems. This valuable reference manual goes far beyond the product's base ...

Get the lowdown on SP-1's added features, including fully supported database mirroring, bug fixes, and add-ons for SQL Express. What's more, SP1 not only contains bug fixes, but also delivers ...

I want to design a query to compute some returns for stock data and in searching the 'SQL Server Books Online' I find a very small and not so helpful at all help section on the lead and lag functions.

Last time we discussed creating a script that can retrieve configuration settings from a list of SQL Servers and placing that data into a SQL Server table. Now, let's take a look at another technology ...

As a heavy user of other RDBMS data platforms, I have long appreciated the extra effort that Microsoft put into their data management and administration tool, the SQL Server Management Studio (SSMS).