Articles

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.

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

4.84 (19)

Log in or register to rate

2020-09-25 (first published: 2018-09-06)

5,343 reads

• Discuss

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.

2020-09-25

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.

2020-09-25

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

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

Log in or register to rate

2020-09-24

1,671 reads

• Discuss

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.

2020-09-24

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.

2020-09-24

Free eBook: SQL Server Backup and Restore

• by Press Release

• Redgate

• ebook

In this free eBook Shawn McGehee offers advice on query tuning, cutting stored procedures, and system process design and implementation for high availability. Discover how to perform backup and restore operations using SQL Server Management Studio (SSMS), basic T-SQL scripts and Redgate's SQL Backup tool.

2020-09-23 (first published: 2014-03-05)

80,501 reads

Managing Azure Blueprints with PowerShell

• by Additional Articles

• MSSQLTips.com

• Azure

Learn about the Azure PowerShell cmdlet for Azure Blueprints in Azure Resource Manager framework and how to export, import, publish, and assign Azure Blueprints with PowerShell cmdlets.

2020-09-23

Dear Past Me on My First Day as a DBA

• by Pam Mooney

• SQLServerCentral

• Career

A letter to a past self from Pamela Mooney that might help a more junior DBA get up to speed quicker.

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

5 (4)

Log in or register to rate

2020-09-22

2,474 reads

• Discuss

Data Masker with SQL Data Catalog Integration Automates Data Protection Process

• by Additional Articles

• Redgate

• Vendors/3rd-party Products

Data Masker for SQL Server now integrates with SQL Data Catalog (seamlessly with our new GUI) to let you fully automate your data privacy and protection process, from data classification through to masking.

2020-09-22