What I’ve Been Up To
Just a short update. I haven’t blogged since May, and that’s because I’ve been presenting. Now, I have a publishing contract, so that’s keeping me busy. I want to...
2021-12-21
1 reads
Blog Posts
Azure Synapse Analytics November updates
Microsoft recently came out with a blog on a bunch of new features available for Azure Synapse Analytics (see Azure Synapse Analytics November 2021 Update), and I wanted to...
2021-12-20 (first published: 2021-12-09)
196 reads
Copying large files from SharePoint Online
I recently worked on a project where we needed to copy some large files from a specified library in SharePoint Online. In that library, there were several layers of...
2021-12-20 (first published: 2021-12-07)
283 reads
Daily Coping 20 Dec 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...
2021-12-20
9 reads
SQL Managed Instances – Failing Over
This is our current setup shown below. There is not much to failing over with Managed Instances, from experience it is similar to that of Azure SQL Database. Let’s...
2021-12-17 (first published: 2021-12-07)
262 reads
SQL Server meta-development (with regular expressions and more)
Yesterday, I had about 30 existing queries (and some multi-query processes) that I needed to turn into individual stored procedures. […]
The post SQL Server meta-development (with regular expressions and...
2021-12-17 (first published: 2021-10-13)
439 reads
Daily Coping 16 Dec 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...
2021-12-16
12 reads
Open Business Continuity Questions & Answers – today at 1p Central
Our holiday gift to the Microsoft Data Platform Continuity Virtual Group is to have a massive panel of industry-leading experts answer YOUR questions with no strings attached! Bring your...
2021-12-16
29 reads
Daily Coping 15 Dec 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...
2021-12-15
10 reads
How Long has Your SQL Server Been Online
This week’s blog post will help you check your SQL Servers up-time. There are numerous reasons I can think of that you would want to know how long your...
2021-12-15 (first published: 2021-12-07)
541 reads
Blogs
A New Word: Ochisia
By Steve Jones
ochisia – n. the fear that the role you once occupied in someone’s life...
Create a Numbers Table in Power Query
This is a quick blog post, mainly so I have the code available if...
Microsoft finally adds Tenant Switcher for Fabric / Power BI
Praise whatever deity you believe in, because it’s finally here, a tenant switcher for...
Forums
To View or not to View, that is the question...
I've read lots of the horror stories about nested views in databases where they're...
Grant user read-write permission to a single database
Hello! How do I grant a user to read-write to a single database and...
Question of the Day
The Density Vector
When building statistics, there is the concept of density that refers to the duplicates in a table. How is this calculated?
See possible answers