Execute SSIS Package from PowerShell
My friend Andy Leonard has written an excellent blog series on getting SSIS up & running in a Docker container. I would never have even tried to go down...
2019-04-30
12 reads
Blog Posts
IN vs UNION ALL
Watch this week's video on YouTube
When you need to filter query results on multiple values, you probably use an IN() statement or multiple predicates separated by ORs:
WHERE Col1 IN...
2019-04-30
14 reads
IN vs UNION ALL
Watch this week's video on YouTube
When you need to filter query results on multiple values, you probably use an IN() statement or multiple predicates separated by ORs:
WHERE Col1 IN...
2019-04-30
5 reads
It’s Been a While …
Last Post – SQL Saturday MN 2018 When last I wrote, it was after I spoke at SQL Saturday in Minnesota. I co-presented a pre-con with Josh Owen. Prior...
2019-04-30
18 reads
Know How to Repair SQL Database Marked as Suspect Mode in SQL Server
Repair SQL Database Marked as Suspect Mode MS SQL server is a widely used relational database management system developed by Microsoft. It is a software product which primarily helps...
2019-04-30
45 reads
Know How to Repair SQL Database Marked as Suspect Mode in SQL Server
Repair SQL Database Marked as Suspect Mode MS SQL server is a widely used relational database management system developed by Microsoft. It is a software product which primarily helps...
2019-04-30
8 reads
Lengthen a Primary Key–#SQLNewBlogger
Another post for me that is simple and hopefully serves as an example for people trying to get blogging as #SQLNewBloggers. I saw a post recently where someone needed...
2019-04-30 (first published: 2019-04-17)
449 reads
Setup SQL Server Alert to get automatically notified of database blockings
Suppose you want to or need to know anytime your SQL Server is experiencing blocking where queries are being blocked and it may or may not escalate to a...
2019-04-30 (first published: 2019-04-17)
1,679 reads
Four Data Integration Design Questions to Ask
We get requests to move data between custom systems regularly, even within systems. I was advising a client on something fairly simple—a collection of tables out of one vendor...
2019-04-29
6 reads
It’s all just data.
Tables, stored procedures, views, logins, constraints, etc, etc. It’s all just data. In every database system I’ve ever worked on ... Continue reading
2019-04-29 (first published: 2019-04-17)
492 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