2018-11-20
774 reads
Articles
Installing SQL Server 2019 CTP 2.0
Greg Larsen offers detailed instructions on how to install SQL Server 2019 CTP 2.0.
2018-11-20
2,371 reads
2018-11-19
3,244 reads
What Is SQLPSX?
SQLPSX is a useful library you can add to PowerShell to automate many DBA tasks. In this article, Laerte Junior demonstrates several useful commands and shows you how to create a SQL Agent job using this library to run daily DBA checks.
2018-11-19
3,347 reads
Batch Mode For Row Store: What Does It Help With?
Considering SQL Server 2019? Erik tells you what kinds of queries will get the biggest performance improvements.
2018-11-16
2,401 reads
T-SQL Decommenter Part II
Demonstration of the T-SQL Decommenter removing comments from a sample T-SQL batch.
2018-11-15
973 reads
SOX and Database Administration – Part 3
Database administrators are typically responsible for the security and availability of financial data. In this article, Robert Sheldon discusses SOX, passed in 2002, that governs financial data of publicly traded companies in the US.
2018-11-15
2,359 reads
CosmosDB Change Feed Processing
This article was created to help readers understand CosmosDB change feed processing.
2018-11-13
1,863 reads
Overview of In-Memory Technologies of Azure SQL Database
Azure SQL Database offers a straightforward approach to controlling its performance through vertical scaling. Despite its simplicity, scaling up has obvious pricing implications and, while it is an online operation, it might result in rollback of in-flight transactions. If you are looking for a supplemental approach to enhancing performance, then you might want to consider implementing in-memory technologies which are part of the Azure SQL Database feature set.
2018-11-13
2,109 reads
Linear barcodes in SSRS using the Barcode Image Generation Library
The open source Barcode Image Generation Library enables insertion of twenty-seven different types of linear barcode symbols into SSRS reports without the use of barcode fonts.
2018-11-12
12,249 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