Useful T-SQL queries and scripts to work in SQL Server
This post is about some queries and scripts that I use in my daily work on SQL Server. Some of them are self-explanatory, i.e. the name of the query/script...
2018-12-05
426 reads
Blog Posts
Useful T-SQL queries and scripts to work in SQL Server
This post is about some queries and scripts that I use in my daily work on SQL Server. Some of them are self-explanatory, i.e. the name of the query/script...
2018-12-05
57 reads
What were you thinking (hidden relationship)???
What were you thinking?
Have you ever been working on some code from another person, and you end up scratching your...
2018-12-05 (first published: 2018-11-20)
2,245 reads
Azure SQL Database – Firewall Rules
If you decide to use IP addresses to control what services have access to your Azure SQL Database, then understanding...
2018-12-04
231 reads
Azure SQL Database Managed Instance Business Critical Tier Now Available
The business critical tier for Azure SQL Database Managed Instance is now available. Customers needing a higher level of high...
2018-12-04
39 reads
High CPU and Query Store, A Story of Spinlock Heartache
This is going to be a quick look at an issue that we recently encountered, I’m not going to go...
2018-12-04 (first published: 2018-11-20)
2,360 reads
SQL Date functions in SQL Server
SQL date format functions like the DateDiff SQL function and DateAdd SQL Function are oft used by DBAs but many...
2018-12-04
662 reads
SQL in the City is Next Week
Next Wednesday, Dec 12, I’ll be back in the UK with Kathi, Kendra, and Grant for SQL in the City...
2018-12-04
800 reads
System Variables in Azure Data Factory: Your Everyday Toolbox
(2018-Nov-20) After working and testing the functionality of variables within Azure Data Factory pipelines, I realized that it's worth to explore...
2018-12-04 (first published: 2018-11-20)
2,856 reads
T-SQL Tuesday 109: Influence Somebody Invite
How have you impacted somebody in the community?
It has now been 28 months since the last time I hosted a...
2018-12-04
225 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