Bad Idea Cowboy Hat: Using a foreign key to prevent updates
When I decided to rip off of Brent Ozar’s (b/t) Bad Idea Jeans series (yes I asked) I decided that ... Continue reading
2019-06-06 (first published: 2019-05-20)
992 reads
Kenneth Fisher
SQL Homework – June 2019 – Property functions
Yep. It’s time for your monthly homework session. You’ve finished last months right? Please turn it in over there. This ... Continue reading
2019-06-03
28 reads
I’m moving my permissions scripts to GitHub
I’ve written very few things that I’m more proud of than my permissions scripts, sp_SrvPermissions and sp_DBPermissions. These scripts are ... Continue reading
2019-05-30
68 reads
How was it done back in the day? T-SQL Tuesday #114
It’s TSQL Tuesday and Matthew McGiffen (b/t) is our host with a subject near and dear to my heart. Puzzles! ... Continue reading
2019-05-27 (first published: 2019-05-14)
483 reads
db_owner in msdb == sysadmin
This doesn’t require much in the way discussion. This isn’t exactly a huge issue since I don’t think granting db_owner ... Continue reading
2019-05-22 (first published: 2019-05-06)
543 reads
Security Learning Pathway at PASS Summit.
This year PASS is trying something new at PASS Summit. There are going to be Learning Pathways. A learning pathway ... Continue reading
2019-05-17
15 reads
What do you get with a Free account in #Azure?
The first thing I want to do is say thank you to Michael Crump (b/t). He tweeted out this: What ... Continue reading
2019-05-08 (first published: 2019-04-29)
1,241 reads
Why am I getting an NT AUTHORITYANONYMOUS error when creating or altering a stored procedure?
If you have to deal with linked servers then you probably have or will run into the following error: Login ... Continue reading
2019-05-08
92 reads
Shrinking a large database with limited outage windows
Yes, I realize you shouldn’t shrink your database (data files or log files), but I recently had a case where ... Continue reading
2019-05-06 (first published: 2019-04-22)
1,606 reads
SQL Homework – May 2019 – SQLCMD and the DAC
Yes, it’s that time again. Time to do your homework. This month your homework is to set up the DAC ... Continue reading
2019-05-01
26 reads
Blogs
Power BI Performance in 2026: A Practical Guide to Faster Semantic Models and Reports
By James Serra
Originally published April 2022; substantially updated July 2026. This post is a complete replacement...
Getting Started with Azure SQL Developer on Macbook
The idea behind Azure SQL Developer is for anyone to build, iterate, and test...
AI Experiments: Claude Solved a DAB Issue
By Steve Jones
I’m sure many of you are using AI regularly, perhaps chatting, perhaps using some...
Forums
Migration Challenge: Excessive FULLSCAN Statistics Update Duration Blocking SQL
Hello everyone , I am planning to migrate a database from SQL Server 2014...
SQL Agent Job Automated Change Capture Process
Comments posted to this topic are about the item SQL Agent Job Automated Change...
Another Model, More Data Loss
Comments posted to this topic are about the item Another Model, More Data Loss
Question of the Day
Finding a Database Master Key
Where do I check for the existence of a Database Master Key (DMK) in SQL Server 2025?
See possible answers