Update here: Script Storage Update Throughout my career, my scripts have been a vital piece of my work. Where I store them has changed over the years. The challenge has been in finding a repository that is reliable, searchable, accessible from where I work, and that looks good with color-coding. Additionally, I don’t want to pay… Read More »
SSMS Boost is an add-on for SQL Server Management Studio. I used it for quite some time but I got tired of using it as freeware. The reason SSMSBoost as freeware didn't work for me was because they require that you continually re-download the new version and re-register every 120 days, otherwise it renders your existing… Read More »
I almost found a bug… but it’s a feature after all. If you are scripting out a Partition Scheme in SSMS, you might notice that your script defaults to the PRIMARY filegroup. For the reason why, go here: http://connect.microsoft.com/SQLServer/feedback/details/641893/management-studio-incorrect-scripting-of-parition-scheme. To fix it, go into SSMS Tools, Options, SQL Server Object Explorer, Scripting, and under the… Read More »
Sometimes, as a DBA, you will have to copy a database role to another instance, such as when you have to move something from development to testing or production. Recently, I discovered that using the SSMS “script as” option doesn’t help very much at all. It simply generates a statement to create the role but… Read More »
This trick is for SSMS users who like the MDI (window) environment. If you’ve noticed that new windows open with the instance connection hidden, then read on. I have your fix! Just open a query window, minimize it, and leave it there. After that, new windows will open at the correct level so you can… Read More »