SQL SERVER – Dedicated Access Control for SQL Server Express Edition – An error occurred while obtaining the dedicated administrator connection (DAC) port.

Recently I had faced very interesting situation. Due to some reason we were not able to login into the production server for one of client. The reason for the same was that server was very busy, we had to login into the system and bring server to normal situation. When…
Read More

SQL SERVER – A Simple Quiz – T-SQL Brain Trick

Today we are going to have very simple and interesting question. Run following T-SQL Code in SSMS. There are total of five lines. Three T-SQL statements separated by two horizontal lines. SELECT MAX(OBJECT_ID) FROM sys.objects ______________________________________ SELECT MIN(OBJECT_ID) FROM sys.objects ______________________________________ SELECT COUNT(OBJECT_ID) FROM sys.objects Now when you execute individual…
Read More

SQL SERVER – Next Version of SQL Server ‘Denali’ is Officially Named as SQL Server 2012

Recently I attended SQLPASS 2011 and it had few announcements and some of them really important. I am going to write in detail in future all the announcements. However, there is one announcement needs special attention and blog post. The official name of the next version of the SQL Server.…
Read More