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,013 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)
25,766 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,184 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)
8,983 reads
By Steve Jones
Another test with Copilot in SSMS (v22 P3) that didn’t go so well. This...
Unused Indexes in SQL Server: Find them, vet them, and drop them safely Indexes are...
By Steve Jones
I hosted this month, late as it turns out, but we still had a...
Comments posted to this topic are about the item Create an HTML Report on...
Hi everyone! I'm new to SQL and am trying to query a view (dbo.)...
This is a topic to test whether reply notifications are working or not.
What does a slipstream installation mean?
See possible answers