Fort Worth SQL Server Users Group

Ok all you data defenders, ignorance of the law is no defense.  If someone is asking you to do something with the data that could get you and your company in trouble you need to know. Many companies do not invest in this kind of training for IT, but we have in our midst a globe-trotting rock star of an auditor that is taking the time to share her experience with us.

She will cover, from the perspective of the DBA, the highlights of Sarbanes-Oxley; Graham, Leach, Bliley;  HIPPA, PCI, and state privacy laws (Texas).  You will be able to better understand the practical solutions you can take to enhance compliance with these laws, regulations, and rules.  We will go to the code and regs and some guidebooks that the regulators use to see how your processes align with requirements.

Joan has been a business consultant, controller and managed the internal audit function of both a financial services company and a global manufacturer. Her interest in compliance began in graduate school when where she pursued a master’s degree in taxation (Title 26 USC).

6:30 PM Meet & Greet | 7 PM Presentation

See you there,

The folks at the Fort Worth SQL Server Users Group

Not one but two members of the Emdeon dream team are taking stage this Wednesday!

This is a farewell tour for Lieutenant Commander Westrell before she heads back to Baltimore to navigate the SQL seas from there. She will be greatly missed. 

This is also your last chance to see Bourgon before he presents at 24 hours of PASS this coming June 24th. If you've missed him speaking seven times previously at SQL Saturdays around the country, you can be sure he saves the best interpretive dance numbers for us!

Come see how they Solve Problems at Scale and learn when "How much?" becomes "Too much!"

6:30 PM Meet & Greet | 7 PM Presentation

See you there,

The folks at the Fort Worth SQL Server Users Group

 Remember, we meet the third Wednesday of most months

Ah, and the things this team does with those requirements! For those of you that came to the data warehousing class, this is the front end steering the outcomes you saw in that class.

You can craft the most elegant solution, but no one cares if you're not solving the right problem.

Synopsis: Gathering requirements is sometimes thought of as an arduous task.  Sometimes there are endless meetings, multiple changes and what you end up with isn’t what the user wanted.  There is hope, and gathering requirements doesn’t have to be endless meetings to decide on what those requirements are.  This presentation will cover how to effectively gather requirements, what to do when those requirements change and learning to speak the same language as your end users. 

About the Presenter:  Nancy Risha is the Manager of Business Analytics for Six Flags Corporate.  She is currently in her final semester for an MBA with an emphasis in IT Management.  

6:30 PM Meet & Greet | 7 PM Presentation

See you there,

The folks at the Fort Worth SQL Server Users Group

 Remember, we meet the third Wednesday of most months

Managing Data Quality In SSIS

Managing data quality should be a part of every enterprise data management strategy, and a key component of that is the detection and resolution of bad data during the ETL process. As the primary data movement and transformation tool in the Microsoft data management stack, SQL Server Integration Services is often the central point of administration for data quality. In this session, I'll demonstrate some methods for detecting and fixing bad data using SSIS using native tools, scripting, and SQL Server Data Quality Services (DQS) integration.

About the Presenter

Tim Mitchell is a business intelligence consultant, author, and trainer.  He has been working with SQL Server for over a decade, working primarily in business intelligence, ETL/SSIS, data quality, and reporting.  He holds a Bachelor’s Degree in Computer Science from Texas A&M at Commerce, and has been a Microsoft SQL Server MVP since 2010.  Tim is an independent business intelligence consultant and a partner with Linchpin People, and is the principal at Tyleris Data Solutions.

As an active member of the community, Tim has spoken at international, regional, and local venues including the SQL PASS Summit, SQLBits, SQL Connections, SQL Saturday events, and various user groups and webcasts.  Tim is coauthor of the book SSIS Design Patterns, and is a contributing author on the charity book project MVP Deep Dives 2.  He is an active group member and speaker at the North Texas SQL Server User Group in the Dallas area.

You can visit his website and blog at TimMitchell.net or follow him on Twitter at twitter.com/Tim_Mitchell.

6:30 PM Meet & Greet | 7 PM Presentation

See you there,

The folks at the Fort Worth SQL Server Users Group

 Remember, we meet the third Wednesday of most months

Thanks everybody who came out and joined the learning community and enjoyed the Real Life Data Warehouse build out.

Here's Mike's samples from the class: Class Files.

This following April's meeting is Tim Mitchell. More details to come. 

Sorry everyone, looks like we need to call it a weather day for the first Saturday of the class.

We wanted to do a delayed start, but there's a good chance the ice shell will not be melted by then. We'll see you on the 7th! 

Stay safe and warm and enjoy the snow! 

We're switching up the format for the first quarter of 2015. We're trading three monthly meetings for three full training days! 

Mike Hotek is donating more time to the local SQL Community by teaching the class. Other people are donating their time and efforts to facilitate space and the rest of the event. 

We're not charging for the class, but we are accepting donations to off set the monthly meeting costs.

We're here to be a part of a professional learning community, not to sell you something. But having said, that, please do sign up HERE as seating is limited. 

We'll be meeting three Saturdays in a row from 9 AM to 5 PM on Feb 28th, March 7 th & 14th. 

Be sure to thank Mark as we will be in our usual location for the class.

Class Description: 

You’ve seen plenty of theoretical articles, lots of demos of disconnected snippets of solutions.  We’re going to take all of these items plus a lot more and put them together into something useable and practical to build a real solution from start to finish. This class will provide the knowledge necessary to implement all of the processes you need to quickly, flexibly, and incrementally build out a data warehouse.  You don’t need weeks of contiguous blocks of time, you just need a few hours here and there, directed appropriately to have a large impact. In this class we will cover the following:

Team Foundation Server (TFS)

What it is, how you use it, and why you need it (or a tool like it)

Source code control

What it is, how to implement it, how to manage your source code, branching/merging

 Work items

Planning your work

Packaging into deliverable components (user stories)

Breaking down business deliverables into technical tasks (tasks)

Estimating work

Work flows

Data modeling

Building out a warehouse model

Source control

Data Dictionaries

Tagging

Automation macros

Basic ETL framework

Building your T-SQL layer

Merge procs

Watermark procs

Code generating the T-SQL layer

Unit testing

                     What is it, why you do it, how you do it

ETL workflows

Code generating the T-SQL layer

Code generating your SSIS packages using BIML

SSIS deployments

Parameters

Environments

References