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
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)
638 reads
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
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
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)
552 reads
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,956 reads
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)
547 reads
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
55 reads
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
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...
2020-07-14
338 reads
By HeyMo0sh
As a DevOps professional, I’ve seen firsthand how cloud costs can quickly spiral out...
By Steve Jones
AI is everywhere. It’s in the news, it’s being added to every product, management...
By Vinay Thakur
RAG — Retrieval Augmented Generation. we have covered so far — embeddings, vectors, vector...
Hi, ssms is free here. I can think of other reasons to do this...
I've written some documentation on using different Markdown types of files on GitHub. It's...
Comments posted to this topic are about the item Not Just an Upgrade
I am doing development work on a database and want to keep a backup so I can reset my database. I make some changes and want to restore over top of my changes. When I run this code, what happens?
USE Master BACKUP DATABASE DNRTest TO DISK = 'dnrtest.bak' GO USE DNRTest GO CREATE TABLE MyTest(myid INT) GO USE master RESTORE DATABASE DNRTest FROM DISK = 'dnrtest.bak' WITH REPLACESee possible answers