Articles

SQLServerCentral Article

How to Recover a Corrupted Azure Data Factory Integration Runtime

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 […]

5 (2)

You rated this post out of 5. Change rating

2024-09-02 (first published: )

4,013 reads

SQLServerCentral Article

How to Delete Large Amounts of Data

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 […]

4.56 (9)

You rated this post out of 5. Change rating

2024-08-30 (first published: )

25,766 reads

Technical Article

Is it still worth it to sponsor PASS Summit?

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.

You rated this post out of 5. Change rating

2024-08-30

External Article

Is your DevOps strategy missing a vital link?

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

SQLServerCentral Article

Big Northwind with AI

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 […]

5 (3)

You rated this post out of 5. Change rating

2024-08-26

2,184 reads

Blogs

A Small LLM Fail

By

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

By

 Unused Indexes in SQL Server: Find them, vet them, and drop them safely Indexes are...

T-SQL Tuesday #191 Round Up

By

I hosted this month, late as it turns out, but we still had a...

Read the latest Blogs

Forums

Create an HTML Report on the Status of SQL Server Agent Jobs

By Nisarg Upadhyay

Comments posted to this topic are about the item Create an HTML Report on...

SQL Newbie HELP: The query references an object that is not supported in distr..

By WBenning

Hi everyone! I'm new to SQL and am trying to query a view (dbo.)...

Are topic notifications working?

By Edward Casbon

This is a topic to test whether reply notifications are working or not.

Visit the forum

Question of the Day

Slip Streaming Installs

What does a slipstream installation mean?

See possible answers