So a little SQL Server Management Studio tip/trick for today (inspired by a user question… Thanks Brandon!!) When you right click on a table you’re given the options to Select Top 1000 rows or Edit Top 200 rows as shown below: If you choose to SELECT, SQL Server Management Studio will build your SELECT statement [...]
Posts Tagged ‘SSMS’
Fail Whale for SSMS and CMS for PBM using PS
Translation: Fail Whale for SQL Server Management Studio and Central Management Server for Policy Based Managment using PowerShell…. lol simple eh? So this is a Microsoft Connect Item in the making… I had created a PowerShell script to run a bunch of policies against a list of servers that I defined in a ServerList.txt file. [...]
Sound Notification When Query Finishes Executing
So on twitter this morning a question was asked about attaching a sound file to SQL Server Management Studio to play a sound when a query completes. So I decided to poke around the managment studio a bit and under Tools -> Options if you select Query Results there is a checkbox for playing the [...]
