Thanks for joining us at #SQLSatPensacola!The 8:30am Careers in Technology panel featured lots of talk about Twitter, so might as well mention that the panelists were (in audience's order,...
2019-06-30
20 reads
This is actually part 2 of a process I am creating to automatically discover SQL Server instances in an Active Directory domain. So there will be a series of...
2019-06-28
7,593 reads
Recently, I needed to be able to determine the total size for all the most recent full backups for certain servers. Luckily for me these particular servers were using...
2019-07-15 (first published: 2019-06-28)
473 reads
First, some blah... blah... blah...
By default when a primary key constrained is created on a table/view, SQL Server automatically creates a unique clustered in order to enforce it. And...
2019-06-27
84 reads
With this script, I have the ability to quick show which step is failing, what the command is for that step, what kind of process is running on that...
2019-06-27
10 reads
With this script, I have the ability to quick show which step is failing, what the command is for that step, what kind of process is running on that...
2019-06-27
94 reads
I’ve written a version of my permissions scripts for Azure SQL Database. It’s still in Beta but I’m confident enough ... Continue reading
2019-07-11 (first published: 2019-06-27)
402 reads
I should start off by mentioning that this post is applicable to sql server versions 2012 and up. If you have an older version of sql server, the solution...
2019-07-09 (first published: 2019-06-26)
1,856 reads
Next month, Microsoft is ending five years of extended support on SQL Server 2008 and SQL Server 2008 R2. This follows five years of mainstream support before that. You...
2019-06-26
62 reads
Recently I reviewed filtered indexes, this time let’s look at columnstore indexes. These indexes are very useful for data warehouse workloads and large tables. They can improve query performance...
2019-07-11 (first published: 2019-06-26)
1,294 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