FWSSUG Meetings http://www.fwssug.com/meetings.aspx http://www.rssboard.org/rss-specification mojoPortal Blog Module en-US 120 no Real World Data Warehouse Class Files 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. 

 


dbo.judith]]> http://www.fwssug.com/real-world-data-warehouse-class-files.aspx http://www.fwssug.com/real-world-data-warehouse-class-files.aspx http://www.fwssug.com/real-world-data-warehouse-class-files.aspx Mon, 06 Apr 2015 04:35:00 GMT Class Begins 9 AM Saturday (March 7) Morning!  

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.

 


dbo.judith]]> http://www.fwssug.com/class-begins-9-am-saturday-march-7-morning.aspx http://www.fwssug.com/class-begins-9-am-saturday-march-7-morning.aspx http://www.fwssug.com/class-begins-9-am-saturday-march-7-morning.aspx Fri, 06 Mar 2015 21:31:00 GMT First Saturday of Class Cancelled Due to Weather 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! 


dbo.judith]]> http://www.fwssug.com/first-saturday-of-class-cancelled-due-to-weather.aspx http://www.fwssug.com/first-saturday-of-class-cancelled-due-to-weather.aspx http://www.fwssug.com/first-saturday-of-class-cancelled-due-to-weather.aspx Sat, 28 Feb 2015 04:13:00 GMT Winter Weather Advisory: Possible Delays to Class Start 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

dbo.judith]]> http://www.fwssug.com/winter-weather-advisory-possible-delays-to-class-start.aspx http://www.fwssug.com/winter-weather-advisory-possible-delays-to-class-start.aspx http://www.fwssug.com/winter-weather-advisory-possible-delays-to-class-start.aspx Fri, 27 Feb 2015 17:48:00 GMT Three Saturdays of Class: Real World Data Warehouse Build : Feb 28th, March 7 th & 14th 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


dbo.judith]]> http://www.fwssug.com/three-saturdays-of-class--real-world-data-warehouse-build--feb-28th-march-7-th-14th.aspx http://www.fwssug.com/three-saturdays-of-class--real-world-data-warehouse-build--feb-28th-march-7-th-14th.aspx http://www.fwssug.com/three-saturdays-of-class--real-world-data-warehouse-build--feb-28th-march-7-th-14th.aspx Thu, 29 Jan 2015 04:10:00 GMT Happy New Year - And Get Well Soon! 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

 


dbo.judith]]> http://www.fwssug.com/happy-2015-and-get-well-soon-.aspx http://www.fwssug.com/happy-2015-and-get-well-soon-.aspx http://www.fwssug.com/happy-2015-and-get-well-soon-.aspx Wed, 14 Jan 2015 04:29:00 GMT Enterprise Information Architecture with Mike Hotek Oct 19th, 26th & Nov 9th 8 AM - 5 PM Ah, it's autumn and back to school time with all our friends! The Forth Worth SQL Sever Users Group is here to facilitate a vibrant learning community of information professionals. Mike Hotek is donating his time and vast experience to focus on the fundamental processes that allow you to take data and forge it into actionable information. Any donations for the class will go toward the user group monthly meetings costs (pizza like substances). 

Sign up here to reserve your seat: https://hotekia.eventbrite.com

Day 1 - Oct 19th -  Data Governance

  • Overview
  • Data Governance Program
    • Building a Business Case
    • Charter
    • Roadmap
    • Establishing Metrics
    • Data Architecture
      • Data Modeling
    • Data Quality
    • Data Integration
      • Data Validation
      • Data Lineage
    • Data Management
    • Data Stewardship
    • Master Data Management

Day 2  - Oct 26th -   Enterprise Data Modeling

  • Building a Data Modeling Practice
  • Modeling Tools and Processes
  • Metadata
  • Conceptual Data Modeling
  • Logical Modeling
  • Physical Modeling
  • Data Dictionaries
  • Master Data Modeling

Day 3  - Nov 9th -   Business Intelligence

  • Business Intelligence
    • Enterprise BI Capabilities
    • Enterprise BI platforms
    • Metadata Repositories
    • Data Lineage
  • “Big Data” – what does it REALLY mean to you
  • Data Governance Lifecycle
 
Instructor Bio:
Mike Hotek is the Senior Business Intelligence Architect for CBRE. He has been building SQL Server systems and database management best practices for almost 20 years and has worked with companies across many industries. Mike has delivered hundreds of sessions and training events around the world and has published numerous articles along with 9 books. He is currently working on book two a four book series on SQL Server. Contact URL: www.ChampionValleySoftware.com 

dbo.judith]]> http://www.fwssug.com/enterprise-information-architecture-class.aspx http://www.fwssug.com/enterprise-information-architecture-class.aspx http://www.fwssug.com/enterprise-information-architecture-class.aspx Fri, 04 Oct 2013 23:21:00 GMT Jump Starting Data Governance Embarcadero just extended their ER Studio product line to include a piece to capture business rules. If you are involved in or are starting a data governance initiative and want an excuse to enjoy a weekend in Austin, this lunch and learn might be for you. http://forms.embarcadero.com/forms/ERStudioLunchLearnAustin

