What is the hardest part of planning a SQL Saturday?
For me so far it has been the speaker selection. Getting sponsors didn’t prove to be difficult, we have a...
2011-07-27
522 reads
Blog Posts
Fastest row counting method
SELECT COUNT(*) is most common method (and exact) how to find out how many records is in table. There is...
2011-07-26
6,371 reads
Leaked Information About AMD Opteron 6200 Series Processors
CPU World has a post about some leaked info regarding the upcoming Opteron 6200 series “Bulldozer” processor line. Here are...
2011-07-26
1,031 reads
My upcoming speaking engagements
A few days ago I had an interesting conversation on Twitter about my upcoming speaking
engagements. I really realized at this...
2011-07-26
785 reads
NYC SQL Server User Group - this Thursday - SQL2K8 Audit Feature
Quick update. This Thursday, July 28, 2011 at the NYC SQL Server User Group at Microsoft HQ in NYC, SQL MVP...
2011-07-26
1,460 reads
Optimize a query by thinking out of the box
Recently I had to create a simple query to lookup a single row in a table containing ranges that do...
2011-07-26
621 reads
Projects – Win Early
Project plans should try to plan for some unknowns. For large projects they include known risks, vacation time, maybe even...
2011-07-26
671 reads
SQL Server, Chennai and Me
It's near to 6 months since I started blogging in SSC and started giving sessions for my Organization on Internal and tuning topics.
While...
2011-07-26
889 reads
Bad Admins: Taking Advantage of Maintenance Periods
This is part of a series of tips on how bad/rogue admins can get access to the data in your...
2011-07-25
1,059 reads
Being an Exceptional DBA Award 2011 Finalist
On Wednesday 13th July at 16:06 (GMT) I got what could only be described as the biggest shock of my...
2011-07-25
834 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