GarryBargsley

Failing SQL Agent Jobs – Part 3

It is Tuesday!!  Time for Part 3 in the series about SQL Server Agent Job Failures. This installment will show you how to setup SQL Agent Alerts and Operators...

2020-09-22 (first published: )

243 reads

Failing SQL Agent Jobs – Part 1

SQL Server Agent Jobs are one of the core features of SQL Server. Agent Jobs perform many actions, from maintenance tasks (server and database), data movement flows, replication, log...

2020-09-09 (first published: )

518 reads

Who is your Fail-Safe Agent??

Did you know it is possible for SQL Server Agent to  alert you of problems if something goes haywire with your Agent? Have you ever had an issue with...

2020-09-02 (first published: )

329 reads

Cleanup Pesky SQL Error Logs

If you are like me, you inherited variously configured SQL Servers when you took over as the DBA for your company. After almost two years, I have gotten all...

2020-08-31 (first published: )

365 reads

Blogs

PASS Virtual Summit 2020 Conference Sessions

By

Whether you are a SQL Server Database Administrator or Infrastructure Architect, you should be...

Running Express Edition in a Container–#SQLNewBlogger

By

Another post for me that is simple and hopefully serves as an example for...

How SQL Server stores data types: sql_variant

By

This post looks at a curious data type that isn’t really a data type....

Read the latest Blogs

Forums

Making 1 row from 2

By SQLHeap

I'm struggling a bit here. It seems easy, but I 'm not getting it....

PowerShell command to Run SQL file Fails asking for a variable

By sunshine-587009

Good morning team, I can run a .sql file that contains a SQLCMD command,...

Move file to Archive after copy and delete the files

By SSCNewbee

Hi All, I have a data pipeline to get the files from an SFTP...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers