Notes from the Field #034: Tim Mitchell explains SSIS component error outputs, how to use them in practice, and the caveats to watch for.
Natively Compiled Procedures: ATOMIC Blocks and T-SQL Limits
Native procedures check every statement when you create them. Build a tiny one and see which habits it will not accept.
SQL SERVER – Backup to Azure Blob using SQL Server 2014 Management Studio
SQL Server 2014 Management Studio has a new URL option on the backup screen. Here is how to use backup to URL to take a database backup to Azure Blob storage.
Finding Rows That Differ Between Two Tables With EXCEPT
Use EXCEPT to find differing rows in both directions, compare selected columns, handle NULLs, and distinguish changed keys from additions.
Unicode Lost: Finding Question Marks Left by varchar Conversion
Customer names turn into question marks, and an nvarchar column does not bring them back. Here is how it happens and how to repair it.
MySQL – Dynamic SQL with EXECUTE and PREPARE Statements
MySQL supports dynamic SQL with EXECUTE and PREPARE statements. Here is how to pass a table name as a parameter and return all rows from it.
SQL SERVER – Keeping MSDB System Database Lean and Fit – Notes from the Field #033
The MSDB database is one of the most ignored on any server. Tim shares his tricks to keep the MSDB system database lean, fit and at its best settings.
Change Fill Factor in SQL Server: SQL in Sixty Seconds #069
To change fill factor for an index, rebuild it with a new FILLFACTOR value. The tests here measure what 100, 80 and 50 do to page count, scan reads and page splits, and when a lower value is not worth the space.
Finding Databases That Have Never Been Backed Up
Your backup job is green, but is every database in it? Here is a read-only way to find the ones missing from msdb history.










