Daily Coping 24 Jan 2022
I started to add a daily coping tip to the SQLServerCentral newsletter and to the Community Circle, which is helping me deal with the issues in the world. I’m...
2022-01-24
10 reads
Blog Posts
Discovering diagram of dependencies in Synapse Analytics and ADF pipelines
Documenting objects dependencies of ETL processes is a tough task. Regardless it is SSIS, ADF, pipelines in Azure Synapse or other systems. The reasons for understanding the current solution...
2022-01-24
110 reads
Discovering diagram of dependencies in Synapse Analytics and ADF pipelines
Documenting objects dependencies of ETL processes is a tough task. Regardless it is SSIS, ADF, pipelines in Azure Synapse or other systems. The reasons for understanding the current solution...
2022-01-24
7 reads
Why Is “WHERE 1=0” Slow?
I saw a question the other day, questioning why they’re creation of temporary tables was so slow. What they were doing was (a much more complicated version of) this:...
2022-01-24 (first published: 2022-01-10)
897 reads
Data Thoughts – Microsoft Exams and Simulations
G’day, I’ve based my career around Microsoft products on the Data Platform. The first product that I seriously learnt was Microsoft SQL Server back around 2000. I was lucky...
2022-01-23
9 reads
Architecture – The Perfect Enemy
When I was younger, I always wanted the perfect solution to an IT problem. I remember getting into argument after argument trying to insist upon the perfect configuration, setup,...
2022-01-21 (first published: 2022-01-10)
385 reads
Daily Coping 21 Jan 2021
I started to add a daily coping tip to the SQLServerCentral newsletter and to the Community Circle, which is helping me deal with the issues in the world. I’m...
2022-01-21
45 reads
T-SQL Tuesday 146: Where should business logic reside?
I am trying to get started on blogging again this year…T-SQL Tuesday came in handy with a great topic. This month’s host is Andy Yun(t |b). Andy’s challenge for...
2022-01-21 (first published: 2022-01-11)
541 reads
Daily Coping 20 Jan 2022
I started to add a daily coping tip to the SQLServerCentral newsletter and to the Community Circle, which is helping me deal with the issues in the world. I’m...
2022-01-20
38 reads
How to tell if Change Data Capture (CDC) is working as expected
I’m not sure how many of you use Change Data Capture (CDC) on your instances, but I’ve had to support it for a while now and I thought I’d...
2022-01-20
441 reads
Blogs
Enterprise AI Operating Rhythm – Top 5 practices for 2026
2025 exposed a growing gap between AI ambition and operational reality. As budgets tightened...
Stop Being Surprised by Your Azure Bill: Use Budgets
By John
When organizations migrate workloads to Azure, the focus is usually on architecture, performance, and...
Resetting on the AI hype train
By Brian Kelley
There's a great article from MIT Technology Review about resetting on the hype of...
Forums
Celebrating Tomorrow
Comments posted to this topic are about the item Celebrating Tomorrow
SQL Art: I Made a Christmas Card In SSMS
Comments posted to this topic are about the item SQL Art: I Made a...
lookup error
I am using ssrs in visual studio 2022, I work on a report, there...
Question of the Day
Celebrating Tomorrow
Which of these is more appropriate for tomorrow?
See possible answers