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 shipping, data cleanup, health checks and many more. Since Agent Jobs are a critical component in a data organization, it is important to know when Agent Read More …
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 Alerts not being sent after critical events? Then you might need to configure the SQL Server Agent Fail-Safe Operator to save the day. A Fail-Safe WHAT Read More …
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 the standards in place where I feel that the environment is clean. One of the last things I accomplished was to standardize SQL Server Error Log Read More …
Do you run SQL Agent Jobs in your environment? Do you know what is running at any given time? Most people do not know what is currently running if you ask them. There are several times I need to know what job(s) is running on which server. For instance, let’s say on the morning of Read More …
Are you a Microsoft SQL Server DBA managing one or more servers? Then you should know about the First Responder Kit from Brent Ozar Unlimited. This is a free set of tools that help you check the health of your SQL Servers. Are you aware of SQL Server configuration settings that differ on your servers Read More …
The long awaited official release of dbatools v1.0 is upon us. Today at DataGrillen the official launch will happen and the release to the PowerShell Gallery will shortly follow. This version has been a long time in the making with tons and tons of awesome community contributors. As you may or may not know, dbatools Read More …
On the first day of Christmas dbatools gave to me: Find-DbaCommand On the second day of Christmas dbatools gave to me: Get-DbaCmsRegServer On the third day of Christmas dbatools gave to me: DbaMaxMemory On the fourth day of Christmas dbatools gave to me: DbaAgentJob On the fifth day of Christmas dbatools gave to me: DbaLogin On Read More …
On the first day of Christmas dbatools gave to me: Find-DbaCommand On the second day of Christmas dbatools gave to me: Get-DbaCmsRegServer On the third day of Christmas dbatools gave to me: DbaMaxMemory On the fourth day of Christmas dbatools gave to me: DbaAgentJob On the fifth day of Christmas dbatools gave to me: DbaLogin On Read More …
On the first day of Christmas dbatools gave to me: Find-DbaCommand On the second day of Christmas dbatools gave to me: Get-DbaCmsRegServer On the third day of Christmas dbatools gave to me: DbaMaxMemory On the fourth day of Christmas dbatools gave to me: DbaAgentJob On the fifth day of Christmas dbatools gave to me: DbaLogin On Read More …
On the first day of Christmas dbatools gave to me: Find-DbaCommand On the second day of Christmas dbatools gave to me: Get-DbaCmsRegServer On the third day of Christmas dbatools gave to me: DbaMaxMemory On the fourth day of Christmas dbatools gave to me: DbaAgentJob On the fifth day of Christmas dbatools gave to me: DbaLogin On Read More …
