Microsoft Security Changes and SQL Server
Windows is changing its security, which will affect SQL Server.
2026-02-14
625 reads
Windows is changing its security, which will affect SQL Server.
2026-02-14
625 reads
This is part of a few memories from the founders of SQL Server Central, celebrating 25 years of operation this month. When we started SQL Server Central, our goal was to build a great resource that helped other people advance in their careers and also made some money. Our decisions in building the site were […]
2026-02-13
129 reads
I had an idea for an animated view of a sales tool, and started to build this in PowerPoint. I decided to switch to Claude and ended up with...
2026-02-13 (first published: 2026-02-03)
395 reads
2026-02-13
962 reads
2026-02-13 (first published: 2026-02-11)
617 reads
Steve discusses privacy and data that is publicly available on the Internet.
2026-02-11
128 reads
For a number of years, we’ve produced the State of the Database Landscape report, based on surveys and research we do every year. I have found it very interesting...
2026-02-10
93 reads
2026-02-09
534 reads
There have many many times when a company or individual has thought that DBAs aren't needed. Steve doesn't think that has ever been true, nor will it be anytime soon.
2026-02-09
394 reads
dolorblindness – n. the frustration that you’ll never be able to understand another person’s pain, only ever searching their face for some faint evocation of it, then rifling through...
2026-02-06
49 reads
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