In SQL Server 2012, the new FileTable feature provides some very interesting new capabilities (which I will blog about later). However, the SSMS GUI only provides a T-SQL script template to create a new FileTable. And while this template is very complete, it isn't easy to use. There are more than 20 placeholders that need … Continue reading Customizing the Create FileTable Template in SQL Server 2012
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
I spent a few hours today trying to understand why a number of computers in our (higher education computer lab) environment did not want to download updates for drivers using Lenovo's System Update tool. I tried disabling the usual suspects (particularly McAfee Anti-Virus 8.7i Enterprise and the Windows Firewall), but nothing made a difference. So then … Continue reading Software Interplay Issues: Netop Vision 7.2 and Lenovo System Update 4.01
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
Just another example of this today: I finally got a signup link for the beta of Office 365. I signed up and connected an e-mail account I have at a hosting provider. The hosting provider uses SmarterMail 7 Enterprise Edition. Apparently, all I had to do was input my e-mail address and my e-mail password. … Continue reading Nothing on the Internet is ever, ever deleted
Routing in ASP.NET 4.0 is a great way to set up friendly URLs with minimal effort. The process of doing this has been well described in many articles (see references below). Routing in ASP.NET 4 supports extension-less URLs, so that you can set up a mapping like this: http://www.mydomain.com/Products/Beverages instead of the version that has … Continue reading Using ASP.NET 4.0 Extension-less Routing on IIS 7.5
For the longest time, I thought it couldn't be done: add an "emphasis" animation to text in a PowerPoint slide by changing the color of the text. Turns out it is possible after all, and here is how to do it (in PowerPoint 2007 - haven't tried older or 2010): Open the Custom Animation pane. … Continue reading Changing the Font Color in PowerPoint using Animation
It's Everybody's Business is a series of webisodes produced by Microsoft. The show features Jack and Suzy Welch (of GE fame) as they visit with IT executives and leaders from Fortune 500 companies and help them work through challenges and opportunities the firm faces. During the sessions, Jack and Suzy gain an understanding of the … Continue reading It’s Everybody’s Business
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
For technology, 2009 turns out to be the anniversary of at least 4 significant events: September 2, 1969 marks the day the foundation for the Internet was first created; by enabling two computers to exchange information over a network [1]. Shortly thereafter, packet switching was developed by the same pioneers. Also in 2009, the first … Continue reading 2009: The 40th Anniversary of …
Sven Aelterman 