SQL Exercise During Candidate Interview Process
A discussion of how BPS uses a SQL exercise for candidates and why it is helpful.
At the Boston Public Schools,...
2011-06-01
2,714 reads
Start All Your Meetings in Pole Position
Let’s face it, a lot of us don’t enjoy attending meetings and can often find them to be a bit...
2011-05-31
1,832 reads
Free SQL Exam cram sessions from Microsoft.
G’day,
I’m a big fan of maintaining and updating your technical skills, but sometimes its difficult to measure your ability at...
2011-05-31
2,949 reads
Taking It to the Extreme: SQLCLR and Parallelism - a NYC event coming soon!
Here’s another awesome SQL event coming to New York City. (Keep reading for your discount below!) It’s already getting hot...
2011-05-31
2,361 reads
An Unexpected Service Gotcha
Recently I was participating in a round of storage rearranging with a client (aka the storage dance) which consisted of...
2011-05-31
1,571 reads
SQLSaturday #85 in Orlando!
It’s that time of year again, actually a little earlier than in previous years as we’ll be holding our fifth...
2011-05-31
1,499 reads
Use Connections Properly in an SSIS Script Task
There are lots of scenarios in SSIS where you'd want to use a connection within a Script Task. Unfortunately, the closest help documentation - the comments inside the Script...
2011-05-31
15 reads
Use Connections Properly in an SSIS Script Task
There are lots of scenarios in SSIS where you'd want to use a connection within a Script Task. Unfortunately, the closest help documentation - the comments inside the Script...
2011-05-31
2,790 reads
Identity Reseeding
I love the identity property. I use it in many of my tables, mostly because it gives me a fairly...
2011-05-31
2,448 reads
What Encryption Algorithms Are You Using?
Security is an important consideration when designing a database application. Who can get access to what data? How much damage...
2011-05-31
2,141 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