SQLStudies

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)

379 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)

271 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)

225 reads

Adding a user to an Azure SQL DB

• by Kenneth Fisher

• SQLStudies

Creating a user is simple right? Yes and no. First of all, at least in SSMS it appears you don’t ... Continue reading

2020-11-19 (first published: 2020-11-05)

203 reads

SQL Homework – November 2020 – Help!

• by Kenneth Fisher

• SQLStudies

If you ask any senior IT person What is the most important tool you have? there is a decent chance that ... Continue reading

2020-11-10 (first published: 2020-11-03)

541 reads

What do they want to hear?

• by Kenneth Fisher

• SQLStudies

I was helping my 16yo write his first college essay the other day. He’s always struggled a bit with writing ... Continue reading

2020-11-03 (first published: 2020-10-29)

279 reads

How do I test if a linked server works using T-SQL?

• by Kenneth Fisher

• SQLStudies

I get that linked servers are almost as despised as the dreaded cursor or (lord save us) NOLOCK, but they ... Continue reading

2020-10-29 (first published: 2020-10-27)

759 reads

SQL Virtual Machines

• by Kenneth Fisher

• SQLStudies

I was recently watching the first session of the Azure SQL Bootcamp by Anna Hoffman (twitter) and Bob Ward (blog|twitter) ... Continue reading

2020-10-22

156 reads

My 800th post!

• by Kenneth Fisher

• SQLStudies

It took me a little bit longer to get here than I expected but I finally made it. 800 posts. ... Continue reading

2020-10-20

1 reads

Permissions script for Azure Synapse

• by Kenneth Fisher

• SQLStudies

I was recently asked to add on to my permissions stored procedures (sp_SrvPermissions, sp_DBPermissions and sp_AzSQLDBPermissions) and create one for ... Continue reading

2020-10-22 (first published: 2020-10-15)

162 reads