fbpx

Design

QUOTED IDENTIFIER Set Incorrectly?!

So What Is Going On? I recently ran into an issue when I set up a job to collect information from an extended event. I wanted to write that to a table in my scratch DBA database. This allowed the customer and I to slice and dice data with ease. This seemed easy enough. I […]

The post QUOTED_IDENTIFIER Set Incorrectly?! appeared first on dbWonderKid.

[...]

Do I Need to Backup System Databases?

Great question!      Before I answer this right off, ask yourself these questions: “Do I want to lose access… [...]

Does Your Database Have any Integrity?

Corruption.  We know it is everywhere.  It is surely a hot-button issue in the news.  If you haven’t given much… [...]

Demystifying System Databases

Recently I have heard a lot of people discussing SQL Server System Databases.  The topic of system databases seems to… [...]

SQL Saturday Houston 2018

We are back this year!  Not only are we sponsoring SQL Saturday Houston, we are also speaking!  All three of… [...]

Validating SQL Server Backups

      You have your SQL Server Backup Plan and your Database Recovery Model set.  How do you know… [...]