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 – Identifying T-SQL Missing Parameter Data Types with SQL Server
A senior developer asked how to catch code from junior developers with wrong or missing parameter data types. SQL Server itself can help you find them.
SQL SERVER – Proof of Concepts with Windows Azure – Notes from the Field #056
Building proof of concepts is harder than it looks. John Sterrett shows how DBAs and developers can build them faster and get more out of Windows Azure.
SQL SERVER – Inside Temp Table Object Creation
How are temp tables created inside tempdb, even when sessions use the same name? My look inside temp table object creation, with a quick metadata check.
SQL SERVER – Maintenance Plan – Maintenance Cleanup Task not Deleting Files
A reader’s Maintenance Cleanup Task reported success but old .bak files were never deleted. The maintenance plan log files helped us find the cause.
SQL SERVER – FIX – The database ‘model’ is marked RESTORING and is in a state that does not allow recovery to be run
After a backup restore mistake, SQL Server would not start and ERRORLOG said the database ‘model’ is marked RESTORING. This is how I got it running again.
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.