Posts

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.

Procure SQL Do I need a Backup System Database

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 to all other databases on the instance?  What would happen if I lose the model my company demands for the specific way every new…

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 thought to database integrity, now is the time to sit up and pay attention.  Corruption can occur at any time. …
Procure SQL Demystifying System Databases

Demystifying System Databases

, ,
Recently I have heard a lot of people discussing SQL Server System Databases.  The topic of system databases seems to be a deceptively basic one.  But how many people truly take the time to understand what system databases are and what purpose…

SQL Saturday Houston 2018

, , ,
We are back this year!  Not only are we sponsoring SQL Saturday Houston, we are also speaking!  All three of us are presenting!  Go here to see the full schedule. What is SQL Saturday? SQL Saturday is a free training event for Microsoft…
Procure SQL Validating SQL Server Backups

Validating SQL Server Backups

,
      You have your SQL Server Backup Plan and your Database Recovery Model set.  How do you know if your Backups are good?  TEST!  Validating SQL Server Backups will ensure that you are in a good place when it…

SQL Server Recovery Models

, ,
In my last post (A Beginner's Guide to SQL Server Backups) we discussed the basics of SQL Server Backups.  As Backups are the foundation for Recovery, the next logical discussion should be Recovery Models.  For reference, I have included this…

A Beginner’s Guide to SQL Server Backups

, ,
As was discussed in a previous blog, (The Most Important Role of a SQL Server DBA) Backups and Recovery are the cornerstone of all successful SQL Server DBA careers.  Exactly how much attention is paid to backups until something drastic…

SQL Server 2017: Making Backups Great Again!

In some DBA circles, backups are just as popular as politicians! However, recoverability is the most important task for database administrators.  While SQL Server 2017 added so many great features like graph, SQL on Linux, and more.  Today,…

The Most Important Role of a SQL Server DBA

The most important task a DBA can perform is Recovery. The work of a SQL Server DBA is ever-changing; data is fluid, and accordingly, so is the manner in which data is treated.  Thankfully there are a vast number of ways to keep up with the…