To the page and back again
To the page
It’s not one of those things you have to do frequently but every now and again you need...
2016-01-18
548 reads
Getting Started with Change Tracking in SQL Server
Change tracking for SQL Server is a flexible and easy-to-use technology for monitoring tables for inserts, updates, and deletes. In...
2016-01-18
1,088 reads
SQLSaturday Austin – Jan 30th
I will be speaking with other SQL Server experts for SQLSaturday #461 in Austin on Jan 30th, 2016. This is...
2016-01-18
476 reads
SQL From South West to Scotland : SQLSaturdays #496 & #502
I’m happy, honoured and humbled to be able to say that I will be presenting pre-cons and both SQL Saturday...
2016-01-17
410 reads
Troubleshooting SQL Server Operating System Error 995
Operating System Error Message
Error: 18210, Severity: 16, State:1
BackupMedium::ReportIoError: write failure on backup device ‘VDI_ DeviceID ‘. Operating system error 995...
2016-01-16
14,928 reads
Chips and Margaritas at SQL Saturday #461
It was a few years back that my wife and I planned a trip to the Austin City Lights music...
2016-01-15
636 reads
T-SQL for UDFs
SQL Server has plenty of built-in functions, but sometimes we just have to combine some of them to create functions for our purposes. Such one, for example, is the function...
2016-01-15
19 reads
T-SQL for UDFs
SQL Server has plenty of built-in functions, but sometimes we just have to combine some of them to create functions for our purposes. Such one, for example, is the function...
2016-01-15
12 reads
T-SQL for UDFs
SQL Server has plenty of built-in functions, but sometimes we just have to combine some of them to create functions for...
2016-01-15
119 reads
Flexibility of T-SQL for designing user defined functions
SQL Server has plenty of built-in functions but sometimes we just have to combine some of them to create functions for...
2016-01-15
88 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