SQL Server 2012 and 2014 and Windows 8.1 Professsional CPU goes up to 100% all freezes and Analysis Services Crashes
<p>Hi All This is a note that I just sent out. I hope that this helps those contemplating upgrading to...
2014-03-24
1,117 reads
Using Variables and Parameters SSIS
When creating an SSIS package it is always a best practice to use variables, and parameters in 2012, to avoid...
2014-03-24
444 reads
Using Variables and Parameters SSIS
When creating an SSIS package it is always a best practice to use variables, and parameters in 2012, to avoid...
2014-03-24
2,628 reads
SQL Server Enterprise is Cheaper than Standard
Free Month of Plural Site
I'm interested in seeing your responses. Any relevant response will be accepted and a free month...
2014-03-24
1,499 reads
Common Table Expressions in SQL
In SQL Server 2005, Microsoft introduced the Common Table Expression (CTE). CTEs share similarities with VIEWS and derived tables, but...
2014-03-23
1,625 reads
CISSP and Enterprise Architecture
CISSP and Enterprise Architecture
One topic that professionals pursing Enterprise Architecture roles should focus on is security. Enterprise Architects are responsible...
2014-03-22
769 reads
The T-SQL ROW_NUMBER() Function
If you learn one new T-SQL (i.e., Microsoft SQL Server) concept today it should be ROW_NUMBER(). Introduced in SQL 2005,...
2014-03-22
2,977 reads
Index Scripting with Powershell
I’ve been actively seeking out opportunities to do more stuff with Powershell of late.
I had wanted to script out only...
2014-03-21
4,084 reads
Webinar Q&A: Getting Started With Analysis Services
I recently presented a free webinar for Pragmatic Works Free Training on the T’s about Getting Started With Analysis Services....
2014-03-21
1,449 reads
Reblog: March 14 to March 20
Photo credit – JStove
Old posts are like unicorns. You might see them just once, but it’d sure be nice to have...
2014-03-21
384 reads
Blogs
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...
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