Handling Flat File Headers and Errors in SSIS
Using SSIS to load a flat file into a database is a common use of the tool. This works great...
2011-09-12
4,048 reads
SSRS 2008 R2: Object reference not set to an instance of an object
We have a report in SSRS 2008 which calls multiple sub-reports. One of the sub-reports contains a data region (tablix) in...
2011-09-10
2,673 reads
SSRS 2005 Error: The Item “/” cannot be found
Couple of months back, one of our SSRS 2005 staging server became inaccessible. When we opened the report manager, it...
2011-09-10
4,063 reads
Using a Display Folder for a SSAS calculation
I was having a problem getting the display folder to work for a calculation in SSAS. Turns out, it will...
2011-09-09
1,385 reads
Little Workaround in Report Manager
I had an issue this week in Report Manager. I was generating a report (we’ll call it General Widgets Report),...
2011-09-09
871 reads
SSRS 2008 R2: Report Server crashing intermittently
One of our report server which is SSRS 2008 R2 (10.50.1720.0) started to crash intermittently. The IE failed with Internet...
2011-09-09
3,893 reads
Round Up of Past Week and Upcoming Events.....
Read on to register for cool events, win an iPad2, be inspired, participate in t-sql tuesday, and more!
It's been an...
2011-09-09
1,605 reads
Come to SQL Saturday 92 in Portland
Are you In Portland, Oregon?
Do you plan to be in Portland on Saturday, October 8th?
Can you be in Portland on...
2011-09-09
507 reads
24 Hours of PASS & SQL Saturday(s)
I survived 24 Hours of PASS! Just wrapped up delivering my presentation for the 24 Hours of PASS (24HOP) on...
2011-09-09
659 reads
SQL Saturday #97 – Austin TX
The schedule for SQL Saturday 97 has been posted and I was selected to give my “It’s TempDB, Why Should...
2011-09-08
469 reads
Blogs
Take Time to Gain Perspective
By Brian Kelley
Probably the best piece of advice I ever received is to take time to...
The Fringe Festival
By Steve Jones
I was lucky enough to take a vacation a decade ago in Edinburgh with...
Demo for Parameter Sniffing and Memory Grant Feedback
Disclaimer: The following is built with Claude Code. Just need to justify my $100/mo...
Forums
Learn From History
Comments posted to this topic are about the item Learn From History
The SQL Server MCP Server
Comments posted to this topic are about the item The SQL Server MCP Server
The Hidden Danger of Wildcard Operators In Join Operations
Comments posted to this topic are about the item The Hidden Danger of Wildcard...
Question of the Day
The SQL Server MCP Server
How do I get an MCP server for my SQL Server 2025 database from Microsoft?
See possible answers