Overview of the SQL Update statement
In this article, we’ll walk-through the SQL update statement to modify one or more existing rows in the table. After reading...
2018-10-08
311 reads
Four tools to help implement Database Continuous Delivery
“We don’t want to know that it’s broken, just that it’s working.” “We want our database to always be available.”...
2018-10-08
438 reads
Database Fundamentals #19: JOINS
The last Database Fundamentals post introduced the SELECT and FROM commands. We’re going to start using JOIN operations shortly, but...
2018-10-22 (first published: 2018-10-08)
2,970 reads
Powershell One Liners: Get status of SQL Instances on All SQL Servers
# Assuming you have list of servers in servers.txt, each sever name in its own line
$ComputerNames=get-content servers.txt
Get-WmiObject -Query "select * from win32_service where...
2018-10-08
219 reads
Interviewing for your first tech job – slides
I was lucky to get an opportunity to present a session to some college students at Seminole State College in Florida last week. I was in town for SQL...
2018-10-08
26 reads
SQL Server monitoring with built-in features
Do you think you need to use commercial tools like SQL Diagnostic Manager, SQL Sentry, Spotlight etc.. ? Or do you think...
2018-10-07
479 reads
MongoDB-CHICAGO .Local
Continue to my interest on MongoDB Blog lastly on MongoDB 4.02, I attended MongoDB CHICOGO .local Sep 12 and learned so...
2018-10-06
224 reads
Don’t believe the myth TRUNCATE TABLE isn’t logged
Remember the Bill Gates email hoax? The one that claims to be some sort of Microsoft beta test saying Gates is going to pay cash money to anyone who...
2018-10-05
19 reads
Moving SQL Server 2008 and 2008 R2 clusters to #Azure for Extended Support
Earlier this year Microsoft announced extended support for SQL Server 2008 and 2008 R2 at no additional cost. However, the...
2018-10-05
61 reads
Walmart Chose Azure, How About You?
Another major corporation has announced their decision to move to Azure. Perhaps you’ve heard of them? Walmart—yes, Walmart and Microsoft...
2018-10-05
291 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