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
47 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
10 reads
sp_Blitz for All Servers
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
327 reads
BBQ Time in Texas
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
2019 PASS Summit Recap from a First Timer
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
NTSSUG Board Elections
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
OLDEST_PAGE Log Reuse Wait type
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,126 reads
NO RDPing!!! dbatools to the Rescue
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
Installing Microsoft MDS on SQL Server Standard Edition
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
87 reads
Blogs
How to Learn SQL Without Quitting Your Day Job
Juggling meetings, deadlines, and family? Yeah, learning SQL might seem like climbing Mount Everest...
Friday Flyway Tips: Chaining Commands for State-based Deployments
By Steve Jones
One of the cool things I’ve seen with the new Flyway CLI is that...
A New Word: Querinous
By Steve Jones
querinous – adj. longing for a sense of certainty in a relationship; wishing there...
Forums
How to Avoid Incorrect Results When Using T-SQL Trigonometric Functions in SQL Server
Comments posted to this topic are about the item How to Avoid Incorrect Results...
The AG Secondary Logs
Comments posted to this topic are about the item The AG Secondary Logs
Simple(r) Coffee
Comments posted to this topic are about the item Simple(r) Coffee
Question of the Day
The AG Secondary Logs
What happens when an AG secondary receives a log record from the primary?
See possible answers