How to Build an Efficient Request Process for SQL Server DBAs
Take a look at some of these DBA request examples and things you could do to improve your request process.
2019-05-08
Articles
MDX (MultiDimensional Expressions) in 148 minutes
If you want to understand the fundamentals of MDX in less than 3 hours - this article can be helpful.
2019-05-07
11,115 reads
Using Azure Data Studio with TFVC
Azure Data Studio (ADS) is a lightweight IDE built on Visual Studio Code. I've written a few articles on how ADS works, shown here: Getting Started with Azure Data Studio Getting Comfortable Writing Code in Azure Data Studio Using Notebooks in Azure Data Studio Using Azure Data Studio with TFVC Using Azure Data Studio with […]
2019-05-07
5,553 reads
Microsoft SQL Server: Current Identify Column Value in a Table
Learn how to find the current identify column value in your Microsoft SQL Server tables.
2019-05-07
Enable SQL Server Agent Mail Profile
Learn how to configure SQL Server Agent to allow emails to be sent for job notifications and alerts.
2019-05-06
The BI Journey: The Expert’s Advice – Part 2
A BI project should return value to the company quickly, not only after months or even years of work. In this article by Gogula Aryalingam, Ruthie, the intern, determines which items from her manager's requirements she can complete before the big meeting. She continues working on her semantic model by including a Date table, the star schema, measures, formatting, and more.
2019-05-06
The Difference Between Rollup and Cube
Learn about the fundamental differences between the ROLLUP and CUBE operators.
2019-05-03 (first published: 2017-11-30)
87,652 reads
Change Not For Replication Value for SQL Server Identity Columns
In this tip we look at how to change the SQL Server setting for a tables identity column to not for replication for existing tables.
2019-05-03
Designing Highly Scalable Database Architectures
While architecting cloud native applications, you need to ensure that your system is highly available, performant, scalable, fault tolerant, and has the capability to recover from a disaster scenario. In this article, Samir Behara discusses the options available when designing the database architecture to achieve scalability.
2019-05-03
A Self-Serve System that Allows Developers to Refresh Databases (Part 1)
Empower developers to refresh their own test systems with production backups.
2019-05-02
6,826 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