An important part of any DBAs job is to ensure database related jobs are running prim and proper. Sometimes that just doesn't happen. When jobs are being overlooked, it...
2019-07-04 (first published: 2019-06-20)
465 reads
An important part of any DBAs job is to ensure database related jobs are running prim and proper. Sometimes that just doesn't happen. When jobs are being overlooked, it...
2019-06-20
22 reads
If you are being serious in your role, then the amount of times you grant permissions to the public role should either be a) never, b) when you want...
2019-06-17
776 reads
If you are being serious in your role, then the amount of times you grant permissions to the public role should either be a) never, b) when you want...
2019-07-01 (first published: 2019-06-17)
360 reads
If you are being serious in your role, then the amount of times you grant permissions to the public role should either be a) never, b) when you want...
2019-06-17
16 reads
Extended Events is a powerful tool with plenty of ease of use and flexibility. This flexibility allows the DBA to capably monitor the server for any issue be it...
2019-06-13
224 reads
Extended Events is a powerful tool with plenty of ease of use and flexibility. This flexibility allows the DBA to capably monitor the server for any issue be it...
2019-06-13
17 reads
Extended Events is a powerful tool with plenty of ease of use and flexibility. This flexibility allows the DBA to capably monitor the server for any issue be it...
2019-06-13
74 reads
Not only should you pay respect to those giving of their time, but you should spend a little time to also give back to the community. I will say...
2019-06-11
22 reads
Not only should you pay respect to those giving of their time, but you should spend a little time to also give back to the community. I will say...
2019-06-11
9 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