Steps to create SQL database at Azure
Hi friends, in this blog we will learn how we can create the SQL database at Microsoft Azure. Login into...
2015-11-26
879 reads
Complete DAX Function Reference
The DAX function documentation in MSDN can be found on separate pages, organized by function categories and then details for...
2015-11-26
1,036 reads
Convert select statements in scripts into Inline-TVF's automatically
Update new download location is https://visualstudiogallery.msdn.microsoft.com/435e7238-0e64-4667-8980-5...
In-line TVF's are awesome, they are a great way to reuse T-SQL code without the...
2015-11-25
901 reads
Convert select statements in scripts into Inline-TVFs automatically
Update new download location is https://visualstudiogallery.msdn.microsoft.com/435e7238-0e64-4667-8980-5… In-line TVF's are awesome, they are a great way to reuse T-SQL code without the performance penalties of multi line TVF's or horror...
2015-11-25
15 reads
Convert select statements in scripts into Inline-TVFs automatically
Update new download location is https://visualstudiogallery.msdn.microsoft.com/435e7238-0e64-4667-8980-5… In-line TVF’s are awesome, they are a great way to reuse T-SQL code without...
2015-11-25
221 reads
Convert select statements in scripts into Inline-TVFs automatically
Update new download location is https://visualstudiogallery.msdn.microsoft.com/435e7238-0e64-4667-8980-5… In-line TVF’s are awesome, they are a great way to reuse T-SQL code without...
2015-11-25
222 reads
ScriptDomVisualizer - Now Displays TSqlParserToken's
New ScriptDom visualizer now also shows the tokens that are found in a sql script. It also highlights the part...
2015-11-25
968 reads
ScriptDomVisualizer - Now Displays TSqlParserTokens
New ScriptDom visualizer now also shows the tokens that are found in a sql script. It also highlights the part of the query that is covered by the token...
2015-11-25
14 reads
ScriptDomVisualizer - Now Displays TSqlParserTokens
New ScriptDom visualizer now also shows the tokens that are found in a sql script. It also highlights the part...
2015-11-25
23 reads
ScriptDomVisualizer - Now Displays TSqlParserTokens
New ScriptDom visualizer now also shows the tokens that are found in a sql script. It also highlights the part...
2015-11-25
47 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