SQL Server perfmon counters provide a wealth of information about performance. In this article, Fabiano Amorim shows how current wisdom about one counter, SQL Compilations/sec, can sometimes be misleading.
2021-08-20
During database development, as well as writing SQL, you must also write the tests that prove your SQL code meets all the requirements. The article will help you get started with database testing for your SQL Server databases, by creating and running unit tests against them, as well as static code analysis tests.
2021-08-20
Learn how to use the CData MySQL connector to access data across SSH.
2021-08-18
956 reads
Instant file initialization can speed up database creation, file growth, and restores. Greg Larsen explains how to configure it and how it works.
2021-08-18
We're thrilled to welcome Microsoft as the Premier Sponsor at this year's PASS Data Community Summit. The Microsoft team will be a fundamental part of the conference program and activities through educational sessions, product deep-dives and announcements, Microsoft-focused workshops, keynotes, and more. We're excited to continue this relationship in support of the global data community.
2021-08-18
One of the lesser used functions is COALESCE(), used to allow you to return one value from a list of those that are potentially NULL. This short pieces gives a few examples where this is useful?
2021-08-16
4,485 reads
In this article we look at the similarities and differences for views in SQL Server, Oracle and PostgreSQL. We also look at indexed views, materialized views and updatable views.
2021-08-16
When you are using Flyway, how can you test your database migration script first to make sure it works exactly as you intended before you let Flyway execute it? Phil Factor explains.
2021-08-16
This short article explains how to quickly run SQL Server in a Docker container, for both Windows and Linux.
2021-08-13 (first published: 2021-08-11)
40,584 reads
Azure storage can be marked Private to control access. Dennes Torres explains how to query private blob storage with SQL and Azure Synapse.
2021-08-13
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