How to visualize a database growth chart using Excel. Here’s a straight up ‘How To’ write up to get you started. You’ll love this. It’s easy I promise. Notice the following graph. […]
Here’s what I traditionally write up as the backup process for SQL Database Servers. You can use a local drive (as I’m doing in this example F:\SQLBACKUPS), or a universal network backup […]
How to install SQL Server Express 2012, SQL Server Management Studio 2012, and add the 2012 Sample AdventureWorks Databases. Go to the following link to get the software: https://www.microsoft.com/en-us/download/details.aspx?id=29062 Once you have […]
Here’s some SQL logic that will use the database size before and after backup compression and produce a simple report. This logic was originally created at SQLSkills from Erin Stellato. The original […]
Here is some SQL logic that will create an SQL Job Alert formatted with HTML and CSS. What does this script do? It creates a Job called “SQL Job Alerts”. If it […]
Here’s some SQL logic that will take the results of sp_dbmmonitorresults and put into a table. This will cover ALL mirrored databases on the server.
Here’s the sql logic to create the Job SEND SQL JOB ALERTS (beta). As usual in case the code gets butchered by the blog post; I’ll go ahead and include the pdf […]
Here’s some sql logic that will create a Trigger on the SysJobHistory table. The Trigger is designed to execute a Job whenever a *Failure* message has been inserted into the table.
The following logic will configure your SMTP Email notification, Create a Job to send notifications out in an HTML & CSS format, and create a Trigger on the MSDB SysJobHistoryDatabase. Each time […]
Here’s some sql logic to help you get the amount of resources any particular user process is taking. It will give you the following information per process. 1. System Name 2. User […]
Here’s some SQL logic that will show you the SQL Server Version and will list the Patches the servers need if you’re behind on your versioning. Works up to SQL Server 2014. […]
Here’s some quick logic to get you the following information about your database server. 1. Server Name 2. SQL Version (complete) 3. Total Combined Database Size (all databases) 4. Number of Days […]
Here is some SQL logic you can use to create a nicely formatted SQL email alert using SQL Database Mail. It’s formatted properly with HTML, and CSS. It’s imbedded into email and […]
Here’s a process I created to email a fairly nice HTML & CSS formatted email (not using attachments) which displays Job Error, and includes the Step name, and error message. It will […]