A reader’s JSON output looked cut off compared to my blog post. Here is how to increase characters displayed in text results using Query Options in SSMS.
Recovering Unsaved Query Windows After SSMS Closes Unexpectedly
A restart ate your script, but maybe not all of it. Two places to look: SSMS recovery files and the text SQL Server remembers.
SQL SERVER – Finding Tables Created Last Week – DBA Tip
A security team wanted a report of tables created last week on production. Here is the simple query I sent my DBA friend instead of building an audit.
SQL SERVER – Filter In-Memory OLTP Tables in SSMS
Need to spot In-Memory OLTP tables among thousands of tables? I show a simple T-SQL query and the SSMS options that list only those tables.
Exporting and Sharing Registered Server Groups in SSMS
One shared server list can save you from running a query on the wrong server. Here is how to build it, export it without passwords and use it.
SQL SERVER – Customization of New Query in SQL Server Management Studio
A junior DBA was fired for dropping a table on production. Here is how to customize the New Query window in SSMS so it opens with the commands you need.
SQL SERVER – SSMS Trick – Generating CSV file using Management Studio
Readers asked why use SQLCMD or BCP at all. Generating CSV file output is easy in SSMS: set Results to Text as comma delimited in Tools, Options.