North Texas SQL Servers Users Group

Dallas SQL Saturday 2019 Info

     4 Full Day Sessions for Ridiculously Low prices. One of them has already sold out. Tell your boss, "Hey, I can get a $1200 class for only $139!". Seriously, it's that much of a steal! And these speakers are
Internationally Known, Book Authors, and Respected Authorities. Good gracious folks, what's holding you up? Can't miss that Friday meeting?


  More than 60 Sessions throughout the day, 10 different sessions to choose from in any particular hour. Absolutely FREE. What's to lose? Register now!



   The MAY 2019 meeting is sponsored by Red Gate. We will have 1 big raffle prize and many smaller raffle items to give out. We will also announce their upcoming SQL in the City, taking place next week in Austin, TX. Thank you Redgate!

Next Meeting: Thu, Nov 20 2014

20 NOV 2014 NTSSUG Meeting

Language: English
Event Type: In-Person
Online Meeting URL: None

6:00 - 6:20 - Welcome, Announcements & Food
6:20 - 7:20 - Scaling and deploying SQL Server 2014 on high core count quad socket servers by Maurice De Vidts
7:30 - 8:30 - Generate T-SQL Automatically With Biml By David Stein
8:30 - 8:45 - Raffle and closing


UTC : Fri, Nov 21 2014 00:00 - 03:00
Event Time : Thu, Nov 20 2014 18:00 - 21:00 (UTC-06:00) Central Time (US & Canada)
Your Local Time: Fri, Nov 21 2014 00:00 - 03:00


7000 North Highway 161
Irving, Texas

Direction: None

Featured Presentation

Scaling and deploying SQL Server 2014 on high core count quad socket servers

Speaker: Maurice De Vidts , Performance Engineer HP

Summary: The session presents deployment topologies and performance characterization of SQL 2014 OLTP databases deployed on Windows 2012R2 in a quad socket environment. From a deployment perspective the session presents multiple physical deployment models including multi-instance and multi-database NUMA aligned installations. In addition, current best practices related to NUMA alignment for SSIS instance co-deployments are shown in both physical and hyper-v topologies. From a performance perspective the session outlines key best practices to achieve optimum performance in high core count servers. Test results highlight the impact subtle SQL default parameters can have if not addressed when migrating from a smaller core count server to a quad core server. Finally a few examples from the field on what to be particularly aware of during platform migration and scaling and notes of interest regarding new licensing model for SQL 2014.

About Maurice: Maurice De Vidts is a performance Engineer with HP. At HP Mr. De Vidts works developing reference architectures and best practices for SQL databases deployed on HP Converged Systems, servers, and storage platforms. He received his B.S.E.E. from the University of Maryland and has been working with databases over 20 years. Prior to his 7 years working at HP, Mr. De Vidts worked as a database consultant and DBA in a number of industries including Energy, State and Federal government. Throughout his career, he has focused on performance tuning and troubleshooting complex systems where he enjoys maximizing database efficiency by tuning both hardware and software layers in the architecture. On his free time he enjoys alpine sports, aikido and scuba diving. Mr. De Vidts is currently certified as a SQL 2012 Data Expert , and Oracle 9i.

Generate T-SQL Automatically With Biml

Speaker: David Stein, Data Warehouse Architect

Summary: Business Intelligence Markup Language is perfect for automating repetitive development tasks. In this interactive, demo-focused presentation we'll rapidly loop through a set of tables and generate useful T-SQL scripts auto-magically, including the dreaded Merge statement. All of the scripts will be available for download so you can adapt and use them in your environments using the free SSIS Add-In Bidshelper.

About David: David is a Data Warehouse Architect with more than a decade of experience working in SQL Server Business Intelligence. He’s designed multi-terabyte, multi-tenant Data Warehouses from scratch as well as saved projects in serious jeopardy. He is also very active in the community, frequently presenting at PASS events at all levels, including SQL Rally, SQL Saturdays, and user group meetings.

Back to Top