GSA Technology Council

Archive for the ‘Users Group Accouncement’ Category

SQL Server Innovators Guild August 2010 Meeting

The August 3, 2010 meeting of the SQL Servers Innovator’s Guild will present ’Visual Studio 2010 Database Projects: Top 7 features to make database development a breeze!’

In this session Rafael explains how you can use Visual Studio database projects  (aka data dude) to have better control over your database schema and reduce the risk and complexity related to the database development cycle. He will talk about the pros and cons he has experienced when using the tool in his  projects and will highlight improvements made since the last version. This is a demo packed session where you will learn about  schema versioning, testing, refactoring,  deployment and more.

Most the content of this session remains relevant to the previous version of the tool- VSDB 2008 GDR2 – and, no, you don’t need prior knowledge of Visual Studio to get the most out of this presentation!

Rafael Salas is a MCITP and MCTS with a Bachelor’s degree in Computer Engineering and a Masters in Information Technology . Currently, he is a Manager of Professional Services Consulting at Quaero, a CSG Solution where he provides technical  leadership and helps organizations improve performance through Customer Intelligence strategy and solutions.

Rafael is a Microsoft SQL Server MVP with more than 12 years of experience in data warehousing and business intelligence. He is a blog and article author, and is very active in SQL Server MSDN  forums. His specialties include Business Intelligence and data warehousing architecture, ETL, OLAP  and Dimensional Modeling. Rafael is a frequent speaker at community events such as  PASS SQL Saturdays, local users groups and code camps. You can find more about  Rafael on his blog:  www.rafael-salas.com

Please register here

6:00 – 6:30 Meal and Networking

6:30 – 6:40 Announcements

6:40 – 8:15 Rafael Salas: Visual Studio 2010 Database Projects: Top 7 features to make database development a breeze!

8:15 – 8:30 Closing remarks and give-a-ways

via SQL Server Innovators Guild

SQL Server Innovators Guild March 2010 Meeting

The March 2, 2010 Meeting of the SQL Servers Innovator’s Guild will feature Processing Flat Files with SSIS as the feature presentation. When doing data integration, a common requirement is to work with flat files, whether for importing data into a system from an external source, or to export it to provide to other systems. SQL Server Integration Services (SSIS) supports flat files, but there can be a number of challenges when working with them. This is particularly true if your flat files have multiple data formats contained in a single file, the data has complex formatting, or the files have inconsistent formatting. This session will help you to be more efficient when working with these types of files. You’ll learn to handle missing delimiters in the files, and parsing files that have multiple data formats. You’ll also see how to produce complex output formats, like headers and footers that contain summary information.

Takeaways:
1. Learn to handle complex formatting in flat files
2. See the techniques to deal with poorly formatted input files
3. See the available open source components for processing flat files

via: SSIG

August Greenville Mac Users Group – Copy DVDs on your Mac

The Greenville Mac Users Group Meeting is Monday, August 10, 2009.
Wireless is available, so bring your laptops.

Agenda:

6:30 PM : Mac Basics

7:00 PM : Do you want to be able to watch movies and your favorite TV shows on your computer or iPod or iPhone? Learn how you can copy DVDs with software like Handbrake to make your movies more portable and convenient to watch – plus how to make backup copies of your DVDs.

Meeting Place: Grace Baptist Church Choir Room
5020 Old Spartanburg Road, Taylors, SC 29687
(At the Intersection of Brushy Creek & Old Spartanburg Roads)

Directions/Map: http://www.gbctaylors.org/AboutUs/LocationDirections/tabid/77/Default.aspx

via: GreenvilleMug.org