Event Location:
El Paso Community College Administrative Service Center
9050 Viscount Blvd
El Paso, Texas
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
This is a list of speakers from the XML Guidebook records. The details and URLs were valid at the time of the event.
LinkedIn: https://www.linkedin.com/in/gabevilla
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.
LinkedIn: https://www.linkedin.com/in/mindycurnutt
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.
LinkedIn: https://www.linkedin.com/in/gabevilla
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.
LinkedIn: https://www.linkedin.com/in/mindycurnutt
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.
LinkedIn: http://www.linkedin.com/pub/rick-lowe/a/228/441/
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.
LinkedIn: http://www.linkedin.com/in/thesqlguru
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.
LinkedIn: http://www.linkedin.com/in/thesqlguru
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.
LinkedIn: http://www.linkedin.com/in/thesqlguru
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 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.
LinkedIn: https://www.linkedin.com/in/chris-hyde-3803706
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.
LinkedIn: https://www.linkedin.com/in/hasani
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;
LinkedIn: https://www.linkedin.com/in/chris-hyde-3803706
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.
LinkedIn: https://www.linkedin.com/pub/colleen-barnitz/5/27b/594
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.
LinkedIn: https://www.linkedin.com/profile/view?id=49530687
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.
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.
LinkedIn: http://www.linkedin.com/in/thesqlguru
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.
LinkedIn: https://www.linkedin.com/profile/view?id=49530687
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.