How to easily automate SQL Code Guard.
It may happenthatyou have a needto check thescripts thatyou have on yourdisk. For example, it may be part of yourbuildprocess.So how...
2014-06-02
1,850 reads
A quicker way to know when DBCC CHECKDB last ran in your database.
Problem : Surely you have scheduled jobs to run DBCC CHECKDB across your SQL Servers to check database integrity. But sometimes...
2014-06-01
956 reads
Building The SQLSaturday Orlando Marketing Plan-Part 16
As you can see my third attempt on Fiverr didn’t work out great. I asked for something bold/high contrast and...
2014-05-31
1,068 reads
Deferred-drop tipping point
I was intrigued by the deferred-drop feature that has been inside SQL since SQL Server 2000 SP3 after watching one...
2014-05-31
1,771 reads
MDX #41–Remove employees with less than $100,000 sales
Table of contents
Need to remove employees who have zero sales amountCreate a calculated measure with the IIF() function The NON...
2014-05-30
1,489 reads
SQL #54–Casting numbers with white spaces as Integer will fail
Table of contents
IsNumeric() funciton is too forgivenUse Pattern Matching with LIKE keywordLIKE keyword in T-SQL doesn’t support regular expressionReplace white...
2014-05-30
1,544 reads
Implementing Checkpoints – To restart SQL Server Integration Services packages from the point of failure
An SQL Server Integration Services package often includes tasks that can take a long time to run. If the package...
2014-05-30
1,304 reads
SQL Server 2005/2008/2008R2: HTTP endpoints
You can use an HTTP endpoint to allow access to data over HTTP and Secure Sockets Layer (HTTPS) without needing...
2014-05-30
1,447 reads
Types of Join in SQL Server
You use a join to combine data from different tables into a single result set. Joins most commonly use foreign...
2014-05-30
1,630 reads
SQL Server: Database Design Basics
In this article, you will learn about database design concepts. The database design concepts discussed in this article focus almost...
2014-05-30
1,714 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