SQLSaturday #299 - Columbus 2014
Event Date: 06/14/2014 00:00:00
Event Location:
- Ohio Dominican University
- 1216 Sunbury Road
- Columbus, Ohio
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: Full life-cycle of Self-Service BI with PowerPivot and the SSAS Tabular Model
Abstract: Within the enterprise, the new Excel self-service tools can enable Power Users to define and create analytic requirements by creating new business models in PowerPivot. We will walk through a scenario of creating relationships, hierarchies, KPIs, calculations, and measures as a business person. When completed we will hand it off the model to the governance board for review to see how it fits into the organization BI collateral. Finally, we will put on our IT hats and convert the PowerPivot model into a SSAS Tabular version and give it enterprise strength of partitions and security. We will end the session by selecting a deployment strategy that will meet the needs of new and existing models in the production environment.
Speaker(s):
- Andrew Holowaty
Track and Room: BI Big Data - N/A
Title: Performance Tuning - Analyzing Execution Plans
Abstract: Did you ever get woken up at night from a call from a user screaming about poor query performance, but didn’t really know how to begin attack the problem? In this session, we will explore the basics of execution plan analysis and how to single out issues that pertain to base table operations. In this presentation, we will identify what indexes are being used by the SQL Optimizer, the different type of index operations that are performed by SQL Server and which operations are generally considered the preferred method of data retrieval. We will discuss how to determine if the indexes used by the Optimizer are optimal, according to best practices, and the exceptions to those cases. Finally, we will cover the relationships between different types of index operations and joins within SQL Server, including how the SQL Optimizer determines which join type it will use, along with the pros and cons of each join operation
Speaker(s):
- Konstantin Melamud
Track and Room: Performance - N/A
Title: Geekin’ Out on Extended Events -Deconstructing the system_health session to solve performance issues
Abstract: Extended Events are used to gather a wide range of performance information to help troubleshoot performance problems in SQL Server. The system_health session is an Extended Events session that is included by default with SQL Server. This session starts automatically when the SQL Server database engine starts, and runs without any noticeable performance effects. This presentations will take you on an in-depth tour of the data provided in the system_health event session and how to use it to troubleshoot performance issues. Cases studies from real-life examples will be used to demonstrate tips and tricks.
Speaker(s):
- Janis Griffin
Track and Room: Performance - N/A
Title: SQL Injection
Abstract: Well, we have all heard about the horror stories of data loss due to SQL Injection and how costly (in many ways) they can be. This in-depth discussion covers various forms of SQL Injection attacks and offers some guidelines on how to avoid them. Lots of code examples in both .NET and TSQL. Watch me hack a website and retrieve user data in just 3 hits on an unprotected html page!
Speaker(s):
- Kevin Boles
Track and Room: Development Security - N/A
Title: Introduction to SQL Server 2012 AlwaysOn Availability Groups
Abstract: One of the most talked about new features in SQL Server 2012 is AlwaysOn Availability Groups. In this session, we will cover the pros and cons of using Availability Groups as well as the basics of how to set them up and take advantage of readable secondary replicas. If you want to improve the availability and performance of your applications databases, are currently using Database Mirroring, or if you’re just curious about Availability Groups, then you won’t want to miss this session.
Speaker(s):
- Adam Belebczuk
Track and Room: Administration - N/A
Title: Manage SQLServer Efficiently w/PowerShell Remoting
Abstract: You have more and more servers to manage and less time to accomplish everything. You’re writing scripts to automate those tasks but they still take time to run. PowerShell remoting allows you to manage servers without the overhead of Remote Desktop, and allows you to run processes on all your servers simultaneously. In this session we’ll walk through how PowerShell remoting works, how to set it up, and how you can save time getting things done more quickly.
Speaker(s):
- Allen White
Track and Room: Administration - N/A
Title: Introduction to SQL Server Service Broker
Abstract: In this session, we’ll cover the basics of setting up SQL Server Service Broker from the ground up with lots of demos. We’ll discuss some pros and cons to using Service Broker, some common problems encountered when using it, and some example use cases. If you’ve ever been curious about Service Broker, need to send data between databases or instances, or are wondering if Service Broker is right for your organization, then you won’t want to miss this session.
Speaker(s):
- Adam Belebczuk
Track and Room: Development Security - N/A
Title: SSIS Templates Can Make Your Life Easier
Abstract: How many times have you started a new SSIS project and added the same components that you’ve added to almost every other package you’ve created? Components to handle logging and errors or even a standard workflow for loading data files. In this session I’ll show you how you can create standard templates that already contain any and all of the common components you desire. We’ll also look at how to implement and use these templates so that the next time you create a SSIS package you can spend your time on the work you actually need to do instead of implementing common components over and over again.
Speaker(s):
- Brian Davis
Track and Room: SSIS ETL - N/A
Title: From 0 to Hadoop
Abstract: Heard about BigData and Hadoop and want to make some sense of it? You will learn about what Hadoop is and what is it not, and how it can help your organization. We will cover Microsoft HDInsight as a cloud solution and Hortonworks HDP 2.0 as an onsite platform for Hadoop implementations. Takeaways include: Why you might want to consider onsite vs hosted, and how to get up to speed as fast as possible on this game changing technology.
Speaker(s):
- Craig Purnell
Track and Room: BI Big Data - N/A
Title: APPLY Yourself
Abstract: Microsoft introduced the APPLY operator in SQL Server 2005. This under-used, non-standard operator can help us solve a number of common (and not-so-common) problems with elegant code which performs well. We will look several problem spaces in which the APPLY operator shines, such as joining to table-valued functions, getting the top N child records for each parent record, string splitting, and word matching. With the use of these examples, we will gain a deeper understanding of when to use the APPLY operator.
Speaker(s):
- Kevin Feasel
Track and Room: Performance - N/A
Title: SQL Audit - auditing doesn’t have to be boring
Abstract: Let’s face it, auditing isn’t fun. But if you’re a DBA, you need to know what’s going on in your SQL Server instance. Fortunately, SQL Audit makes it easy. In this session, we’ll cover what you can and can’t audit using SQL Audit, enhancements in 2012, configuring database and server audits, ways to process output, and ideas for how to implement SQL Audit on a larger scale. Auditing doesn’t have to be hard. And with the help of a little custom coding, it can even be fun.
Speaker(s):
- Colleen Morrow
Track and Room: Administration - N/A
Title: Get Near Realtime ETL with Service Broker
Abstract: Most of the time you’ll see ETL being done with a tool such as SSIS, but what if you need near-realtime reporting? This session will demonstrate how to keep your data warehouse updated using Service Broker messages from your OLTP database.
Speaker(s):
- Allen White
Track and Room: SSIS ETL - N/A
Title: Achieving Compliance with SQL Server
Abstract: There are a plethora of regulatory compliance mandates that affect business today with names like Sarbanes-Oxley, PCI-DSS, and HIPAA. How does a database professional implement these controls in your SQL Server infrastructure? We will review the basics of the GRC (Governance, Risk Management, and Compliance) methodology. You will learn about the tools that you can use to achieve compliance such as TDE, Auditing, and Identity Management. Come to this session and learn how to build a compliant infrastructure that keeps the DBA team, the auditors and the business leaders happy.
Speaker(s):
- Craig Purnell
Track and Room: Development Security - N/A
Title: Tally ‘Em Up
Abstract: Database administrators as a rule hate Row-By-Agonizing-Row (RBAR) solutions due to how poorly they perform in T-SQL. Sometimes, though, it seems as though we need to make do and take that performance hit. This presentation will show you that the humble tally table can eliminate RBAR-dependency across a number of different problem spaces, including splitting text, validating dates, and even reporting on errors. With plenty of examples, you’ll get to see exactly how powerful a tally table can be.
Speaker(s):
- Kevin Feasel
Track and Room: Performance - N/A
Title: Unit Testing SQL Server
Abstract: In the nearly 20 years I have been working with SQL Server, most of that as an independent consultant, I can count on two hands the number of clients I have come across that had ANY database tests constructed. I can count on TWO FINGERS the number of them that had repeatable database tests. Even the most ardent Agile/Scrum/pick-your-new-and-shiny-development-mantra shops hardly ever do anything more than wave a magic wand at testing the database, because it can be REALLY HARD to do and do correctly. In this session we will cover examples of why repeatable database testing is CRITICALLY important and then examine both a free and a low-cost commercial product to ease the pain and improve developer efficiency.
Speaker(s):
- Kevin Boles
Track and Room: SSIS ETL - N/A
Title: Power BI with SQL, Excel and SharePoint
Abstract: SQL has always enabled business intelligence through databases and analysis services. But working with them has historically required a development team. Learn how Microsoft’s new suite of BI tools for Excel and SharePoint can put the power of business intelligence back into the hands of your power users.
Speaker(s):
- Scott Brickey
Track and Room: BI Big Data - N/A
Title: Hacking SQL Server - A Peek into the Dark Side
Abstract: The best defense is a good offense. Learn how to practice hacking without going to jail or getting fired. In this presentation we’ll be demonstrating how to exploit weak SQL servers with actual tools of the penetration testing trade. You will learn why the SQL Service is a popular target on your network and how to defend against basic attacks.
Speaker(s):
- Dustin Prescott
Track and Room: Development Security - N/A
Title: Transactional Replication-10 steps for successful implementation
Abstract: What is potentially our biggest problem with transactional replication? You guessed it…it breaks! It may break for a variety of reasons and we as DBA’s probably have experienced them all at one point or another. Our biggest worry? Bringing replication back online whenever a full snapshot reinitialization is not an option due to time or space concerns. But don’t you worry; we have a couple of tricks up our sleeves! During this session, we will go over options available to you to re-sync your replication with minimal downtime for your production environments.
Speaker(s):
- Konstantin Melamud
Track and Room: Administration - N/A
Title: Policy Based Management: Introduction and Implementation
Abstract: In this session users will be introduced to the concepts of Policy Based Management. It will include demos for setting up new policies, evaluating policies, and scaling policies across an environment.
Speaker(s):
- Ryan Brickey
Track and Room: Administration - N/A
Title: Exposing SQL data with SharePoint
Abstract: You’ve got your data, but accessing it means using one application among dozens, which can be difficult for once-in-a-while users. Alternatively, you can make the data to SharePoint where it can be easily searched, related, and even (securely) exposed for integration via the SharePoint native OData, REST, and WCF interfaces.
Speaker(s):
- Scott Brickey
Track and Room: BI Big Data - N/A
Title: Getting Started with Hekaton (In-Memory OLTP)
Abstract: So you’ve heard of Hekaton (In-Memory OLTP) but you aren’t sure where to start or if it’s for you or not. Maybe you’ve heard or read some information and not sure what’s true or not. There’s a number of misconceptions out there about Hekaton. By the end of this session you’ll have a better understanding of what Hekaton is and how it may be able to help you. We’ll discuss the basics of Hekaton and more as well as walking through some demos to show you how to use Hekaton and what it can do as well as help you get started diving into Hekaton on your own.
Speaker(s):
- Brian Davis
Track and Room: BI Big Data - N/A
Title: All About the SSIS Catalog (SSISDB)
Abstract: Wow, deployment of SSIS packages in SQL Server 2012 is radically different, when the new SSIS catalog is used (“Who Moved My Cheese?”). This session examines the “new” SSISDB, its architecture and functionality and compares that to the “old” method of Package Configurations in previous versions of SSIS.
Speaker(s):
- George Squillace
Track and Room: SSIS ETL - N/A
Title: The Spy Who Loathed Me - An Intro to SQL Security
Abstract: You have lots of data you have painstakingly collected over the years. How do you ensure that data is protected from hackers, spies and other ne’er-do-wells? Understanding the vast array of security features available in SQL Server is the first step in helping you determine what actions you need to take now to protect your data.
Speaker(s):
- Chris Bell
Track and Room: Development Security - N/A
Title: SSIS for the Absolute Beginner
Abstract: Absolutely an understatement, SSIS is a very powerful construction set for moving and processing data and performing a huge variety of tasks. This session will explore the basics of SSIS development, architecture, and terminology, so that you’ll know Control Flow v. Data Flow, Tasks v. Components, Precedence Constraints v. Data Flow pipeline, to explore the types of problems SSIS can address and be able to develop basic SSIS workflows.
Speaker(s):
- George Squillace
Track and Room: SSIS ETL - N/A
Title: Indexing Fundamentals
Abstract: A solid understanding of clustered and nonclustered indexes and a thorough look at their costs and benefits. This will include looking in execution plans to see how indexes are used, going through the buffer cache to see the memory costs and benefits, and a complete look at how they fit into a strategy to improve page life expectancy and server performance.
Speaker(s):
- Steve Hood
Track and Room: Performance - N/A
Speakers
This is a list of speakers from the XML Guidebook records. The details and URLs were valid at the time of the event.
Adam Belebczuk
Twitter: - @SQLDiablo
LinkedIn: Adam Belebczuk
Contact: http://www.sqldiablo.com/
Adam Belebczuk is the Owner amp; Principal Consultant at Belebczuk Consulting Services, LLC and has more than 10 years of experience in IT, ranging from customer service to server/network administration to software and database development and administration. Adam is the Chapter Leader for the Ohio North SQL Server Users Group, a frequent speaker and volunteer at PASS events, and specializes in SQL Server development, performance tuning, high availability, and disaster recovery.
Konstantin Melamud
Twitter: - @kmelamud
Konstantin has over 15 years of SQL Server experience and demonstrates his expertise and commitment to helping SQL Server DBAs succeed through his position as Director of Service Delivery at RDX. In his role, Konstantin is responsible for designing and implementing RDX’s service delivery strategies, including those for SQL Server. Since joining RDX in 2009, Konstantin has proven to be a strong leader and expert in SQL Server database administration, architecture, performance tuning, and business intelligence. He is also a very active member of the SQL Server community and frequently presents at SQLSaturdays and user groups throughout the year. In addition, Konstantin presented during 24 Hours of PASS and at the PASS Summits.
Janis Griffin
Twitter: - DoBoutAnything
LinkedIn: Janis Griffin
Janis Griffin has over 30 years of DBA/database experience including design, development and implementation of many critical database applications. Before coming to Quest Software, Janis primarily worked in the Telecom/Network Industry, working with both real-time network routing databases and OLTP business to business applications. Janis also held positions as a Principal Architect and Senior Manager, mentoring other DBAs on best practices in database performance tuning.
George Squillace
Contact: http://www.e-Squillace.com
George has been in the I.T. industry for over twenty eight years and has been a professional trainer for over twenty years, an MCT since 1997. He has worked with and certified in every version of SQL Server since SQL Server 2000 along with a number of other industry certifications. He is very enthusiastic about the SQL Server product, especially the BI capabilities.
Ryan Brickey
Twitter: - SQLBrickey
LinkedIn: Ryan Brickey
Contact: http://mindofadba.blogspot.com/
Ryan is currently a Database Administrator with Wells Fargo where he is responsible for a production SQL Server environment. Before coming to Wells Fargo, he started his career working as a data analyst doing data mining and developing ETL procedures. From there he turned to performance monitoring and tuning as a Software Support Engineer with SQL Sentry. He also holds the certification of MCITP - SQL Server 2008 Database Administration.
Colleen Morrow
Twitter: - @ClevelandDBA
LinkedIn: Colleen Morrow
Contact: http://colleenmorrow.com
Colleen Morrow is a database professional living in Cleveland, OH who has been working with database systems since 1996. For more than 12 years, she was a Database Administrator at a large law firm where she developed an appreciation for auditing, automation, and performance tuning. Since that time she has worked with clients in the healthcare, manufacturing, software, and distribution/freight delivery industries. Colleen is currently a Senior Consultant at Fortified Data. She is an active member of the Ohio North SQL Server User Group and has presented at many SQLSaturday events as well as PASS Summit 2014 and 2015.
Kevin Feasel
Twitter: - feaselkl
LinkedIn: Kevin Feasel
Contact: http://www.catallaxyservices.com
Kevin Feasel is a Microsoft Data Platform MVP and CTO at Envizage, where he specializes in data analytics with T-SQL and R, forcing Spark clusters to do his bidding, fighting with Kafka, and pulling rabbits out of hats on demand. He is the lead contributor to Curated SQL (https://curatedsql.com), president of the Triangle Area SQL Server Users Group (https://www.meetup.com/tripass), and author of PolyBase Revealed (https://www.apress.com/us/book/9781484254608). A resident of Durham, North Carolina, he can be found cycling the trails along the triangle whenever the weather’s nice enough.
Craig Purnell
Twitter: - @CraigPurnell
LinkedIn: Craig Purnell
Contact: http://www.craigpurnell.com/
Craig Purnell is a career database professional, trainer, and community activist. He has spent over 10 years as the Database Administrator at a large Midwestern law firm. He has been in IT for 15 years and has spent his entire career working with enterprise databases and ERP systems. Craig is an active member of the Ohio North SQL Server User Group and has presented at many user groups, SQLSaturdays, and the PASS Summit in 2012 and 2013
Dustin Prescott
Twitter: - @nujakcities
LinkedIn: Dustin Prescott
Contact: http://nujakcities.wordpress.com
Dustin has worked for a large insurance company since graduating from Western Michigan University in 2006. Dustin has certifications from Microsoft, EMC, VMWare and Cisco. He currently wears three hats as a SQL/Storage/Virtualization administrator but enjoys a large array of other infrastructure and automation topics. He blogs about these topics at http://nujakcities.wordpress.com.
Brian Davis
Twitter: - @Brian78
LinkedIn: Brian Davis
Contact: http://blogs.sqlsentry.com
Brian Davis is a Product Integration Engineer at SentryOne and has over 15 years in the IT field in multiple areas including software development, support, user training, and as a DBA. He has been working with SQL Server since 2003 and has hands-on experience with SQL Server 2000 through 2016. Brian is also a PASS Regional Mentor and an active member and leader of the Ohio North SQL Server User Group.
Adam Belebczuk
Twitter: - @SQLDiablo
LinkedIn: Adam Belebczuk
Contact: http://www.sqldiablo.com/
Adam Belebczuk is the Owner amp; Principal Consultant at Belebczuk Consulting Services, LLC and has more than 10 years of experience in IT, ranging from customer service to server/network administration to software and database development and administration. Adam is the Chapter Leader for the Ohio North SQL Server Users Group, a frequent speaker and volunteer at PASS events, and specializes in SQL Server development, performance tuning, high availability, and disaster recovery.
Steve Hood
Twitter: - @SteveHoodSQL
LinkedIn: Steve Hood
Contact: http://simplesqlserver.com
I#39;m a DBA who has gone through most of my career with few people to learn and unsure of where to find great help until I found a real mentor. When I started at a company with a great, knowledgeable manager and learned to find others speaking about SQL Server online my skills boomed. This is especially true in my most passionate area, SQL Server performance.
Knowing that my knowledge came from others, I now have a second passion of sharing my knowledge with others.
Chris Bell
Twitter: - @cbelldba
LinkedIn: Chris Bell
Contact: https://www.wateroxconsulting.com/
Chris Bell offers a unique view of how we live and work with data, both now and as we head into the future. Having braved many roles, lifecycles, and battles in the IT world, he has honed his DBA (Database Administration or Do ‘Bout Anything) skills in Information Systems and development, focusing on SQL Server. Currently, he serves as the lead DBA at The Motley Fool. You can keep up with Chris’ thoughts and technical community activities at WaterOxConsulting.com.
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.
Konstantin Melamud
Twitter: - @kmelamud
Konstantin has over 15 years of SQL Server experience and demonstrates his expertise and commitment to helping SQL Server DBAs succeed through his position as Director of Service Delivery at RDX. In his role, Konstantin is responsible for designing and implementing RDX’s service delivery strategies, including those for SQL Server. Since joining RDX in 2009, Konstantin has proven to be a strong leader and expert in SQL Server database administration, architecture, performance tuning, and business intelligence. He is also a very active member of the SQL Server community and frequently presents at SQLSaturdays and user groups throughout the year. In addition, Konstantin presented during 24 Hours of PASS and at the PASS Summits.
Andrew Holowaty
Contact: http://www.smartlogicsystems.com
Andrew Holowaty has been working with the Tabular model since 2011 with PowerPivot. He is a regular speaker at the Columbus PASS User Group. He found his passion of working with technology, data, and code when he got his first computer in 1982.
Craig Purnell
Twitter: - @CraigPurnell
LinkedIn: Craig Purnell
Contact: http://www.craigpurnell.com/
Craig Purnell is a career database professional, trainer, and community activist. He has spent over 10 years as the Database Administrator at a large Midwestern law firm. He has been in IT for 15 years and has spent his entire career working with enterprise databases and ERP systems. Craig is an active member of the Ohio North SQL Server User Group and has presented at many user groups, SQLSaturdays, and the PASS Summit in 2012 and 2013
Kevin Feasel
Twitter: - feaselkl
LinkedIn: Kevin Feasel
Contact: http://www.catallaxyservices.com
Kevin Feasel is a Microsoft Data Platform MVP and CTO at Envizage, where he specializes in data analytics with T-SQL and R, forcing Spark clusters to do his bidding, fighting with Kafka, and pulling rabbits out of hats on demand. He is the lead contributor to Curated SQL (https://curatedsql.com), president of the Triangle Area SQL Server Users Group (https://www.meetup.com/tripass), and author of PolyBase Revealed (https://www.apress.com/us/book/9781484254608). A resident of Durham, North Carolina, he can be found cycling the trails along the triangle whenever the weather’s nice enough.
Allen White
Twitter: - SQLRunr
LinkedIn: Allen White
Contact: http://dataperfpro.com/blog/
Allen White is a Data Platform consultant. He has been both a developer and an administrator, so he understands both perspectives towards database technology. He loves sharing his experiences and helping people learn how to use SQL Server. Allen has spent over 40 years in IT, using SQL Server since 1992, and has been awarded Microsoft’s MVP Award for the last 13 years. Allen was a PASS Director from 2016 - 2018.
Scott Brickey
Contact: http://www.sbrickey.com/Tech/Blog
Scott Brickey is the SharePoint Practice Director at Strategic Data Systems. His background includes solution architecture, database and SharePoint administration, .Net and SharePoint development, and training.
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.
Allen White
Twitter: - SQLRunr
LinkedIn: Allen White
Contact: http://dataperfpro.com/blog/
Allen White is a Data Platform consultant. He has been both a developer and an administrator, so he understands both perspectives towards database technology. He loves sharing his experiences and helping people learn how to use SQL Server. Allen has spent over 40 years in IT, using SQL Server since 1992, and has been awarded Microsoft’s MVP Award for the last 13 years. Allen was a PASS Director from 2016 - 2018.
George Squillace
Contact: http://www.e-Squillace.com
George has been in the I.T. industry for over twenty eight years and has been a professional trainer for over twenty years, an MCT since 1997. He has worked with and certified in every version of SQL Server since SQL Server 2000 along with a number of other industry certifications. He is very enthusiastic about the SQL Server product, especially the BI capabilities.
Brian Davis
Twitter: - @Brian78
LinkedIn: Brian Davis
Contact: http://blogs.sqlsentry.com
Brian Davis is a Product Integration Engineer at SentryOne and has over 15 years in the IT field in multiple areas including software development, support, user training, and as a DBA. He has been working with SQL Server since 2003 and has hands-on experience with SQL Server 2000 through 2016. Brian is also a PASS Regional Mentor and an active member and leader of the Ohio North SQL Server User Group.
Scott Brickey
Contact: http://www.sbrickey.com/Tech/Blog
Scott Brickey is the SharePoint Practice Director at Strategic Data Systems. His background includes solution architecture, database and SharePoint administration, .Net and SharePoint development, and training.
Sponsors
The following is a list of sponsors that helped fund the event: