Updating the TCP Port on a SQL Server Cluster Node
When installing 2 SQL Server instances on a Windows Cluster, the installation program requires a Named Instance during the installation of the second node and a dynamic TCP port is created. How do you update the TCP port after the installation in a clustered environment for the named instance?
SQL Server Sample Databases
This is a landing page for the sample SQL Server databases we are aware of.
The Job Posting - Do I really have to be the SQL God?
Looking for a job in the SQL Server industry can be a challenge for many people. Craig Farrell examines part of this process in his look at job postings and how you can interpret them.
Using source data from an SSRS report in PowerPivot for Excel
In this tip we would look using an existing SSRS report to provide the data for PowerPivot in Excel.
Automating SQL Traces
Capturing the activity on a server when a problem occurs can be a challenge for many DBAs. This article shows how you can automate the capture of information when a CPU spike occurs.
Transaction Log Stairway Series available as a book
Red Gate Books has released SQL Server Transaction Log Management, a free eBook on maintaining and troubleshooting the enigmatic transaction log based on the Stairway Series.
Trusting Systems
The trust we build by ensuring our computer systems work is important. If we can't maintain that trust, Steve Jones sees a problem for our careers.
Backup and Restore SQL Server with the SQL Server 2012 PowerShell cmdlets
There are plenty of occasions when it makes a lot of sense to do backup and restore scripts in PowerShell. Microsoft have put effort into making it much easier, as Allen White demonstrates.
Data Mining Introduction Part 5: the Neural Network Algorithm
This is the 5th article about Data Mining with SQL Server. This chapter is about Neural Networks.
Blogs
AI Helps Me with My Sloppiness
By Steve Jones
I type fairly well. Well, I type fast, but I do wear out a...
Automatic Index Compaction
By ReviewMyDB
Index maintenance has always meant nightly jobs and a window you have to defend....
The Goldilocks problem – Materialized Views
I’m sure you’ve all heard the tale of Goldilocks and the Three Bears, but...
Forums
SQL Art, Part 4: Happy 4th of July — A British DBA's Guide to Celebrating a War We Don't Talk About
Comments posted to this topic are about the item SQL Art, Part 4: Happy...
How We Handled a Vendor Retry That Loaded Twice in Snowflake
Comments posted to this topic are about the item How We Handled a Vendor...
Cognitive Coverage
Comments posted to this topic are about the item Cognitive Coverage
Question of the Day
Getting the Average
I have this data in the dbo.Commission table in a SQL Server 2022 database.
salesperson commission Brian 12 Brian 16 Andy 7 Andy 14 Andy 21 Steve 20 Steve NULLAll the data is a varchar, and I decide to run this query to get the totals for each salesperson.
SELECT SalesPerson
, AVG(TRY_PARSE(Commission AS int)) AS TotalCommission
FROM commission
GROUP BY SalesPerson
GO
What average commission is calculated for Steve? See possible answers