Starting with SQL Server 2012, AlwaysOn Availability Groups provided group level high availability for any number of databases for multiple...
2015-10-01
1,438 reads
Read-only routing refers to the ability of SQL Server to route incoming read-intent connection requests, which are directed to an...
2015-10-01
492 reads
If you are familiar with the new feature Read-Only Routing introduced in SQL Server 2012 with AlwaysOn then you should...
2015-10-01
517 reads
Replication is still a major component of SQL Server today even with Availability Groups as an alternative to certain scenarios....
2015-10-01
701 reads
It’s been a while since my last pre-con, in fact it’s been a while since my last SQL Saturday with...
2015-10-01
546 reads
October is going to be a very busy month for me! Three conferences and a pre-con are on the agenda.
This...
2015-10-01
377 reads
This weekend I’ll be traveling to Kansas City, Missouri for their annual SQL Saturday. Normally, I would just drive to this...
2015-10-01
467 reads
SQL Server Days 2015 is over and it was a blast. Met a lot of people from the #sqlfamily, too...
2015-10-01
583 reads
SQL 2016 is right around the corner and one of the new security enhancements promised is Row-Level security for tables....
2015-10-01
1,308 reads
In the case of the final core component, Targets, the exploration into the metadata can be a little awkward. At least at first. Read on to see how to...
2015-10-01
15 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