Posting SQL Server notifications to Slack
Learn how you can post notifications from SQL Server directly to a Slack channel.
2018-10-23
1,481 reads
SQL Server Agent
Installing SQL Server Agent on SUSE Linux
Manvendra Singh explains how to install SQL Server Agent on SUSE Linux server, so that you can create SQL Server Jobs to schedule repetitive work.
2017-08-23
3,181 reads
How to Decipher sysschedules
Take the mystery out of sysschedules and interpret the data into a plain text format.
2017-06-22
7,705 reads
Installing SQL Server Agent on Ubuntu Server
Manvendra Singh explains how to install SQL Server Agent on an Ubuntu server, so that you can create SQL Server Agent Jobs to schedule repetitive tasks.
2017-05-19
2,721 reads
Execute a data-driven SSRS subscription from SSIS to archive a report
This article demonstrates how to generate and save an SSRS report to a network folder when an SSIS package is executed.
2016-06-30
3,925 reads
SQL server Agent - Status
As part of the application to monitor SQL health I created.
The procedure returns status of the SQL server Agent
2016-04-29 (first published: 2016-04-16)
596 reads
Add empty first step for every job
This script adds empty first step for every job for easier job history viewing.
2015-12-28 (first published: 2015-12-10)
1,698 reads
Monitoring Longest Running Transaction using SQL Server Agent Alerts
Step by Step guide to setup SQL Server Agent Alert for the proactive monitoring of Monitoring of Longest Running Transactions.
2014-09-25
15,862 reads
Automating SQL Server Agent Notification
This article looks at some automated approaches of monitoring SQL Server agent jobs.
2014-08-13
9,647 reads
Setting Up Your SQL Server Agent Correctly
It is important to set up SQL Server Agent Security on the principles of 'executing with minimum privileges’, and ensure that errors are properly logged and alerts are set up for a comprehensive range of errors. SQL Server Agent allows fine-grained control of every job step that should allow tasks to be run entirely safely even if they occasionally need special privileges.
2014-06-13
3,563 reads
Blogs
Creating a user for a STONITH resource in vSphere
I previously blogged about how to create a STONITH resource for a pacemaker cluster...
Default event_file path for Extended Events
By Zikato
Foreword Have you ever wondered where the .xel file is saved when you create a...
Query Store Hints in SQL Server 2022
Another neat little feature in SQL Server 2022 is Query Store Hints. This is...
Forums
Display Top N values of a table with calculation next to it
Hi, In Power BI Report Builder I need to use SSRS code for my...
Package runs in Debug mode but fails otherwise
Hi We have a SSIS package that uploads data to Blob storage. The package...
Can anyone suggest a plan with backup full and backup log without backup diff ?
I need only one backup full at mid night, and one backup log each...
Ask SSC