PASS Data Architecture VC presents Mike Fal: SQL Server Table Partitioning
Thursday’s (May 17th, 2012) PASS Data Architecture Virtual Chapter has Mike demonstrating some cool Table Partitioning scripts which I was...
2012-05-14
559 reads
Blog Posts
SQL Rally 2012 Recap
Much Learning Was Had By All
SQL Rally 2012 had a diverse group of speakers and something for all levels of...
2012-05-14
856 reads
SQL Server – Check SQL Agent Job History using T-SQL
To check SQL Server Agent Job History you can use the Log File Viewer from SQL Server Management Studio.
To Open...
2012-05-14
2,863 reads
The Effective Permissions Tool is Handy
An recurring issue with Integration Services packages that read or write to file systems is permissions issues. It's quite difficult...
2012-05-14
1,080 reads
The Effective Permissions Tool is Handy
An recurring issue with Integration Services packages that read or write to file systems is permissions issues. It's quite difficult to have a package run properly when it can't...
2012-05-14
34 reads
Varied and Interesting Links
Here are some things I’ve run across in the past few weeks you may find interesting:
FailCon. Billed as a one-day...
2012-05-14
581 reads
We Need More Folks in Technology, Period.
I took my boys to a game design workshop on Saturday that was sponsored and put on by an organization...
2012-05-14
1,287 reads
Chance to win a free seat in my SQL Server 2012 Deep Dive Days workshop in London!
As you might know, I'm
running my "SQL Server 2012 Deep Dive Days Workshop" from May 28
– 30 in Central London....
2012-05-13
967 reads
Denali – Day 13: FileTable
Denali – Day 12: FileTable
“FileStream” is introduced in sql server 2008, for storing BLOB data like varbinary(max), it is integrated...
2012-05-13
905 reads
Denali – Day 12: More Manageability Features
Denali – Day 12: – More Manageability Features:
-K switch
With new feature added in an engine to use that feature with different way...
2012-05-12
1,203 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