TSQL Tuesday #127 Invite – Non SQL Tips and tricks
How about for this months TSQL Tuesday let’s do another month of tips and tricks. But just to be a ... Continue reading
2020-06-02
28 reads
Kenneth Fisher
Use session_context to create a “variable” that lasts between batches.
The other day I had a brief conversation with Itzik Ben-Gan (about|twitter) on twitter and I have to tell you ... Continue reading
2020-05-26
134 reads
Explain CROSS APPLY like I’m 5.
A good friend of mine (Randolph West (blog|twitter) asked that someone Explain CROSS APPLY like they are 5. So, here’s ... Continue reading
2020-05-25 (first published: 2020-05-11)
1,826 reads
Connecting to Azure SQL Database: Requested tenant identifier ‘00000000-0000-0000-0000-000000000000’ is not valid.
The other day I got this rather interesting error while connecting to an Azure SQL DB. I was connecting using ... Continue reading
2020-05-20
106 reads
Negative (-) is an operator and will affect the order of operations.
An interesting question came to my attention the other day. A strange operation problem in SQL Server: -100/-100*10 = 0 ... Continue reading
2020-05-18
413 reads
Running Azure from my android phone
The other day I had a random thought. I wonder if there is a version of Azure Portal for Android. ... Continue reading
2020-05-13
73 reads
What is (local)?
When connecting to a SQL Server instance sometimes you’ll see (local), localhost or even just a single period (hard to ... Continue reading
2020-05-12 (first published: 2020-04-27)
383 reads
Could not obtain information about Windows NT group/user
This is an interesting error that you’ll occasionally get when accessing an AD/Windows ID. Msg 15404, Level 16, State 11, ... Continue reading
2020-05-06
166 reads
Is there an easy way to tell what pricing tier my Azure SQL DB/DW is using T-SQL?
I ran into an interesting problem today. I needed to find out the pricing tier of an Azure SQL DB ... Continue reading
2020-05-06 (first published: 2020-04-22)
460 reads
SQL Homework – May 2020 – Forum Lurking.
A few months ago I suggested writing blog post(s) as a great way to learn and document your progress (among ... Continue reading
2020-05-04
28 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
Can You Really Downgrade from Enterprise to Standard and Save Thousands? Here's What Happened
Comments posted to this topic are about the item Can You Really Downgrade from...
What is CPU Usage?
Comments posted to this topic are about the item What is CPU Usage?
Limiting Checkpoints
Comments posted to this topic are about the item Limiting Checkpoints
Question of the Day
Limiting Checkpoints
If I use the -k parameter with a number after it, what does this change in SQL Server?
See possible answers