Recently I stumbled upon really weird issue with VS 2010. We have bunch of database projects created in VS 2010…
Bugs
Error Deploy01234: The target database schema provider could not be determined. Deployment cannot continue.
This was the error that I was getting when i was trying to deploy our database project to one of…
Issue with Backup sets of Backup in SSMS 2012
Just like many fellow early adopters, me too have installed shiny new SQL Server 2012 in my work machine. And…
And I have “4,294,967,295” messages in my inbox !!
I have more then 4 billion messages in my inbox, and without doubt I will be record holder for “the…
Resolving … Agent XPs disabled issue in SQL Server 2005
SQL Server sometimes behaves very strangely for no apparent reason. Few days back I was playing with our staging server…
Intellisense in SQL Server 2008 r2 management studio
This quick post is about my recent experience with SSMS for SQL Server 2008 r2. Usually I use some other…
‘Delete ‘ with Alias in T-SQL
Last week I was working on something where I was required to write a delete query against few records in…