What Makes The Perfect DBA Role?
What is it that makes the perfect role for a Database Administrator?
Well I can’t tell you that because you and...
2011-12-07
1,308 reads
Blog Posts
Create Drillthrough Reports
Use Actions!
Your user wants a summary report, containing sales for calendar year, for example. When the user clicks on the...
2011-12-06
931 reads
DATEADD and variables in SQL
To make the T-SQL function DATEADD more dynamic use variables. The example below , accepts an input parameter , in this case...
2011-12-06
2,320 reads
DBA in Space: Behind the Scenes—Question 12
This is a continuation of my DBA in Space journal.
As this scene starts on Lunar Exhibition set, Miss Friday is...
2011-12-06
464 reads
December Event Reminder
We are now only two days away from the biggest event of the week!!
More accurately though, it is the BIGGEST...
2011-12-06
654 reads
December Event Reminder
We are now only two days away from the biggest event of the week!! More accurately though, it is the BIGGEST event for the Las Vegas chapter of...
2011-12-06
2 reads
Excel for the DBA, Part 1–The Basics
This will be a series of handy hints for people that know SQL and are frustrated by Excel. I am...
2011-12-06
2,114 reads
Extended Events - inaccurate_cardinality_estimate
Extended events have been a bit of a personal “Elephant in the room” for me. I know they are there...
2011-12-06
2,701 reads
How to Build a Resume (that doesn’t suck)
Resumes are like opinions, which are like something else: everybody’s got one. And if you don’t have one, then certain...
2011-12-06
3,158 reads
Meet the DBA in Space Judges
Judging any contest is difficult, as you want to be as fair as possible. So coming up with the final...
2011-12-06
637 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
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