Balmukund Lakhani of Microsoft India GTSC writes a guest post with a fun title and a useful trick: how to hide yourself from SQL Server, in his own words.
SQL SERVER – Find Referenced or Referencing Object in SQL Server using sys.sql_expression_dependencies
Which tables does a procedure use, and which procedures use a table? sys.sql_expression_dependencies answers both, with referenced and referencing objects.
AutoRecover Settings in SSMS: Protect Your Unsaved Queries
The AutoRecover settings in SSMS decide how often unsaved work is copied to disk and how long the copies are kept. This post shows where to find the two options, what they can and cannot protect, how to test them once, and which habit still matters more than any setting.
Copy Column Headers From SSMS Results to Excel
To copy column headers from SSMS results, use Copy with Headers or press Ctrl+Shift+C. This post also shows the Options setting that includes headers every time, why a change can seem to do nothing, and how to stop Excel from dropping leading zeros.
SQL SERVER – Excel Losing Decimal Values When Value Pasted from SSMS ResultSet
I often get questions that how to fix the issue where excel loses decimal values when values are pasted from SSMS Resultset.
SQL SERVER – Powershell – Importing CSV File Into Database – Video
PowerShell expert Laerte Junior shows importing CSV file into database tables with PowerShell, with a video, building on my SQL in Sixty Seconds post.
SQL SERVER – Running SSIS Package in Scheduled Job
How to run an SSIS package on a schedule with a SQL Server Agent job, step by step, after my earlier post on running it from the command line.