Tools For Successful Remote Working
I’ve been asked a few times recently how I find remote working and how well it works so I thought...
2014-10-13
46 reads
Creating a Reporting Services Subscription
Subscriptions are a great feature in Reporting Services that will run a report unattended and deliver it to users either...
2014-10-20 (first published: 2014-10-13)
8,089 reads
SQL Saturday Minnesota Precon 10/24 – Virtualization for SQL Server DBAs
Coming soon is the SQL Saturday #332 in Minneapolis, MN on October 25th, with my preconference training session on Friday, October 24. I am really looking forward to...
2014-10-13
1,155 reads
Creating a Reporting Services Subscription
Subscriptions are a great feature in Reporting Services that will run a report unattended and deliver it to users either...
2014-10-13
1,075 reads
Final Prep for SQL in the City
I can’t believe this will be the fourth SQL in the City in London next week. It’s amazing to me...
2014-10-13
934 reads
Configure SQL Server Database Mirroring
1) Take Full backup of database at Principle Server
BACKUP DATABASE USERDB1 TO DISK = ‘H:USERDB1.BAK’
2) Take Log Backup at Principle Server
BACKUP...
2014-10-17 (first published: 2014-10-13)
15,974 reads
My Best Technical Sites and Blogs
Many times my friends ask me which technical sites they should refers for finding the solutions, so below is the...
2014-10-12
1,487 reads
Navel Gazing
I love negative feedback. Well, not really. I love constructive feedback. I love the feedback that gives me things to...
2014-10-17 (first published: 2014-10-12)
6,605 reads
SQL Server proxy account and local policy
Originally posted on Peter's blog:
If a user is a member of Sysadmin server role of SQL Server 2005, the...
2014-10-11
1,309 reads
Reblog: October 3 to October 9
Photo credit – Travis
Ever go digging through your backyard for dinosaur bones? Maybe not, but it’s worthwhile from time to time...
2014-10-10
969 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