When database development is described, the details often get vague when the data gets beyond spreadsheet-size. There is 'hand-waving' talk of providing databases for each developer, but little detail of how you would provision all the databases that would be needed, at the correct version and with the correct development data, and then keep them all in sync with the source code, as developers commit changes. This article explains the requirements, and how SQL Clone can meet them.

New Stuff Can Be Scary

by Grant Fritchey

SQLServerCentral

I'm learning how to be a net controller for a high frequency (HF) radio network. Nets are a fun way to make lots of contacts quickly. Taking part in a net is simple. You check in with the net control and then you can answer calls or make calls (different nets have different rules). It's […]

Creating Subtotals and Totals in Aggregated Queries

by Adam Aspin

SQLServerCentral.com

Query Answers with SQL Server

Grouping Sets are an effective way to add subtotals to aggregated queries. T His article explains how.

The Danger of xp_cmdshell

by Steve Jones

SQLServerCentral.com

Editorial

This week Steve Jones wonders what you think of xp_cmdshell.

Database Development with GitHub

by Additional Articles

Redgate

Vendors/3rd-party Products

How can you use GitHub to do team-based database development? This article proposes a process that splits development work into task-based GitHub branches, incorporates daily database builds and integration testing, and using Redgate tools to automate tasks such as provisioning, database scripting, and testing.

Searching and Finding a String Value in all Columns in a SQL Server Table

by Additional Articles

MSSQLTips.com

Scripts

Sometimes there is a need to find if a string value exists in any column in your table. This script will help you find all occurrences in all columns in the table.

Incremental Data Loading using Azure Data Factory

by Sucharita Das

SQLServerCentral

ETL/SSIS/Azure Data Factory

Introduction In my last article, Loading data in Azure Synapse Analytics using Azure Data Factory, I discussed the step-by-step process for loading data from an Azure storage account to Azure Synapse SQL through Azure Data Factory (ADF). ADF basics are covered in that article. In this article I will go through the process for the incremental […]

The 10X Programmer

by Steve Jones

SQLServerCentral.com

Editorial

Today Steve Jones discusses the mythical 10x programmer from the context of databases.

Hands-On with Columnstore Indexes: Part 4 Query Patterns

by Additional Articles

SimpleTalk

Development

All queries run fast against columnstore indexes, right? In this article, Edward Pollack demonstrates some query patterns that don’t perform well and how to get around the issues.

Why you Should Embed Monitoring Earlier in Your Database DevOps Cycle

by Additional Articles

Redgate

Vendors/3rd-party Products

With insights from a recent Gartner report, Redgate’s Jamie Wallis looks at the benefits of tracking, and acting on, key metrics early in the DevOps process and how they can apply equally to database monitoring. Read more.

Solving the Provisioning Problem in Database Development using Clones

New Stuff Can Be Scary

Creating Subtotals and Totals in Aggregated Queries

The Danger of xp_cmdshell

Database Development with GitHub

Searching and Finding a String Value in all Columns in a SQL Server Table

Incremental Data Loading using Azure Data Factory

The 10X Programmer

Hands-On with Columnstore Indexes: Part 4 Query Patterns

Why you Should Embed Monitoring Earlier in Your Database DevOps Cycle

Blogs

Why your data still can’t answer a simple question

T-SQL Tuesday #197 Invitation – An impactful session or two from a conference

Did You Really Name That Default?

Forums

The day-to-day pressures of a DBA team, and how we can work smarter with automation and AI

Daily aggregation of Azure Blob Storage by tier (created/tier-change/deleted)

SQL 2017 to SQL 2025. Good to Go ?

Question of the Day

Using OPENJSON