Space Coast SQL User Group

Frequently DBA's are tasked with restoring databases from servers across the WAN for troubleshooting and other various reasons. SSIS can be very useful in automating these tasks.

The following demonstrates using SSIS to automate restoring a large database to different location.

Bonnie's Blog

SCSUG Meeting

By Bonnie Allard on 1/13/2012 7:17 AM

Max Trinidad did an fantastic job presenting Extend you TSQL skills with PowerShell

Bonnie's Blog

Space Coast SQL Users Group Holiday Social

By Bonnie Allard on 12/13/2011 7:32 AM

My sincere thanks to Red Gate, a premier supporter of our SQL community and their many Microsoft users. They offered a holiday competition for ideas to create the best holiday party and our input won providing the Space Coast SQL Users Group an excellent holiday party evening. We were able to provide dinner, gifts, and a free round of drinks for our members and their spouses and significant others. The party was hosted in the back room of the Broken Barrel, an excellent sports bar/family restaurant in Palm Bay, Florida. The food was delicious and consisted of Asian potato salad, sweet potato fries, smoked wings and assorted smoked meat sliders. Broken Barrel’s service was excellent; they even helped with suggestions on food types and combinations. The best part was the gifts weren’t technical books or left over swag like the previous years. I will never forget giving a member s wife a book on Administering Windows Server 2008. Thankfully everyone in our group loves humor. This year I found a little store in Jensen beach that had a ton of unique gifts. We gave tickets to spouses and significant others and had each person choose a wrapped gift from the table. I picked out several Florida Santa figurines, threw in a mounted prehistoric shark’s tooth, nice chocolates and a bottle of fine wine. Then everyone received a ticket for our door prize, a decorated Santa on the beach. The event was an outstanding success, we cannot thank Red Gate enough for their kindness. Everyone have a wonderful holiday and a safe New Year, I know I will.

Bonnie's Blog

First meeting at our new location

By Bonnie Allard on 10/21/2011 8:46 AM

Thank you Florida Institute of Technology and Dr. Philip Bernhard for sponsoring our group for a new meeting place!

Bonnie's Blog

PASS Summit 2011

By Bonnie Allard on 10/15/2011 11:46 AM

This was my third year attending PASS, I had the privilege of being apart of my friends first time experience at PASS Summit. It was with great pleasure I was able to introduce my friend to all the people that have helped shape my career over the past 3 years. Everyone was friendly and all the presentations she attended were spot on! Thank you all! There is a lot of knowledge with in our community and these events really facilitate and encourage collaboration amongst the technical people. Networking and Professional Development has given an increased focus at PASS and I really believe this is critical for career growth. Are you a Linchpin was a great session. I find it very encouraging when those you admire for their technical expertise sit on a panel to and share personal experiences that have help shape their career . This humanizes the technical industry.

Bonnie's Blog

SQL Table Columns Disappear in Access

By Seth Phelabaum on 9/28/2011 9:23 PM

A couple weeks ago a user complained that on one of our development databases, one of the views he was linking to via Access was missing some of the columns. There were no permissions issues and the columns all showed up properly if they looked at the view via SSMS; but when they went into Access and linked to the view… the columns weren’t there. After scratching our heads for a bit, we realized that the user didn’t have access to the User defined Types that the columns in the underlying table were designated as. SQL doesn’t actually care about this, you can view data in the table or view whether you have the references permission or not… but Access is a bit more picky and will ignore the column if the user doesn’t have the proper permissions. Normally we grant references on these types to Public in all the databases so that we don’t have this issue, but on this particular development server we forgot. This is another issue that can be very puzzling when it happens out of the blue and is very hard to Google...

SCSUG Blog