SqlServer Powershell Cmdlets 2017 - Initialize Look
Diving into the Sql Server Management Objects library can be a pretty interesting process. You get to work with database objects as in...
2017-08-09
21 reads
SqlServer Powershell Cmdlets 2017 - Initialize Look
Diving into the Sql Server Management Objects library can be a pretty interesting process. You...
2017-08-08
1,422 reads
InfluxDb & Grafana Series
Running InfluxDb As A Service in WindowsSetting Up InfluxDb, Chronograf, and Grafana for the SqlServer Dev
InfluxDB And AnnotationsCapturing...
2017-08-08
801 reads
Setting up Telegraf to Capture Metrics I had a lot of issues with getting the GO enviroment setup in windows, this time and previous times. For using telegraf, I'd...
2017-08-08
52 reads
Diagraming and Documentation
Previously, I've written up on database diagramming for visualization of database structures. Check that out for more detailed...
2017-08-07
754 reads
This post assumes you've already setup InfluxDB and have Grafana running.
Inserting annotations Annotations are not a special type of resource, instead it's just another metric that you query with...
2017-08-07
67 reads
update 2019-02-22
Image links broken. Since their product is continually improving, I'm going to just link to their product here instead so you can review their latest demo content there....
2017-08-07
20 reads
There are a few .NET tools that until recently I haven't had the chance to work with as much, specifically...
2017-07-21
1,205 reads
With how many updates are coming out I threw together a script to parse the latest version from the webpage,...
2017-07-12 (first published: 2017-07-03)
1,629 reads
Previous Related Post:
Split personality text editing in SSMS with Sublime Text 3
In this prior post I wrote about how...
2017-06-26
542 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