Blog Posts

This script is from my library and I use it to review what is going on with my transactional replications, try to remove statements that didn't get purged for...

2018-04-18

26 reads

SSMS: Batch Separator (Day 35)

by Wayne Sheffield

A Discussion of SQL Server-Related Topics

SSMS (and other SQL Server utilities) utilize a batch separator to, well, separate batches of T-SQL statements. Before we go...

2018-04-18

2,039 reads

What’s in a Name?: Inside the Wacky World of T-SQL Identifiers

by Solomon Rutzky

SQL Quantum Leap

(last updated: 2018-04-28)
Today we are going to take a look into an area that you probably are thinking has very...

2018-04-18 (first published: 2018-04-09)

2,908 reads

Fix WHERE clause AND/OR/NOT confusion with truth tables

by Jen McCown

SQL Awesomesauce

The ANDs, ORs, and NOTs in a T-SQL query's WHERE clause can get confusing, especially if you're thinking of it...

2018-04-17

2,028 reads

Guide for Set Up of Telegraf for Monitoring Windows

by Tracy Boggiano

Database Superhero’s Blog

Problem
As good DBAs, we sometimes have the need to monitor stats or just want to be nice to our system...

2018-04-17

2,431 reads

Guide for Set Up of Telegraf for Monitoring Windows

by Tracy Boggiano

Database Superhero’s Blog

Problem
As good DBAs, we sometimes have the need to monitor stats or just want to be nice to our system...

2018-04-17

1,914 reads

In-Memory OLTP: A Case Study

by Bert Wagner

Bert Wagner

Watch this week's video on YouTube
When In-Memory OLTP was first released in SQL Server 2014, I was excited to start using it. All I could think was "my queries...

2018-04-17

8 reads

In-Memory OLTP: A Case Study

by Bert Wagner

Bert Wagner

Watch this week's video on YouTube
When In-Memory OLTP was first released in SQL Server 2014, I was excited to start using it. All I could think was "my queries...

2018-04-17

5 reads