I would like to share my recent experience with Azure Data Factory (ADF) where AutoResolveIntegrationRuntime become corrupted and how did I recover it. I still don't know how the Integration Runtime (IR) was corrupted. However, if it happens, then this article will help you to solve the issue. Problem In general, the ADF AutoResolveIntegrationRuntime should […]
2024-09-02 (first published: 2021-11-05)
4,113 reads
In this article, learn how to set the current fiscal month identity in a calendar table using DAX for Power BI when dealing with fiscal periods.
2024-09-02
As a DBA, we are often tasked with maintenance work on the database. Often this includes making sure that old data is purged from the tables. This is especially true with logging tables. Sometimes multiple applications write to the same logging tables, and they can grow very quickly. Let’s say we have a logging table […]
2024-08-30 (first published: 2021-10-15)
27,759 reads
Conference planning is underway. Several folks have asked me whether I think the PASS conference is still worth exhibiting. I thought an article would be best to break down my thoughts. I’m in an interesting position, being a marketing leader who also specializes in SQL Server and doesn’t work for Microsoft. I’ve worked directly for several companies in the ecosystem, so I know how difficult reaching the DBA market has been post-pandemic.
2024-08-30
Real-Time dashboards are a great feature in Real Time Intelligence experience to monitor our data. However, by default ...
2024-08-30
Database DevOps practices can help you ship features faster, but how do you safely enable this, and ensure those updates will successfully deploy? Redgate Test Data Manager was developed to resolve bottlenecks and challenges, helping organizations ship deployments they can trust by enabling developers and testers to self-serve test data that walks and talks like production with sensitive customer data taken care of. Read more on the blog.
2024-08-28
Learn about object-level, column-level, and row-level security in Microsoft Fabric Warehouse and how this can be implemented to limit access to data.
2024-08-28
As part of my work with Redgate, I wanted to do some testing on our subsetting and masking tools. Subsetting needs a big data set, and while Stack Overflow is big, it's kind of simple. I wanted something a little different. Since our engineers use Northwind to do a lot of demos, I decided to […]
2024-08-26
2,326 reads
I recently had to help support synchronization and distribution of workloads between multiple servers.
2024-08-26
Learn about the different iterator activities in Azure Data Factory.
2024-08-23 (first published: 2021-10-22)
9,252 reads
By Brian Kelley
A few months ago I started using Deepstash. Deepstash breaks books into the key...
By Brian Kelley
Do you have a case where you have a named instance you'd like to...
I’ve been running this blog on Hugo for a long time, and like most...
Comments posted to this topic are about the item Admin Rights for Everyone
Comments posted to this topic are about the item Kerberos Authentication for Aurora PostgreSQL:...
Comments posted to this topic are about the item RegEx Functions I
Which of these RegEx functions need compatibility level 170 in SQL Server 2025?
See possible answers