It’s All in the Name, Index Naming Conventions

Awhile back, if you are on Twitter, you can probably recall my ranting about the 949 indexes I was reviewing....

Regular Expressions (Day 10)

Have you ever downloaded a script from an internet site, only to find that there are extra blank lines between...

SCOM: SQL Instance and Databases exclusion

This  post is by Chris Gibson

I recently wanted to exclude some temporary SQL databases from being discovered by our SCOM...

SQL Homework – January 2017 – Inspect an Execution Plan

It’s a new year and yet education never ends. So this month let’s take a look at an important part...

Summiting that Technical Challenge

The challenge at hand - conquering that technical problem and getting that high associated with the metaphorical high of summiting a tough task.
Related Posts:

Summiting that Technical Challenge Part II...

The cloud is not just someone else’s computer

A year ago, I wrote in a post that cloud computing is just someone else’s data center. I was wrong. Whether...

A Better Way To Script Database Objects

Photo by Andy Beales on Unsplash
Happy New Year! My New Year’s resolution for 2018 is to help you become a...

A Solution for Squirrely SQL Server Security: TSQL Tuesday #98

It’s the first T-SQL Tuesday of the year! Arun Sirpal (b/t) is our host this month. Thanks, Arun! The subject...

DBA’s need resolutions, too!

It’s that time of year again: time to make resolutions, then try to stick to them. Sure, we could start...

How to fix the database consistency and integrity issues using DBCC CHECKDB and Third Party Tool

Overview
The database protection and recovery is a vital role of database administrators. While working on SQL Server, sometimes users get...