SQLStudies

What is the CONTROL permission?

• by Kenneth Fisher

• SQLStudies

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

“They need help, we must help.” #forGarethSwan

• by Kenneth Fisher

• SQLStudies

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

Sometimes a change is as good as a break : T-SQL Tuesday #134

• by Kenneth Fisher

• SQLStudies

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

SQL Homework – January 2020 – Create an End of Year/New Year checklist.

• by Kenneth Fisher

• SQLStudies

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

SQL Homework – January 2020 – Create an End of Year/New Year checklist.

• by Kenneth Fisher

• SQLStudies

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

Hope!

• by Kenneth Fisher

• SQLStudies

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

SQL Homework – December 2020 – Participate in the Advent of Code.

• by Kenneth Fisher

• SQLStudies

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

How do I tell what compression level my tables/indexes are?

• by Kenneth Fisher

• SQLStudies

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

A quick and dirty scan of a list of instances using a dynamic linked server.

• by Kenneth Fisher

• SQLStudies

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

I get by with a little help from my friends : T-SQL Tuesday #132

• by Kenneth Fisher

• SQLStudies

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