SQLpassion Black Friday Deal 2018
(Be sure to checkout the FREE SQLpassion Performance Tuning Training Plan - you get a weekly email packed with all the...
2018-11-22
221 reads
Blog Posts
Using RANKX in Computed Column and MEASURE
This is my first blog for PBI – DAX. I lately started working on DAX and trying to understand it in depth. While looking for a DBA hat, getting...
2018-11-22
21 reads
Using RANKX in Computed Column and MEASURE
This is my first blog for PBI – DAX. I lately started working on DAX and trying to understand it in...
2018-11-22
5,606 reads
Azure Data Studio and XEvents
Azure Data Studio (ADS) is getting all sorts of love and attention these days. So much so that they have finally gotten around to adding Extended Events (XE) to...
2018-11-21
3 reads
Azure Data Studio and XEvents
Azure Data Studio (ADS) is getting all sorts of love and attention these days. So much so that they have...
2018-11-21
858 reads
Cannot Use the Special Principal – Back to Basics
I recently had a client call me out of the blue because he happened to be getting an error while...
2018-11-21 (first published: 2018-11-07)
2,574 reads
Dates and Times in SQL Server: DATEDIFF() and DATEDIFF_BIG()
Last time we looked at adding or subtracting date parts using the DATEADD() T-SQL system function. This week we see...
2018-11-21
376 reads
Join me for an upcoming webinar, “Data Masking: Insights & Actions”
There has never been a better time to start a project to champion data privacy In a recent Harris poll sponsored by the payment company Stripe, over 1,000 C-level...
2018-11-21
6 reads
Learning from PASS Summit Feedback
I got my feedback the other day, and was a bit surprised by a comment. I wasn’t having a great...
2018-11-21
757 reads
The Cloud and Shadow IT.
Shadow IT has been, well, maybe not the bane of the IT department, but certainly a pain in the neck....
2018-11-21
936 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