I asked this question myself: Is there a way to use Extended Events to capture the T-SQL of a prepared statement? Why would I be concerned with prepared statements?...
2020-07-15 (first published: 2020-07-06)
348 reads
I’ve started to add a daily coping tip to the SQLServerCentral newsletter and to the Community Circle, which is helping me deal with the issues in the world. I’m...
2020-07-06
23 reads
You can read about all the new role based qualifications from Microsoft here – https://www.microsoft.com/en-us/learning/certification-overview.aspx Today I want to talk about the Azure Data Engineer one from my experience...
2020-07-06
47 reads
It’s the eve of the Fourth of July, when the Declaration of Independence is celebrated in the US. I’ve always like this holiday, but lately I find myself less...
2020-07-03
23 reads
I’ve started to add a daily coping tip to the SQLServerCentral newsletter and to the Community Circle, which is helping me deal with the issues in the world. I’m...
2020-07-03
19 reads
No, not that kind of volume! Over the past couple of blog posts, I have been talking about the versatility of deploying SQL Server with Docker. This combination is...
2020-07-03
16 reads
No, not that kind of volume! Over the past couple of blog posts, I have been talking about the versatility of deploying SQL Server with Docker. This combination is...
2020-07-13 (first published: 2020-07-03)
866 reads
Introduction Jennifer Stirrup is a data strategist and technologist, Microsoft Data Platform Most Valuable Professional (MVP), Microsoft Regional Director, Microsoft Certified Trainer, founder of Data Relish Ltd, diversity and...
2020-07-02
86 reads
My Pluralsight course for new SQL Server DBAs (Needs to upgrade to a bigger bowl) Common scenario: Company is using SQL Server Express to save on licensing costs...
2020-07-02
243 reads
I’ve started to add a daily coping tip to the SQLServerCentral newsletter and to the Community Circle, which is helping me deal with the issues in the world. I’m...
2020-07-02
14 reads
By James Serra
Microsoft shared a broad set of Fabric, Power BI, and SQL updates at FabCon...
By Steve Jones
No, I’m not quitting or retiring. Just going on vacation, but I leave tonight...
Comments posted to this topic are about the item Let's Talk Certifications, which is...
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