Load balancing in Azure has more importance for the DBA, because it is essential for Windows Server Failover Clustering in Azure, whether it is for AlwaysOn Availaiblity Groups, Failover Clustered Instances, or any other highly-available solution. Azure load balancing works out the location of the availability group, and routes traffic there. The load balancer detects a failure, and routes traffic to the new primary replica. Joshua Feierman gives an overview of what is required.

How to implement a T-SQL code formatting standard using SQL Prompt

by Additional Articles

Redgate

formatting

Louis Davidson shows how to save a defined SQL formatting style as a shareable template that you can quickly share with your coworkers.

More Open Data

by Steve Jones

SQLServerCentral.com

Editorial

A new site from Steve Ballmer opens lots of data to the public.

Why deadlines stink, and are so necessary

by drsql@hotmail.com

SQLServerCentral.com

Editorial

I hate deadlines. Really. I truly hate them. The problem is: they are usually unrealistic, often not much more than a wild guess. They restrict the amount of time that I can spend in preparation and research so that I can do things right; they squeeze the artistic quality out of my work as a […]

Introducing a DevOps Workgroup to Farm Credit Services of America

by Additional Articles

SimpleTalk

DevOps and Continuous Delivery (CI/CD)

If you are introducing DevOps workflows into a large organization, you’ll need to plan carefully and prioritize tasks, adapt, maintain a thick skin, communicate constantly, and ensure that all...

What the heck is a DTU?

by Additional Articles

SQLPerformance.com

Andy Mallon explains DTUs (Database Transaction Units) and the differences you might see between the documentation and practical usage.

Display SSIS package version on the Control Flow design surface

by Herman van Midden

SQLServerCentral.com

Integration Services (SSIS)

In this article I will show a simple trick to display version information on the Control Flow surface, so we immediately see which version and build we are modifying.

Starting to Use SQL Server 2017

by Steve Jones

SQLServerCentral.com

Editorial

Today Steve Jones looks forward to the next version of SQL Server, with his curiosity to see if you feel the same way.

Getting Started with Azure SQL Data Warehouse - Part 3

by Additional Articles

Database Journal

Microsoft Fabric (Azure Synapse, Data Engineering, etc.)

Microsoft introduced Azure SQL Data Warehouse, a new enterprise-class, elastic petabyte-scale, data warehouse service that can scale according to organizational demands in just few minutes. In this article, Arshad Ali discusses the different types of tables you can create in SQL Data Warehouse, how they impact performance and the best practices around them.

SQL Server on Linux is Just SQL Server

by Steve Jones

SQLServerCentral.com

Editorial

Steve Jones looks at SQL Server on Linux and how this may differ from what most of us have worked with in the past.

Azure Load Balancers and SQL Server

How to implement a T-SQL code formatting standard using SQL Prompt

More Open Data

Why deadlines stink, and are so necessary

Introducing a DevOps Workgroup to Farm Credit Services of America

What the heck is a DTU?

Display SSIS package version on the Control Flow design surface

Starting to Use SQL Server 2017

Getting Started with Azure SQL Data Warehouse - Part 3

SQL Server on Linux is Just SQL Server

Blogs

Red Flags in Your Query (T-SQL Tuesday #200)

T-SQL Tuesday #200: When I Look at a Query …

Reflections on the Life of a DBA

Forums

cons for a dev machine in a different version of sql from our prod server

Inquiry – Enforcing ApplicationIntent=ReadOnly via GPO

Calculating Geometric Mean in Power BI

Question of the Day

TempDB Facts I