Aunt Kathi's SQL Server Home

Who will play you in the movie?

Posted on 2015/02/21 by Kathi Kellenberger

I started writing articles and, eventually, books about 10 years ago. The first book I contributed to was also the very first book on SSIS. One of my co-workers joked at the time “Who will play you in the movie?” I guess that Hollywood isn’t quite ready to make a movie about SSIS, but one of my blog posts was recently turned into a movie, well, a video at least. Webucator has a free course with videos based on posts by SQL Server bloggers called SQL Server Solutions from the Web.

The video and post explain the difference between ROWS and RANGE when working with window functions. If you would like to take a look at the video, you can sign up for this free class or watch it here:

Posted in Life in IT | Leave a comment

Taking a break from computers

Posted on 2015/01/29 by Kathi Kellenberger

I absolutely love my smartphone and being a database professional, but sometimes you just have to unplug for a few days. I’m trying to recover today after a four day Rock Boat cruise featuring my favorite band, Barenaked Ladies. While I did use my phone as a camera and clock, I was completely cut off from the world while on the cruise. This is the first time I’ve had a disconnected vacation since my last cruise in 2011.

I’ve heard that musicians are the only professionals who love what they do so much that they make music just for fun. I feel that way about what I do for a living, too. I think of my work as playing rather than working. I am so excited to learn new things about SQL Server and never want to stop. Being a part of the SQL Server community, actually family, is a bonus.

Despite how much I love my job, it was great to get away for a few days. I am still feeling the cruise after-effects like wondering where the buffet is and the room is swaying.

Posted in Life in IT | Leave a comment

What is the SSIS Catalog?

Posted on 2015/01/15 by Kathi Kellenberger

Microsoft gave SSIS a complete makeover with the 2012 release. Most of the changes were cosmetic in nature – pun intended. The biggest change with SSIS 2012 is deployment to the new SSIS Catalog.

In earlier versions of SSIS you had an overwhelming number of decisions to make. Should the packages live on a file share or in MSDB? Should your configurations go in an XML file or maybe in a SQL Server table? How will you protect sensitive information? What about a using framework or third party tool to make managing SSIS easier?

Starting with SSIS 2012, you can forget all those decisions by using the new Project Model deployment and the SSIS Catalog. OK, I admit that switching your existing SSIS projects to the new model is going to take some planning and work, but the end results will be worth it.

The SSIS Catalog is the one place where you will manage SSIS projects and packages, including the configuration and monitoring. If you take a look at SSMS, you will see a new folder, Integration Services Catalogs. The catalog is not set up by default, you will have to create it. Even though the name is plural, at this time, you can create just one catalog.

To create the catalog, right-click Integration Services Catalog and select Create Catalog. You will be asked to enable CLR integration and to enter a password for encryption. If you don’t want your to enable CLR in your environment, you can always create an instance just for SSIS.

Once you click OK, you will see an SSISDB icon and an SSISDB database.

If you are so inclined, you can take a look at the tables and views in the new SSISDB database. The SSIS Catalog has built in logging and reports, but you could create your own reports if you wish.

Once the catalog is in place, you can deploy your projects, and they’ll show up in a folder under the catalog. From here, you can set up environments, map parameters, and run packages, but those are topics for another day.