MSSQLTips.com Rookie of the year 2018
You need a lot of hard work for success!2018 was a good year for me in a lot of areas...
2019-01-21
257 reads
Easy Permissions Audit
This is an introductory level method demonstrating how to quickly audit database objects and principals for granted permissions.
Related Posts:
Failed to Create the Audit File December 31, 2017
Quick Permissions...
2019-01-21
21 reads
Easy Permissions Audit
Something I have written about more than a handful of times is the need to audit. When people think about...
2019-02-05 (first published: 2019-01-21)
2,592 reads
Read-only tables
Sometimes you need a table that is read only. You don’t want anyone to be able to write to it...
2019-02-05 (first published: 2019-01-21)
2,674 reads
Memory Grants part 4: The Resource Semaphore
Part of query memory grants, part 4! This post will cover the wait type RESOURCE_SEMAPHORE briefly, but the focus is...
2019-01-21
1,222 reads
What could you achieve with 60% more time?
Regardless of your job or industry, do you ever have enough hours in the day to get everything done? If...
2019-01-21
212 reads
Move database between drives
SQL server Move user database steps and scripts:...
[[ This is a content summary only. Visit my website for full links, other content, and more! ]]
2019-01-21
28 reads
Move database between drives
AdvertisementsSQL server Move user database steps and scripts:
Check you have a free space on the moving drive and make sure...
2019-01-21
264 reads
Azure SQL Database – Reduce the workload before initiating another service objective update
Getting straight to the point, I initiated a very common task recently, another scale up request. However, a new message...
2019-01-21
240 reads
Things I Wish I Knew When I Started
Way back in August, Matt Cushing (blog|twitter) was preparing to teach and asked for a list of “what do you wish you’d known when you started” items that he...
2019-01-21
26 reads
Blogs
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...
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
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