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
46 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
46 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
10 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
315 reads
My first go at smokin’ a brisket is documented below. It is summertime and we are stuck at home in isolation, might as well find a new hobby. I...
2020-07-09
1 reads
Heading to PASS Summit… It is Sunday the week of PASS Summit and I am at the airport after a relaxing morning with my wife and son. Unfortunately, I...
2019-12-06
2 reads
It is that time of year again. The NTSSUG has two spots coming open on the board. Last year I decided at the last minute to opt in as...
2019-11-21
2 reads
Do you frequently use the “log_reuse_wait_type_desc” column in the [crayon-5f297eff3d7ff981952735-i/] view? Have you ever seen the type of OLDEST_PAGE? You are not the only one!! Recently I was troubleshooting...
2019-09-24
1,093 reads
So you hear this spread across the Twitterverse and Blogosphere. You should not RDP your SQL Servers to do administrative work. My nature has always been to troubleshoot issues...
2019-09-12
7 reads
HaHa, tricked you. You can’t install SQL MDS on Standard Edition. You must first upgrade to SQL Enterprise Edition before you can proceed with an MDS installation. Upgrading SQL...
2019-08-15
80 reads
By Chris Yates
A brief introduction to the tool and its advantages for database migrations DevOps is...
In a previous blog post we went through how to build a Docker container...
Businesses are drowning in data, but starving for insights. That's where SQL experts swoop...
select Custno, Addr1, City, Res_Phone, Bus_Phone, Fax_Phone, Marine_Phone, Pager_Phone, Other_Phone, email1, email2 from customer...
I'm only processing 50,000 records not everything from the Table where there are 250,00...
Comments posted to this topic are about the item The Marked Transaction
I want to mark a transaction in the log as a recovery point. How do I do this in my code if I use the transaction, myTran?
See possible answers