Ending My Time as PASS President
With the end of the year, other things are coming to an end as well. Tomorrow, December 31st, will mark my final day as President of the PASS organization....
2020-01-10 (first published: 2019-12-30)
453 reads
Blog Posts
PowerShell to Backup XE Session
Working with Extended Events will help you become a better DBA. Working with PoSh can also help you in many various tasks to become a better DBA. Combine the...
2020-01-10
3 reads
The recap of the passing year 2019
Good morning girls and boys, ladies and gentlemen, in the new year 2020! I recently thought that we had started a new decade. But that’s not true. The new...
2020-01-10
2 reads
The recap of the passing year 2019
Good morning girls and boys, ladies and gentlemen, in the new year 2020! I recently thought that we had started a new decade. But that’s not true. The new...
2020-01-10
11 reads
What I’ve learned from Groundhog Day.
One of my all time favorite movies is Groundhog Day staring Bill Murray. In case you’ve never watched it (and ... Continue reading
2020-01-10 (first published: 2019-12-30)
423 reads
Installing PowerShell for SQL Server – #SQLNewBlogger
Another post for me that is simple and hopefully serves as an example for people trying to get blogging as #SQLNewBloggers. PowerShell is the hot new scripting language for...
2020-01-09 (first published: 2019-12-27)
4,416 reads
Previous SQL Server Updates
Hello everyone, this is John your Austin SQL Server Consultant here and today I am going to answer a question that comes up often so I wanted to blog...
2020-01-09
8 reads
T-SQL Basics: using OUTPUT
You are working on a database development project, and you need to obtain the records before/after an INSERT, DELETE, UPGRADE or MERGE Statement to present it to the user...
2020-01-09 (first published: 2020-01-03)
1,072 reads
[Cross post] Innovating Yourself as an IS Auditor
This is also posted to the ISACA Journal blog, Practically Speaking: As new technologies are developed, we have to stay up to date with them. More so than almost...
2020-01-08 (first published: 2020-01-02)
229 reads
Azure – BGP Community for Application Insights (Need Votes)
Working with Microsoft, we determined that there is no BGP community for Azure’s Application Insights. As a result, I’ve created a feedback request for Microsoft to consider doing just...
2020-01-08 (first published: 2019-12-30)
116 reads
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
SSIS with VS2022 64/32 issue with Excel files
Hi all, I'm trying to do classic scenario for loading multiple Excel files into...
Case part is sloooooow
Hi So the case statement is slowing this down - but for the life...
Why the following cmds in sequence do not work
I need to delete rows from both the temporal main and history tables. The...
Question of the Day
The String Distance I
In SQL Server 2025, what is returned by this code:
SELECT EDIT_DISTANCE('tim', 'tom')
Assume preview features are enabled. See possible answers