The all new, in-person, PASS Data Community Summit is in just a few weeks. Since I’m shortly going to be publishing a 100% rewritten book on query tuning, I...
2022-10-12 (first published: 2022-09-28)
198 reads
While Query Store has been out for quite some time now, released in 2016, there’s still quite a lot of missing understanding of what Query Store can do for...
2022-10-11
2 reads
Recently, a person asked about the costs differences in an execution plan, referencing them as if they were performance measures. The key to understanding performance is to check every...
2022-10-10
2 reads
Recently I was looking through DBA.StackExchange when I saw a pretty simple question that I decided to answer. I went off, set up a test database and some test...
2022-10-03
17 reads
And no, the answer is not because you want to be a Microsoft MVP. Multiple surveys have been published over the decades that list “fear of public speaking” as...
2022-09-29
15 reads
In case you don’t know, I’ve been writing a series of articles over on Simple-Talk as I learn PostgreSQL. It’s all from the point of view of a SQL...
2022-09-26 (first published: 2022-08-01)
258 reads
Just a suggestion, but I’d say you should look into Chocolatey. Let me explain why. Sabbatical For those who don’t know I was recently on a six-week sabbatical from...
2022-09-23 (first published: 2022-09-12)
345 reads
Honestly, sincerely, no kidding, I love Distributed Replay. Yes, I get it. Proof positive I’m an idiot. As we needed proof. To be a little fair to me, I...
2022-09-21 (first published: 2022-08-15)
183 reads
Wouldn’t it be great to be able to directly monitor specific behaviors within SQL Server, like, oh, I don’t know, knowing exactly when, and how, someone is using BULK...
2022-09-19
3 reads
The other types of constraints are referred to as check constraints. They limit the data by defining a logical operation that checks the state of the data prior to...
2022-09-05
2 reads
We’re working through the major refresh of my Certified Kubernetes Administrator series at Pluralsight! The...
By Brian Kelley
In information security (INFOSEC), there several foundational concepts and principles. One of the ones...
By Steve Jones
the standard blues– n. the dispiriting awareness that the twists and turns of your...
Comments posted to this topic are about the item One more reason to use...
I'm tracing activity on one database and would like to include the client_app_name in...
select Custno, Addr1, City, Res_Phone, Bus_Phone, Fax_Phone, Marine_Phone, Pager_Phone, Other_Phone, email1, email2 from customer...
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