North Texas SQL Servers Users Group

Next Meeting

Thursday,

October

16

16 OCT 2014 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 - Using PSSDiag to Troubleshoot Performance Issues by Stacy Gray
7:30 - 8:30 - Lightning Talks - 10 minutes each by Various Speakers
8:30 - 8:45 - Raffle and closing

Featured Presentation:

Using PSSDiag to Troubleshoot Performance Issues

Stacy Gray Microsoft

We’ve all experienced working on a slow computer. It is frustrating trying to figure out what is wrong with it. It is even more frustrating when that slow computer is your SQL Server. How is one to know what data to collect, what are the acceptable thresholds, and what to do when those thresholds are exceeded? Searching for answers on the internet is sometimes scary. PSSDIAG is a utility used by Microsoft SQL Support Engineers to diagnose performance problems with SQL Server. This presentation details what the tool is, why you’d want to use it and how to interpret the output.

About Stacy:
Stacy has worked with SQL Server since 6.5 working for and supporting enterprise-level corporations before landing a contract position at Microsoft in 2011. Hired as a PFE for Microsoft Mediaroom in 2012, I moved back to SQL Support when Mediaroom was sold to Ericsson in 2013. I’m a MCSE, Be The Next Microsoft Employee contestant, poker player, wife, mother & Gone With the Wind fanatic.

I'm All About Those Dates - No Trouble

David Stein, Independent Consultant

Date Dimensions are helpful in many situations, not just data warehousing. In 10 minutes, you'll learn many different ways to leverage a date table which will make your life easier. Most importantly, you'll leave with code which dynamically creates a Date Dimension customized for your needs.

About David:
David Stein is an independent consultant specializing in designing and building Agile Data Warehouses using SQL Server Integration Services and Business Intelligence Markup Language (Biml). Bio: David Stein is an independent consultant specializing in designing and building Agile Data Warehouses using SQL Server Integration Services and Business Intelligence Markup Language (Biml).

SSMS Tips and Tricks

Hakim Ali, Senior Dev DBA SQLzen

If you spend a fair amount of time with SQL Server's IDE, you will want to know about these tips and tricks that boost productivity and speed up tedious and repetitive tasks.

About Hakim:
Database developer and designer with valuable experience on and a great liking for SQL Server. Trying to get the word out on developing SQL Server databases with Visual Studio.

What’s Next?

Bryan Smith, Database Technology Specialist Microsoft

At some point in our careers, we will have exhausted the prescribed career paths and wrestle with the question of what is next for us professionally. In this brief presentation, Bryan will share a few thoughts on navigating this seemingly directionless territory.

About Bryan:
Bryan Smith is a Data Platform Technology Specialist with Microsoft in Dallas, TX. He is co-author of several books on Microsoft Business Intelligence technologies including Microsoft SQL Server 2008 MDX Step by Step.

How to Keep your DBA from Killing You

Amy Herold, DBA

Are you always finding yourself in the crosshairs of your DBA? Don't know why they won't give you the access you believe you need? While as a developer you are trying to get your deliverables to the business, the DBA is trying to make sure the business has accurate data available for those deliverables. This talk will give you a bit of insight into the world of the DBA.

About Amy:
Bio: Former .NET Developer turned Database Administrator, working with SQL Server 2000 thru 2012. I have MCITP Certifications on SQL Server 2008 for both Database Administrator and Database Developer and regularly attend SQL Server events.

Kerberos Configuration

Ryan Adams, Sr. DBA Verizon

This talk will show you how to configure Service Principal Names to enable Kerberos authentication. We'll walk through a common use case scenario and discover where and how to set Service Principal Names. The use case will also demonstrate when and how to enable delegation.

About Ryan:
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.

Building Your Online Brand

Hakim Ali, Senior Dev DBA SQLzen

There will be many times in your career when somebody who does not personally know you will try and find information about you. This could be a potential employer, HR, a recruiter, coworkers, and direct reports. Will their findings help you or hurt you?

About Hakim:
Database developer and designer with valuable experience on and a great liking for SQL Server. Trying to get the word out on developing SQL Server databases with Visual Studio.


Thank You to the 

PLATINUM

SPONSORS 

of our May 2018 

SQL Saturday!











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