In many cases Azure SQL Database offers an economically and functionally viable alternative to SQL Server deployments. However, there are also scenarios where we might discover that rather than serving as a replacement, it provides synergy, working side by side with your on-premises databases. One of technologies that illustrate this paradigm is Stretch Database, introduced in SQL Server 2016. Marcin Polichtdescribes its basic characteristics and reviews its implementation steps in this article.

Resolving an Error When Creating an Availability Group Listener

by Ganapathi varma Chekuri

SQLServerCentral.com

always on

In this post, I’m going to talk an issue that I found when creating an availability group listener by using SQL Server Management Studio's Add Listener. This article helps you to resolve the issue.

Minimizing impact of widening an IDENTITY column – part 4

by Additional Articles

SQLPerformance.com

Aaron Bertrand continues his series on widening an IDENTITY column, showing how he would attack the problem directly.

NCAs and NDAs

by Steve Jones

SQLServerCentral.com

Editorial

When accepting an offer of employment, what do you do about NCAs and NDAs that you might be asked to sign? Steve Jones offers some advice. (This editorial was originally published on Mar 12, 2008. It is being re-run as Steve is on holiday.)

Towards a Single Management Stack

by Phil Factor

SQLServerCentral.com

Editorial

Phil Factor argues that with both SQL Server and PowerShell now running on Linux, the latter becomes increasingly important in achieving the goal of a single management stack for databases across all hosting environments.

The Exploratory Testing Chrome Plugin

by Additional Articles

SimpleTalk

.Net

If all your application testing is done by test experts, who know how to record images, do screen-capture, write issue-reports to TFS more appropriate and consistent format and so on, you probably don't need the 'Exploratory Testing' chrome plug-in. Otherwise, it is worth checking out Ambily KK's walkthrough.

Comprehensive Baseline Collector Solution (Updated)

by Robert Virag

SQLServerCentral.com

Baseline

There are no more excuses for not having baseline data. This article introduces a comprehensive Free Baseline Collector Solution

The Copy Cat Poll

by Steve Jones

SQLServerCentral.com

Editorial

This poll asks about copies, specifically those of your databases. How many do you keep around? How much extra storage does this cost? Steve Jones thinks that most organizations have quite a few copies, which can use a lot of resources.

Writing Better T-SQL: Top-Down Design May Not be the Best Choice

by Mickey

SQLServerCentral.com

One of the best ways in which you can build better applications is by learning to write better T-SQL. Mickey Stuewe begins a new series showing how you might start to think about writing queries.

Writing Better T-SQL: Top-Down Design May Not be the Best Choice

by Mickey

SQLServerCentral.com

One of the best ways in which you can build better applications is by learning to write better T-SQL. Mickey Stuewe begins a new series showing how you might start to think about writing queries.

Introduction to SQL Server Stretch Database

Resolving an Error When Creating an Availability Group Listener

Minimizing impact of widening an IDENTITY column – part 4

NCAs and NDAs

Towards a Single Management Stack

The Exploratory Testing Chrome Plugin

Comprehensive Baseline Collector Solution (Updated)

The Copy Cat Poll

Writing Better T-SQL: Top-Down Design May Not be the Best Choice

Writing Better T-SQL: Top-Down Design May Not be the Best Choice

Blogs

Database AI Agents: The Read-Only Rule

Creating a SQL Stored Procedure to Load a SCD2

Funny Money: #SQLNewBlogger

Forums

Backup Availability Group

How Do the Experts Become Experts?

Stairway to Reliable Database Deployments Level 4 – Preparing for Production Deployment

Question of the Day

Secure Communications