The Data-Tier Application Package (DacPac), together with the Data-Tier Application Framework (DacFx), provides an alternative way to automate the process of scripting out, or deploying a SQL Server database, reporting on changes, or checking version-drift. As such, it seems to provide an obvious cost-free start for tackling automated Database Delivery as part of Database Lifecycle Management (DLM). We asked Phil Factor if it is ready for Prime-time.

Cloud Security Issues

by Steve Jones

SQLServerCentral.com

Editorial

The cloud is always going to be a challenge for security, but is it harder or easier than on premises? Steve Jones has a few comments.

Running SQL Server with Hyper-V Dynamic Memory - Best Practices and Considerations

by Additional Articles

Microsoft MSDN

Hyper-V

There are unique considerations that apply to virtual machines that run SQL Server workloads in such environments. This document provides insight into considerations and best practices for running SQL Server in Hyper-V Dynamic Memory configurations on Windows Server.

Be Professional

by Steve Jones

SQLServerCentral.com

Editorial

Today Steve Jones talks about the impressions we make as career minded individuals.

But we've always done it that way…

by Grant Fritchey

SQLServerCentral.com

Editorial

Inspired by his visit to the battlefield of Waterloo, Grant Fritchey explains the dangers of doing things the way you've always done them and the need to challenge constantly your beliefs and understanding of how the technology you manage works.

Do It Yourself Load Balancing with SSIS

by Adam Aspin

SQLServerCentral.com

Integration Services (SSIS)

This article takes a simple look at loading data in parallel from a single data source, be it a flat file of a database

Learning Columnstore Indexes

by Site Owners

SQLServerCentral.com

ColumnStore Index

References and links to learn more about columnstore indexes.

Change operating modes for SQL Server Database Mirroring

by Additional Articles

MSSQLTips.com

Database Mirroring

SQL Server Database Mirroring offers two methods for exchanging data: synchronously and asynchronously. Sometimes there may be a need to switch between modes for an existing mirror and in this tip we will look at how this can be done.

Dynamic Grouping in SSRS Reports

by Andy Owl

SQLServerCentral.com

Reporting Services (SSRS)

This article shows how you can create a dynamic report in SQL Server Reporting Services (SSRS), walking you through the steps needed to create a dynamically-grouped report.

How To Keep Up with SQL Server

by Andy Warren

SQLServerCentral.com

Editorial

It can be a challenge to keep up with the rapidly evolving SQL Server platform. Andy Warren has a few ideas today.

Microsoft and Database Lifecycle Management (DLM): The DacPac

Cloud Security Issues

Running SQL Server with Hyper-V Dynamic Memory - Best Practices and Considerations

Be Professional

But we've always done it that way…

Do It Yourself Load Balancing with SSIS

Learning Columnstore Indexes

Change operating modes for SQL Server Database Mirroring

Dynamic Grouping in SSRS Reports

How To Keep Up with SQL Server

Blogs

Monitoring Fabric Mirroring for SQL 2025

Monday Monitor Tips: Intelligent Alert Thresholds

A New Word: los vidados

Forums

String_agg not working as needed

Vectors in SQL Server 2025

Odd Sequences

Question of the Day

Odd Sequences