2019-12-03
Articles
What’s in that database? Getting information about routines
There is a lot of information held in SQL Server metadata about your SQL Server procedures, triggers, views and functions. Some of it is valuable, other nuggets are useful and a few are rather dull but worthy. It really all needs to be tied together to tell the full story, especially if you are not able to, or do not want to, query the metadata directly.
2019-12-02
View R Plots from within SQL Server Management Studio
Describes how to view R plots in SSMS and gives a brief introduction to R plotting
2019-11-29 (first published: 2017-05-08)
6,258 reads
Power BI Filter Pane
Data Filtering | Configurations - In this tip we look at a new feature in Power BI that allows users to filter data in Power BI reports using the new Filter Pane.
2019-11-29
The Road to Database CI
One firm's journey on the road to mastering (or at least attempting) continuous database integration.
2019-11-28 (first published: 2017-05-17)
3,978 reads
Accelerating Database Recovery with SQL Server 2019
Learn how to turn on and use newer SQL Server database recovery option called “Accelerated Database Recover”. Read on....
2019-11-28
Finding Correlated Rows Using EXISTS or COUNT
Should you always use EXISTS rather than COUNT when checking for the existence of any correlating rows that match your criteria? Does the former really offer "superior performance and readability". Louis Davidson investigates.
2019-11-28
Introduction to DevOps: 10 Guidelines for Implementing DevOps
In this last article in the series, Robert Sheldon discusses ten guidelines that will help organisactions implement DevOps successfully.
2019-11-27
Moving Encrypted Data to Azure SQL Database
Learn how you can move encrypted data from on premises SQL Server to Azure SQL Database.
2019-11-26
2,546 reads
Introduction to the Partition By Window Function
Window functions can be life savers by making a complicated SQL calculation easy. A window function combines that logic and provides row by row or window by window feedback. Read on to learn more!
2019-11-26
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