I sincerely hope this isn’t the first time you’re hearing about the Pass Data Community Summit that’s coming up in just a few weeks on November 8-12, 2021. But,...
2021-10-15 (first published: 2021-10-04)
134 reads
I was recently approached at work about a company that was seeing tons of timeouts in SQL Server. I was asked how to troubleshoot this. There are lots of...
2021-10-06 (first published: 2021-09-27)
508 reads
I find myself doing more and more work with containers. Yet, I also find that a lot of people seem to be resistant to the concept. I’m always surprised...
2021-09-29 (first published: 2021-09-20)
424 reads
I spent a chunk of the day yesterday, after work, but before working on a new book (yeah, I've got two jobs now), playing with my radios. I was programming the digital one to get it to use my Raspberry Pi as a hotspot (it used to work, now it doesn't). I also spent some […]
2021-09-25
70 reads
While I have not yet signed the contract, I have submitted an outline and proposal for a new version of my book on query performance tuning. Most of the...
2021-09-13
24 reads
I've recently moved house from Massachusetts to Oklahoma. Long story. Anyway, sitting in my new office looking out at the trees, some of the leaves are starting to change. Ah, Fall. Lovely Autumn colors... WAIT! Actually, something else is going on. Only a few trees are changing color. Word is, we've been a little dry […]
2021-09-04
95 reads
Did you know, you can use Actions to Filter Extended Events? Well, you can. Filtering is one of the greatest ways in which Extended Events differentiates itself from other...
2021-07-26 (first published: 2021-07-19)
212 reads
After 23 years in one place, I'm pulling up stakes and moving. We're selling our house in one state in the US and we're buying a house in another state about half a continent away. To say it's a stressful and exhausting process is an understatement. The worst part is that no one has defined […]
2021-07-24
129 reads
While we are clearly beginning to see in-person events on the calendar, the vast majority of presentations, events, talks, etc., are virtual. There are a lot of positives to...
2021-07-16 (first published: 2021-06-29)
119 reads
I was recently asked what permissions were needed to force plans in query store. I’m sure I knew at one point, but at the moment I was asked, I...
2021-07-06
24 reads
By DataOnWheels
For anyone who read the title of this and immediately thought, “Oh no, I...
By Kevin3NF
TLDR: Nope. Keep on doing your full backups. Make sure that any databases you...
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
Hello all, I've been tasked (rather randomly) with finding out if there is somewhere...
We get a sql connection from host informatica server and the query runs in...
I am trying to write a query to get a list of all SQL...
Ask SSC