SSMS: Batch Separator (Day 35)
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,058 reads
Blog Posts
What’s in a Name?: Inside the Wacky World of T-SQL Identifiers
(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,909 reads
Fix WHERE clause AND/OR/NOT confusion with truth tables
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,029 reads
Guide for Set Up of Telegraf for Monitoring Windows
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,440 reads
Guide for Set Up of Telegraf for Monitoring Windows
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,961 reads
In-Memory OLTP: A Case Study
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
6 reads
In-Memory OLTP: A Case Study
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
9 reads
Power BI Custom Visuals Class (Module 98 – Hierarchy Chart by Akvelon)
In this module you will learn how to use the Hierarchy Chart. The Hierarchy Chart displays hierarchical data in a...
2018-04-17 (first published: 2018-04-12)
2,501 reads
Syspolicy Phantom Health Records
SQL Server comes with a default SQL agent job installed (for most installations) to help manage the collection of system...
2018-04-17 (first published: 2018-04-06)
4,062 reads
Default and Custom Widgets in SQL Server Operations Studio
There are already a number of articles and blog posts that reveal the benefits of the SQL Operations Studio tool. The...
2018-04-16 (first published: 2018-04-04)
2,056 reads
Blogs
Finding Balance: Things Will Come Up
By Steve Jones
I have a presentation on finding balance in your career that got quite a...
Who Are You Doing It For?
By Brian Kelley
But as I've matured over the years, I came to realize that I needed...
Presenting Twice in May 2026
By alevyinroc
I will be presenting my latest session, Documenting Your Work for Worry-Free Vacations, in-person...
Forums
The day-to-day pressures of a DBA team, and how we can work smarter with automation and AI
Comments posted to this topic are about the item The day-to-day pressures of a...
Migrate SSRS Reports to PowerBI Report Server in SQL Server 2025
Comments posted to this topic are about the item Migrate SSRS Reports to PowerBI...
Identities and Sequences III
Comments posted to this topic are about the item Identities and Sequences III
Question of the Day
Identities and Sequences III
When thinking of the Identity property for auto incrementing columns and sequences for the same action, which can be used with the BIGINT data type?
See possible answers