SQLSaturday #231 - Cocoa Beach 2013
Event Date: 07/27/2013 00:00:00
Event Location:
- 1550 N Atlantic Ave
- Cocoa Beach, Florida
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: Leveraging PAL for SQL Server Perfmon Analysis
Abstract: In this session we will cover the Performance Analysis for Logs (PAL) tool in depth. We will cover the best methods for capturing a .blg capture leveraging PAL to find critical performance area. We will also cover creating your own PAL templates. System Monitor has long been a tool used by system admins, DBAs, and other engineers to get a handle on performance issues in their environment. The tool is powerful, but can be difficult to understand which perfmon counters are valuable, to find the correct counters, and to be able to properly view the output. In this session, we will cover how the PAL tool can be used to produce a rich HTML output of your perfmon capture exposing performance risks and trends with full documentation on what the perf counters means to your given workload. We will cover how to leverage existing PAL templates on SQL Server and other technologies. We will discuss how to adjust existing templates and how to create your own template for performance baselining.
Speaker(s):
- David Pless
Track and Room: DBA - N/A
Title: Real World Lessons from Starting a Software Company
Abstract: While starting Pragmatic Works and other companies, Brian (as with others) made a lot of naïve mistakes. In this session, he will share with you the pitfalls he found when starting a business and managing a team of developers and consultants. Learn how to create a culture in your organization or team that will help you retain employees and help your team stand out. Learn some of the mistakes that most leaders make when starting a company. Finally, learn how to turn your idea into reality and grab your first customers.
Speaker(s):
- Brian Knight
Track and Room: BI - N/A
Title: Introduction to SQL Server Replication
Abstract: With replication being a source for many data warehouse systems, this session will cover aspects regarding your data and business that should drive design decisions when architecting a replication topology. Discussed will be design decisions for snapshot, transactional, and merge replication. Also discussed will be agent profiles and optimizations for replication. What type of replication to use to solve business needs will also be covered.
Speaker(s):
- Chad Churchwell
Track and Room: SQL Suite - N/A
Title: Excel 2013: BI for the Masses
Abstract: With the release of Excel 2013 many new features have taken what has always been the most popular Business Intelligence tool to a new level. This session highlights many of those new features like Flash Fill, Office Apps, Inquire Add-in, PowerPivot, Power View, GeoFlow, and Data Explorer.
Speaker(s):
- Devin Knight
Track and Room: BI - N/A
Title: SSRS: On Premises or Azure? What’s the difference?
Abstract: With a lot of companies looking to the cloud for cost savings, it helps to know what the differences are between on premises and cloud installations of your IT services. In this session, we’ll take a look at SQL Server Reporting Services and the feature differences between deploying in the cloud, and deploying on premises. We’ll look at different options for where you can deploy your reports as well. Also, Shannon Lowder will help with the associated costs of each solution, as well as preparing you for some of the gotchas you’ll face as you move to the cloud today.
Speaker(s):
- Josh Luedeman
Track and Room: SQL Suite - N/A
Title: Exploring The Microsoft Reporting Technologies
Abstract: The Microsoft BI Stack provides many different options when it comes to choosing a presentation layer. From PerformancePoint to PowerView the options are plentiful; however each option presents different benefits and is intended for different use cases. In this session I will cover the different presentation options provided by Microsoft and more importantly dive into when and where it is proper to use the different options. I will also demonstrate ways to integrate the different options like including a Reporting Services report in a PerformancePoint dashboard.
Speaker(s):
- David Ortiz
Track and Room: DBA - N/A
Title: A Balanced BI Approach (Self-Service Corporate)
Abstract: In this session I will cover how PowerPivot and BISM Tabular complement each other in the domains of self-service and corporate BI. Let’s face it, The Finance department does not have the expertise to model a database for reporting, and IT doesn’t have the expertise in advanced financial calculations that the executive team is interested in. To bridge the gap from a large requirements process with the risk of functionality lost in translation, I will show you how you can roll out a PowerPivot model for business units in your organization and when it makes sense to centralize it in a BISM Tabular model.
Speaker(s):
- Anthony Sammartino
Track and Room: BI - N/A
Title: Dealing With Errors in SSIS 2012
Abstract: This session focuses on error handling in SQL Server Integration Services 2012. Different techniques and strategies will be introduced for error handling in control flow, data flow, and script tasks as well as how to dynamically handle errors.
Speaker(s):
- David Dye
Track and Room: SQL Suite - N/A
Title: DBA Task Automation: Unleash the PowerShell Hero in You!
Abstract: As DBAs, we constantly have to stretch our time and budget resources, and the best way to keep up with demands is through process automation. Workflow and PassThru parameters are just two of the features that will allow you to turn complex tasks into simple, repeatable, automated processes easier than you would have ever dreamed possible. And if you’ve had trouble with PowerShell in the past, the auto-completion and eager loading of modules will make your transition to PowerShell hero even simpler. Come see how mid-tone blue can help take your skills to the next level.
Speaker(s):
- Michael Wells
Track and Room: DBA - N/A
Title: Backup Strategies are for Losers!
Abstract: Every company has a backup strategy. That backup strategy is worthless and will cause your business to fail miserably while losing valuable customer data and more importantly you will lose my order of chicken wings! In this session you will learn why backup strategies are for losers, what can I do to keep from being a loser, and how can I build a winning strategy!
Speaker(s):
- Ed Watson
Track and Room: SQL Suite - N/A
Title: PCI For The SQLDBA
Abstract: Are you storing or planning to store credit card numbers? If so, you need to learn all you can about the requirements for PCI compliance. We’ll cover how PCI works from the requirements to the final audit, and eveything in between that you’ll need to know something about. We’ll talk about encryption, key management, logging, alerting, administration access, granular permissions, tokenization, and as much more as we can fit into an hour. It’s a complex topic, but that just makes it more interesting!
Speaker(s):
- Andy Warren
Track and Room: DBA - N/A
Title: The T-SQL Features in SQL Server 2012 You Can’t Ignore
Abstract: Forget AlwaysOn and Columnstore Indexes the really fun features of SQL Server 2012 are in T-SQL. In this session you’ll get the grand tour of these new features. You’ll be introduced to the powerful new analytic window functions, discover new ways to generate numeric sequences and explore the awesome new query paging feature. You’ll also be enamored with the new error handling features and new string functions such as the awesome Format function. Upon completion you’ll have a great understanding of these great new features and how you can utilize them in your environment.
Speaker(s):
- Richie Rump
Track and Room: DBA - N/A
Title: You Inherited a Database, Now What?
Abstract: You have recently inherited the support of a new or existing database, what are the things you should immediately check and start monitoring and what are the things that you should address over the next few weeks. When taking over support of a database or system, you cannot ASSUME anything. At the end of this session you will have a nice checklist of things you should check and be doing on ALL your databases not just the one you inherited. Whether you are a seasoned DBA or just starting out, this session should be informative and something you can relate to.
Speaker(s):
- Tim Radney
Track and Room: DBA - N/A
Title: Tips Tricks for dynamic SSRS Reports
Abstract: In this session we will explore the multitude of ways that you can make your reports adapt to the needs of your users. This will include defining formats based on the data contents. We will explore how to refine layouts based on the data to be delivered. We will demonstrate how to create a parameter driven data source. We will take a look at how creating templates can give your catalog of reports a more professional look. All of this together will empower you to have more control over the reports you create.
Speaker(s):
- Pam Shaw
Track and Room: SQL Suite - N/A
Title: SQL Automation Using SSIS
Abstract: In this session we are going to cover how to find patterns within your processes and how to used ssis to automate standard ETL processes within your organization from basic file loading to complex ETL extracts and Imports.
Speaker(s):
- Jorge Novo
Track and Room: SQL Suite - N/A
Title: Model-Driven Database Design
Abstract: Model-Driven Database Development: Myths, Magic and Methods. In this presentation, Karen discusses data model-driven database development from the point of view of the Data Architect, the DBA, and the Developer. She will cover topics such as “Who does what?”, “Why are we doing this?”, “Do I have to Use a GUI?” and “Just who do you think you are?”. Demos, too. Finally, 10 tips for making model-driven database development successful in your organization’s culture and environment.
Speaker(s):
- Karen Lopez
Track and Room: BI - N/A
Title: MDS in Practice: An Integrated Approach
Abstract: Businesses depend on reliable, consistent and correct data that can be managed effectively and shared through-out the enterprise. Master Data Services provides a powerful, feature-rich platform for arriving at this destination but the successful journey to this end requires a proven integrated approach. This session will discuss how MDS fits in the overall EIM architecture within your organization including real-world strategies for integrating (cleansing, matching and loading) Master Data into MDS and for making it available organization-wide.
Speaker(s):
- Christopher Price
Track and Room: BI - 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.
Brian Knight
Twitter: - @BrianKnight
Contact: http://www.bidn.com/people/brianknight
Brian Knight, a SQL Server MVP, MCSE, and MCDBA, is the owner and founder of Pragmatic Works. He is also the co-founder of SQLServerCentral.com, BIDN.com, and SQLShare.com. Brian runs the local SQL Server users group in Jacksonville (JSSUG), is a contributing columnist at several technical magazines, and does regular webcasts at PragmaticWorks.com. He is the author of 15 SQL Server books and a frequent speaker at conferences such as PASS Summit, SQL Connections, TechEd, and many Code Camps.
Tim Radney
Twitter: - @tradney
LinkedIn: Tim Radney
Contact: http://www.timradney.com
Tim is a Data Platform MVP and has a whole collection of Microsoft and other industry certifications. His experience includes HA/DR, virtualization, SSIS, SSRS, and performance tuning, among everything else SQL Server-related. Tim is very active and passionate in the SQL Community. He runs the Columbus GA SQL Users Group, has been a PASS Regional Mentor for a number of years, was named a PASS Outstanding Volunteer in 2012, and is a frequent speaker at user groups, SQLSaturdays and PASS Summits. Tim is one of the top ranked in karma on ask.sqlservercentral.com, answers questions as @tradney on Twitter, and blogs at http://timradney.com and SQLskills blog at http://www.SQLskills.com/blogs/tim.
Christopher Price
Contact: http://bluewatersql.wordpress.com/
Chris Price is a Sr. BI Consultant with Pragmatic Works based in Tampa, FL. He has a B.S. in MIS and a MBA, both from the Univ. of South Florida. He previously worked as a software architect before being bitten by the BI bug. His current focus is on ETL and Data Integration, Data Quality and MDM, SSAS, SharePoint and Big Data. He regularly speaks at SQLSaturdays, Code Camps and other community events. He has authored multiple whitepapers and books and served as technical editor.
David Dye
David is a Sergeant with the Cape Coral Police Department and currently works as a database administrator and developer in the Administrative Services Division. He began his career with the police department in 1990 in the patrol division and worked various assignments until being promoted to Sergeant in 1998. Based on his education and experience David was assigned to his current position in 2002 and is responsible for database administration, software integration, and development for public sa
Anthony Sammartino
Twitter: - @SQLAnt
LinkedIn: Anthony Sammartino
Contact: http://www.sqlant.me
Anthony Sammartino is the Vice President of the BI Solutions division for TekPartners. Anthony has been building Business Intelligence solutions as a consultant for many fortune 500 companies for over 13 years. For the last 11 years he has almost exclusively used the Microsoft SQL Server BI stack and focused on the following technologies: DB Engine, SSIS, SSAS, SSRS, PowerPivot, Power View, and SharePoint. Anthony currently holds certifications as an: MCP, MCTS(BI), MCITP (BI), and PMP#174;
David Pless
Twitter: - @dpless
Contact: http://blogs.msdn.com/b/sql_pfe_blog/
For the past nine years, I have been a Technical Solution Professional with Microsoft. As a TSP I conduct full training workshops, conduct demo sessions, and perform architectural reviews on all supported builds of SQL Server. I mainly support the Southeast focusing on Florida, but I can be anywhere in the world.
My core areas are Performance Tuning and Optimization, Azure, AlwaysOn, Reporting Services (SSRS), custom monitoring, building custom dashboards, and more.
Andy Warren
Twitter: - @sqlandy
Contact: https://sqlandy.com
Andy Warren is a SQL Server consultant and trainer based in Orlando, FL. Focusing on administration, performance tuning, and SQL Server patterns and practices, he’s been a SQL Server MVP since 2008. Andy served two terms on the PASS Board of Directors, was a founding principal in SQLServerCentral, and created both the SQLSaturday and SQLRally event models.
Josh Luedeman
Twitter: - http://www.twitter.com/joshluedeman
LinkedIn: Josh Luedeman
Contact: http://www.joshluedeman.com
Josh is a Sr FastTrack Engineer with the FastTrack team in the Azure Engineering Group at Microsoft. Josh focuses on Microsoft’s Cloud Scale Analytics Solutions in Azure using products like HDInsight, Data Lake, Data Factory, and DataBricks. He has worked in IT for over 10 years holding positions in Application Support, Database Administration, and Business Intelligence, in industries like Higher Education, Consulting, Manufacturing, and Software Development.
David Ortiz
David has spent the last 10 years focusing on enterprise data solutions. He has implemented large scale BI projects at companies such as Office Depot, AutoNation, Citrix, Bank Atlantic and most recently Ultimate Software, where he served as a Data Architect. David currently holds certifications as a: Microsoft Certified Professional for SQL Server (MCP), Microsoft Certified Technology Specialist for SQL Server 2008 BI (MCTS), Microsoft Certified IT Professional for SQL Server 2008 BI (MCITP).
Richie Rump
Twitter: - @jorriss
LinkedIn: Richie Rump
Contact: http://jorriss.net
Richie Rump is a dataveloper with Brent Ozar Unlimited, where he writes code to solve data problems. He developed statisticsparser.com and sp_DataProfile, two tools that help data professionals tune SQL Server. Richie is also the co-host of the Away From The Keyboard Podcast and founded dotNet Miami, a community focused on enterprise development with .NET. He holds the Project Management Professional (PMP) and Certified Scrum Master (CSM) certifications as well as certifications in various Microsoft development technologies. He can be found on Twitter at @Jorriss or at http://jorriss.com.
Jorge Novo
Contact: http://etldevelopernotes.blogspot.com/
Jorge Novo is a database developer with more than 10 years of experience in the design, implementation, and maintenance of OLAP, ROLAD database system for the enterprise. Jorge specialize himself on ETL processes using automation, and dynamic programming for SSIS. Currently Jorge is working in the programming and development of Data Master Service for the organization.
Ed Watson
Twitter: - http://twitter.com/SQLGator
LinkedIn: Ed Watson
Contact: http://sqlgator.com
Ed Watson is a Principal Data Platform Consultant for Improving Enterprises, a full-stack Microsoft consulting firm in Atlanta. Ed is a Microsoft Data Platform MVP since 2014 and like most children, Ed was born at an early age. Today, Ed specializes in the Business Intelligence stack and enjoys specializing in Power BI immensely. He currently lives in Atlanta and is active with the Atlanta MDF and Atlanta BI user groups and is an organizer for SQLSaturday Atlanta, Atlanta BI, and Pensacola.
Pam Shaw
Twitter: - @PamShaw
LinkedIn: Pam Shaw
Contact: http://sqlpam.wordpress.com/
Pam Shaw has been in IT for over 30 years. Since 2001, Pam has been working with SQL Server, first 2000, then 2005, 2008, 2008 R2, 2012 and now 2014. Pam currently works as a BI Developer as an independent contractor. Pam is also the Chapter Leader of the Hillsborough SQL Users Group PASS chapter and organizer of SQLSaturday Tampa.
Chad Churchwell
Twitter: - @chadchurchwell
LinkedIn: Chad Churchwell
Contact: http://www.sqlchad.com
Seasoned SQL Server DBA Professional with over 18 years IT experience with 15 years experience in databases. I have managed an enterprise DBA team and am currently in a strategic consulting role specializing in HA, DR, Replication, and Performance Tuning and Optimization. I am currently speaking at several SQLSaturday’s as well as local user group meetings.
Michael Wells
Twitter: - @SqlTechMike
LinkedIn: Michael Wells
Contact: http://sqltechmike.com
Michael Wells is a Microsoft Specialist at Dell EMC covering enterprise customers. He has worked in IT since 2000 and has supported all versions of SQL Server from SQL Server 2000 to SQL Server 2014. Michael has been presenting since 2007 for local user groups, CodeCamps, SQLSaturday events, IT Pro Camps, and large conferences like PASS Summit and Oracle OpenWorld.
Karen Lopez
Twitter: - @datachick
LinkedIn: Karen Lopez
Contact: http://datamodel.com
Karen Lopez is a Sr. Project Manager and Architect for InfoAdvisors. A frequent speaker at conferences and local user groups, she has 20+ years of experience in project and data management on large, multi-project programs. Karen is a chronic volunteer, a Data Platform MVP, and an active advocate for science, technology, engineering, and mathematics (STEM) education and data quality.
Karen’s presentations are known for their lively and interactive approach to learning. Her motto: “Love Your Data!”
Devin Knight
Twitter: - @knight_devin
LinkedIn: Devin Knight
Contact: http://devinknightsql.com
Devin Knight a Microsoft Data Platform MVP and the Training Director at Pragmatic Works. He is an author of seven SQL Server and Business Intelligence books and speaks at conferences like PASS Summit, PASS Business Analytics Conference, SQLSaturdays and Code Camps. He is also a contributing member to several PASS Virtual Chapters. Making his home in Jacksonville, FL, Devin is the Vice President of the local Power BI User Group and SQL Server User Group (JSSUG).
Sponsors
The following is a list of sponsors that helped fund the event: