No More Mysterious Truncation

If you read the Microsoft White Paper on SQL Server 2019, there’s a gem buried on page 17. It mentions...

Power BI Custom Visuals Class (Module 118 – Stacked Bar Chart by Akvelon)

In this module you will learn how to use the Stacked Bar Chart by Akvelon. This version of the Stacked...

The Project Graveyard

This post is a response to this month's T-SQL Tuesday #107 prompt by Jeff Mlakar.  T-SQL Tuesday is a way for the SQL Server community to share ideas about...

The Project Graveyard

This post is a response to this month's T-SQL Tuesday #107 prompt by Jeff Mlakar.  T-SQL Tuesday is a way for the SQL Server community to share ideas about...

Azure Database Migration Service (DMS)

As I first mentioned in my blog Microsoft database migration tools, the Azure Database Migration Service (DMS) is a PaaS solution that...

Four tools to help implement Database Continuous Delivery

“We don’t want to know that it’s broken, just that it’s working.” “We want our database to always be available.”...

Interviewing for your first tech job – slides

I was lucky to get an opportunity to present a session to some college students at Seminole State College in Florida last week. I was in town for SQL...

Overview of the SQL Update statement

In this article, we’ll walk-through the SQL update statement to modify one or more existing rows in the table.    After reading...

Powershell One Liners: Get current cpu utilization on all your SQL Servers

# Assuming you have list of servers in servers.txt, each server name in its own line
$ComputerNames = get-content servers.txt

# Method 1 - Using the Get-Counter cmdlet#...

Powershell One Liners: Get status of SQL Instances on All SQL Servers

# Assuming you have list of servers in servers.txt, each sever name in its own line
$ComputerNames=get-content servers.txt
Get-WmiObject -Query "select * from win32_service where...