This quick post is about my recent experience with SSMS for SQL Server 2008 r2. Usually I use some other…
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…
SQL Server Function … and two hours of my life
Actually this is kind of same issue that I blogged about way back in last year. At that time it…
Solving MsiGetProductInfo failed to retrieve ProductVersion for package with Product Code = ‘{8BDD006D-D5F0-4AAA-BA13-65995063EC44}’. Error code: 1608
Today I got call from one of my friend for help in installing SQL Server 2008 R2. Apparently, he somehow…
Simple Backup Solution for SQL Server Express
So last week I was asked by one of our developers, if I can help them in setting up some…
SQL Agent Error : Unable to start JobManager thread for job XXXX
This week, we had really really strange error in one of our production databases. We had few jobs running internally…
Sorting in GridView
Sorting is kind of very useful information if we want to quickly analyze bunch of data based on columns. And…