PASS Board 2016: Update #3
I didn’t post an update last month, but I did do something more important: I elicited your feedback on a question...
2016-05-23
396 reads
Master_Views: master_objects, master_tables, etc
There is a highly useful system view called sys.master_files. If you’ve never encountered it before it returns a list of...
2016-06-01 (first published: 2016-05-23)
1,588 reads
The Road to SQLSaturday Orlando – 2016
This year I’ll blog sporadically on the event, focusing on pain points, discoveries, and new ideas with the occasional progress...
2016-05-23
429 reads
How Do I Change My Domain Password on Windows Server 2012?
As a DBA I spend a lot of time in RDP sessions, both to SQL Servers and to "jump"/pass-through servers...
2016-05-23
5,986 reads
SQL Server Random Workload Generator
Hello Dear Reader! Before I start this blog I want to give credit to Jonathan Kehayias (@SQLPoolBoy | Blog). He’s an Microsoft Data Platform MVP, MCM, part of the...
2016-05-20
10 reads
SQL Server Random Workload Generator
Hello Dear Reader! Before I start this blog I want to give credit to Jonathan Kehayias (@SQLPoolBoy | Blog). He’s an...
2016-06-01 (first published: 2016-05-20)
2,205 reads
SQL Server Exercise for Data Warehouse Candidates
Background
Part of the process when looking for candidates to bring into a data warehouse team is to ensure that you hire...
2016-05-30 (first published: 2016-05-20)
2,604 reads
Simple Way to Decrypt SQL Server Stored Procedure
When stored procedures are created in SQL Server, their entire text body is accessible to all those who have the...
2016-05-20
51,696 reads
Objects dependency check up
It’s a very good practice that you check the dependencies of the other objects when you change an object. Many...
2016-05-20
419 reads
Objects dependency check up in SSMS
It’s a very good practice that you check the dependencies of the other objects when you change an object. Many developers just don’t do it, even when the change(s)...
2016-05-20
10 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...
FARE LABS Pvt. Ltd. is a Proficiency testing laboratory located in India.
The top proficiency testing facility in India is Fare Labs. We employ particular metrics...
The Hidden Security Risks of Role Combination in SSAS Tabular
Comments posted to this topic are about the item The Hidden Security Risks of...
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