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 ...

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 ...

Just a few days ago Eric Ligman, Microsoft’s director of partner experience, posted a massive list of free e-books from Microsoft on programming everything Redmondish. It’s a potential treasure trove ...

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).

Next up in our series looking at open-source business applications is SQL-Ledger. This software package, written in the Perl scripting language, is a double-entry accounting system aimed at small and ...

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.