Running tSQLt tests from C/VB.Net/Java/Whatever
When you already have a test framework setup such as MSTest or NUnit and possibly a CI build in place and you want to add Sql Server tests it...
2014-11-20
17 reads
Running tSQLt tests from C/VB.Net/Java/Whatever
When you already have a test framework setup such as MSTest or NUnit and possibly a CI build in place...
2014-11-20
26 reads
Running tSQLt tests from C/VB.Net/Java/Whatever
When you already have a test framework setup such as MSTest or NUnit and possibly a CI build in place...
2014-11-20
56 reads
Running tSQLt tests from C/VB.Net/Java/Whatever
When you already have a test framework setup such as MSTest or NUnit and possibly a CI build in place...
2014-11-20
67 reads
Clustered Columnstore Indexes – part 43 (“Transaction Log Basics”)
Continuation from the previous 42 parts, starting from http://www.nikoport.com/2013/07/05/clustered-columnstore-indexes-part-1-intro/
This post is dedicated to the Transaction Log behaviour, which might explain...
2014-11-19
430 reads
SQL Konference 2015
My first speaking date of the new year is scheduled. I’ll be at the SQL Server Konference 2015, near Frankfurt,...
2014-11-19
870 reads
How to determine Meta data or result set information of a stored procedure /trigger ? TIP # 73
Sometimes it may require that you don’t know what will be output of a stored procedure ? what kind of result...
2014-11-19
475 reads
T-SQL Tricks – Custom Templates
I wrote about the Template Explorer, which comes with the SQL Server tools and is visible in Management Studio (SSMS)....
2014-11-25 (first published: 2014-11-19)
8,351 reads
Fast Track Data Warehouse Reference Architecture for SQL Server 2014
I have previously blogged about the Fast Track Data Warehouse, a reference configuration optimized for data warehousing (see Microsoft SQL Server...
2014-11-19
1,628 reads
You don’t really need ORDER BY do you?
You see dozens of blog posts and articles about how the order of a result set is not guaranteed without...
2014-12-01 (first published: 2014-11-19)
9,670 reads
Blogs
How to Clear the SSMS Cache (SSMS 21 and Later)
By SQLPals
How to Clear the SSMS Cache (SSMS 21 and Later) Updated...
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...
Forums
Let's Talk Certifications
Comments posted to this topic are about the item Let's Talk Certifications
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