Making Databases Personal
If you can use a database to create automation routines to help sustain your work life, you can certainly do the same to sustain your personal life. Databases are...
The...
2019-04-09
The Lighter Side
SpaceX likely to win NASA’s crew competition by months, for billions less
What lessons can the space agency learn as it considers a lunar return?
2019-04-08
2006-12-25
3,668 reads
2006-09-04
5,990 reads
Who Has The Monitor?
A Friday distraction from work when you have time. Can you figure out who has the dual 19" LCD monitors?
2006-04-28
9,458 reads
Automatic Excuses for IT Pros
Now that the novelty of the Xbox 360, the Razr cell phone, and King Kong have likely run their course, Red Gate Software presents a truly functional gift for the harried IT professional: A handy excuse generator for those projects that just don't work out as planned.
2006-01-27
4,413 reads
2005-12-23
5,637 reads
The DBA Game
Are you up for a quick game of who's the best DBA? A little humerous diversion on one of the big holidays in the US.
2005-11-24
9,916 reads
SQL Server on Linux
A secret project is underway up in Redmond, according to sources not so high up in the development team. A port is partially working for various reasons. Read this exclusive scoop!
2015-12-25 (first published: 2005-04-01)
48,186 reads
HIGHER SOURCE RAISES STAKES IN INTERNET INDUSTRY
Microsoft Corporation has announced plans to acquire the
Website and Internet development corporation Higher Source for an
undisclosed fee.
2005-04-01
2,383 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