A quick script for point in time recovery: set up and back up a database, restore it to a point in time, then clean up. Three simple steps.
SQL SERVER – Mastering the Basics – Igniting Learning – A Unique Learning Experience
I had very clear idea what my goals were in the book. I believed in unique learning experience. Let us talk about it in today’s blog.
SQL SERVER – A Quick Trick about SQL Server 2012 CONCAT Function – PRINT
A quick trick with the SQL Server 2012 CONCAT function: three SQL experts suggested within minutes that it works with the PRINT statement too.
SQL SERVER – A Quick Trick about SQL Server CONCAT function
A quick trick from a Virtual Tech Days demo: adding a string to GETDATE() throws an error. CAST fixes it, and SQL Server 2012 CONCAT does it more simply.
Watermarks for Incremental Extracts
Watermarks for incremental extracts need clear boundaries, durable checkpoints, and a plan for late updates, deletes, and missed rows.
SQL SERVER – AdventureWorks for SQL Server 2012 RC0 – Samples Database for SQL Server 2012 RC0
Microsoft released AdventureWorks for SQL Server 2012 RC0. Here is the download link, plus why this sample database belongs on a development box only.
Msg 3201: Cannot Open Backup Device, Operating System Error 3 in SQL Server
Msg 3201 with operating system error 3 means SQL Server cannot find the folder in your backup path. The tests here trigger errors 3, 5 and 67 on SQL Server 2025, show how to check the folder from the server side, and explain why a folder created on the SSMS computer does not help.