North Texas SQL Servers Users Group

Next Meeting

Thursday,

November

20

20 NOV 2014 NTSSUG Meeting

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

RSVP Here: 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

Featured Presentation:

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

Maurice De Vidts , Performance Engineer HP

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

David Stein, Data Warehouse Architect

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.


Thank You to the 

PLATINUM

SPONSORS 

of our May 2018 

SQL Saturday!











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