Know How to Import SQL Server database From One to Another
Looking to import SQL Server database from one server to another ? Confused how to copy from one to another or...
2018-10-05
1,834 reads
Setting up Code Repository for Azure Data Factory v2
In this blog post I want to quick go through one of useful capabilities that Microsoft provided with version 2...
2018-10-05
213 reads
DevOps Terms – and Why They Matter to Database Specialists
In this 20 minute session, I define scrum, continuous deployment, test driven development, DevOps, and related concepts. I close with a quick discussion of why Database Administrators and Developers...
2018-10-04
23 reads
Running a SQL Server Azure Container Instance in a virtual network
Up until now Azure Container Instances only had one option to allow us to connect. That was assigning a public...
2018-10-04
355 reads
Azure IP Advantage
In today’s Azure Every Day post, I’d like to talk about something a little different from our normal posts, and...
2018-10-04
224 reads
Quick PoSh SQL Provision Databases for New Developers
As part of some presentation work, I wanted to demonstrate some onboarding of new developers. To that end, as part...
2018-10-04
360 reads
Giant Azure SQL Databases
Okay it is not really called Giant Azure SQL Database but its close. There is a new public preview vCore...
2018-10-04
344 reads
Sharding: Horizontal Scaling in Azure SQL Database
David has produced a talk all about Sharding. Or if you prefer horizontally scaling your Azure SQL database.
You can view...
2018-10-19 (first published: 2018-10-04)
2,740 reads
Query to determine XE Session status
On a previous post, we discussed what is an extended event (XE) and how to create one.With the following T-SQL you can quickly check what are the currently running...
2018-10-03
32 reads
Azure Data Relational Services
Today I’d like to talk about the Azure Relational Data Services Platform. This is an important foundational component for many...
2018-10-03
739 reads
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