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)
398 reads
Kenneth Fisher
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
136 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)
877 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
44 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
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
105 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
518 reads
What is a distributed transaction?
A while back I did a post defining a transaction. Basically, a transaction is a unit of work. The example ... Continue reading
2019-06-13 (first published: 2019-05-28)
825 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
Using VALUES to construct an in-line table.
This has come up a few times recently, I find it rather fascinating and I can never seem to remember ... Continue reading
2019-06-07 (first published: 2019-05-22)
1,167 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
Alamat Kontak Bank BCA KCP Soreang Telp:08218154392
WA CS:08218154392 No. 1-A, Jl. Raya Soreang, Pamekaran, Kec. Soreang, Kabupaten Bandung, Jawa Barat...
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