They will be discussing:

 

  • Obtaining reliable and relevant information via data governance
  • Using ER/Studio for key governance ingredients: enterprise information maps and metadata collaboration
  • Mapping  ER/Studio features to data governance maturity milestones

 


dbo.judith]]> http://www.fwssug.com/jump-starting-data-governance.aspx http://www.fwssug.com/jump-starting-data-governance.aspx http://www.fwssug.com/jump-starting-data-governance.aspx Tue, 21 May 2013 22:48:00 GMT SQL Server 2012 Learning Opportunity on Saturdays in April in Fort Worth with Mike Hotek. This is your chance to break past the learning curve and be ahead in your career. Budgets are tight and several people fail to make the case to get adequate training or experimentation time to stay current.

 

These weekend classes are a great way to build a solid foundation to be confident and capable with SQL Server. They also provide a great way to get to know the other SQL Server professionals in the area.

 

Training of this quality and this depth and length does not come around for free very often.  This will be the only class from Mike Hotek this year.

 

The course material will follow this book: SQL Server 2012 Data Design and Retrieval by Mike Hotek

 

You may purchase the class text book http://championvalleypress.com/data-design-and-retrieval.aspx.

You may still reserve your seat http://hoteksql.eventbrite.com.

 

For those of you who have signed up already, can't wait to see you and here are a few things to remember:

 

  • In the training lab your cell phones will have very limited signal.
  • Mark has graciously made wireless available, but that many laptops is a challenge for the access point.
  • There are vending machines and microwaves upstairs.
  • We break for lunch and go off site. This is a great time to get to know your classmates.
  • If you bring your own coffee and snacks, please be respectful of the space we have been granted for the class and cleanup after yourself.

 

Class dates: April 6, 13, 20 & 27 (all four Saturdays)

Class Times: 9 AM -  4 PM


dbo.judith]]> http://www.fwssug.com/sql-server-2012-learning-opportunity-on-saturdays-in-april-in-fort-worth-with-mike-hotek.aspx http://www.fwssug.com/sql-server-2012-learning-opportunity-on-saturdays-in-april-in-fort-worth-with-mike-hotek.aspx http://www.fwssug.com/sql-server-2012-learning-opportunity-on-saturdays-in-april-in-fort-worth-with-mike-hotek.aspx Sat, 30 Mar 2013 03:37:00 GMT Return of the Weekend SQL Server Classes! We are delighted to announce we are cancelling the monthly meetings in March and April.

 

We are happy about this because in replacement, we are offering you the return of the Weekend SQL Server classes! Instead of a small lecture, we're offering you 24 hours of solid SQL Server 2012 education!

 

Seating is limited, so reserve your spot here:  http://hoteksql.eventbrite.com

 

 

Mike Hotek is donating his Saturdays in April to the SQL community!

 The weekend SQL classes are back for a SQL Server 2012 round! For the veterans who have drank from this particular flavor of fire hose, we've missed you and we can't wait to see you again.

 We are excited to be able to invite you all back for four Saturday classes in April. They will be April 6, 13, 20 & 27 from 9 am to 4pm.

 For those of you who have not yet experienced Mike Hotek's training, what ever your experience level you will benefit from spending time talking about SQL Server with someone who has tirelessly worked with this product since its very beginning in more industries and sizes of environments and countries than you can imagine. 

The class is designed to go through the first book in a series of four. The book will be available just in time for the class. Check here at the end of March for class materials: http://www.championvalleypress.com/books.aspx

 

SQL Server 2012 Data Design and Retrieval

Courseware Modules:

 

Installation and Configuration

 

  • SQL Server Tools
  • Creating Databases
  • Database Structure
  • Contained Databases  
  • Designing Tables
  • Data Modeling
  • Data Types
  • Hierarchy
  • Constraints
  • FileStream
  • FileTable
  • Storage Engine Internals
  • Data Manipulation
  • Manipulating Hierarchies
  • Bulk Loading Data
  • Change Tracking
  • Transaction Management
  • Locking
  • Isolation Levels
  • Row Versioning
  • Data Retrieval
  • Joins
  • Subqueries
  • Aggregates
  • Advanced Data Retrieval
  • Set Operators
  • Table Expressions
  • Window Functions
  • XML
  • Spatial Objects
  • Spatial Calculations
  • Geography Data
  • Indexes
  • Clustered
  • Non-Clustered
  • Filtered
  • Covering
  • Statistics
  • Index Internals
  • Forwarding Pointers
  • Indexing Hierarchies
  • XML Index
  • Selective XML Index
  • Spatial Indexes
  • Index Maintenance
  • Columnstore Indexes
  • Full text index
  • Word Breakers and Stemmers
  • Stop Lists
  • Document Properties
  • Querying Full Text Data
  • Semantic Search
  • Partitioning
  • Functions
  • Schemes
  • Partitioning Tables and Indexes
  • Modifying Partition Functions
  • Manipulating Partition Tables

 


dbo.judith]]> http://www.fwssug.com/return-of-the-weekend-sql-server-classes.aspx http://www.fwssug.com/return-of-the-weekend-sql-server-classes.aspx http://www.fwssug.com/return-of-the-weekend-sql-server-classes.aspx Sun, 17 Mar 2013 00:13:00 GMT