Microsoft Data Platform – Sven Aelterman

Microsoft Data Platform, SSIS, Troubleshooting

SSIS will not warn if metadata is out-of-date for a Lookup

I ran into this problem today that didn't take a long time to resolve, but took me a little by surprise. Most of my SSIS packages use the Lookup transformation component to look up keys used in source systems and match them to the data warehouse. When SSIS packages fail at the Lookup component, the most common cause is that the source system's key does not exist in the data warehouse and must be added first. This time was different, however.

FILESTREAM, Microsoft Data Platform, SQL Server

The Truth Behind FilestreamEffectiveLevel and FilestreamConfiguredLevel SERVERPROPERTY values

There is a lot of confusion (not in small part due to Books Online’s inaccurate descriptions) around the meaning of the SQL Server server properties FilestreamEffectiveLevel and FilestreamConfiguredLevel. There are 2 problems with the way Microsoft describes these properties: the list of values they can have is incomplete, and their actual description (as well as … Continue reading The Truth Behind FilestreamEffectiveLevel and FilestreamConfiguredLevel SERVERPROPERTY values

FILESTREAM, Microsoft Data Platform, SQL Server

FILESTREAM and Rebuilding Clustered Indexes: Caution

There is some caution needed when working with FILESTREAM and clustered indexes. Specifically, if all of the following conditions are true, your FILESTREAM data ends up being moved to the default FILEGROUP even though this may not be your intent: Your database has more than one FILESTREAM filegroup. You have one or more tables that … Continue reading FILESTREAM and Rebuilding Clustered Indexes: Caution

FILESTREAM, Microsoft Data Platform, SQL Server

Using SQL Server 2008 FILESTREAM in an N-Tier Solution

For my recent talk at SQL Saturday #14, I had to find a solution that would allow a client to read SQL Server 2008 FILESTREAM BLOBs using SqlFileStream. The Problem While the addition of the FILESTREAM attribute is a great solution to a common problem, most performance benefits are only realized when accessing the BLOBs … Continue reading Using SQL Server 2008 FILESTREAM in an N-Tier Solution

My Tweets

RT @intelnews: Gordon Moore, Intel Co-Founder who set the course for the future of the semiconductor industry, has passed away at the age o… 1 day ago

This talk and many other ones this Saturday at @AtlCloudCon 2023! twitter.com/atlcloudcon/st… 2 days ago

RT @SCMagazine: .@github announced in May that it will make 2FA mandatory for all contributors by the end of 2023. #cybersecurity #infosec… 1 week ago

RT @MSFTImagine: Calling all students and #Tech career-seekers! The academic event of the year is BACK. 🙌 Join us at the Microsoft Student… 1 week ago

RT @DayTechHistory: On this day in 1986, @Microsoft went public. The company sold 2.5 million shares by the end of the day. https://t.co/CF… 1 week ago

Follow @svenaelterman

Blog Disclaimer

This is a personal blog. The opinions expressed on these pages and in these entries are entirely my own and do not necessarily represent those of my employer, my customers or associates.
I have never accepted any form of payment in return for mentioning a product name or linking to a site on my blog.
I make no representations as to the accuracy, currency, completeness and suitability for any purpose of the information found on this site. All information is provided as-is.
The information on this blog and on these pages is copyrighted material. Everyone is encouraged to reference and cite the material for personal and academic purposes. The material may not be used in a for-profit fashion.
The Comments section of each entry is open for discussion and dialogue. I welcome feedback to my blog entries from anyone. However, I reserve the right to remove any comment or reply that is off-topic, contains profanity or is intended to generate traffic to a for-profit web site.