SQLSaturday #435 - El Paso 2015
Event Date: 08/29/2015 00:00:00
Event Location:
- El Paso Community College Administrative Service Center
- 9050 Viscount Blvd
- El Paso, Texas
This event has completed. All data shown below is from the historical XML public data available.
If there are any data quality issues or corrections needed, please contact the webmaster for this site or submit a pull request for the appropriate file(s).
Sessions
This is a list of sessions from the event, based on the schedule in the XML files.
Title: Why should I care about the plan cache?
Abstract: SQL Server is a huge product, with many different places a DBA can go to look for information on how the server is performing. So many in fact that they can often overlap, which sometimes makes it hard to understand why tackling a new tool is worth the effort. In this first (and hopefully not last) installment of Rick’s “Why should I care” series a case for why working knowledge of how to query the plan cache is critical for performance tuning efforts in real world environments, followed by a review of relevant DMV’s for the newly motivated audience. Perfect for those who are relatively new to performance tuning concerns, or advanced DBAs trying to figure out how to have a similar conversation with their less experienced peers, or developers who are curious as to why their DBA is sometimes so moody.
Speaker(s):
- Rick Lowe
Track and Room: Enterprise Database Administration Deployment - B322
Title: Becoming Certified In Microsoft SQL Server
Abstract: Becoming certified in SQL Server is a great career enhancement for a database professional. This session will provide you with an overview of the SQL Server Certification program, including the numerous changes made to the program for SQL 2012. You’ll discover several reasons why you should become certified, and some of the best ways in which to do so. You’ll also leave the session armed with some tips and tricks for passing the exams that the presenter has used over the last thirteen years.
Speaker(s):
- Chris Hyde
Track and Room: Professional Development - B324
Title: Breaking Productivity Boundaries with BIML
Abstract: Has your ETL process ever bogged down productivity because of the repetitive tasks needed to prepare data for usability? Business Intelligence Markup Language (BIML) is an XML Dialect that can be used to create SSIS Packages in Visual Studio’s Business Intelligence Developer Studio. This session will cover the BIML basics and introduce some design patterns for code generation.
Speaker(s):
- Adrian Chacon
Track and Room: BI Platform Architecture, Development Administration - B324
Title: Row-Based Security in SSRS and SSAS
Abstract: It is relatively straight-forward to grant a user access to a particular SSRS report, multi-dimensional cube, or tabular model table, but what happens when the user needs access to the object but should be denied access to view certain rows of data? In this session we’ll investigate a real-world solution to this common BI problem.
Speaker(s):
- Chris Hyde
Track and Room: BI Platform Architecture, Development Administration - B324
Title: Common TSQL Mistakes
Abstract: We are going to examine a variety of oopsies MANY developers fall prey too - some obvious, some pretty subtle and some down right sneaky! Lots of code examples with the bad AND good code presented. I GUARANTEE that you will find things here that will either prevent you from getting bad data, throwing unwanted errors or vastly improving your database application’s performance. I have given this talk over SEVENTY times now and it is always very highly rated!
Speaker(s):
- Kevin Boles
Track and Room: Application Database Development - B321
Title: Relational Databases to Relational Leadership - how to be a great leader
Abstract: As a tech expert, you’ve excelled as an individual, but now you’re moving out of your comfort zone into a leadership role. This transition is not only challenging but also critical to continued career advancement.
If you’re an emerging leader in transition or looking to someday lead, join us for an intense session based on the Rise Of A Leader program. In our session, we’ll share leadership tools, insights, and pragmatic approaches for going from relational databases to relationship leadership.
Learn: The 15 Core Principles of RISE Leadership Your Personal Rise Formula (PRF) and How to Maximize Leadership Performance
Speaker(s):
- Hasani X
Track and Room: Professional Development - B324
Title: Don’t fall victim to Little Bobby Tables: Guide to Developing a Secure Database Application
Abstract: Is your SQL Server driven application safe? Does your application have ‘sa’ anywhere in the code? Are you a victim of SQL Injection? If you answer “yes” or “not sure”, come see how to secure a SQL Server driven .Net application. Learn about some exploits and vulnerabilities and implementing best practices for securing SQL Server driven applications. See firsthand how to use Object Relation Mappers, MVC.Net and other tips to develop a secure application. Take home the ability to defend your SQL Server and your data at your applications level.
Speaker(s):
- Gabriel Villa
Track and Room: Application Database Development - B321
Title: SQL Server Defaults SUCK!!
Abstract: If you just click next-next-next and think you have a good-to-go SQL Server . . . THINK AGAIN!! :-) There are umpteen things you just GOTTA change right out of the box if you want your potentially very expensive and always precious SQL Server resource to perform optimally and behave correctly.
This session will cover a laundry list from BIOS Power Setting to data file growth and many useful items in between sitting everywhere from the physical server to the storage to the VM to Windows to SQL Server to database.
Speaker(s):
- Kevin Boles
Track and Room: Enterprise Database Administration Deployment - B322
Title: SQL Server Bingo – Install, Migration Config
Abstract: Get ready to play SQL Buzzword Bingo with the subject matter being SQL Install, Migration Configuration. Are you preparing to move a database from one SQL Server to another? Whether it’s your first SQL install, a SQL Server Upgrade or changing from physical to virtual, there is a lot to consider. In some areas of the setup, you get only one chance to “get it right.” Come to this session and find out all about the process - and have some fun while you’re at it. First one to hit BINGO! will win a copy of the book SQL Server 2012 - Step by Step.
Speaker(s):
- Mindy Curnutt
Track and Room: Enterprise Database Administration Deployment - B322
Title: Build Android and iOS Apps with C# and Xamarin
Abstract: You can build Android apps with Java and iOS apps with ObjectiveC or Swift. But Xamarin allows developers to use c# and still produce native applications. This is not a marketing session. We will discuss (and demonstrate) the very real situation where an organization can take advantage of existing code and existing skills and still reach the mobile audience.
Speaker(s):
- Russ Burns
Track and Room: Strategy and Architecture - B322
Title: What’s this ‘Scaffolding a CRUD’ all about? Build a Website from your SQL Database
Abstract: So you have a SQL Server database, and you want a web site for your tables? Come see how to develop and deploy a simple .NET website against any SQL Server database. See firsthand how to use Microsoft’s Entity Framework, ASP.Net MVC and other tricks to develop a website by writing very little code. Take home the ability to create and deploy a simple website to your own database once this demonstration is seen.
Speaker(s):
- Gabriel Villa
Track and Room: Application Database Development - B321
Title: Reporting with Spatial Data
Abstract: With Microsoft’s Spatial Data type, we can represent locations and shapes in the database. Far more than just strings and decimals, geometries and geographies are objects we can compare and manipulate. From basic maps to custom areas, we will explore the power of adding Spatial to your data.
Speaker(s):
- Russ Burns
Track and Room: Analytics and Visualization - B322
Title: The Ins and Outs of SQL Indexes
Abstract: This course will focus on the fundamentals of strategic SQL Server index design and creation. Terms that will be covered and clarified: clustered index, non-clustered index, uniqueness, covering index, fill-factor, scan, seek, key lookup, and fragmentation. This is a beginning level course for those who have always found indexes confusing and somewhat elusive. Lots of valuable information will be provided in a short amount of time.
Speaker(s):
- Mindy Curnutt
Track and Room: Application Database Development - B321
Title: SQL Server 2014 New Features
Abstract: There is MUCH more to SQL Server 2014 than just Hekaton and Updatable Column Store Indexes!! This session will be a medium-to-high-level overview of many of the new features and enhancements coming in SQL Server 2014. When I thought of doing this session I initially wanted to have some demos, but there are SOOO many things to cover I couldn’t fit in any demos in a 1 hour session!
Speaker(s):
- Kevin Boles
Track and Room: Other - B321
Title: Data Warehouse Design Decisions
Abstract: Building a data warehouse is not just learning about a star schema. Data sources, volumes and platforms are all changing and the concept of a data warehouse needs to adapt. During this session we will explore this bedrock of the enterprise data services, where it’s been, and where it needs to go.
Speaker(s):
- Colleen Barnitz
Track and Room: BI Platform Architecture, Development Administration - B324
Title: Solving Business Problems Using SQL Window Functions
Abstract: In this presentation, the CIO of one of the largest transportation companies in the US will introduce SQL window functions and demonstrate their use tackling real-world challenges including both time series and geospatial problems.
Speaker(s):
- Swan Webb
Track and Room: Advanced Analysis Techniques - B322
Speakers
This is a list of speakers from the XML Guidebook records. The details and URLs were valid at the time of the event.
Gabriel Villa
Twitter: - @extofer
LinkedIn: Gabriel Villa
Contact: https://extofer.wordpress.com/
Gabriel is a skilled leader, architect, and technical expert focusing primarily on Microsoft technologies and is passionate about open-source technologies for integration, automation, and development. Gabriel’s versatility extends from systems, data and development and leverages hybrid/SaaS/Cloud integration, proven software engineering platforms, and best-of-breed data management and business intelligence solutions.
Originally from El Paso, Texas, Gabriel lives in Colorado Springs with his wife and kids, where he is an Architect for RevGen Partners, volunteers in the tech community and enjoys the Colorado outdoors.
Mindy Curnutt
Twitter: - @sqlgirl
LinkedIn: Mindy Curnutt
Contact: http://www.mindycurnutt.com
Mindy Curnutt is a 5X Microsoft Data Platform MVP, Business Owner and Entrepreneur. Her specialties include SQL Server hardware, configuration, migrations, scalability, performance tuning. She has been actively involved in the SQL Server Community for over two decades and has become a well known speaker within the SQL and Transportation Management communities. She is a two-time PASS Volunteer of the Month, has presented at 6 SQLPASS Summits, Live360, DevConnections, MVPMix and too many SQLSaturdays to count. She is currently the President of the North Texas SQL Server User Group out of Dallas/Fort Worth, TX.
Gabriel Villa
Twitter: - @extofer
LinkedIn: Gabriel Villa
Contact: https://extofer.wordpress.com/
Gabriel is a skilled leader, architect, and technical expert focusing primarily on Microsoft technologies and is passionate about open-source technologies for integration, automation, and development. Gabriel’s versatility extends from systems, data and development and leverages hybrid/SaaS/Cloud integration, proven software engineering platforms, and best-of-breed data management and business intelligence solutions.
Originally from El Paso, Texas, Gabriel lives in Colorado Springs with his wife and kids, where he is an Architect for RevGen Partners, volunteers in the tech community and enjoys the Colorado outdoors.
Mindy Curnutt
Twitter: - @sqlgirl
LinkedIn: Mindy Curnutt
Contact: http://www.mindycurnutt.com
Mindy Curnutt is a 5X Microsoft Data Platform MVP, Business Owner and Entrepreneur. Her specialties include SQL Server hardware, configuration, migrations, scalability, performance tuning. She has been actively involved in the SQL Server Community for over two decades and has become a well known speaker within the SQL and Transportation Management communities. She is a two-time PASS Volunteer of the Month, has presented at 6 SQLPASS Summits, Live360, DevConnections, MVPMix and too many SQLSaturdays to count. She is currently the President of the North Texas SQL Server User Group out of Dallas/Fort Worth, TX.
Rick Lowe
Twitter: - DataFLowe
LinkedIn: Rick Lowe
Contact: http://dataflowe.wordpress.com/
Rick is a Microsoft Certified Master with more than 20 years of SQL Server experience in a variety of roles. He currently lives in Washington state and works as an independent consultant providing remote performance DBA and performance tuning services for clients in the USA and Canada. His first exposure to SQL Server was as a database developer, but over time he became more and more interested in how the database engine operated… eventually specializing more on performance issues than code.
Rick will work with all things relational, but most enjoys helping smaller companies get better performance from MSSQL, as well as smoothing over relationships between DBA and development teams.
Kevin Boles
Twitter: - @TheSQLGuru
LinkedIn: Kevin Boles
Kevin Boles is a SQL Server expert, working exclusively with the product since v6.5. With over 25 years of database experience and over 45,000 man hours of SQL Server engine experience, he holds many related certifications, is an MCT and was a SQL Server MVP from 2007 to 2012. Kevin has been a very successful independent consultant for over 20 years. His passion is the relational engine, especially designing, building, analyzing and tuning high-performance database applications.
Kevin Boles
Twitter: - @TheSQLGuru
LinkedIn: Kevin Boles
Kevin Boles is a SQL Server expert, working exclusively with the product since v6.5. With over 25 years of database experience and over 45,000 man hours of SQL Server engine experience, he holds many related certifications, is an MCT and was a SQL Server MVP from 2007 to 2012. Kevin has been a very successful independent consultant for over 20 years. His passion is the relational engine, especially designing, building, analyzing and tuning high-performance database applications.
Kevin Boles
Twitter: - @TheSQLGuru
LinkedIn: Kevin Boles
Kevin Boles is a SQL Server expert, working exclusively with the product since v6.5. With over 25 years of database experience and over 45,000 man hours of SQL Server engine experience, he holds many related certifications, is an MCT and was a SQL Server MVP from 2007 to 2012. Kevin has been a very successful independent consultant for over 20 years. His passion is the relational engine, especially designing, building, analyzing and tuning high-performance database applications.
Adrian Chacon
Adrian Chacon is a recent graduate who has a solid background in Hardware Design but has adopted the lifestyle of a Business Intelligence Developer. Throughout his educational career, he’s picked up an assortment of computer languages including HTML, Verilog, CSS, C, C#, Java, and Objective-C. Adrian received his bachelor’s degree in Electrical Engineering and his Master’s degree in Computer Engineering.
Chris Hyde
Twitter: - ChrisHyde325
LinkedIn: Chris Hyde
Chris Hyde is a Microsoft Data Platform MVP and Microsoft Certified Trainer based in Albuquerque, New Mexico. He works as an independent SQL Server BI and DBA consultant, and is the leader of the Albuquerque PASS local user group. He is also part of the Friends of Redgate program and was a member of the Idera ACE class of 2018. He loves loud music and cricket, but usually not at the same time.
Hasani X
Twitter: - Hasani
LinkedIn: Hasani X
Contact: http://hasanix.com/blogs
Hasani X is CEO and founder of Xecute Sciences, where he works with business owners and emerging leaders who want to eXecute and grow. His simple, direct, and focused approach to eXecution has helped hundreds of businesses and leaders to grow and prosper.#160;
Chris Hyde
Twitter: - ChrisHyde325
LinkedIn: Chris Hyde
Chris Hyde is a Microsoft Data Platform MVP and Microsoft Certified Trainer based in Albuquerque, New Mexico. He works as an independent SQL Server BI and DBA consultant, and is the leader of the Albuquerque PASS local user group. He is also part of the Friends of Redgate program and was a member of the Idera ACE class of 2018. He loves loud music and cricket, but usually not at the same time.
Colleen Barnitz
Twitter: - @ColleenBarnitz
LinkedIn: Colleen Barnitz
Colleen has worked with SQL Server since version 6.5 and has been both a developer and an architect on data warehouse projects during that time. Colleen leads a team of developers in providing business intelligence solutions for the enterprise and is always looking for new directions. She co-founded and is active in the Las Cruces amp; El Paso SQL Server User Group.
Russ Burns
Twitter: - @rssllbrns
LinkedIn: Russ Burns
Russ is Senior Application Developer in El Paso, TX. A developer by title but an Accidental DBA since SQL Server 7.0, he trains with DBAs to leverage database efficiency in his solutions. His experience focuses on Business Intelligence with SSIS, SSRS, SharePoint and web development with ASP.Net. He is co-founder, former vice-president, and recurring speaker with the Las Cruces and El Paso SQL Server User Group http://lcep.sqlpass.org.
Swan Webb
Twitter: - @sqlista
An accomplished data scientist and business executive with a strong passion for solving the hardest problems with a data-driven approach. In the course of my career, I have helped railroads and trucking companies create billions of dollars in value through improved profitability and productivity. Now, I am very excited about leveraging those same skills honed in industry to help organizations realize their environmental and social goals.
Kevin Boles
Twitter: - @TheSQLGuru
LinkedIn: Kevin Boles
Kevin Boles is a SQL Server expert, working exclusively with the product since v6.5. With over 25 years of database experience and over 45,000 man hours of SQL Server engine experience, he holds many related certifications, is an MCT and was a SQL Server MVP from 2007 to 2012. Kevin has been a very successful independent consultant for over 20 years. His passion is the relational engine, especially designing, building, analyzing and tuning high-performance database applications.
Russ Burns
Twitter: - @rssllbrns
LinkedIn: Russ Burns
Russ is Senior Application Developer in El Paso, TX. A developer by title but an Accidental DBA since SQL Server 7.0, he trains with DBAs to leverage database efficiency in his solutions. His experience focuses on Business Intelligence with SSIS, SSRS, SharePoint and web development with ASP.Net. He is co-founder, former vice-president, and recurring speaker with the Las Cruces and El Paso SQL Server User Group http://lcep.sqlpass.org.
Sponsors
The following is a list of sponsors that helped fund the event: