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

Extended Events Made Easy: Using XEvent Profiler

In this post we’ll look at how quick and easy it is to use the XEvent Profiler to create an...

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

SQL Saturday #796 – Minnesota, 2018

First, many thanks to the SQL Saturday and MNPass team for putting on another great event and letting me participate.
I...

SQL Server monitoring with built-in features

Do you think you need to use commercial tools like SQL Diagnostic Manager, SQL Sentry, Spotlight etc.. ?  Or do you think...