SSIS Talk

Saturday, August 27th, in Omaha, NE, we are hosting a SQL Saturday event that is promising to be a great time. This is a free event ($10 lunch fee if you want lunch on us) that helps promote our local SQL PASS chapter. Register here: http://www.sqlsaturday.com/91/eventhome.aspx

I will be presenting on two topics: SSIS changes in Denali, and Using Event Notifications for Monitoring SQL Instances.

The first session, SSIS Changes in Denali, is pretty self-explanatory. Expect that I will go through each of the major changes in demo form, with some discussions around each.

The second session around Event Notifications, will be quite a bit more advanced and will talk about using the Event Notifications infrastructure in SQL Server combined with Service Broker to implement a very robust monitoring system. This infrastructure allows for capturing all kinds of audit information such as creating a table, dropping an index, rebuilding statistics, blocking, deadlocks, etc… There’s quite a bit of information that can be captured. I will show how to set this up and how to consume the information for monitoring purposes.

Don’t miss your chance at seeing me speak (!) and most importantly don’t miss your chance at learning SQL Server topics for free. See you there!

An event flyer can be found here: http://www.ssistalk.com/Flyer_updated.pdf Please distribute as you see fit!

Omaha, Nebraska. A town based alongside the Great Flood of 2011 Part II (The Missouri River) will be hosting its first SQLSaturday event on August 27th, 2011. A SQL PASS sponsored event offering a full day of free SQL Server education, networking, food, and fun. The event will be held at the brand new, state of the art College of Business Administration building at the University of Nebraska at Omaha’s campus.

We have the call for speakers open right now. If you would like to speak and would like to know more information, please contact me (using the Contact link at the top of the page) or submit your details online and let us know you’d like some more information.

For more details, visit http://www.sqlsaturday.com/91/eventhome.aspx.

For those of you that wished this site was accessible on mobile clients, this request is now complete. The site will detect that you are browing with a mobile client and present you automatically with a format suited for your device. Please let me know if you run into issues.

Also, when viewing the mobile version, at the bottom of the page is an option to switch back to the full site (see the switch titled “Mobile Theme”). Enjoy.

If you have something that you’d like to see blogged here regarding SSIS and/or SQL Server, please let me know and I’ll see what I can do.

Also, if you find a post here that you’re using to work on an issue in SSIS 2008, let me know if it isn’t working for you. It could be that I don’t have updated content for use in the SSIS 2008 environment. It’s easy enough to update, I just won’t be able to catch all of the items listed here.

One last thing – the annual MVP Summit is coming up in February. If you have something that you’d like for me to bring to the SSIS dev team in terms of feedback, feature requests, bugs, etc…, let me know and I’ll do my best to present them to the team.

I had a little “snafu,” if you will, regarding my domain name provider which caused this site to be unavailable for a few days over the weekend… This has been resolved….

Sorry for the inconvenience!

Happy New Year to all of the readers of SSISTalk.com!!

You can look forward to reading about the SSIS API using real world examples, a review of Itzik Ben-Gan’s new book, “Microsoft SQL Server 2008 T-SQL Fundamentals,” more blog posts about tough SSIS concepts, news from the dev team (that I can share!), and much more! Stay tuned!

The MSDN & TechNet Search team have made some improvements to their search engine.

Here’s a quick walk-through….
(more…)

Please ensure that if you fall under the affected operating systems in MS08-067, patch your system immediately. Basically, if you are on Windows 2000, XP, or Server 2003, Microsoft has put you in the “critical” bucket. Vista and Server 2008 are in the “important” bucket.

So, I’ve decided to move into the realm of having my own blog space for SSIS along with a nifty domain name. Please note that from time to time the site look and feel may change. I’m bound and determined to try to find something I really like in terms of presenting this content… This site will replace http://ssistalk.blogspot.com.