Day 6: MySQL Programs
On day 5 we understand how to install MySQL or upgrade to latest version. Today we will discuss once installation...
2018-05-06
224 reads
Blog Posts
SQL Server Trace Flags
Trace Flags are a way to change the behavior of the SQL Server database engine. They are often used for...
2018-05-06
111 reads
Avoid Errors With using SNAPSHOT Isolation From Transactions Under Different Isolation Levels
For older systems where the move to READ COMMITTED SNAPSHOT (RCSI) might not be an option or you’re running a...
2018-05-05
123 reads
Day 5: Install MySQL and Upgrade
There are multiple ways you can install MySQL, MySQL is compatible for almost all the Operating System. it would be...
2018-05-05
290 reads
Thanks for joining us at the Spring Houston Tech Fest 2018
Congrats to Michael, Eric, John, all the organizers and volunteers, and all the speakers for a successful Spring Houston Tech Fest 2018. It was a pleasure for the wife...
2018-05-05
19 reads
A rant about presentations
My company’s internal conference is in a couple of weeks, so this seems like a good time to have a...
2018-05-04 (first published: 2018-04-24)
2,380 reads
Day 4: MySQL Architecture Continue…
MySQL is an open source and configuration of MySQL is very simple and can be customized per the requirement. MySQL...
2018-05-04
280 reads
Friday Reading 2018-05-04
Phew, busy week. In the middle of updating presentations and making sure demos work!
Here’s a few of the articles...
2018-05-04
349 reads
Moving Birthdays with Data Masker
Data Masker for SQL Server is a fantastic product, and one that can reduce your attack surface area and exposure...
2018-05-04
1,142 reads
SQL Server: Database snapshots vs Database backups
In the article, we’ll walk through the concepts to understand database snapshots, and their benefits and limitations. This article will...
2018-05-04
2,328 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