SQL Azure Databases - Active Secondary - Failover Groups - Part 4
150th Blog Post . So, the post involves video demo 🙂
Previous posts on this series was about using "Geo Replication" to...
2017-10-27
387 reads
Blog Posts
SQL Server on Linux – External Memory Pressure
In this blog post we’re going to explore how SQL Server on Linux responds to external memory pressure. On Windows...
2017-10-27 (first published: 2017-10-20)
1,957 reads
And YOU Get a Deadlock and YOU Get a Deadlock and EVERYBODY GETS A DEADLOCK!
https://memegenerator.net/img/instances/400x/59507872/you-get-a-deadlock-everybody-gets-a-deadlock.jpgWe all get them at one point or another - deadlocks.
I have Object 1 and need Object 2, you have Object...
2017-10-26 (first published: 2017-10-18)
3,594 reads
Pass Summit 2017
It’s about that time of year again when there is a buzz in Seattle in regards to PASS Summit. Many...
2017-10-26
421 reads
Permissions required for developing with Temporal Tables
Temporal tables are one of those new (2016+) cool features that recently came across my desk. Basically, a temporal table...
2017-10-26 (first published: 2017-10-16)
1,855 reads
Seattle SQL Pro Workshop 2017 Schedule
Free workshop on SQL Server leading up to Summit 2017 that will provide attendees an alternate means to increase affordable learning opportunities during the week.
Related Posts:
Seattle SQL Pro Workshop...
2017-10-26
8 reads
Seattle SQL Pro Workshop 2017 Schedule
Seattle SQL Pro Workshop 2017
You may be aware of an event that some friends and I are putting together during...
2017-10-26
399 reads
SQL Server – Concat_WS function in SQL Server 2017
Hello friends, Please find the link for my new article at below url – https://social.technet.microsoft.com/wiki/contents/articles/44327.sql-server-concat-ws-function-in-sql-server-2017.aspx Regards Kapil
2017-10-26
563 reads
Basic FORMATting– #SQLNewBlogger
Another post for me that is simple and hopefully serves as an example for people trying to get blogging as...
2017-10-25
1,184 reads
Configuring a Subscription to an Azure SQL
This is my first post where I utilize an hybrid cloud, item that I personally find very interesting and useful so expect more posts like this to come.Microsoft Azure...
2017-10-25
28 reads
Blogs
How to Clear the SSMS Cache (SSMS 21 and Later)
By SQLPals
How to Clear the SSMS Cache (SSMS 21 and Later) Updated...
The flight recorder: Replaying what an AI agent did on my SQL Server
By Arun Sirpal
“What exactly did it do on my server?” is the first question a DBA...
Announcements from the Microsoft Fabric Community Conference — Barcelona 2026
By James Serra
Microsoft shared a broad set of Fabric, Power BI, and SQL updates at FabCon...
Forums
Let's Talk Certifications
Comments posted to this topic are about the item Let's Talk Certifications
The Hidden Security Risks of Role Combination in SSAS Tabular
Comments posted to this topic are about the item The Hidden Security Risks of...
The Empty Aggregate
Comments posted to this topic are about the item The Empty Aggregate
Question of the Day
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