SQL Server According to Bob

Two guys who work on SQL Server

Month: February 2020

How It Works: TSQL TRY/CATCH Behavior Fooled Me

If I would have simply read the documentation (https://docs.microsoft.com/en-us/sql/t-sql/language-elements/try-catch-transact-sql?view=sql-server-ver15) the answer to my problem is answered.

Read More

SQL Server BDC Hints and Tips: VDI Seeding for High Availability

A high availability SQL Server BDC uses the Virtual Device Interface (VDI) to seed databases to secondary replicas.

Read More

SQL Server BDC Hints and Tips: Contained AGs, Ports, containedag_msdb, logs, …

This blog post focuses on connecting to the SQL Server BDC, some helpful log files and utility outputs. Understanding a few basics about a SQL Server BDC and the Contained Availability Group (containedag) makes managing and troubleshooting easier.

Read More

SQL Server dbcc clonedatabase – Gotcha

The dbcc clonedatabase is a handy command to clone metadata and information such as query disk store. Then you can use the database for various activities …

Read More