Table partitioning
What is partitioning.
To start with partition is the feature provided by SQL server in which very large tables are split...
2015-09-28
546 reads
SQL Saturday as an Attendee
Last week I did something that many people have already done. However this was my first experience, and I really...
2015-09-25
663 reads
Thoughts on the 2015 PASS Election
We had a decent election this year. Thanks to all four candidates – Argenis Fernandez, Jen Stirrup, Ryan Adams, and Tim...
2015-09-25
678 reads
The Extended Event GUI
The Extended Events GUI provides a visual access to the Extended Events engine that can help to better understand the XEvents Engine and how a Session is built.
Related Posts:
Profiler...
2015-09-25
13 reads
The Extended Event GUI
In the previous article in this series I shared the basics around assembling an XEvent session. The method used in...
2015-10-01 (first published: 2015-09-25)
2,655 reads
SQL Server SSIS: ReplaceNull
One of widespread problems in SSIS packages is to replace NULL values with some specific value. Unfortunately, before it was not a simple task as Integration Services didn’t have...
2015-09-25
66 reads
SQL Server SSIS: ReplaceNull
One of widespread problems in SSIS packages is to replace NULL values with some specific value. Unfortunately, before it was not a simple task as Integration Services didn’t have...
2015-09-25
14 reads
SQL Server SSIS: ReplaceNull
One of widespread problems in SSIS packages is to replace NULL values with some specific value. Unfortunately, before it was...
2015-09-25
1,332 reads
Azure Virtual Machine Blog Series – Changing the size of a VM
I’m starting a new blog series on Microsoft Azure Virtual Machines, and my goal is to write blog posts exclusively on...
2015-09-30 (first published: 2015-09-24)
2,811 reads
I Was Once a Very Crappy Carpenter + SQL Bolts to Buzzwords
Tonight I spoke to Dr. Alkadi's CMPS 411 class, which was hijacked by the Hammond .NET User Group onsite at...
2015-09-24
670 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