Author: Shawn Melton

dbatools and a SQL Agent

The mission: Tell every DBA around the world about a secret formula that will give them powers. What power do you think that is? Freedom! Freedom to go work on projects that you want to do versus constantly putting out…

Read More >

How You Can Use dbatools Module to Make Your Life Easier

The mission: Tell every DBA around the world about a secret formula that will give them powers. What power do you think that is? Freedom! Freedom to go work on projects that you want to do versus constantly putting out…

Read More >

Visual Studio Code and PowerShell

Introduction Visual Studio Code (aka VSCode or just Code) has been around for a few years now. The 1.0 release came out in April of 2016 and from there we have seen feature after feature added with every release. VSCode…

Read More >

Extended Events – Fetching API CURSORS

Forum questions can sometimes cause distractions for me because they pique my interest at times, especially when I see someone say “Extended Event (XE) session is not showing the expensive query”. Extended Events are just… The particular forum question that…

Read More >

How to Build AD Domain on Windows Core Edition

This is a follow up post building an Hyper-V lab to learn SQL Server. Active Directory offers the PowerShell module ActiveDirectory for managing various aspects of the domain. If you are a full-time AD Administrator you may need to learn…

Read More >

Hyper-V Lab for SQL Server

Find out how to build a Hyper-V Lab for SQL Server.

Read More >

PowerShell Editors

Learn what to consider when changing editors, and things to look at when testing a new one.

Read More >

Aim for Exceptional: Reflecting on my Employment at Pythian

Shawn Melton, SQL Server Database Consultant at Pythian, discusses how his employment at Pythian differs from past jobs, and why.

Read More >

SQL Server Fast Food

  An environment where you have a high number of databases on one server, or many, can be time consuming to something as simple as adding a user account. You have the option of using the GUI with SQL Server Management…

Read More >

Pillars of PowerShell: SQL Server – Part 2

Introduction This is the seventh and final post in the series on the Pillars of PowerShell. The previous posts in the series are: Interacting Commanding Debugging Profiling Windows OS SQL Server – Part 1 In this final post I am going to…

Read More >
Page 1 of 212