SQL Homework – July 2019 – Table Size
In general this homework series is meant to give you ideas of things to play with that most if not ... Continue reading
2019-07-01
134 reads
SQLStudies
Introducing sp_AzSQLDBPermissions (Beta)
I’ve written a version of my permissions scripts for Azure SQL Database. It’s still in Beta but I’m confident enough ... Continue reading
2019-07-11 (first published: 2019-06-27)
384 reads
What does the User Mapping tab of Login Properties really tell us.
In case it’s not clear, we are talking about the Login Properties GUI in SQL Server Management Studio (SSMS). Now, ... Continue reading
2019-06-24
42 reads
What permissions do temp stored procedures use?
In a performance tuning class I recently took with Brent Ozar (b/t) he mentioned temporary stored procedures and an interesting ... Continue reading
2019-06-19
103 reads
It’s interesting how an OR short circuits.
I recently did a post on the case expression short circuting and received a very very interesting comment from Chad ... Continue reading
2019-06-27 (first published: 2019-06-17)
875 reads
Does the case statement short circuit?
Let’s start with definitions: CASE Statement: This is basically an inline IF .. ELSE IF .. ELSE IF ….. etc ... Continue reading
2019-06-13
496 reads
The butterfly effect. T-SQL Tuesday #115
This month, our host Mohammad Darab (b/t) has given us an interesting subject. Dear 20 year old self. Where we ... Continue reading
2019-06-11
12 reads
How do I force a SQL Login to change it’s password on next login
Forcing someone to change their password on a periodic basis is a pretty common thing, and any time I’ve gotten ... Continue reading
2019-06-19 (first published: 2019-06-05)
559 reads
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
26 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
59 reads
Blogs
Claude AI Convinced Me Not to Build an iPad App
By Steve Jones
I coach volleyball and I do a lot of stat stuff on paper. I...
A New Word: Dolorblindness
By Steve Jones
dolorblindness – n. the frustration that you’ll never be able to understand another person’s...
Claude Code Helps Analyze Test Data Manager Log Files
By Steve Jones
I had a customer ask about analyzing their Test Data Manager (TDM) usage to...
Forums
Data Warehouse Toolkit meets Star Schema: The Complete Reference
Is there a good syllabus for reading these two together? (Yes, it's called the...
GPX distance and time analysis in SQL Server
Comments posted to this topic are about the item GPX distance and time analysis...
The DBA is Dead; Long Live the DBA
Comments posted to this topic are about the item The DBA is Dead; Long...
Question of the Day
Changing the AG Listener
In SQL Server 2025, if I want to remove an IP from a listener, what do I do?
See possible answers