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).
Category: 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
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 was all about view, but I didn’t knew that same limitation exists for functions (aka UDF) as well. Exactly like view, in function also when one function (child function) is calling another function (parent function)
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 cancelled the installation at very beginning of process for some reason and then every single attempt to install it again failed with really weird error. To resolve this problem, we removed registry entries leftover, removed
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 sort of automated backup system which actually takes backup of database to a shared network drive at given time and also we need to retain past X day’s (or 3 day’s) backup copy just in
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 (SQL Agent) and externally (Windows Scheduler) for usual data fetching and feeding. But yesterday, we got notification from our watchdog application (which basically monitors our system/job status) start sending us alert messages that jobs are
Sorting in GridView
Sorting is kind of very useful information if we want to quickly analyze bunch of data based on columns. And being one of most used control to display data in ASP.NET, GridView can implement easily with few more line of codes (who doesn’t love to write more … right ?? )… And in today’s post