Read contents of a file to variable – SSIS
Sometimes you will find the need to import a file to a variable using SSIS. In this post, I’ll use Script...
2012-01-24
1,843 reads
Blog Posts
RECONFIGURE can flush the procedure cache
I ran across this KB article the other day, which lists a few ways in which performance is affected by...
2012-01-24 (first published: 2012-01-19)
2,194 reads
Sitting Between Two Stools: Analysis Services 2012, Windows 8 and Market Niche Confusion at Microsoft
In my last post, I wrote that the game plan was to post by Dec. 10 on changes in data...
2012-01-24
1,957 reads
Slammer, Alive…Barely
By now you must have heard of the SQL Slammer worm. It was quite an infectious little nuisance. The harm it caused came largely due to unpatched, unprotected SQL...
2012-01-24
4 reads
Insert multiple rows from one INSERT statement
One of the things that has been annoying for a long time in SQL Server is adding lots of data...
2012-01-23
29,032 reads
January 2012 SQL Server 2008/2008 R2 Diagnostic Information Queries
Since Microsoft recently released a couple of new Cumulative Updates for SQL Server 2008, I thought it was finally time...
2012-01-23
1,168 reads
Monday Morning Mistakes: Remote Connectivity to SQL Server
Inspired by common emails and questions I see, I figured I’d do a series of blog posts on common mistakes...
2012-01-23
991 reads
New Article: How to audit sysadmin members on multiple servers using PowerShell
My first article of 2012 has published over at MSSQLTips.com. This one covers the basic technique for using PowerShell to audit...
2012-01-23
1,941 reads
Notes from the January 2012 oPASS Meeting
It’s been quite a while – where did the time go? – since I had done a presentation for oPASS, so when...
2012-01-23
547 reads
Revamping SUG 2nd Meeting
Friends,
Last Saturday, 21st we have 2nd meeting of SUG members and this time we made progress – I, Vinay and Matang...
2012-01-23
594 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