VMUG Ireland End of Year Event
This Thursday, November 30th, is the next VMUG Ireland event…our end of year social meetup! We’re going to be down in BrewDog Dublin: – THREE LOCKS SQUARE, 4, DUBLIN...
2023-11-27
16 reads
Blog Posts
Last Weeks Reading (2023-11-26)
📰 News Deploy a Delta Sharing Server on Azure Want to learn how to deploy a DeltaSharing server on Azure, but don’t know where to begin? Why Structured Streaming...
2023-11-26
13 reads
A New Word: Emodox
emodox – someone whose mood is perpetually out of sync with everyone else around them, prone to feelings of naptime panic, heart-to-heart snark, or dance club pensiveness. I had...
2023-11-24
50 reads
Creating a Self Referencing FK in a CREATE Statement–#SQLNewBlogger
I had written about a FK in a CREATE TABLE statement recently, but the second half of this was that after the original question, the person asked if this...
2023-11-24 (first published: 2023-11-06)
257 reads
Memories of the PASS Data Community Summit 2023
I’ve been to a lot of conferences, and one that I’ve probably attended the most is the annual PASS Data Community Summit. It’s been listed under various names, but...
2023-11-24
83 reads
Query Store Reports Time Intervals
A great question came up over at DBA.StackExchange regarding the query store reports time intervals: How can SQL Server’s Query Store Reports show data for minute-length intervals, when “Statistics...
2023-11-24 (first published: 2023-11-13)
262 reads
Crosstream - Efficient Cross-Server Joins on Slow Networks in Python
Earlier this year I presented at PyCon 2023 in Salt Lake City, UT on the topic of "Efficient Cross-Server Data Joins on Slow Networks with Python". You can watch...
2023-11-22 (first published: 2023-11-13)
161 reads
Get Certificate Details for SQL Encryption In-Transit Using PowerShell – UPDATED
In a previous blog post, I showed you how to use PowerShell to retrieve the details of the certificate being used for encryption-in-transit, aka TLS encryption. I have received...
2023-11-22 (first published: 2023-11-14)
1,404 reads
T-SQL Tuesday #168–Roundup
Last week was the 168th T-SQL Tuesday, which I hosted. The invitation is here. I didn’t get much of a chance to check out the posts as I was...
2023-11-21
26 reads
How to write efficient TSQL
This is an article on How to write efficient TSQL. When it comes to composing T-SQL (Transact-SQL) code, there exist a multitude of vital considerations developers should bear in...
2023-11-20 (first published: 2023-11-06)
1,058 reads
Blogs
PowerShell Remoting for SQL DBAs: WinRM + SSH Guide (Updated 2026)
By SQLPals
PowerShell Remoting for SQL DBAs: WinRM + SSH Guide (Updated 2026) ...
The 2026 Redgate Summit in New York City
By Steve Jones
We’re coming back to New York, which is exciting for me. I love NYC....
Monitoring Fabric Mirroring for SQL 2025
I previously wrote about how the underlying technology for Fabric mirroring changed with SQL...
Forums
Why SQL Server Orphaned Users Cause Login Failures
SQL Server Orphaned Users often appear after restoring or migrating a database to another...
Seeding a Fabric Warehouse with dbt for Visual Studio Code: The Fabric Modern Data Platform
Comments posted to this topic are about the item Seeding a Fabric Warehouse with...
Seeding a Fabric Warehouse with dbt for Visual Studio Code: The Fabric Modern Data Platform
Comments posted to this topic are about the item Seeding a Fabric Warehouse with...
Question of the Day
Historical Data Tracking
If I want to track historical data values, which mechanism should I use?
See possible answers