How to Programmatically Identify When Your SQL Server Was Last Started
Greg Larsen shows you a quick trick to programmatically script a way to identify when SQL Server was last started.
Avoiding Unexpected Results with DATEDIFF in Year Comparisons
Learn how to avoid unexpected results when using the DATEDIFF function to find the difference between two dates in years.
Stumbling over Words
Phil Factor argues that the ability to write simply and expressively is a much under-valued skill in IT, and explains the main traps to avoid.
What's Downtime?
Steve asks the question today of how you might measure downtime and the scope you are concerned about.
Mount SQL Server DMVs and Custom Queries Using DBFS on Linux
With SQL Server now supported on Linux, traditional SQL Server DBAs will need to learn how to work with Linux, and Linux administrators will need to learn how to work with SQL Server. Fortunately, there are several tools available to assist. In this article Prashanth Jayaram describes how to work with the DMV tool which treats queries as files.
How to execute a Powershell script via SSIS
Learn how you can execute a PowerShell script via the SSIS execute process task.
One Size Does Not Fit All
Today we have a guest editorial from Derik Hammer that reminds us that there isn't one solution that will fit all your solutions.
Data Retention: An Inexact Art
A myriad of laws regulate data retention and generally compete with each other. William Brewer provides an introduction to the principles, but gives good advice -- leave the details to the specialists.
Analyze entity data flow in Power BI Desktop using Sankey charts
Siddharth Mehta looks at how and why to use Sankey charts and how this can be done in Power BI Desktop.
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