Uncategorized

SQLServerCentral Article

How to Access and Use Azure Key Vault Secrets in an Azure Devops Pipeline

  • Article

When you run a CI/CD pipeline, you often need confidential values like passwords, authentication tokens, service principal secrets etc. when you want to deploy a certain artefact. You don’t want to store those secrets directly in your pipelines as this might pose a considerable security leak. Instead, you either store them as secret variables, or […]

You rated this post out of 5. Change rating

2025-09-02 (first published: )

1,466 reads

SQLServerCentral Editorial

Hack Your Brain

  • Editorial

Now, let's be really clear up front, I don't mean getting a surgically implanted chip in your head, done on your kitchen table. Brain hacks are generally either, forming habits that are good for learning and concentration, changing how you do things to help enhance your brains function, eating differently in support of brain health, […]

You rated this post out of 5. Change rating

2025-08-02

123 reads

SQLServerCentral Editorial

Get Your Chores Done

  • Editorial

I grew up in a pretty rural environment, in the southern US, in what's considered the Old West (Jesse James, reportedly, had a hideout a few miles from my current home, the Daltons, Belle Star, I can keep going, all came through this part of Oklahoma). Here, we call our daily tasks, like taking out […]

You rated this post out of 5. Change rating

2025-08-01

107 reads

SQLServerCentral Editorial

A Little Appreciation

  • Editorial

I'd like to take a moment and simply voice my appreciation for Steve Jones. Steve's still on sabbatical, so I've been doing some of the work, along with my co-worker, Kellyn Gorman (who I also appreciate, very much). I'm sure you've noticed. Oh, not simply that the editorials are different. That's to be expected. Nah, […]

(5)

You rated this post out of 5. Change rating

2025-07-30

110 reads

SQLServerCentral Article

How a Legacy Logic Choked SQL Server in a 30-Year-Old Factory

  • Article

When a SQL Server Express-based factory app started crawling, the culprit wasn’t hardware or network — it was a decades-old WHILE loop migrated from C/C++ to SQL. This real-world story breaks down how procedural habits, memory grants, and lack of window functions nearly derailed a production floor.

(6)

You rated this post out of 5. Change rating

2025-07-28

14,541 reads

Blogs

Introducing azsql-migration-test: Test and Validate Azure SQL Database Migrations

By

Introducing azsql-migration-test, a small open-source CLI that validates your Azure SQL Database migrations against...

Rambling about Data on Wheels – origins, branding, expansion

By

I have been asked many times about how the name “Data on Wheels” came...

Think Twice Before Enabling Fabric’s Inbound Network Protection

By

Fabric inbound network protection involves two tenant-level controls: Private Link and Block Public Internet...

Read the latest Blogs

Forums

AI Observability Challenges in FinOps as a DBA

By dbakevlar

Comments posted to this topic are about the item AI Observability Challenges in FinOps...

Migration Challenge: Excessive FULLSCAN Statistics Update Duration Blocking SQL

By abdalah.mehdoini

Hello everyone , I am planning to migrate a database from SQL Server 2014...

SQL Agent Job Automated Change Capture Process

By James Greaves

Comments posted to this topic are about the item SQL Agent Job Automated Change...

Visit the forum

Question of the Day

Finding a Database Master Key

Where do I check for the existence of a Database Master Key (DMK) in SQL Server 2025?

See possible answers