Speaking at Charleston PASS on January 19th
I will be presenting on SQL Server security on January 19th in Charleston, SC. You can find the details at...
2012-01-04
857 reads
Blog Posts
Speaking at Knoxville SQL Server User Group
I am excited to announce that I will be giving a virtual presentation to the Knoxville SQL Server User Group. ...
2012-01-04
989 reads
SQL Server Error Logs
I read a blog post this morning on SQLServerCentral by Tim Radney about SQL Server Error Logs. Tim talks about...
2012-01-04
1,079 reads
SQL SERVER REBUILD INDEX
Use the script below to rebuild an index on a table
ALTER INDEX MY_INDEX_NAME on MY_TABLE_NAME REBUILD ;
Check SQL Server...
2012-01-04
1,044 reads
SSIS Community Tasks and Components
Do you know there are hundreds of additional tasks, tools, and components for SSIS, many which are free? Why re-invent...
2012-01-04 (first published: 2011-12-30)
3,092 reads
SSIS ETL Frameworks
In my years as a BI Professional I have seen many ETL Frameworks. They range from homegrown internal solution to...
2012-01-04
9,673 reads
Dropping a Database
I came across an issue on a server this morning where a drive had run out of free space. Now given...
2012-01-03
617 reads
Estimated Completion Time for Backups and Restores
I’m in the middle of a database migration and thought I’d quickly share a script I threw together to show...
2012-01-03 (first published: 2011-12-30)
79,735 reads
SQL SERVER DISABLE INDEX
Use the script below to disable an index on a SQL Server table
ALTER INDEX MY_INDEX_NAME on MY_TABLE_NAME DISABLE;
Executing the...
2012-01-03
1,438 reads
Start 2012 with Your Best of 2011
The first week following on from the Christmas break is a very hectic one for us Data Professionals.
Your customers are...
2012-01-03
622 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