DBA supertech . Specialise or generalise?
Specialise or a generalise? It all depends on how you define these terms.
A SQL Server DBA may be considered to...
2012-03-13
757 reads
Blog Posts
Houston Area SQL Server User Group Presentation
Thanks to everyone who attended my presentation “Scaling SQL Server to HUNDREDS of Terabytes” at HASSUG.
Here is the PowerPoint presentation: Scaling SQL...
2012-03-13
721 reads
Parsing T-SQL – The easy way
UPDATE 2012-09-12 : For my latest adventures with TSQL Parsers please see this post
Every once in a while, I hit an issue...
2012-03-13
11,096 reads
SQL Server 2012 Books
SQL Server 2012 was released to manufacturing last week, you can download it from MSDN if you have subscription or...
2012-03-13
2,185 reads
Synchronizing subscriptions in SQL Server Express
I was recently asked about synchronizing a Merge pull subscription in SQL Server Express using RMO, the lack of a...
2012-03-13 (first published: 2012-03-12)
4,331 reads
T-SQL Tuesday #028 - I'm a Jack of All Trades, and Proud of It
If I wasn't, would I have proposed the following topic for several speaking chances, including SQLRally?
Being a specialist means you're...
2012-03-13
1,467 reads
T-SQL Tuesday #028 – Is it really specialization?
This is the first time I've participated in T-SQL Tuesday - I hope to do so more often...
I can recall several...
2012-03-13
1,029 reads
T-SQL Tuesday #028 – Jack of All Trades ie Integration Specialist
Argenis Fernandez (blog | twitter) is hosting the latest T-SQL Tuesday and asking about specialization. For the earlier part of my career I was doing application development while really...
2012-03-13
24 reads
T-SQL Tuesday #028 – Jack of All Trades ie Integration Specialist
Argenis Fernandez (blog | twitter) is hosting the latest T-SQL Tuesday and asking about specialization.
For the earlier part of my career...
2012-03-13
698 reads
T-SQL Tuesday #028 – Jack of All Trades, Master of None?
Every month the folks of the SQL Server community get together for a virtual block party of sorts called T-SQL...
2012-03-13
699 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