2014-12-25 (first published: 2014-12-04)
1,133 reads
Scripts
PowerShell Query to remove backup folders against multiple servers
Remove backup folders from multiple servers.
2014-12-23 (first published: 2014-12-09)
646 reads
2014-12-22 (first published: 2014-11-23)
1,240 reads
DB memory/RAM consumption
This script is used to get the memory or RAM consumption for the database(s).
2014-12-19 (first published: 2014-11-20)
2,810 reads
2014-12-12 (first published: 2014-11-19)
1,128 reads
dbWarden - Purge old data
helps you manage dbWarden history.
No warranty given it will do what you expect, so test it !
2014-12-11 (first published: 2014-11-19)
1,016 reads
2014-12-08 (first published: 2014-11-18)
1,386 reads
2014-12-04 (first published: 2014-11-17)
1,450 reads
2014-12-02 (first published: 2014-11-12)
2,302 reads
Create Table At Runtime
With the help of this script we can generate Create Table Script At Run Time.
2014-11-27 (first published: 2014-11-06)
1,186 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