DBA in Space: Behind the Scenes Part 1
The DBA in Space contest ends November 18, 2011. If you haven’t entered yet, you still have time.
Filming DBA in...
2011-11-14
726 reads
Blog Posts
DBCC CHECKDB
Torn Pages \ Corrupt pages – all in a days work for a DBA. But can anyone tell me how to use...
2011-11-14
27,708 reads
Do You Use “Forced Parameterization”?
In SQL Server 2005 and later, there is a database option called “forced parameterization”. When it is turned on, it...
2011-11-14
792 reads
Lists of Words You May Not Know
The Merriam-Webster site has an interesting list of Top 10 Lists, ranging from commonly confused words to things you didn’t...
2011-11-14
642 reads
Many-to-Many Dimensions
In SSAS, data structures do not always conform to the snowflake or star schema model where one fact is associated...
2011-11-14
1,498 reads
No SQL Saturday - Columbia, SC in 2012
Last week my partner in crime, Bobby Dimmick (blog | twitter) and I sat down for lunch and caught up and...
2011-11-14
1,663 reads
Some SQL Server Security Housekeeping
Managing SQL Server security changes in mass is something which screams automate it. Let’s look a at few examples using...
2011-11-14
1,660 reads
SQL Inspire NYC – 2011
The lineup for SQLInspire
I spoke at the SQL Inspire event this last weekend and it was a greart experience. This...
2011-11-14
1,494 reads
SQL Server – Error Msg 102, Level 15, State 1, Line x when using sys.dm_db_index_physical_stats
You run into this error when using sys.dm_db_index_physical_stats DMV on a database which is running under SQL Server 2000 (80)...
2011-11-14
1,853 reads
SQL Server 2012 licensing
Microsoft has recently released the licensing overview for SQL Server 2012. A few things has changes from SQL Server 2008,...
2011-11-14
949 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