Locks, Blocks, and Deadlocks Oh My!
Abstract Managing concurrency is one of the most challenging aspects of working with any enterprise DBMS. There is much confusion out there about locking, blocking, and deadlocks. In this...
2014-02-12
14 reads
Locks, Blocks, and Deadlocks Oh My!
Abstract
Managing concurrency is one of the most challenging aspects of working with any enterprise DBMS. There is much confusion out...
2014-02-12
839 reads
Powershell in a Month Day 16 – Working with many objects
This is part of my Powershell Challenge, to learn more about PowerShell (PoSh) using the Learn Windows Powershell 3 in a Month...
2014-02-12
1,156 reads
On Why Titles Don’t Matter
The chief executive of eClinicalWorks says he guards against “title warfare” at his company, saying that new job titles “get...
2014-02-12
274 reads
Does Your Company Make You a Better Person?
Successful organizations place personal development front and center.
from HBR.org http://ift.tt/1aq03xy
via IFTTT
2014-02-12
391 reads
Interest In SQL Server Seems To Be Declining?
Amusing myself for a minute at Google Trends. Anyone missing 2005?
2014-02-17 (first published: 2014-02-12)
3,558 reads
Don’t Forget About the Second Shot
Photo credit – Dennis Wong
A couple weeks back, in a post on certifications, I mentioned the Second Shot offer from Microsoft...
2014-02-12
561 reads
Say “No” to Innovation-in-General #innovation
You need to get specific if you’re going to get anything done.
from HBR.org http://ift.tt/LYdfPk
via IFTTT
2014-02-12
254 reads
Scaling SQL Server 2014 Pre-Con in Copenhagen
I will be travelling to Copenhagen, Denmark to deliver a full day pre-con for SQLSaturday #275 on Friday, March 28,...
2014-02-12
965 reads
SQL Server 2014 and the New Cardinality Estimator
Cardinality, basically the number of rows being processed by an operation with the optimizer, is a calculation predicated on the...
2014-02-12
1,176 reads
Blogs
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...
Au Revoir for now
By Steve Jones
No, I’m not quitting or retiring. Just going on vacation, but I leave tonight...
Forums
Let's Talk Certifications
Comments posted to this topic are about the item Let's Talk Certifications, which is...
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