What is the CONTROL permission?
One of the most powerful permissions available in SQL Server is control. But what exactly is it? Per BOL: CONTROL: ... Continue reading
2021-01-27 (first published: 2021-01-19)
488 reads
One of the most powerful permissions available in SQL Server is control. But what exactly is it? Per BOL: CONTROL: ... Continue reading
2021-01-27 (first published: 2021-01-19)
488 reads
We just finished a memorial for Gareth Swanepoel. He was an amazing person and someone I wish I’d gotten to ... Continue reading
2021-01-22 (first published: 2021-01-14)
313 reads
James McGillivray (blog|twitter) wants us to give him a break. Well. Actually I guess he wants to know how we ... Continue reading
2021-01-12
126 reads
It’s a brand new year and hopefully it will be better than last year. While that may be particularly true ... Continue reading
2021-01-11 (first published: 2021-01-05)
343 reads
It’s a brand new year and hopefully it will be better than last year. While that may be particularly true ... Continue reading
2021-01-05
2020 was a rough year. We’ve had friends and family leave us. Jobs lost. Health scares a plenty and that’s ... Continue reading
2020-12-31
5 reads
Christmas. Depending on where you live it’s a big deal even if you aren’t Christian. It pervades almost every aspect ... Continue reading
2020-12-03
40 reads
It’s been a while since I worked with compression and the other day I needed to check which of my ... Continue reading
2020-11-27 (first published: 2020-11-17)
431 reads
Note: This is not exactly a dyanmic linked server. It just gets dropped and recreated in a loop. I recently ... Continue reading
2020-11-23 (first published: 2020-11-12)
295 reads
Taiob Ali (blog|twitter) is our host for TSQL Tuesday this month and he’d like us to talk about how our ... Continue reading
2020-11-13 (first published: 2020-11-10)
230 reads
By Steve Jones
Another post for me that is simple and hopefully serves as an example for...
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
By Brian Kelley
Tomorrow, March 9, 2020, at 3 PM EST, I will be giving a presentation...
Hi. I am trying to download a report from SSRS 2019 in word format...
I've yet to find an answer for this. I've found a few queries that...