How to implement a T-SQL code formatting standard using SQL Prompt
Louis Davidson shows how to save a defined SQL formatting style as a shareable template that you can quickly share with your coworkers.
2017-05-02
5,605 reads
Articles
Introducing a DevOps Workgroup to Farm Credit Services of America
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...
2017-05-01
2,454 reads
What the heck is a DTU?
Andy Mallon explains DTUs (Database Transaction Units) and the differences you might see between the documentation and practical usage.
2017-05-01
6,723 reads
Display SSIS package version on the Control Flow design surface
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.
2017-04-28 (first published: 2015-08-04)
4,559 reads
Getting Started with Azure SQL Data Warehouse - Part 3
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.
2017-04-28
3,633 reads
Doing Fuzzy Searches in SQL Server
A series of arguments with developers who insist that fuzzy searches or spell-checking be done within the application rather then a relational database inspired Phil Factor to show how it is done. When the database must find relevant material from search terms entered by users, the database must learn to expect, and deal with, both expected and unexpected.
2017-04-27
7,260 reads
How to setup a tabular data model in SSAS Azure
Microsoft announced the availability of SQL Server Analysis Services (SSAS) on Azure late last year. Siddharth Mehta walks through how to quickly set up a tabular data model in SSAS Azure.
2017-04-26
2,859 reads
Building Dynamic React Apps with SQL Server Data
This article demonstrates using React and the CData API Server to build dynamic Web pages using SQL Server data.
2017-04-24
52,317 reads
6 shades of masking your data
The Redgate Foundry team have been researching data masking, and have found that generally speaking there's six common approaches. In this blog post, Toby Smyth runs through all six.
2017-04-24
3,252 reads
The right way to approach a legacy code base
Andrea Angella shares what he learned from attending Michael Feather's workshop on working effectively with legacy code.
2017-04-20
4,251 reads
Blogs
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...
Au Revoir for now
By Steve Jones
No, I’m not quitting or retiring. Just going on vacation, but I leave tonight...
Forums
Let's Talk Certifications
Comments posted to this topic are about the item Let's Talk Certifications, which is...
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