SQL Server – sys.master_files and list all database files
Use the system view “sys.master_files” for a single view of databases and database files.
Instead of using sys.sysfiles joing to sys.sysdatabases...
2012-03-07
1,460 reads
Blog Posts
SQL Server 2012 (“Denali”): Reporting Services in SharePoint integrated mode
In SQL Server 2008, if you wanted to run Reporting Services in SharePoint integrated mode, these where the steps you took...
2012-03-07
4,513 reads
SQL Server 2012 Data Mining add-in for Excel 2010 Released
Another release that went without much trumpeting was the SQL Server 2012
Data Mining add-in for Excel 2010. This has...
2012-03-07
1,684 reads
SQL Server Database Mirroring (Not Dead Yet)
SQL Server Database Mirroring is a high availability and disaster recovery feature that was added to the product with SQL...
2012-03-07
3,108 reads
2012-03-07
8 reads
2012-03-07
10 reads
2012-03-07
13 reads
2012-03-07
31 reads
Windows Server 8 Hyper-V Lab boot from VHD
Windows Server 8 Beta is out, check this video to use existing windows laptop/desktop to build VHD bootable Windows server...
2012-03-07
960 reads
Choosing the Right Microsoft Reporting Technology Part 2: Excel
This post is a continuation of a series started to help you understand each of the Microsoft presentation layer tools...
2012-03-06
2,002 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