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.
SQL SERVER – FIX – ERROR : Msg 3201, Level 16 Cannot open backup device.Operating system error 3 (The system cannot find the path specified.)
Got Msg 3201, Cannot open backup device, with operating system error 3? The folder in the backup path is missing. Create it and run the backup again.
SQL SERVER – 2012 Auditing Enhancement – On Audit Log Failure Options – Maximum Rollover Files
SQL Server 2012 adds two auditing enhancements: new options on audit log failure, like fail operation or continue, and a maximum rollover files setting.