When it comes to Azure Data Factory deployment, I always have a few words to say. You might be aware that there are two approaches in this terms. I...
2021-11-26 (first published: 2021-11-01)
168 reads
A question came up recently concerning whether it was still possible to connect to .xlsx Excel files as SQL Server linked servers.
Short answer: Yes, it's possible as recently as...
2021-11-26 (first published: 2021-11-05)
1,551 reads
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...
2021-11-25
33 reads
This is one of those shameless plugs I’m allowed to do from time to time to promote my user group here in Calgary. Tonight, starting 5pm Mountain time, Bob...
2021-11-24
10 reads
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...
2021-11-24
8 reads
I was honored to speak at Pass Summit last week (Thanks again Redgate), and if you’ve ever been to one ... Continue reading
2021-11-24 (first published: 2021-11-16)
232 reads
As Simon Sabin (SQL Bits co-founder) pointed out recently, the 2022 SQL Bits conference is looking to get 40% of their sessions to be 20 minute talks. He did...
2021-11-24 (first published: 2021-11-18)
168 reads
I got two packages this week, both unexpected. They were nice surprises. First, a huge thanks to the Cloud Summit and Stephen Simon for running a great event and...
2021-11-24
110 reads
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...
2021-11-23
9 reads
A lot of my colleagues and people in my network reached out to me to train them on the SQL Server and T-SQL. They think that my style of...
2021-11-23
291 reads
By Steve Jones
ochisia – n. the fear that the role you once occupied in someone’s life...
This is a quick blog post, mainly so I have the code available if...
Praise whatever deity you believe in, because it’s finally here, a tenant switcher for...
Here's my data... I am trying to return total days in status for each...
Here's my data... I am trying to return total days in status for each...
When building statistics, there is the concept of density that refers to the duplicates in a table. How is this calculated?
See possible answers