How to configure Always Encrypted in SQL Server 2016 using SSMS, PowerShell and T-SQL
In an era of remote storage and retrieval of data, including the cloud, data security plays a vital role, especially...
2017-10-02
477 reads
Blog Posts
How to reset the password of Microsoft Azure virtual machine using PowerShell
Hello friends, Please find the link of my article here – https://social.technet.microsoft.com/wiki/contents/articles/40112.microsoft-azure-how-to-reset-the-password-of-azure-virtual-machine-using-powershell.aspx
2017-10-02
452 reads
Monday Coffee: Long hours worked
Last week I asked the following question on twitter: –
I had a load of responses from a lot of DBAs...
2017-10-02
287 reads
Query Azure CosmosDB from a SQL Server Linked Server
[read this post on Mr. Fox SQL blog]
Recently I had a requirement to combine data that I already had in SQL Server...
2017-10-02 (first published: 2017-09-25)
3,889 reads
SQL Homework – October 2017 – Sample/Test Database(s)
Last month your homework was to set up your own lab. Now it’s time to put a sample database or...
2017-10-02
436 reads
SQL Server – Pause VS Stop
You have the ability to actually pause SQL Server, if you are in SQL Server Management Studio (SSMS), you might...
2017-10-02
375 reads
Test Your SQL Memory Setting with dbatools
I really like the dbatools project. This is a series of PowerShell cmdlets that are built by the community and...
2017-10-02
439 reads
Want to know what software is running on the VSTS Hosted Agent? Go here….
This is related to my previous post about installing things on my Private-Hosted agent that I use for my VSTS...
2017-10-02
280 reads
New Pluralsight Course – LFCE: Linux Service Management – HTTP Services
My new course “LFCE: Linux Service Management – HTTP Services” in now available on Pluralsight here! If you want to learn about the course, check out the trailer here or if you want to...
2017-10-01
30 reads
New Pluralsight Course – LFCE: Linux Service Management – HTTP Services
My new course “LFCE: Linux Service Management – HTTP Services” in now available on Pluralsight here! If you want to learn about the course,...
2017-10-01
515 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