T-SQL Tuesday 107 – Viral Demo

For this month’s T-SQL Tuesday. Jeff Mlakar invites to talk about “a project you worked on or were impacted by...

Letting the business bully you: T-SQL Tuesday #107

Before I start anything I want go give a disclaimer. I absolutely believe that the business should be involved in...

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

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