Import Excel Data into SQL Server with PowerShell
In this article we look at PowerShell code you can use to import Excel data into SQL Server.
What’s most important to you when dealing with database software?
Take part in this short exercise (no more than 5 minutes) by letting us know what matters most to you when considering, purchasing, or using database software. As a thank you, you can also enter our prize draw at the end for a chance to win a $150 Amazon gift voucher.
Do *not* place TEMPDB on a local disk in a SQL failover cluster
What happens with tempdb on a local disk in a cluster? Read on to see that you will not get a failover if the local disk fails
Dread or Desire
Today Steve wonders about the move back to offices and if you are looking forward to it or trying to avoid it.
Ten tips for attracting and retaining DevOps talent
To stay competitive and bring value to customers, organisations are adopting DevOps, but finding people experienced in DevOps can be challenging. Robert Sheldon has ten tips to help managers attract and retain DevOps talent.
SQL Server Management Studio Database Diagram Support Objects Cannot be Installed
In this article we look at how to resolve the error database diagram support objects cannot be installed because the database does not have a valid owner.
Blogs
A New Word: Dolorblindness
By Steve Jones
dolorblindness – n. the frustration that you’ll never be able to understand another person’s...
Claude Code Helps Analyze Test Data Manager Log Files
By Steve Jones
I had a customer ask about analyzing their Test Data Manager (TDM) usage to...
PowerPoint to HTML with Claude AI
By Steve Jones
I had an idea for an animated view of a sales tool, and started...
Forums
GPX distance and time analysis in SQL Server
Comments posted to this topic are about the item GPX distance and time analysis...
The DBA is Dead; Long Live the DBA
Comments posted to this topic are about the item The DBA is Dead; Long...
Changing the AG Listener
Comments posted to this topic are about the item Changing the AG Listener
Question of the Day
Changing the AG Listener
In SQL Server 2025, if I want to remove an IP from a listener, what do I do?
See possible answers