Blog Posts

This script is from my library and I use it to review what is going on with my transactional replications,...

2018-04-18

433 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,096 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,927 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,032 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,462 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,013 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

7 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

14 reads