Disclaimer: I think this post will probably be more of a "memo to self" than be widely useful, but I wanted to jot down how I go about setting up my presentation environment, beyond just the basics. First of all, I go through quite some lengths to set up an environment like this, so there … Continue reading Setting Up a Virtualized Demo Environment
Update: 2012-05-07: Apparently, this method does work for SSIS 2005 tasks. However, these extensions should not use the native interfaces. Thanks to Matt Masson for the correction. For the next few weeks, the topic of upgrading SSIS 2008 packages to SSIS 2012 will be keeping me very busy. I am preparing to speak on the topic three times … Continue reading Using SSIS 2008 Components in SQL Server Data Tools with SSIS 2012
I am excited to have three sessions accepted for SQL Saturday #112, Birmingham 2012. This will be my third year attending the Birmingham edition of SQL Saturday and I am very much looking forward to it. The Steel City SQL Users Group is sponsoring the event, and they have the same great location as previous … Continue reading My SQL Saturday #112 (Birmingham 2012) Sessions
It appears, after all, that Microsoft doesn't believe the FileTable security bug I described in a previous post (here) is By Design. The bug on Connect was Resolved as By Design a few weeks ago, but I didn't agree. So the upshot is that it will be fixed in a forthcoming update (presumably this means … Continue reading Update on FileTable Security Bug
Yesterday's SQL Saturday in Atlanta was another wonderful event. Thanks so much to the organizers (whom rumor has it aren't exactly sure who I am...), the sponsors and the attendees. I had a great time interacting. Next up is SQL Saturday #112 in Birmingham. But before that, below are the slides and demo code from my … Continue reading SQL Saturday 111 Atlanta 2012 Wrap-Up
Semantic Search is a powerful new addition to SQL Server 2012. Semantic Search builds upon the full-text index feature and adds the ability for SQL Server to determine key words in documents. Uses can include analysis of text to determine similarity between two documents, extract key words from documents, or find documents that contain key … Continue reading Step-by-Step: Enabling Semantic Search on SQL Server 2012
So this blog post has a long title, apologies for that. This is an important FileTable issue that you must be aware of before implementing this feature. Now that SQL Server 2012 is officially released, people are looking to deploy it and take advantage of the many new and improved features. While HADRON is the … Continue reading SQL Server FileTable: Cannot prevent users with read-only access to the FileTable from modifying file contents using non-transactional access
I am very sorry to have to write this blog entry... but due to low registration numbers (we leveled off around 60 people registered), it was decided to postpone the code camp indefinitely while we can evaluate the attractiveness of the location (make no mistake, I think the venue -- Sorrell College of Business at … Continue reading Alabama Code Camp 9 Postponed Til Further Notice
If you haven't already done so, check your calendar for Saturday, April 14, 2012 and attend SQL Saturday #111 in Atlanta, GA. The event this year will be held again at Georgia State University's Alpharetta location. Follow the latest news on Twitter using hashtag #sqlsat111. Despite almost insurmountable odds, one of my submitted sessions was … Continue reading SQL Saturday #111 (Eleventy-one) in Atlanta
UPDATE: 2012-03-02: Due to low registrations, the event was postponed. Read more here. The ninth edition of the Alabama Code Camp is less than one month away! It will be held at Troy University's Sorrell College of Business in Troy, AL on Saturday, March 10, 2011. I remember (OK, just vaguely) attending and presenting at my … Continue reading Alabama Code Camp 9: March 10, 2012