Last year Azure SQL Database Managed Instance saw the introduction of bring your own key (BYOK) functionality for transparent data encryption (TDE). This functionality has been in the singleton...
2020-01-31 (first published: 2020-01-24)
1,111 reads
This article takes us to the edge with a couple of CRM related errors after changing the service account to a more secure Managed Service Account. Despite the CRM...
2020-01-23
18 reads
This article takes us to the edge with a couple of CRM related errors after changing the service account to a more secure Managed Service Account. Despite the CRM...
2020-02-03 (first published: 2020-01-23)
247 reads
2019 was a busy year for me. I presented sessions in over 10 countries, averaging speaking at two conferences per month. I also helped organise Data Relay and attended...
2020-01-23
13 reads
For me it’s a bit surprising how little information can be found regarding the “Process Add” option which I consider as the best choice for incremental data load to...
2020-01-23
65 reads
SQL Server 2019 Administration Inside Out
Honored again to be leading the talented SQL Server 2019 Administration Inside Out author team, and share some fun insights from the team as...
2020-01-22
202 reads
Thanks to all 180+ of you who joined the Data Architecture Virtual User Group for a hour all about SQL Server 2019! We reviewed everyone's favorite new features of...
2020-01-22
83 reads
That aging hippie (he likes Apple products and has a goatee) known as Brent Ozar wrote a post recently about his home office studio setup, with a big focus...
2020-01-22
60 reads
This is one of those things that probably doesn’t happen all that often, but bit me in the … elbow ... Continue reading
2020-01-31 (first published: 2020-01-22)
409 reads
Now that I have written about In-Memory Tables and Migrating to In-Memory tables, let’s look at indexes and how they are created and how they work within those tables....
2020-01-27 (first published: 2020-01-22)
784 reads
By James Serra
Microsoft shared a broad set of Fabric, Power BI, and SQL updates at FabCon...
By Steve Jones
No, I’m not quitting or retiring. Just going on vacation, but I leave tonight...
Comments posted to this topic are about the item Let's Talk Certifications, which is...
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