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

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

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

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

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

Database Fundamentals #19: JOINS

The last Database Fundamentals post introduced the SELECT and FROM commands. We’re going to start using JOIN operations shortly, but...

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

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

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