When you run an application using spark-dotnet, to launch the application you need to use spark-submit to start a java virtual machine which starts the spark-dotnet driver which then...
2019-08-20
43 reads
Starting on dbatools version 1.0.31 we introduced better coverage for commands that make use of PowerShell Remoting. Which commands? Commands like Get-DbaComputerCertificate, Get-DbaPrivilege, Get-DbaClientAlias, just to mention a few...
2019-08-29 (first published: 2019-08-20)
1,354 reads
7 years ago today I posted my very first blog post and I’ll tell you it’s been a heck of ... Continue reading
2019-08-20
22 reads
Download session materials and watch the recordings of my excellent sessions on Transact-SQL and IT careers! I'm looking especially at you, women in technology!
The post Beginning T-SQL and Career...
2019-08-19
35 reads
This post continues looking at my process of learning more about Kubernetes. I’ve been working through the 50 days of Kubernetes (K8s). I completed the first 3 sections (Days...
2019-08-30 (first published: 2019-08-19)
395 reads
A brand new product by Microsoft called Azure Data Share was recently announced. It is in public preview. To explain the product in short, any data which resides in...
2019-08-29 (first published: 2019-08-19)
682 reads
This is the first in a series of posts about simple things that I had a hard time figuring out in Azure DevOps services. It can be very useful...
2019-08-19
88 reads
I love going to SQLSaturday events because I’m always asked questions that make me think. I was just at SQLSaturday Indianapolis (a great event, if you weren’t there, you...
2019-09-09 (first published: 2019-08-19)
326 reads
It’s a running joke among the more experienced (read, older) Microsoft Data Platform specialists as to whether you’re #teamprofiler or #teamexevents. I’m very much #teamexevents, but I really don’t...
2019-08-28 (first published: 2019-08-19)
730 reads
I have just written the fifth article of the Machine Learning topic. !!! This time it is an example of the process – step by step. Do not miss...
2019-08-17
63 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