North Texas SQL Servers Users Group

Next Meeting

Thursday,

April

18

18 Apr 2013 NTSSUG Meeting

  • In-Person @ 7000 North Highway 161 Irving, Texas, United States (map)
  • 18:00 - 21:00 Central Daylight Time
  • Language: English

RSVP Here: None

6:00 - 6:20 - Welcome, Announcements & Food
6:20 - 7:20 - When a Strange Server Calls: Getting to Know a SQL Instance by Jen McCown
7:30 - 8:30 - Data Warehouse Series - Basics and Beyond - David Stein
8:30 - 8:45 - Raffle and closing.

Microsoft is between Highway 114 and MacArthur Boulevard in Irving (Las Colinas), on Highway 161. The easiest way to get to there is to take the outer access road for Highway 161 North and exit into the Microsoft parking lot. It is the first building you will see once you exit. We'll be in the first building, LC-1. Please park in the front of the building that faces Highway 161. Enter the front of the building and sign-in at the front desk.

Featured Presentation:

When a Strange Server Calls: Getting to Know a SQL Instance

Jen McCown, Independent Consultant

When a Strange Server Calls: Getting to Know a SQL Instance Have you checked the databases lately? It could be that you’re new on the job, or you’ve inherited a set of servers from another team. Maybe things have just been busy lately. Any which way, you’ve got a SQL Server instance (or five) that may have issues, may have backups, may have maintenance…or not. How do you start getting to know an instance? We’ll go over scripts and methods to gather and prioritize important information about your server, so you don’t have to be afraid when the server calls. http://www.midnightdba.com/Jen/strangeserver

About Jen:
Jen McCown is an independent consultant, Microsoft SQL Server MVP awardee, developer and DBA. She is Senior Editor at MidnightDBA.com, where she creates training videos, the DBAs at Midnight webshow, blogs, reviews, and podcasts. Jen is a member, volunteer, and speaker in NTSSUG, PASS, and the PASS Women in Technology virtual chapter. She has presented at multiple SQL Saturday and 24 Hours of PASS events, PASS Summit 2010 and 2012, PASS SQLRally 2011, and SQLBits 2012. She lives in Dallas, Texas in the vicinity of approximately 6.5 million other humanoids.

Data Warehouse Series – Basics and Beyond

Dave Stein, Data Warehouse Architect

In a series of 1 hour sessions, David will cover both the basics and gotchas of Data Warehouse Development using the SQL Server 2012 toolset. Some of the things he'll cover are: • Basic methodology for evaluating business requirements/needs, obtaining user cooperation, and identifying source data quality issues. • Data Warehouse basic concepts including Facts, Dimensions, Star and Snowflake Schemas. • Deep dive into slowly changing Dimension types and how to handle them using T-SQL and SSIS. • T-SQL Merge Fundamentals and how it can be used to load Dimension and Fact Tables. Yes, I swear the Merge Generation Code will be ready for the presentation. :) • Understanding the three basic Fact Table types, how they are used, and loaded with SSIS. • Date Dimension creation and configuration. • Taking advantage of SSIS 2012 functionality improvements including Environments, Project Parameters etc. • Strategies for SSIS and database optimization, insuring data integrity, etc. • And much, much more. Each session will progressively build upon the previous sessions and session material will be posted on his blog. Come watch this exciting and progressive series as David takes you from padawan to Jedi Master.

About Dave:
David Stein is a Data Warehouse Architect. 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.


Thank You to the 

PLATINUM

SPONSORS 

of our May 2018 

SQL Saturday!











Back to Top
cage-aids
cage-aids
cage-aids
cage-aids