Additional Articles

Hands-On with Columnstore Indexes: Part 1 Architecture

Microsoft introduced Columnstore with SQL Server 2012 and have improved the feature in every version since then. You may be wondering why they are different than traditional indexes and how they work. In this series, Edward Pollack explains the architecture of Columnstore indexes. In future articles in the series, he will describe best practices for Columnstore.

2020-06-18

Allowing for manual checks and changes during database deployments

SQL Change Automation enables users to make database changes to production safely and efficiently using PowerShell cmdlets, which can be integrated easily into any release management tool. This article will show you how to automate database deployments safely, by using SQL Change Automation from within PowerShell scripts, and how a deployment script for a release can be checked and amended as part of the process.

2020-06-15

Blogs

Social: Going Along to Get Along

By

It’s the eve of the Fourth of July, when the Declaration of Independence is...

Daily Coping 3 Jul 2020

By

I’ve started to add a daily coping tip to the SQLServerCentral newsletter and to...

Using Docker Volumes for SQL Server in Linux

By

No, not that kind of volume! Over the past couple of blog posts, I...

Read the latest Blogs

Forums

stored procedure to delete user and login

By SZ

I was trying these but it does not work: USE [MyDatabase] GO /****** Object:...

Managing Stress

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Managing Stress

Failover Cluster Instance Share

By Mike Scalise

Hi, I am using AlwaysOn Availability Groups in SQL Server 2016 with a primary...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers