Posts in Category: Meeting

-August 2020+
SMTWTFS
2627282930311
2345678
9101112131415
16171819202122
23242526272829
303112345
  • RSS
  • Add To My MSN
  • Add To Windows Live
  • Add To My Yahoo
  • Add To Google

Statistics

  • Entries (106)
  • Comments (0)

Archives

Happy New Year to Our Fellow SQL Enthusiasts! 

Tuesday, January 7, 2014 5:49:00 PM Categories: Announcement Meeting

 

Happy new year to our fellow SQL enthusiasts from the folks at the Fort Worth SQL Server Users Group!

 

Our new year's resolution every year is to stay current and master the technologies that make us quality professionals and help us explore patterns and move data.

 

We are a community-based organization which provides, promotes, and directs people to opportunities, education, training, and fellowship related to Microsoft SQL Server and other database technologies in the DFW area.

 

We facilitate occasional weekend classes  and host monthly meetings to cover topics ranging from SQL queries, SQL Server Reporting Services, SQL Server Integration Services, SQL Server Database implementation and maintenance, Business Intelligence, SharePoint and more.

 

We have a great spring lined up for you:

 

January 15: Bryan Smith - Hadoop!

February 19: Tim Mitchell

March 19: Michael Bourgon

April 16: Ryan Adams

Oct 16 2013 Tim Costello : Tableau: Self Service BI made easy 

Thursday, October 10, 2013 8:54:00 AM Categories: Meeting

Wednesday, Oct 16th, 2013

6:30 PM Meet & Greet | 7 PM Presentation

 

We have Tim Costello back! Show solidarity and sport every scrap of yellow you can find and come see how to transform your data into meaningful information.

Topic
Rapid-fire visual analysis. Ad-hoc query capability. Easy interactive dashboard building. No, this isn't going to be a session of buzzword bingo. This time we will actually deliver on the promise of self service BI. Using SQL in conjunction with a visual analysis tool like Tableau, you can help users find the questions they didn't know they wanted to answer. This session will be demo heavy and will highlight best practices in data visualization and dashboard design.

Bio

Tim is a business intelligence developer with InterWorks inc. in Dallas, Texas. Tim is passionate about data visualization and helping people realize new insights from their data through data visualization.

 

 

September 18 Mike Hotek: Build a Scalable Data Validation Framework 

Tuesday, September 10, 2013 10:16:00 PM Categories: Meeting

Wednesday, Sept 18th, 2013

6:30 PM Meet & Greet | 7 PM Presentation

 

Build a Scalable Data Validation Framework

Millions of ETL applications have been built using DTS, SSIS, Informatica, DataStage, and a host of other products.  The ETL may or may not get tested before it is deployed.  If it gets tested, we run them through some token “sample” data and call it good enough.  Inevitably almost every target database of these ETL applications comes crashing in on itself because no one was watching the single thing these systems are built for, DATA.  Processes blindly moving data around with no clue as to whether everything was actually moved or whether the data is even valid in the first place.  This session will walk you through building a framework using SSIS to perform internal and source to target data validation.

 

August 21 Russ Loski : Introduction to BIML and BIMLScript 

Tuesday, August 13, 2013 7:39:00 AM Categories: Meeting

Wednesday, Aug 21th, 2013

6:30 PM Meet & Greet | 7 PM Presentation

 

We would like to apologize for last June. We promised you a Mike lecture and ended up swapping at the last minute do to a little emergency room action. We are all better than ever and back on track.

 

Topic:

Microsoft has provided some great tools for creating and editing SSIS packages. First Business Intelligence Development Studio (BIDS) then SQL Server Data Tools (SSDT). However, when creating an SSIS package you frequently repeat the same steps over and over. BIML is an XML markup language designed for representing the structure of an SSIS package. BIML Script takes that structure and generates an SSIS package.In this session we will use BIDS Helper to create a simple SSIS package using BIML. We will handle a couple SSIS scenarios with BIML and BIML Script.

 

Russ Loski is a SQL Server developer and occasional DBA with fifteen years of experience.  He has designed databases and created the SQL code to support applications for the Dallas Cowboys, Bank of America, T-Mobile, Coca Cola Enterprises and others.  In addition, Russ has developed large data loading projects using Microsoft's SQL Server Integration Services and its predecessor Data Transformation Services.  He has developed reports using SQL Server Reporting Services.  Russ is a regular contributor to the MSDN news groups as well as to the SQL Saturday events sponsored by SQL PASS.  He occasionally blogs at http://www.sqlmovers.com and his twitter account is @sqlmovers.

Additional notes: Dominic Nagy over at the InSource Group has a couple of contract to hire gigs in both Las Colinas (Database Developer) and Addison (SQL DBA/Developer).

 

Also, Paul LaGrone is making his way back North! Look for his new users group to be starting in Waco! 

July 17 2013 Clint Hutchison : Understanding MS SQL- A Journey Through Change Data Capture 

Tuesday, July 16, 2013 5:24:00 AM Categories: Meeting

Wednesday, July 17th, 2013

6:30 PM Meet & Greet | 7 PM Presentation

 

We are delighted to have Clint help us celebrate our 7th year anniversary as a user group! He's working with many great technologies in his shop and we can't wait to hear more. 

 

Topic:

The ETL consultants wowed us with their proof of concept, but a few records per million kept slipping through the cracks.
 
The diagnosis was exhausting, but the solution was simple.
 
Join Clint Hutchison of Heartland Payment Services for an evening of mysterious bugs, low-level mechanics, and sound advice. 
 
 
 

May 15 2013 Brian Swales : Supporting SharePoint Databases for DBAs 

Wednesday, May 15, 2013 5:54:00 AM Categories: Meeting

 

I am excited to announce we have finally have Brian Swales on stage! He and Brian G have lead the certification groups in the past when he's not solving the world's SharePoint problems for Microsoft. We have long wanted to hear his experience taming Sharepoint!

 

Topic: Indexes, statistics and other maintenance for SharePoint databases may be thought of as no different than any other application which uses databases. This is not quite true. SharePoint has been coded and optimized to make the best and exclusive use of SQL Server. SQL Server is the engine for the framework known as SharePoint. And SharePoint has been designed to work easily with minimal intervention. Of course, larger implementations will have additional needs. We will be covering the things you can do to optimize your SharePoint database environment and scale it properly.

 

Bio: Brian Swales is a Support Escalation Engineer for SharePoint at Microsoft specializing in SharePoint Performance and Publishing. He is a Microsoft Certified Technology Specialist - MCTS: SQL Server 2008, Implementation and Maintenance

No March or April Meeting 

Wednesday, March 20, 2013 11:24:00 AM Categories: Meeting

We reiterate, no March or April monthly meeting as we are doing the Saturday classes. See you in April if you are taking the classes. 

Return of the Weekend SQL Server Classes! 

Saturday, March 16, 2013 7:13:00 PM Categories: Meeting Training

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

 

February 20, 2013 - David Stein: Data Warehouse Mistakes You Can’t Afford to Make 

Monday, February 18, 2013 3:52:00 PM Categories: Meeting
Wednesday, February 20th, 2013
6:30 PM Meet & Greet | 7PM Presentation
 
Our February speaker had to cancel but David Stein has agreed to come present for our group even though he is already booked for the very next night up in Irving!  Kudos David!  We thank you! 

 

Topic:  Data Warehouse Mistakes You Can’t Afford to Make

Many data professionals understand the basics of Data Warehouse design, including Dimension and Fact Tables, slowly changing Dimensions, and the use of meaningless surrogate keys. However, it isn't until you've created a dimensional model and put it into production, that you realize just how much of an impact seemingly trivial mistakes can make. They can hobble performance, allow inaccuracy, and perhaps worst of all, inhibit adoption and usage of the new system. 
 
Learn how to avoid many common mistakes, from someone who’s made them and then found ways to correct them. 
 

Bio:  David Stein is a Data Warehouse Architect with RealPage Inc. in Carrollton, TX. He’s worked in SQL Server Business Intelligence for almost a decade in many roles as both a consultant as well as a corporate employee.  He’s designed Data Warehouses from scratch as well as saved projects in serious jeopardy.

He is also very active in the community, having spoken at PASS events at all levels, including the PASS Summit, SQL Rally, and at numerous SQL Saturday events and user groups. You can learn more about Data Warehousing, Business Intelligence, and other technical topics on his blog at Made2Mentor.com or follow him on Twitter @Made2Mentor.
 

Food at 6:30 PM (Tantalizing rumors abound that THE BAKING DBA *might bring some of his famous Perushki!)

Lecture at 7PM

 
Freese & Nichols
Ground Floor Training Room
4055 International Plaza
Fort Worth, Texas 76109
 

January 16 Meeting - Mike Hotek: Big Data INSIDE SQL Server - A Real World 10+ Exabyte Data Warehouse 

Monday, January 14, 2013 10:31:00 PM Categories: Meeting

 

Wednesday, January 16th, 2013

6:30 PM Meet & Greet | 7 PM Presentation

 

Happy 2013 everybody! Welcome back to another year with the Fort Worth SQL Server Users Group! We're happy to crack open the new year's lecture series with Mike Hotek. He always brings crazy amounts of industry experience and knowledge to the discussion.

 

Topic:

A large number of people, including many at Microsoft have bought into the marketing BS called “Big Data”.  When you hear “big data”, everyone automatically assumes that you have to do this in some other database platform being foisted on IT.  The marketing myth that many have bought into is that SQL Server can’t handle “big data”.  This session will walk you through the architecture and build out of a real world data warehouse, built entirely with SQL Server, which is currently in excess of 10 Exabytes.

 

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 having worked with thousands of companies and on the largest, most complicated platforms in the world. Mike has delivered hundreds of sessions and training events around the world and has published numerous articles along with 8 books. He is currently working on a four book series on SQL Server 2012.

 

Contact URL: http://www.ChampionValleySoftware.com

 

 

See you there!  Location

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