Failing SQL Agent Jobs – Part 2
Welcome to Part 2 in the series about SQL Server Agent Job Failures. In this part you are going to learn how to build an HTML report with Failed...
2020-09-18 (first published: 2020-09-10)
643 reads
GarryBargsley
T-SQL Tuesday #130 – Automate Permissions Audits
This month’s T-SQL Tuesday is being hosted by Elizabeth Noble. The subject chosen “what have you automated to make your life easier?” For me the topic is near and...
2020-09-14 (first published: 2020-09-08)
441 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: 2020-09-01)
639 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: 2020-08-25)
400 reads
Certified Azure Database Administrator (DP-300) – Passed!!!
Deja Vu, back in March I saw a Tweet about the beta Microsoft Certification Exam DP-300. I work with Azure and Databases, so I thought to myself why not...
2020-09-04 (first published: 2020-08-20)
757 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: 2020-08-18)
553 reads
Why a 60GB Database Backup Grew to 1TB in Size
Recently, I was alerted to a network file share that was running low on disk space. This interesting as there was only one process that used this particular location...
2020-08-11
3,957 reads
What Agent Jobs are Running??
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...
2020-08-13 (first published: 2020-08-04)
548 reads
Certified Azure Administrator (AZ-104) – Passed!!!
Back in March I saw a Tweet about the beta Microsoft Certification Exam AZ-104 program was looking for 300 candidates to take the exam by May 31st. Since moving...
2020-07-28
56 reads
Creating New Database — Standard Settings
Recently I have been able to work with our development teams to not create new databases. There are several reasons for me making this request of the teams. The...
2020-07-21
14 reads
Blogs
Reading SQL Server File Headers with DBCC FILEHEADER
I’ve been doing a deep dive into SQL Server on-disk structures lately, and one...
T-SQL Tuesday #197 – An impactful session or two from a conference – RECAP
By DataOnWheels
Thanks to everyone who joined the blog party this month. I noticed three themes...
OpenClaw- Agentic Engineering
By Vinay Thakur
This week has training on AI – Cyber security experts – Omar Santos and...
Forums
What's new in R 4.6
Comments posted to this topic are about the item What's new in R 4.6
Interesting Changes in R
Comments posted to this topic are about the item Interesting Changes in R, which...
PostgreSQL String Functions Part 1
Comments posted to this topic are about the item PostgreSQL String Functions Part 1
Question of the Day
Identities and Sequences V
When thinking about the identity property and sequence objects, which of these can generate values before an insert statement is executed?
See possible answers