Recently I stumbled upon really weird issue with VS 2010. We have bunch of database projects created in VS 2010 which are part of our regular development build. As part of my task, I was trying to automate deployment of these database projects using PowerShell and came across really really strange issue that I have
Category: 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 our test system in a batch script. To me it was a bit surprise because I had done same process many times in past and it has worked just fine. But today I spent hefty
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 I have been using it quite a while. Since it is “Powered by Visual Studio” now it has look and feel of VS 2010 too (for me main reason was included support of BIDS …
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 most emailed a person ever” or “person with super giant mail box” or “person who does nothing but keeps getting (and reading) emails” …..and so on ….. Don’t believe me … here is the proof
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 and I had to stop SQL Server service for some testing purposes. When I started it back, I saw that SQL Server Agent was disabled and next to it a message showing that “Agent XPs
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 3rd party tool for SQL Server Development because it is sort of more easier to use when we are developing (but that tool is not good at all when it comes to managing SQL Server).
‘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 table. Now a days I am kind of habituated to use alias for tables whenever I write any query (mostly because of tool I am we are using for SQL development, which don’t have intellisence