We wish to use these pages for publishing various documents, announcements, FAQ etc related to beyondrelational.com...

Random thoughts about SQL Server...

Dedicated Admin Connection (DAC) in SQL Server doesn’t need any introduction now that it is in the product for almost 6-7 years i.e from the days of SQL Server 2005....

Dedicated Admin Connection (DAC) in SQL Server doesn’t need any introduction now that it is in the product for almost 6-7 years i.e from the days of SQL Server 2005. Starting from the early builds of SQL Server 2012, there is an error when connect...

Looking at wait types in SQL Server is a great way to get some insight into how SQL Server is operating under the current load. Although wait types in SQL Server are around from the days of SQL Server 2000 (may be earlier), it h...

Looking at wait types in SQL Server is a great way to get some insight into how SQL Server is operating under the current load. Although wait types in SQL Server are around from the days of SQL Server 2000 (may be earlier), it has improved significantly...

Different ways to get the internal database version for SQL Server...

By this time everyone are aware that the next version of SQL Server i.e DENALI comes with ColumnStore Indexes which is a new concept in SQL Server....

By this time everyone are aware that the next version of SQL Server i.e DENALI comes with ColumnStore Indexes which is a new concept in SQL Server. If you haven’t tried this feature yet then its about time to try it out on CTP3. I am pretty sure y...

Accessing remote data in SQL Server is inevitable sometimes and often people use linked servers for this task. Linked servers are a good option because they are easy to setup and the maintenance is relatively easy but they quick...