Earlier this weekend I have presented at Bangalore User Group on the subject of SQL Server Tips and Tricks. During the presentation I have asked a question to attendees. It was very interesting to see that I have received various different answer to my question. Here is the same puzzle for you and I would like to see what your answer to this question.
SQL SERVER – A Quick Notes on SQL Azure
I was recently attending a small meeting where I was asked if I can share few things to be considered when designing SQL Azure database. Today I am sharing the same notes over here.
SQL SERVER – Copy Database from Instance to Another Instance – Copy Paste in SQL Server
SQL Server has a feature which copy database from one database to another database and it can be automated as well using SSIS.
SQL SERVER – What is SQL Azure
A very common question which I often receive is What is SQL Azure?
SQL SERVER – Running SSIS Package in Scheduled Job
I previously wrote article SQL SERVER – Import CSV File into Database Table Using SSIS. I was asked following question by reader that how to run the same SSIS package from command prompt. In response to the same I have written article SQL SERVER – Running SSIS Package From Command Line. Within few minutes of the blog post, I received email from another blog reader asking if this can be scheduled in SQL Server Agent Job.
SQL SERVER – Management Studio and Browser in Same Application – SSMS Browser
First of all – I must confess that I was not aware of this feature till I noticed it today. At home, I have multiple monitors, but when I am traveling, I have single laptop along with me. It is often that when I am working with SQL Server I have to refer web for information on the subject I am working on. Let us understand about SSMS Browser in this blog post.
SQL SERVER – Connecting to Server Using Windows Authentication by SQLCMD
Recently I got a call from an old friend I used to call “DJ”. Here is the exact conversation we had about SQLCMD.