PowerShell editors and environments: Part 1
There is no shortage of PowerShell editors and environments for developing and running scripts. Greg Moore explains some of his favorites.
2021-03-03
Articles
Using Azure SQL Data Sync to Replicate Data
Learn how to setup and use Azure SQL Data Sync to synchronize and replicate data from various locations including Azure SQL Database, cloud and on-premises databases.
2021-03-02
Win a Pluralsight subscription with Redgate’s competition
Redgate is giving you the chance to win a three-month subscription to the technical skills platform Pluralsight and Redgate goodies with their latest competition. To enter, visit the Redgate Forums and answer the question ‘What’s your favorite SQL Monitor feature and why?’
2021-03-02 (first published: 2021-02-16)
Microsoft Azure ADF - Dynamic Pipelines
Azure Data Factory (ADF) is a cloud based data integration service that allows you to create data-driven workflows in the cloud for orchestrating and automating data movement and data transformation. Azure Data Factory does not store any data itself. but it allows you to create data-driven workflows to orchestrate the movement of data between supported […]
2021-03-01
11,705 reads
sqldf in R Example for SQL Server
R has a package called sqldf that allows developers to manipulate data inside a dataframe in the same way a SQL developer queries a SQL table which we will cover with examples in this article.
2021-03-01
Monitoring the Number of Connections
Monitoring your SQL Server is important. This article examines one of the metrics you might want to keep an eye on.
2021-02-26 (first published: 2019-02-26)
47,781 reads
Customizing Database Deployments using Flyway Callbacks and Placeholders
How to customize a database deployment process using Flyway, demonstrating how to incorporate tasks such stamping a version number into the latest database build, or writing to the SQL Server log.
2021-02-26
Partitioned Tables Cause Longer Plan Compilation Times
Folks sometimes ask, “When a table has more indexes, and SQL Server has more decisions to make, does that slow down execution plan generation?”. Brent Ozar talks through his response in this article.
2021-02-26
Query Optimizer Suggests Wrong Index and Query Plan -- Why?
A good example where the Query optimizer picks the wrong query plan and suggested index.
2021-02-25
5,221 reads
Ten tips for building a collaborative DevOps culture
There is more to DevOps than tools and automation. In this article, Robert Sheldon explains how to create a DevOps culture based on collaboration.
2021-02-25
Blogs
How to Clear the SSMS Cache (SSMS 21 and Later)
By SQLPals
How to Clear the SSMS Cache (SSMS 21 and Later) Updated...
The flight recorder: Replaying what an AI agent did on my SQL Server
By Arun Sirpal
“What exactly did it do on my server?” is the first question a DBA...
Announcements from the Microsoft Fabric Community Conference — Barcelona 2026
By James Serra
Microsoft shared a broad set of Fabric, Power BI, and SQL updates at FabCon...
Forums
Let's Talk Certifications
Comments posted to this topic are about the item Let's Talk Certifications
The Hidden Security Risks of Role Combination in SSAS Tabular
Comments posted to this topic are about the item The Hidden Security Risks of...
The Empty Aggregate
Comments posted to this topic are about the item The Empty Aggregate
Question of the Day
The Empty Aggregate
I have this table in a SQL Server 2025 database:
CREATE TABLE [dbo].[CustomerOrder] ( [OrderID] [int] NULL, [CustomerID] [int] NULL, [total] [money] NULL ) ON [PRIMARY] GOWhat is returned from this code? (answers are for the sum and then the count)
SELECT SUM(total) AS sum,
COUNT(total) AS count
FROM dbo.CustomerOrder;
See possible answers