Moving Encrypted Data to Azure SQL Database
Learn how you can move encrypted data from on premises SQL Server to Azure SQL Database.
2019-11-26
2,545 reads
Azure SQL database
Very Hot Patches
Azure SQL Database can be patched without stopping the sqlsrvr.exe process. Quite a feat of engineering.
2019-10-08
202 reads
2019-08-15
768 reads
Cross Database Queries in Azure SQL Database
Cross database queries in Azure SQL Database aren't as straightforward as you might think, but they aren't hard to implement. Follow along to learn how to implement them.
2019-07-25
38,274 reads
Technology Flows Downstream
The technologies that we see in other data platform products sometimes flow to SQL Server.
2019-06-20
276 reads
2019-05-16
620 reads
Five Ways to Migrate Your On-Premises SQL Database to Azure
There are currently three deployment options for SQL Server Database on the cloud. Well, four, if you count Azure SQL Databases in elastic pool. But Azure SQL DB in...
2019-05-09
A short Azure SQL Database Edge explainer
On Thursday 2 May 2019, Microsoft announced a new edition of SQL Server, targeting Internet of Things (IoT) edge devices. That means SQL Server can now run almost anywhere....
The...
2019-05-06
2019-04-29
803 reads
Building Azure SQL Db with Terraform with Visual Studio Code
I have been using Terraform for the last week or so to create some infrastructure and decided to bring that knowledge back to a problem that I and others...
2019-04-17
Blogs
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...
Au Revoir for now
By Steve Jones
No, I’m not quitting or retiring. Just going on vacation, but I leave tonight...
Forums
Let's Talk Certifications
Comments posted to this topic are about the item Let's Talk Certifications, which is...
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