Steps to backup to Windows Azure storage with T-SQL: create a credential for your storage account, then back up to a blob, with no extra tools needed.
SQL SERVER – Linked server creation error: OLE DB provider “SQLNCLI11” for linked server returned message “Invalid authorization specification”
Creating a linked server between two local instances failed with OLE DB provider SQLNCLI11 returned Invalid authorization specification. Here is the fix.
SQL SERVER – Three Simple Guidelines for System Maintenance – Notes from the Field #098
Notes from the Field #098: three simple guidelines for system maintenance. Automate what you can, document the rest, and always validate.
SQL SERVER – Security Considerations for Contained Databases
Security considerations for contained databases: how contained authentication works, the initial catalog it needs, and the fallback to server logins.
Putting a Database Under Source Control
Putting a database under source control starts with state or migration scripts, consistent object files, and a reviewable first commit.
Volunteering in the Data Community
Volunteering in the data community can mean welcoming people, reviewing talks, answering questions, or organizing events within a clear time budget.
Hey DBA – Do You Study Mistakes? – Notes from the Field #097
A scare with a chainsaw got Mike Walsh thinking. In Notes from the Field #097, he explains why DBAs should study their mistakes and learn from each one.