How Do You Find a DBA?
Looking for a new DBA can be a daunting process, and a lot of work as the resumes flood in. Steve Jones talks about a better way that might work for some of you.
How Do You Find a DBA?
Looking for a new DBA can be a daunting process, and a lot of work as the resumes flood in. Steve Jones talks about a better way that might work for some of you.
Database Server Upgrades – The Plan, The Template, and The Task List
This article enables DBAs to efficiently upgrade servers by assembling an upgrade team, using an upgrade template, and communicating effectively.
A SQL Server Issue? (Database Weekly May 11, 2009)
The problems with Windows 7 downloads were blamed on SQL Server. Steve Jones thinks this was a huge mistake.
A SQL Server Issue? (Database Weekly May 11, 2009)
The problems with Windows 7 downloads were blamed on SQL Server. Steve Jones thinks this was a huge mistake.
A SQL Server Issue? (Database Weekly May 11, 2009)
The problems with Windows 7 downloads were blamed on SQL Server. Steve Jones thinks this was a huge mistake.
A SQL Server Issue? (Database Weekly May 11, 2009)
The problems with Windows 7 downloads were blamed on SQL Server. Steve Jones thinks this was a huge mistake.
Asymmetric Keys in SQL Server
I've been tech editing an encryption book for SQL Server. It's long overdue, and I think it will be a nice addition to any DBA's library. It also addresses a complicated subject that Books Online has inadequately covered. In fact, they've...
Attribute Discretization: Using the Automatic Method
Join BI Architect Bill Pearson as he continues his overview of Attribute Discretization, within his extended examination of the dimensional model lying at the heart of the integrated Microsoft Business Intelligence solution. In this article, we begin a hands-on overview of the use of the Automatic discretization method.
SQL Server Optimization
This article describes different ways of improving the performance of SQL Server queries, with a focus on index optimization.
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
Optimism Without Illusion or Why AI Needs Blunt Technologists
Comments posted to this topic are about the item Optimism Without Illusion or Why...
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...
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