Often you have a list of values that you need to put into a query, but you only need certain columns of the data. I used to have to edit the data to get it in the format I needed, but now I can easily copy out the values I need using a single ALT key.
Continue reading Vertical Text Selection in SSMSTag: ssms
Display row numbers in SSMS
How do you show row numbers in SQL Server Managment Studio? Read on and find out.
Continue reading Display row numbers in SSMSSSMS: Saving changes is not permitted error
I was trying to change the datatype of a field in one of my tables using SSMS, and I received the Saving changes is not permitted error. Read below to see how I was able to make the change.
Continue reading SSMS: Saving changes is not permitted errorSSMS Red Squiggly Line
Often when you are working in SQL Server Management Studio (SSMS), tables, views, and other objects will get highlighted with a red squiggly line like SSMS does not know if the object exists or not in the database.
Extract code from your databases
Quick, you need to get all of the code for all of your stored procedures in your database! All you need to do is go to your source control system and get them right? What do you mean you do not have them, well here is how to extract them from the database so you can create a source control baseline.
Restoring your Sql Server Database
In a previous posting, we backed up your WideWorldImporters database and created a job to run transaction log backups so we can recover with no more than 30 minutes of data loss. Continue reading Restoring your Sql Server Database
Jim Salasek's SQL Server Blog 