“They need help, we must help.” #forGarethSwan
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)
316 reads
Kenneth Fisher
Sometimes a change is as good as a break : T-SQL Tuesday #134
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
128 reads
SQL Homework – January 2020 – Create an End of Year/New Year checklist.
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)
350 reads
SQL Homework – January 2020 – Create an End of Year/New Year checklist.
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!
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
8 reads
SQL Homework – December 2020 – Participate in the Advent of Code.
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?
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)
442 reads
A quick and dirty scan of a list of instances using a dynamic linked server.
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)
300 reads
Adding a user to an Azure SQL DB
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)
246 reads
I get by with a little help from my friends : T-SQL Tuesday #132
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)
232 reads
Blogs
Daily Coping 24 Jun 2021
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
DDL Trigger to log database level security commands.
In my last post I talked about reasons why your permissions might go missing....
Azure SQL Managed Instance Versions
By Arun Sirpal
Just a really quick FYI for the readers. If you are using Managed Instances...
Forums
Cannot log in to new SQL server
Hello, I'm fairly new to installing SQL 2019 standard and am having two issues....
Single Query Instead of a Cursor
Is it possible to rewrite this routine to be a single query, instead of...
Report with 2 tables per page grouped on same data
hi all looking some advice on the best approach on designing a report in...
Ask SSC