SQL Server 2016 available June 1st!
Woo hoo! Microsoft has announced that SQL Server 2016 will be generally available on June 1st. On that date all four...
2016-05-02
665 reads
PowerSehll : How to suppress the table heading and remove the blank space from a text file
There are a multiple ways to suppress and remove the first line from text file. The first scenario would be writing...
2016-05-02
7,830 reads
How to Convince the Boss to Send You to PASS Summit
August two years ago I originally posted, Make the PASS Summit Work for Your Employer. After conversations at several SQL...
2016-05-02
998 reads
Remove files from a filegroup
You have a database with one or more filegroups, and one or more of those filegroups has multiple files. You’ve...
2016-05-02
1,666 reads
SQL 2016 - The Time Has Come!
Microsoft dropped it on us this morning:
Get ready, SQL Server 2016 coming on June 1st
https://media.makeameme.org/created/yes-finally.jpg
I read the article and was...
2016-05-02
937 reads
Why you should think about upgrading to SQL Server 2016!
SQL Server 2005 is out of support and you might be (Or rather, you should be) planning an enterprise wide upgrade of SQL Server. Are you thinking of upgrading...
2016-05-01
10 reads
Why you should think about upgrading to SQL Server 2016!
SQL Server 2005 is out of support and you might be (Or rather, you should be) planning an enterprise wide...
2016-05-01
3,092 reads
SQL Server 2005 Modernization Checklist
As Bala Narasimhan from PernixData and I discussed in a webinar last week, SQL Server 2005 hit end of it’s...
2016-05-01
555 reads
Power BI Box and Whisker visualization vs. Box Plot chart in SSRS
[2016-Apr-30] I don't work with box plot charts very often, however when I do then it becomes a very interesting experience. First,...
2016-04-30
4,364 reads
3 Things I Wish I Knew When I Started Using Entity Framework
Entity Framework (EF) is Microsoft's object-relational-mapping tool (ORM) that allows programmers to easily map database objects to C# object models. What attracts developers to Entity Framework is the automatic...
2016-04-30
18 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