SQL Server Configurations – Back to Basics

One thing that SQL Server does very well is come pre-configured in a lot of ways. These pre-configured settings would be called defaults. Having default settings is not a...

T-SQL for Performance and Accuracy – Vern Rabe: A preconference essential for anyone using SQL Server

SQL Saturday Preconference: February 9th, 2018 in Redmond, WA Do you think you write T-SQL queries that perform well?  Think...

T-SQL Tuesday #98 Round Up

Thank you to everyone that took the time to write and contribute, I enjoyed reading about how you conquered your...

Comparing two SQL instances

Last week I was working on a couple of SQL instances that contained databases which were part of an Always...

Dynamics AX Event Session

Many moons ago, I wrote about how to enable the context info for Dynamics AX. Having the context info enabled...

Fixing logins

I ran into an issue recently where I couldn’t get a Windows login to work with some application software. This...

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...