A while back I wrote an editorial about how I believed the data community would easily continue after the PASS organization was no more. I'm pleased as punch to be able to report that I was right. Not because I enjoy being right (I do, who doesn't), but because I care very much for the […]
I read this great little blog post called "Trying to Notice What's Missing." It's not real long and it's worth your time. If you'd like a TLDR, the author points out how in-person meetings at conferences resulted in enhancements to open source software due to superior, in-person, communication. Strictly on a personal level, I miss […]
After reading a recent article on identifying islands and gaps in sequential numbers, one of our readers was inspired to develop a more efficient solution for fragmented data. New Author Goce Smilevski brings us his solution and supporting data to show how this can be done better.
A year of remote work has made life hard, and harder to get a break from the same environment you are in most of the time.
A frequent question among those learning about DevOps is "How do we do code reviews in this automated process?". Grant Fritchey shares three options - and a word of caution - to ensure you can appropriately understand the changes happening in your system.
Keeping databases secure is critical. In this article, Robert Sheldon explains what to monitor for SQL Server security.
I was asked to load multiple Excel files, each with multiple Excel worksheets. I found a very easy way to complete this in SSIS using a Script Task. This article will explain how I did this. For this example, I have two Excel files, File1.xlsx and File2.xlsx, as shown here: Each Excel File has three […]
In this article we will focus on Power Apps canvas apps which are natively optimized for mobile devices and we will look at potential use cases for canvas apps.
Migration to the cloud and PaaS solutions has accelerated in the past years, and many organizations now manage hybrid estates. To reflect this, the latest release of SQL Monitor adds Azure SQL Managed Instances to its list of supported cloud platforms. This article explains how to monitor performance and activity for Azure SQL Managed Instances using SQL Monitor, with advice on monitoring hybrid estates and migrating from on-prem to Azure SQL Managed Instance.
By SQLPals
PowerShell Remoting for SQL DBAs: WinRM + SSH Guide (Updated 2026) ...
By Steve Jones
We’re coming back to New York, which is exciting for me. I love NYC....
I previously wrote about how the underlying technology for Fabric mirroring changed with SQL...
SQL Server Orphaned Users often appear after restoring or migrating a database to another...
Comments posted to this topic are about the item Seeding a Fabric Warehouse with...
Comments posted to this topic are about the item Seeding a Fabric Warehouse with...
If I want to track historical data values, which mechanism should I use?
See possible answers