FWSSUG Meetings

April 15 Meeting - Tim Mitchell: Managing Data Quality In SSIS 

Monday, April 13, 2015 10:38:00 AM Categories: Meeting

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, SQLBitsSQL ConnectionsSQL 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

Real World Data Warehouse Class Files 

Sunday, April 5, 2015 11:35:00 PM Categories: Meeting Training

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. 

 

Class Begins 9 AM Saturday (March 7) Morning! 

Friday, March 6, 2015 3:31:00 PM Categories: Meeting Training
 

I hope you all benefited from a snow day or two. Or at least I hope you enjoyed the snowy view out the window as you worked from home. 

Class begins at 9 in the morning and you are welcome to bring a lunch. There are plenty of restaurants in the area as well and we will have about an hour break for you to go enjoy one. Class will go till 5 PM. The only caveat is our meeting facility has a door that auto-locks at 1 PM. Please try to be back before the outside doors lock. 

The other thing is you will have limited cell signal in the training lab as it is partially underground. There is wi-fi available.

 

First Saturday of Class Cancelled Due to Weather 

Friday, February 27, 2015 10:13:00 PM Categories: Meeting Training

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! 

Winter Weather Advisory: Possible Delays to Class Start 

Friday, February 27, 2015 11:48:00 AM Categories: Meeting Training
Happy snowy Friday!
 
If you have not paused to look out the window, it is beautiful and fluffy white in many parts of North Texas currently. 
 
We are under a Winter Weather Advisory until Saturday and road conditions are expected to get worse. 
 
We are taking a wait see approach on the class in the morning. 
 
We planned to start at 9 AM tomorrow and the following two Saturdays. 
It could be fine tomorrow, but there is a chance we may have to delay start until noon or worse. 
 
Please watch the web sites for weather postings BEFORE you make the trek to South West Fort Worth. 
 
Thanks and see you soon! 
The Folks of the Fort Worth SQL Server Users Group

Three Saturdays of Class: Real World Data Warehouse Build : Feb 28th, March 7 th & 14th 

Wednesday, January 28, 2015 10:10:00 PM Categories: Meeting Training

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

Happy New Year - And Get Well Soon!  

Tuesday, January 13, 2015 10:29:00 PM Categories: Announcement Meeting Training

Well wishes to our Mascot who is recovering. Let's all wish him a much better rest of the year.

We normally facilitate a small segment of time the third Wednesday of the month to get together and learn about SQL Server and related database technologies. 

We want to start out the first quarter of 2015 a little differently How about we trade you three Wednesday evening 1 hour sessions for 3 full day training classes? Would you take that trade? 

We are finalizing another round of Saturday classes. Back by popular demand, Mike Hotek is giving up more of his weekend time. 

The 3 days of topics coming the last Saturday in Feb and the first two Saturdays in March: 

Real World Data Warehouse Build

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

 

Oct 15 Meeting - Ryan Adams: AlwaysOn Live Deployment 

Monday, October 13, 2014 11:18:00 AM Categories: Meeting

Joyous tidings of autumnal coolness to you all. We are ecstatic to have Ryan Adams come out again and show us how to prevent harrowing tales of SQL outage. AlwaysOn has made database availability easier than ever. I encourage ALL of you to maintain your own learning labs, but if you don't want to spin up your Virtual library of lab machines at least check out the Microsoft labs: http://technet.microsoft.com/en-us/virtuallabs?id=J+avMPtWlXk. Search for "Exploring AlwaysOn Availability Groups in SQL Server 2014"

 

 

Abstract:

This session is 90% live demonstrations.  I'll walk you through a complete AlwaysOn deployment.  You will see firsthand how to install and configure an AlwaysOn Failover Cluster.  I'll also show you how to setup an AlwaysOn Availability Group across 5 nodes using both the GUI and T-SQL so you know why and when to use each method.  I'll finish up by showing how you can connect to a readable secondary.

 

Bio:

Ryan Adams is a SQL Server MVP and has worked for Verizon for 16 years. His primary focus is the SQL Server Engine, high availability, and disaster recovery. Previously he was a Senior Active Directory Architect and designed the company's worldwide Active Directory infrastructure.  He serves on the Board of Directors for the North Texas SQL Server User Group and is President of the PASS Performance Virtual Chapter. He is also a PASS Regional Mentor and holds the following certifications: MCP MCSA MCSE MCDBA MCTS MCITP

 

See you there,

The folks at the Fort Worth SQL Server Users Group

 

 Remember, we meet the third Wednesday of most months

September 2014 Meeting Cancelled 

Tuesday, September 16, 2014 9:45:00 PM Categories: Meeting

Happy autumn everyone! We will not be facilitating any SQL fun this month, but we will be back in October with great stuff from Ryan Adams, so stay tuned. 

SQL Watchdog! 

Monday, August 18, 2014 5:42:00 PM

August 20 Meeting - Michael Bourgon presents SQL Watchdog!  Edit

Monday August 18, 2014 5:45:00 PM Categories: Meeting

 

 

Our own Baking DBA is going to wow us with his latest presentation!  Michael has presented for not only us in the past, but also at SQL Saturday 255 (Dallas), SQL Saturday 271 (Albuquerque), SQL Saturday 308 (Houston), and the PASS Database Administration VC.   Plus, he is going to be presenting at SQL Saturday Oklahoma City on August 23rd, at 2:45 PM. 

 

 

SQL Watchdog - find out instantly when SQL changes in production

Almost everyone's seen it happen - problems due to changes, be it code, index rebuilds, or even configuration. But what if you could look historically and see which changes were made, when, by whom, and from where? What if you could see it in realtime? It exists, it's built into SQL Server (yes, even standard edition) from 2005-2014, and it's easy to implement. Come learn what Event Notification is and why you'll want it in your environment. This is not theory! All code provided and is in production on hundreds of servers in multiple environments.

 

Michael Bourgon - Michael Bourgon is the Senior Production DBA for a large healthcare company. He's always looking for a better way to be a Lazy DBA - spending far too many hours automating processes in order to accomplish that.

 

 

 
Page 3 of 9 << < 1 2 3 4 5 6 7 8 9 > >>
Site Map | Printable View | © 2008 - 2017 Fort Worth SQL Server Users Group | Powered by mojoPortal | HTML 5 | CSS | Original design by Andreas Viklund