FWSSUG Meetings

-June 2017+
SMTWTFS
28293031123
45678910
11121314151617
18192021222324
2526272829301
2345678
  • RSS
  • Add To My MSN
  • Add To Windows Live
  • Add To My Yahoo
  • Add To Google

Statistics

  • Entries (91)
  • Comments (0)

Aug 19 Meeting - SQL Server Unit Testing with Mike Hotek 

Thursday, August 13, 2015 8:31:00 AM Categories: Meeting
For those of you that joined us for the warehousing class Mike taught earlier this the year we went through source control, branching & merging, unit testing, code generators and all kinds of great processes. Mike wanted to say more about unit testing than he had time to in the class.
 
Topic:
To meet the needs of rapid application development and the rapidly changing needs of the business, your database code needs to be resilient.  Even the most resilient code can become incredibly expensive when things break.  Catching issues early in a development cycle saves time, money, and a lot of sleepless nights.  In this session, we will go over the basics of unit testing using the open source tSQLt framework.
 
Speaker: 
Mike Hotek has lectured, authored and consulted all over the world and is currently the Business Intelligence Architect at Six Flags. He has enabled a huge variety of companies in numerous industries with SQL Server tools since before it was a Microsoft product (long time). After authoring 10 SQL Server books, he not going to Disney World. Six Flags is more fun. 
 

 

6:30 PM Meet & Greet | 7 PM Presentation

 

See you there,

The folks at the Fort Worth SQL Server Users Group

 

July 15 Meeting - Defend your Data! Know the Rules: Compliance, Laws & Regulations with Joan Bradford-Pope  

Tuesday, July 14, 2015 10:23:00 AM Categories: Meeting

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

June 17 Meeting - Double the Speaker Fun with both Michael Bourgon & Margaret Westrell 

Monday, June 15, 2015 5:39:00 PM Categories: Meeting

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!"

 
Topic: "How much?" becomes "Too much!"
Organizations are collecting and storing increasing amounts of data.  While business 
managers discuss analyzing data, it is often left to IT and the DBAs to figure out how to 
store and manage that data.  In this short presentation, Margaret will discuss data 
retention, a facet of data governance, review the options SQL Server offers, and present 
an effective, low impact, method for pruning large tables to maintain a manageable amount 
of data.
 
Margaret Westrell has been a SQL Server DBA for 3 years and is currently lead for an DBA 
operations group wrestling with substantial data growth.  Prior to being a DBA, she was a 
.Net developer of database-centric applications.  In her first career, she served in the Navy during the Cold War and Operation Desert Storm.  When not taming space issues, she enjoys spoiling her husband, the family dog and two cats, and keeping up with her daughter at college.

 

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

May 20 Meeting - Nancy Risha: Gathering Requirements Can Be Painless 

Sunday, May 10, 2015 10:23:00 PM Categories: Meeting

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

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

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