I really meant to write a quick post about attending SQL Saturday 234 in Baton Rouge much earlier, but it's only now that I've arrived in Baton Rouge (first time visitor) that I've finally been able to sit down and do it. I am very much looking forward to the event. I haven't been to … Continue reading SQL Saturday 234 Baton Rouge 2013 in a few hours
Yesterday, Microsoft released the preview of Windows 8.1. It received a lot of attention and it may have somewhat overshadowed the preview release of Windows Server 2012 R2 ("12R2" suggests Mark Minasi). I installed it and here are some first impressions of the release. There is a Start button. It just takes you to the … Continue reading Windows Server 2012 R2 First Impressions
As part of my research for my Managing SSISDB talk, I came across an interesting script by Mike Davis. The script intends to copy an environment in the SSISDB. Mike does a good job explaining why this is useful. The SSIS Catalog does not provide a UI for that. Mike's script seems to work, but it has … Continue reading Copy or Duplicate an SSIS environment in the SSIS 2012 Catalog (SSISDB)
First of all, thanks and congratulations to the organizing team! Setting up a record attendance (555 actual attendees) is no small feat. It was great to be there. I have uploaded the SQL script files I used in my SSISDB session to the SQL Saturday site. The presentation (PDF) is available from my SkyDrive account. … Continue reading SQL Saturday #220 Atlanta 2013 wrap-up
SQL Saturday Atlanta 2013 is around the corner: this Saturday, May 18. Like in previous years, the event will be held at the GSU location in Alpharetta, GA. It looks to be a full event with a great roundup of speakers and sessions. I wasn't originally scheduled to speak. Due to a cancellation in the … Continue reading Speaking at SQL Saturday Atlanta #220: Managing the SSIS Catalog
As a follow-up to my blog series on Windows 8 (1 | 2 | 3), I felt compelled to write something about Windows RT. Just like Windows 8, Windows RT is receiving lots of press, mostly around how it's a commercial failure. Apparently, Microsoft has sold "only" about 1 million Surface RTs and I can … Continue reading My Windows RT Tablet Experience
Just a quick post to publicize the PASS DBA Virtual Chapter meeting on Wednesday where I will be presenting an online session on Configuring and Managing FILESTREAM and FileTable in SQL Server 2012. The link for registration (enters you in a drawing for a $50 Amazon gift card) is https://www.livemeeting.com/lrs/8000181573/Registration.aspx?pageName=58svx93t12hx5f16. If you just want to … Continue reading Presenting for PASS DBA Virtual Chapter on Wednesday
While reviewing some blog posts I meant to read a long time ago, I came across a post from Peter Meinl. He has a well-written blog post that first compares FILESTREAM, FileTable, VARBINARY(MAX) and file system storage for BLOBs and then discusses a sample application where he integrates WCF, EF and FILESTREAM. Well worth the … Continue reading FILESTREAM, Entity Framework and WCF Sample Application
I am not sure if I am the only one, but it seems to me that recently, the level of personalization of ads you see on web pages has increased dramatically. I usually don't pay much attention to the ads on the sides of articles, etc. However, lately for some reason I couldn't help but … Continue reading Personalized/Behavioral Web Ads Reaching New Levels
A brief post about something I just learned the hard way: Windows Server 2012 iSCSI Targets do not support dynamically expanding VHDs. The new iSCSI target that's integrated into Windows Server 2012 looked like a great tool for setting up a virtual NAS on VMware Workstation to create a SQL Server 2012 failover cluster test … Continue reading iSCSI Target in Windows Server 2012 does not support dynamically expanding VHDs
Sven Aelterman 