A few days ago, I received DM asking What is an AdventureWorks database and why in all the examples I use that instead of any other database (e.g. Pubs or Northwind)? As matter of fact, when I went back to my question list, which I have yet not answered, there were a few more variations of this same question.
SQL SERVER – Enumerations in Relational Database – Best Practice
Marko Parkkola This article has been submitted by Marko Parkkola, Data systems designer at Saarionen Oy, Finland. Marko is excellent developer and always thinking at next level. You can read his earlier comment which created very interesting discussion here: SQL SERVER- IF EXISTS(Select null from table) vs IF EXISTS(Select 1…
Read MoreSQLAuthority News – Microsoft SQL Server Protocol Documentation Download
Download Microsoft SQL Server Protocol Documentation Authored by Microsoft The Microsoft SQL Server protocol documentation provides detailed technical specifications for Microsoft proprietary protocols (including extensions to industry-standard or other published protocols) that are implemented and used in Microsoft SQL Server to interoperate or communicate with Microsoft products. The documentation includes…
Read MoreSQL SERVER – Interview Questions & Answers Needs Your Help
Click here to get free chapters (PDF) in the mailbox About an year ago, I had posted SQL Server related Interview Questions and Answers. It was very well received in community. I have received many comments, suggestions and emails on this subject. I am planning to upgrade the Interview Questions…
Read More
SQL SERVER – Difference Between ROLLBACK IMMEDIATE and WITH NO_WAIT during ALTER DATABASE
We are going to discuss something very simple topic. Difference Between ROLLBACK IMMEDIATE and WITH NO_WAIT during ALTER DATABASE.
SQLAuthority News – SQL Server 2008 R2 Update for Developers Training Kit (March 2010 Update)
Note: Download SQL Server 2008 R2 Update for Developers Training Kit (March 2010 Update) Authored by Microsoft SQL Server 2008 R2 offers an impressive array of capabilities for developers that build upon key innovations introduced in SQL Server 2008. The SQL Server 2008 R2 Update for Developers Training Kit is…
Read MoreSQLAuthority News – SQL Server Modeling CTP – Nov 2009 Release 2 (formerly Oslo)
Note : Download SQL Server Modeling CTP – Nov 2009 Release 2 (formerly Oslo) by Microsoft SQL Server Modeling (formerly code name “Oslo”) is a set of future technologies that provide significant productivity gains across the lifecycle of .NET applications by enabling developers, architects, and IT professionals to work together…
Read More