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
Intel Xeon E5-2600 Series Processors Released
Yesterday, Intel finally released the much anticipated Xeon E5-2600 family of processors, also known as Sandy Bridge-EP. This is a...
2012-03-07
1,244 reads
Physical or Virtual
Today I get to share something that has been on my someday list for quite some time. I have planned on getting a solution that involves TSQL to help...
2012-03-07
18 reads
Physical or Virtual
Today I get to share something that has been on my someday list for quite some time. I have planned...
2012-03-07
2,143 reads
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
PowerPivot 2012 RTM Release
Somewhat overshadowed, for obvious reasons, by the big RTM release of SQL Server 2012 was the RTM release of PowerPivot...
2012-03-07
1,190 reads
Moving MSDB to new location
In recent past we have a situation where in we required to move MSDB, Model and Master databases to new...
2012-03-06
883 reads
SQL Server 2012 RTM. Translation: SQL 12 is out now! (Virtual Launch event update)
Originally published March 6, now with Post-launch updates.
Just a quick note for you today: Microsoft announced that SQL Server 2012...
2012-03-06
999 reads
Second Chances for Plagiarism
I had an exchange with someone that had plagiarized some work recently. That’s nothing new, and I run into plagiarism...
2012-03-06
1,209 reads
2012-03-06
1,436 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