TSQL Basics Part 2: Inner Join – Video Explanation
This is part 2 “inner JOIN” of a 19 part series on TSQL Basics. You will first gain an understanding of the differences between each… Read More »TSQL Basics Part 2: Inner Join – Video Explanation
TSQL
TSQL Basics Part 1: Basic JOIN – Video Explanation
This is part 1 “basic JOIN” of a 19 part series on TSQL Basics. You will first gain an understanding of the differences between each… Read More »TSQL Basics Part 1: Basic JOIN – Video Explanation
Checking job history log size with TSQL
One of the important settings on SQL Server is the job history log size and the maximum rows per job. Without these set accurately you… Read More »Checking job history log size with TSQL
TSQL Query to find the user the SQL services run as
Occasionally I need to look up what user the SQL Server services are running as, and when this happens, you can either run a quick… Read More »TSQL Query to find the user the SQL services run as
TSQL To Start A SQL Agent Job
Most of us are familiar with the quick and easy right clicking on an agent job an select “Start job at Step…”, but what if… Read More »TSQL To Start A SQL Agent Job
TSQL Formatting and Wild Card Expansion
For years I have struggled to find a good way to do TSQL formatting. Here is a short video of how to simple TSQL cleanup… Read More »TSQL Formatting and Wild Card Expansion
TSQL to find Failed Jobs
It can be frustrating to find recently failed jobs in the job history in SQL Server Management Studio. A quicker way to do it is… Read More »TSQL to find Failed Jobs
TSQL JOIN Types Poster
In preparation for my PASS Summit 2018 presentation on Friday, here is an updated version of the SQL Server JOIN Types poster Try our JOIN… Read More »TSQL JOIN Types Poster
Script all Agent Jobs Using SQL Server Management Studio
While doing a recent server move, I came across the need to script all agent jobs and save them to a file so that if we needed to reference what was there after the move we could get at the agent jobs without having to restart the old SQL Server.
It made me realize that sometimes what you want to do is available in SQL Server Management Studio, but that perhaps it is not always entirely obvious.
In the example below, where I have four jobs (imagine if it was 150 jobs), I want to script all of them out and save them for future use.
I could just right click on each one, choose “Script Job As, CREATE To, New Query Window”, which wouldn’t be that bad for 4 jobs, but assume you need to do this for 150 jobs, it could take you a while.
Read More »Script all Agent Jobs Using SQL Server Management Studio
TSQL Script to Display Agent Job History
It can be a bit time consuming to work through the the SQL Server Management Studio (SSMS) user interface to check on the agent job… Read More »TSQL Script to Display Agent Job History