Building a SQL Server Fleet Audit That Leadership Actually Reads
Learn how to build a report that shows the health of your database estate that your leadership will read and use.
2026-10-07
1,208 reads
Learn how to build a report that shows the health of your database estate that your leadership will read and use.
2026-10-07
1,208 reads
SQL databases are crucial for businesses, so it's critical to back them up. A dependable and affordable option is offered by Azure Blob Storage. Let's examine the advantages, the steps involved in backing up to and restoring from a device, recommended practices, and more.
2023-09-15
12,303 reads
Learn how you can back up your SQL Server 2022 databases to Google Cloud Storage.
2023-01-30
4,962 reads
2022-09-02 (first published: 2022-08-23)
11,312 reads
In this article we look at different SQL Server backup types and schedules and the steps to take to properly restore a database.
2021-07-12
Without a good backup and recovery strategy in place, a DBA should make sure their resume is always up to date. In this article, Greg Larsen discusses what should be considered when developing a backup plan.
2020-12-17
One of the most important responsibilities for a DBA is to ensure that a database can be restored in case of corruption, a dropped table, or another disaster. In this article, Greg Larsen explains the different types of backups available with SQL Server.
2020-12-01
By SQLPals
How to Clear the SSMS Cache (SSMS 21 and Later) Updated...
By Arun Sirpal
“What exactly did it do on my server?” is the first question a DBA...
By James Serra
Microsoft shared a broad set of Fabric, Power BI, and SQL updates at FabCon...
Comments posted to this topic are about the item Let's Talk Certifications
Comments posted to this topic are about the item The Hidden Security Risks of...
Comments posted to this topic are about the item 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