SQLSaturday #226 - South Florida 2013

Event Date: 06/29/2013 00:00:00

Event Location:

Nova Southeastern University
3301 College Ave
Davie, Florida

This event has completed. All data shown below is from the historical XML public data available.

Sessions
Speakers
Sponsors

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: Into the Wild,Taming Unstructured Data

Abstract: There is runaway growth in the data volumes many organizations are facing today. The bad news is that much of this data is unstructured which means your traditional RDBMS just isn’t capability of helping you deal with it. As a result significant emphasis has been put on technologies like Hadoop, No SQL and other distributed databases which are better suited to handling unstructured data. With the latest release SQL Server 2012 however, Microsoft has provided new features which will help tame some of this unstructured data. This session will dive into the new FileTable and Statistical Semantic Search features. We will show you how they work and highlight real world examples for integrating these exciting new features into your organization.

Speaker(s):

Christopher Price

Track and Room: DBA Performance (1054) - N/A

Title: SSAS Tabular and PowerPivot - Choose Your Own Adve

Abstract: In this session I will cover how SSAS tabular and PowerPivot compliment each other and make the slicing and dicing of large amounts of data a breeze for Power Users. I will give a brief explanation and history of each, then will let the audience choose their own adventure in creating a SSAS tabular model or PowerPivot model from scratch. I will walk everyone through how to import data into it, create data relationships from a regular database model, then expose the elements from the model for users to slice and dice data with ease with a Pivot table then a Power View visualization. I will demonstrate a few DAX commands that are very powerful yet very easy.

Speaker(s):

Anthony Sammartino

Track and Room: Business Analytics (3033) - N/A

Title: Changing Data Is Easy, Managing Data Change is Hard!

Abstract: Databases are growing. The way we use data is changing and growing. When you have a lot of change, it has to be managed, or bad things happen to your data and your job! A common problem with database change management is… database change management. This session walks the user through the concepts of database change management, why it’s important, and how SQL Server Data Tools (SSDT) makes this process easy. There are a lot of great features in this frequently overlooked product, and if you are not using it, your job is a lot harder than it needs to be. Some things we will discuss: schema compare, database versions in source control, renaming objects, and how your job is pushing the button to deliver it the EASY way with SSDT.

Speaker(s):

James McAuliffe

Track and Room: Business Analytics (3033) - N/A

Title: Discover, Document, Diagnose Your Servers on Your Coffee Break

Abstract: Documentation is the bane of every DBA’s existence. We all know we should do it but it’s time consuming; by the time you’re finally done it’s probably out of date. Throw in the new servers you just found out about last week and keeping documentation up to date can turn into a full time job. And with everything we have to do in our day, who has time for that?

You need a way to work smarter, not harder, and automate your documentation. It can be done, and in this session you’ll learn how to discover all the SQL Servers on your network, document their configuration from top to bottom (including OS details), and diagnose common problems before they turn into big headaches - all while you’re on a coffee break. You’ll look like a rock star without writing a line of code on your own or having to ask management to sign a check.

Attend this session and walk away with everything you need to generate documentation for your entire SQL Server environment on your first day back at the office

Speaker(s):

Kendal Van Dyke

Track and Room: DBA Auditing (1053) - N/A

Title: Putting Quality Back Into Your Data Analysis

Abstract: This session introduces Data Quality Services, a feature introduced in SQL Server 2012. One of the challenges in developing Business Intelligence solutions is ensuring that the data does not have inconsistencies, incomplete records, invalid or inaccurate values, and data duplication. Sometimes when consolidating data from more than one source you have to transform data to create one standard set of domain values in a standard format. SQL 2012 answers this need with Data Quality Services (DQS). In this session, you will learn the basics of what DQS is and how it can be used to clean your data. You will see how to build a domain both manually and from an existing data table. You will then see how to use these domains to validate tables in SQL Server and Excel preparing them for use in SSAS and PowerPivot. After this session, you will understand how by putting quality back into your data, you can be your organization’s BI hero.

Speaker(s):

Michael Antonovich

Track and Room: Business Dev (3032) - N/A

Title: Implementing a HIPAA Compliance Strategy with SQL Server

Abstract: HIPAA puts a lot of responsibility on our companies and compliance can be hard to maintain. Today medical data is more valuable on the black market than a social security number or a credit card. As DBAs we’re charged with the security of our data and thus act as front line defense.

In this hour long session We’ll delve into the Health Insurance Portability and Accountability Act (HIPAA) and what implications it has for us as data professionals. We’ll discuss SQL Server best practices that can help protect ourselves, our company, and the people whom we serve. We’ll also dive into features in SQL Server that can help in this endeavor.

Speaker(s):

Brandon Leach

Track and Room: DBA Auditing (1053) - N/A

Title: Code Paradigms in BIDS

Abstract: Using BIDS we are able to answer questions in two contradictory worlds the OLTP and the OLAP in order to do that BIDS is presented with the three services SSIS, SSRS and SSAS and a variety of languages such as SQL, T-SQL, MDX, DMX, etc. It is impossible to explain even one aspect of one of the tools that comprise BIDS (Database Tools) even less to explain the main components of the MS BI stack SSIS, SSAS, SSRS in a single presentation. So in this presentation we are trying to explain the mind set of these three services and paradigms from the perspective of the problems they are trying to solve.

Speaker(s):

Frank Quintana

Track and Room: DEV Programming (1052) - N/A

Title: SQL Server 2012 ColumnStore Indexes

Abstract: Come and learn how the new SQL Server 2012 feature, ColumnStore Indexes, can parallelize your Data Warehouse aggregations. I will be doing a deep dive into the inner workings of ColumnStore indexes; how they work, key characteristics, dos and don’ts, restrictions, and more. I will have some insight into how CSI’s will work in SQL Server vNext, as well. If you are a production DBA who needs to find out more about some of the additional hot features that have been included with CSI’s, like batch mode processing and data segments, then this session is for you. If you are a BI DBA or developer who needs to find out how CSI’s can increase the performance of your aggregations and star-joins by up to 40 times, then this session is also for you.

Speaker(s):

Gareth Swanepoel

Track and Room: DBA Track (1048) - N/A

Title: Building a SQL Server for Optimal Performance

Abstract: Do SQL Server Administrators or Developers really know how to configure the hard- and software components of a SQL Server in order to have it running at peak performance ? This is not their fault and is purely due to the fact that they have not been exposed to these options before. If you are a DBA or developer and find yourself wondering how hardware changes affect a system or have questions relating to the performance implications of partitioning or compression, then this session is for you. In this session, I will be exploring topics such as Memory configuration, CPU and cache options, IO considerations, partitioning, compression and database file placement and many other performance optimisation tricks.

Speaker(s):

Gareth Swanepoel

Track and Room: DBA Performance (1054) - N/A

Title: Introducing Cube World To Users From Flat Table Land

Abstract: This session explores the tabular approach to building cubes in SQL Server Analysis Services 2012 for those DBAs and developers who are more comfortable working with relational databases than cubes. Starting with a ‘normal’ relational database, the attendee will learn how to build a basic model by loading data from several data sources, establish relations between these data sources, define measures and dimensions, build hierarchies, create KPIs and deploy functional cubes that can be used to answer management’s questions about what is really going on with their data. For users already familiar with PowerPivot, this session provides a good transition into the world of SSAS as both use essentially the same techniques.

Speaker(s):

Michael Antonovich

Track and Room: Business Dev (3032) - N/A

Title: Moving Big Data - SSIS, Pig, and Sqoop

Abstract: Wondering how all that big data is going to be moved around? Or how you are going to move any of it into your SQL Server environment? Come to this session, and learn about some of the familiar and not so similar tools you can use for moving big data. We’ll compare the options, discuss how they can work with your existing Microsoft technologies, and provide some guidance on when to use each of the tools.

Speaker(s):

John Welch

Track and Room: DEV Programming (1052) - N/A

Title: HDInsight: What’s all the Hadoopla about Big Data?

Abstract: Are you keeping up with buzz around big data? Are you wondering what opportunities and changes big data may bring to your data warehouse architecture? In this session you will learn about HDinsight, Microsfot’s big data platform, capabilities and tool set. We will address common myths and develop recommendations to successfully bring big data capabilities to your data warehouse and business intelligence implementation. After this presentation you will better prepared to make architectural and functional design decisions when considering Microsoft HDInsight as part of your solution.

Speaker(s):

Rafael Salas

Track and Room: Self Service BI (3034) - N/A

Title: Tuning Analysis Services Processing Performance

Abstract: You’ve got your Analysis Services cube created, and deployed in production. However, you notice that every night, the cube is taking longer and longer to process, and users are starting to complain about their data not being ready when they arrive in the morning. If you’ve found yourself in this situation, or want to avoid being in it in the first place, come to this session. We’ll cover how to benchmark processing performance, track down bottlenecks, and how to tune things to get the best performance for processing your cube.

Speaker(s):

John Welch

Track and Room: DBA Performance (1054) - N/A

Title: Applied Enterprise Semantic Mining

Abstract: Text mining is projected to dominate data mining, and the reasons are evident: we have more text available than numeric data. Microsoft introduced a new technology to SQL Server 2012 called Semantic Search. This session’s detailed description and demos give you important information for the enterprise implementation of Tag Index and Document Similarity Index. The demos include a web-based Silverlight application, and content documents from Wikipedia. We’ll also look at strategy tips for how to best leverage the new semantic technology with existing Microsoft data mining.

Speaker(s):

Mark Tabladillo

Track and Room: BI Reporting (3031) - N/A

Title: Building Your Own SQL Server Virtual Playground

Abstract: As the number of SQL Server versions and features grow over time so does the the difficulty in maintaining a set of tools for working with all of them on your local machine. Add in that some features require multiple physical instances and suddenly a single installation isn’t enough. Need to quickly switch between versions and editions of SQL Server? Want to learn how to set up a cluster? Or maybe you want to try out the latest features in SQL 2012…virtualization offers a convenient way to do any or all of these. In this session we’ll show you how by covering the fundamentals of desktop virtualization and demonstrating how to set up a virtual playground on your own machine.

Speaker(s):

Kendal Van Dyke

Track and Room: DBA Auditing (1053) - N/A

Title: PowerShell Working with XML and SMO

Abstract: Come and learn some basic technique on how to use PowerShell to work with your XML file. XML files are everywhere and you need to be prepare to use your tools that already are available at your fingertip. In this case, using PowerShell with SMO and Sapien XML editor which is a great tools. Also, I will be demostrating one particular scenario on how to convert UTC XML generated Dates to PowerShell w/SMO and T-SQL DateTime. You will get some PowerShell, T-SQL, and creating/viewing XML schemas in this session.

Speaker(s):

Maximo Trinidad

Track and Room: DBA Track (1048) - N/A

Title: Unit Testing SSIS Packages

Abstract: Unit testing is a widely accepted best practice, yet it is difficult to do well with SSIS packages. This session will focus on both the practice of test driven development as it applies to SSIS, and the tools for actually implementing it. It will cover in depth how to set up your development environment to support test driven development and what techniques can be used to make this practical for SSIS. You will also see how to automate the testing of SSIS packages, using the open source ssisUnit framework. The session will cover several of the common questions about automated unit testing, including how to handle test data , how to set up the environment for multiple developers, and how to make tests flexible.

Speaker(s):

John Welch

Track and Room: DEV Programming (1052) - N/A

Abstract: Are you looking to create more stability in your professional future in uncertain economic times? Developing a social media platform is a challenge for highend professionals and consultants. The presenter has established a blog (http://marktab.net), cofounded an online journal (http://solidq.com/sqj), become a paid video presenter, secured a spot at Microsoft TechEd, and earned credit toward his first Microsoft MVP. This presentation introduces the basic elements for 2013 of a successful web strategy. The presenter shares his own statistics and first-hand experiences with website development, WordPress blog hosting, leveraging social media services (including Twitter, Linked in, YouTube and Facebook), and working with Microsoft.

Speaker(s):

Mark Tabladillo

Track and Room: Business Dev (3032) - N/A

Title: Data Mining Innovation with SQL Server 2012

Abstract: This presentation includes a complex business analytics solution using elements across the Microsoft Business Intelligence technology. This talk will not have all the steps spelled out. Therefore you should prepare – for example, by looking at the SQL Server 2012 Developer Kit – since attendees will be expected to have working knowledge of SQL Server relational database, SSIS, SSAS, SSRS, SSMS and SSDT. Key elements of this solution will highlight features new to SQL Server 2012. At the end of the demonstration, you will be expected to participate in groups to promote one idea which builds on the demo, and everyone will be voting for their favorite groups. Come ready to create and celebrate your peers.

Speaker(s):

Mark Tabladillo

Track and Room: BI Track (3030) - N/A

Title: AlwaysOn - Finally, A usable ‘mirror’!

Abstract: In the past, High Availability and Disaster Recovery (HADR) had many limitations. Clustering and Mirroring are great, but the mirror/secondary database is not very usable since it is not online. Finally, AlwaysOn solves this limitation by merging both multi-node Clustering and mirroring. AlwaysOn also allows the secondary database to remain ONLINE, so we can use it for reporting purposes without resorting to a Snapshot! Come see this lively session with extensive demos of setting up, configuring and testing AlwaysOn. We’ll also test automatic fail-over using a real web app to see how well this feature works.

Speaker(s):

Jim Murphy

Track and Room: DBA Track (1048) - N/A

Title: Whats New in T-SQL With SQL Server 2012

Abstract: This session covers the new features and functions introduced to T-SQL in SQL Server 2012. Our time will be spent reviewing enhancements to T-SQL specifically for SQL Server 2012 with attention to demonstrations and code samples. This is a basic session, but ttendees should have a general knowledge of T-SQL.

Speaker(s):

David Dye

Track and Room: DBA Track SQL2012 (1047) - 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: Self Service BI (3034) - 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: DBA Auditing (1053) - N/A

Title: TempDB under the hood

Abstract: There are many operations performed internally by SQL Server engine that use TempDB besides the objects created by developers (temporary tables or table variables). This session will present situations where SQL Server uses TempDB under the hood, and what can be done to prevent your TempDB to be your bottleneck.

Speaker(s):

Sam Mesel

Track and Room: DBA Track (1048) - N/A

Title: Column Level Encryption

Abstract: This session will introduce column level encryption using t-sql. We will discuss the introduction of cryptographic services in SQL Server and how this enables native encryption as well as real life scenarios and uses of column level encryption.

Speaker(s):

David Dye

Track and Room: DBA Auditing (1053) - N/A

Title: SQL Server 2012 AlwaysOn Step-by-Step

Abstract: Cluster MVP David Bermingham will walk you through the process of creating high availability and disaster recovery configurations using the new features of SQL Server 2012 AlwaysOn Availability Groups as well as AlwaysOn Failover Clusters and Multisite Clusters. And then finally David will demonstrate how Availability Groups and Failover Clusters can be used together for a combination of High Availability and Disaster Recovery. This session will make use of VMs to demonstrate the technology in a “hands-on” fashion.

Speaker(s):

David Bermingham

Track and Room: DBA Track SQL2012 (1047) - 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: BI Track (3030) - 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: Database Developers (1049) - N/A

Title: Database Design Disasters: Common Mistakes Found in the Wild

Abstract: Not every system has a database architect available to design it. But what happens when a database is created the proper care wasn’t taken into designing it? This session will take a real-world look into my experiences with some database design choices. We’ll take a deep look into these design choices including a detailed discussion on why they didn’t work and what could have been done better. We may even take a peek into SQL Server internals. This session is primarily for data professionals that are new to database design.

Speaker(s):

Richie Rump

Track and Room: Database Developers (1049) - N/A

Title: SQL Server 2012 IaaS and SQL Database In Depth

Abstract: Let’s talk database! SQL Server 2012 IaaS is a new offering, while SQL Database (previously SQL Azure) is a PaaS relational database engine. How do they compare? Which one should you use? Let’s discuss pros and cons, and see how easy it is to build a database in the cloud.

Speaker(s):

Herve Roggero

Track and Room: Database Developers (1049) - N/A

Title: SSIS - Integrating PowerShell in a ScriptTask component

Abstract: This session will demostrate how you can reuse a PowerShell script in SSIS “Script Task” component as part on a ETL flow. I’ll be showing some basic .NET Script code in both C# and VB. I’ll be adding some useful tips when re-using existing Powershell code. Integrating different .NET technologies in a SSIS package: C#, VB.NET, XML, and PowerShell. Everyone is welcome to attend.

Speaker(s):

Maximo Trinidad

Track and Room: BI Track (3030) - N/A

Title: SQL Server 2012 Column Store Index

Abstract: Take your relational data warehouse query performance all the way to ELEVEN!! The Column Store Index is a new feature that allows for stunning performance. We will cover how it works, why it is so fast as well as the v1.0 limitations and gotchas.

Speaker(s):

Kevin Boles

Track and Room: DBA Track SQL2012 (1047) - N/A

Title: Getting started with Master Data Services 2012

Abstract: Are you currently using Master Data Services? if the answer is no, you can’t afford to miss this presentation. In this session Luis will provide an overview of MDS 2012. What is it? What can you use it for? Whether you are looking for a better solution for your business users than the common spread-marts or you are implementing a Master Data Management strategy to go along with your EDW, this session is for you.

Speaker(s):

Luis Figueroa

Track and Room: BI Reporting (3031) - N/A

Title: High Performance SANLess Clustering

Abstract: Powered by Fusion-io, Protected by SIOS: Learn how to eliminate the bottlenecks and costs of SAN-based clustering. Leverage the performance of high-speed Fusion ioMemory and achieve higher levels of availability with SIOS. It is the best of both worlds - performance and protection – at a price you can afford. Join us and you could win a $100 American Express gift card.

Speaker(s):

Sios Technology and Allan Hirt

Track and Room: Auditorium (1124) - N/A

Title: Agile BI with SQL Server 2012 and TFS 2012

Abstract: In a world where executives/CXOs are keen to perform analytics and data consolidation with lightning speed, there is a strong push towards incorporating the principles of Agile manifesto in the BI world to deliver solutions faster than ever before. In this session, I will share techniques that will help a consultant deliver BI solutions with a rapid prototyping approach and how Agile features of TFS can be leveraged to run projects. The session will involve case studies and practical demos using Team Foundation Server and SQL Server 2012’s BI tools - SSIS, SSRS, SSAS (tabular) and Excel PowerPivot.

Speaker(s):

Mohamed Kabiruddin

Track and Room: BI Reporting (3031) - N/A

Title: Fundamentals of Join Operations

Abstract: This is a wonderful session for those that don’t yet grok the three types of joins available to the SQL Server engine or the scenarios for which each join type is optimal. All will be explained here with some very slick visual demonstrations of internal data flow as well as TSQL code samples. We will also show how bad performance can get when suboptimal joins are used.

Speaker(s):

Kevin Boles

Track and Room: DEV Programming (1052) - N/A

Title: Self-Service Visualization with Power View

Abstract: In this session I will give a brief history of Self-Service Visualization and some tools out there today that facilitate it. I will then introduce Power View and the two ways it can be used; SharePoint 2010 (or 2013) and now Excel 2013. I will then cover what sources can be used to create a Power View report then jump into a demo and create a few visualizations from a blank canvas to demonstrate how easy, yet powerful this visualization tool really is. I will also show the SSAS Tabular model that houses the data for the Power View reports and will enhance it as part of the session to make Power View shine.

Speaker(s):

Anthony Sammartino

Track and Room: Self Service BI (3034) - N/A

Title: SQL Server 2012 AlwaysOn for HA and DR

Abstract: This presentation will focus on the concepts behind AlwaysOn Availability Groups and new improvements to Failover Clusters, benefits it provides, and a demo of setting up AlwaysOn Availability groups

Speaker(s):

Chad Churchwell

Track and Room: DBA Track SQL2012 (1047) - N/A

Title: ETL Automation Using SSIS

Abstract: On this session you will learn how to find patterns and generic processes to create an ETL framework to automate the most common task within your organization using SSIS, from metadata driven package execution to ETL tracking of file loading processes.

Speaker(s):

Jorge Novo

Track and Room: BI Track (3030) - N/A

Title: How to be a GREAT DBA

Abstract: This presentation describes the tasks a DBA needs to perform to do a great job. Formal training classes and certifications only take you so far; this session talks from experience about everything from preventive maintenance to planning to scaling to communication.

Great for beginner to intermediate DBAs, as well as Developers who think this is a direction in which they might want to move.

Speaker(s):

Jeffrey Garbus

Track and Room: Auditorium (1124) - 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: Business Analytics (3033) - N/A

Title: Indexing for performance

Abstract: Learn all you wanted to know about index design but were afraid to ask. This session focuses on physical index structures as well as how the server chooses indexes. Note: Join optimization is a separate session

Speaker(s):

Jeffrey Garbus

Track and Room: DBA Performance (1054) - N/A

Title: A Big Data Primer

Abstract: The term “big data” dominates the headlines in technology news these days, but what is the fuss really all about? What are the implications for traditional data warehousing and reporting? What kind of technology and skill sets do you need to successfully implement to a big data strategy? Come to this session for a gentle, business-focused introduction to big data and leave with some inspiration and practical steps for tackling your first big data project.

Speaker(s):

Stacia Varga

Track and Room: Self Service BI (3034) - N/A

Title: Best Practice Data Visualization

Abstract: This fun and informative session covers best practices for data visualization and even infographics using Microsoft BI: Excel, Power View, the Office 2013 Web Apps Framework, Reporting Services, Visio and other open source and third-party data visualizations.

Speaker(s):

Jen Underwood

Track and Room: BI Track (3030) - N/A

Title: SSIS Programming using .Net

Abstract: Learn how to create metadata driven SSIS Packages using .NET code. Create a complex or simple framework to generate SSIS templates for custom configurations and automate most ETL processes. Traverse, modify and audit your current SSIS packages.

Speaker(s):

Jorge Novo

Track and Room: Database Developers (1049) - 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: BI Reporting (3031) - N/A

Title: Wrangling performance with Resource Governor

Abstract: In this introductory session we’ll delve into the basics of the resource governor feature in SQL Server. We’ll look at the types of issues this feature can help resolve. We’ll then delve into various components of the feature, such as a classifier function, workload groups and resource pools. Finally we’ll bring all this together with an example implementation. From there, if time allows, we’ll look at best practices and questions to answer to ensure a successful implementation.

Speaker(s):

Brandon Leach

Track and Room: DBA Performance (1054) - N/A

Title: Dashboard Do’s and Don’ts

Abstract: SharePoint makes it easy for users to create their own dashboards but there’s more to dashboards than just fast and easy set-up. This session will explore not only the characteristics of an effective BI dashboard using SharePoint 2013, but also the design flaws to avoid. Attend this session and learn how to perform a dashboard makeover. Starting with a review of a dashboard that uses technology correctly but not as effectively as it could, you’ll explore common problems found in dashboards, learn the characteristics of good dashboard design and discover how to implement a dashboard that communicates information clearly and concisely.

Speaker(s):

Stacia Varga

Track and Room: Business Analytics (3033) - N/A

Title: Keynote - Women in Technology Panel

Abstract: In this session we’ll start the day by a Welcome from Nova’s Associate Dean of Information Tecnology followed by a Women in Technology panel discussion with prominent IT women from our community at large, among them we have Jen Underwood and Lesley Frohman, in which we’ll be talking about “How it is to be a woman in IT today” and how we can attract and retain more women in this field. Diana Betancourt will be moderating this discussion with a guided Q/A format with interaction from our audience.

Speaker(s):

Diana Betancourt

Track and Room: Auditorium (1124) - 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.

John Welch

Twitter: - @john_welch

LinkedIn: John Welch

Contact: http://agilebi.com/jwelch

John Welch joined SentryOne in spring 2018 as VP of Engineering with the acquisition by SentryOne of the software division of Pragmatic Works. John leads the development of a suite of products that make developing, managing, and documenting data solutions easier. John has been successfully delivering IT solutions to business problems since 1994, and has been focused on business intelligence and data warehousing technologies since 2001. He is a Microsoft Most Valued Professional (MVP), and a frequent presenter on SQL Server and data topics. He also contributes to several open source projects and community initiatives targeted toward making data professionals work more productive.

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

John Welch

Twitter: - @john_welch

LinkedIn: John Welch

Contact: http://agilebi.com/jwelch

David Dye

James McAuliffe

LinkedIn: James McAuliffe

James McAuliffe is a Cloud Solution Architect with CCG Analytics, a Microsoft Gold Partner. He is also a Microsoft Preferred Partner Solutions expert and has been worked with clients of all sizes, from local businesses to Fortune 500 companies. Today’s mix of Big Data and cloud offerings make yesterday’s dream today’s possibility. Let’s talk about it!

Gareth Swanepoel

Twitter: - @GarethSwan

Contact: http://mygareth.com

Gareth Swanepoel is a sysadmin-turned-SQL Server DBA. He has been working in the IT industry doing support and administration for over 25 years. He enjoys solving the complex problems that customers encounter when performance tuning SQL Server or when deploying SQL Server in large data warehouse environments. He is originally from South Africa and is currently a Dedicated Support Engineer (PFE) with Microsoft. He is a passionate member of the SQL Server community and is an accomplished author and speaker having presented at various user groups, SQLSaturdays, the PASS Summit and other technical conferences.

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;

John Welch

Twitter: - @john_welch

LinkedIn: John Welch

Contact: http://agilebi.com/jwelch

Rafael Salas

Twitter: - @RafSalas

Contact: http://www.rafael-salas.com

Rafael Salas is a recognized speaker and published author with more than 17 years of experience in business intelligence and information architecture. He is the recipient of multiple industry recognition, including the Microsoft MVP Award and The Data Warehouse Institute Best Practices Award. Rafael is also an active member of the SQL Server technical community and blogs regularly at www.rafael-salas.com.

David Dye

Frank Quintana

Twitter: - Frankqr2

LinkedIn: Frank Quintana

Contact: http://www.businessintelligencematters.us

Doctor Quintana has been involved in optimization and math modeling since the ’80s. He is an IT University professor of Data Science, Databases, Data Mining, and Knowledge Discovery. He is a former head of an RD department. He worked as a research engineer at the Memorial University of Newfoundland. He also worked as a consultant in the role of a technical team leader and software architect for EDS responsible for critical parts of the SDLC for multi-million dollar projects. He is one of the Software Architects that designed and built the “Health and Benefits System for the of the Veteran Affairs of Canada” He is a regular speaker at national and international events In 2004 he started his consulting practice in South and Central Flori

Gareth Swanepoel

Twitter: - @GarethSwan

Contact: http://mygareth.com

Maximo Trinidad

Twitter: - maxtrinidad

LinkedIn: Maximo Trinidad

Contact: http://www.maxtblog.com

Maximo Trinidad (Florida Aka – Mr. PowerShell), currently work as a SAPIEN Technologies Evangelist and specialing in scripting automation on SQL Server Microsoft Cloud Technologies. Also a Microsoft MVP (PowerShell) since 2009 and active speaker since 2007 participating at SQLSaturday, IT Pro .NET Code Camps events.

Luis Figueroa

Contact: http://blog.extremebi.net

Luis Figueroa is an IT professional focused on delivering business solutions that leverage the Microsoft SQL Server platform. His area of expertise is Data Warehousing and Business Intelligence but he is passionate about all things SQL Server. With 10+ years of experience in the IT field, Luis has delivered data management solutions for companies in the Security, Online Marketing and Healthcare Industries. He is also the chapter leader of the MS BI user group of South Florida.

Sios Technology and Allan Hirt

Contact: http://www.sqlha.com

Cluster MVP Allan Hirt is a consultant, published author, speaker, and trainer who has been using Microsoft SQL Server in various guises since 1992. He is currently based in the Boston, MA, area and travels all over the world to work with and train clients. His most recent book is “Pro SQL Server 2008 Failover Clustering” (Apress) and is currently working on its sequel, Mission Critical SQL Server due in 2014.

Mohamed Kabiruddin

Twitter: - mdkabir

LinkedIn: Mohamed Kabiruddin

Contact: http://www.nobrainerlab.com

Mohamed is a Cloud Solutions Architect with extensive experience in designing BI / Data Analytics solutions with expertise in analysis, design, modelling and implementation. He is a keen data enthusiast with a flair for managing and consolidating data.

Anthony Sammartino

Twitter: - @SQLAnt

LinkedIn: Anthony Sammartino

Contact: http://www.sqlant.me

Kendal Van Dyke

Twitter: - SQLDBA

LinkedIn: Kendal Van Dyke

Contact: http://www.kendalvandyke.com

Kendal is a database strategist, community advocate, public speaker, and blogger. A practiced IT professional with over 15 years of SQL Server experience, Kendal excels at disaster recovery, high availability planning/implementation, amp; debugging/troubleshooting mission critical SQL Server environments. Kendal is a Senior Consultant on the Microsoft Premier Developer Support team and President of MagicPASS (http://magicpass.sqlpass.org), the Orlando, FL based chapter of PASS. Before joining Microsoft, Kendal was a SQL Server/Data Platform MVP from 2011-2016.

Anthony Sammartino

Twitter: - @SQLAnt

LinkedIn: Anthony Sammartino

Contact: http://www.sqlant.me

Sam Mesel

will be provided later on

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.

Jeffrey Garbus

LinkedIn: Jeffrey Garbus

Contact: http://mssqlperformance.blogspot.com/

Jeff has been consulting on and performing technical training for MS SQL Server since 1989, Version 4, on OS/2. Since then, he has worked extensively with each release of the product, specializing in performance and tuning, from concept through legacy system, on systems of all sizes, from small start-up company applications to multi-terabyte data warehouses.

In addition to hands-on consulting, he speaks at SQLSaturdays several times/year, has a youtube channel with free training, and has written 20 books on database management systems.

His latest book is “Transact SQL the Definitive Guide.”

Chad Churchwell

Twitter: - @chadchurchwell

LinkedIn: Chad Churchwell

Contact: http://www.sqlchad.com

Brandon Leach

Twitter: - SQLServerNerd

LinkedIn: Brandon Leach

A Microsoft Data Platform MVP, Brandon manages the DB Operations team for financial company x. With a data estate of several petabytes, he puts a high focus on performance tuning and automation. He is a frequent speaker at events like conferences and user groups.

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.

Maximo Trinidad

Twitter: - maxtrinidad

LinkedIn: Maximo Trinidad

Contact: http://www.maxtblog.com

Kendal Van Dyke

Twitter: - SQLDBA

LinkedIn: Kendal Van Dyke

Contact: http://www.kendalvandyke.com

Stacia Varga

Twitter: - @StaciaV

LinkedIn: Stacia Varga

Contact: http://blog.datainspirations.com

Stacia Varga is a Microsoft Data Platform MVP and SSAS Maestro with a Bachelor’s Degree in Social Sciences. A consultant, educator, author, and principal of Data Inspirations, her career spans more than 30 years, with a focus on improving business practices through technology.

Since 2000, Stacia has provided consulting and education services for Microsoft’s Business Intelligence technologies. As Stacia Misner, she also authored several books covering the Microsoft BI stack.

Brandon Leach

Twitter: - SQLServerNerd

LinkedIn: Brandon Leach

Kevin Boles

Twitter: - @TheSQLGuru

LinkedIn: Kevin Boles

Michael Antonovich

Twitter: - @SharePointMikeA

LinkedIn: Michael Antonovich

Contact: http://sharepointmike.wordpress.com

Michael Antonovich is the assistant director of Web and Technology Services in the Communications Division for Orange County Public Schools in Orlando, FL, where he manages the Internet and intranet infrastructure. He has published seven books, ranging from an Apple II User Guide to Office and SharePoint 2010 User’s Guide. His blog has focused mainly on PowerPivot and Power BI, but for the last year Mike has taken a break to pursue some other activities. He hopes to restart his blog later this year focusing more on style and presentation. Mike has used SQL Server since 1998 and, for the past 7 years, has been promoting SSAS, PowerPivot, and Power BI for the masses.

Mark Tabladillo

Twitter: - https://twitter.com/MarkTabNet

LinkedIn: Mark Tabladillo

Contact: http://marktab.net

Mark Tabladillo Ph.D. works for Microsoft as a Cloud Solution Architect for the US CTO Customer Success Team. He has a science doctorate from Georgia Tech. Based in Atlanta, GA, Mark provides cloud enterprise solutions for companies in the US for Microsoft’s strategic clients. He is a chapter leader for the PASS Data Science virtual chapter.

Mark Tabladillo

Twitter: - https://twitter.com/MarkTabNet

LinkedIn: Mark Tabladillo

Contact: http://marktab.net

David Bermingham

Twitter: - https://twitter.com/daveberm

LinkedIn: David Bermingham

Contact: http://clusteringformeremortals.com/

David Bermingham is recognized within the community as a high availability expert and has been honored by his peers by being elected to be a MVP in Clustering since 2010 and most recently has been recognized as a Cloud and Datacenter MVP. David’s work as technical evangelist at SIOS has him focused on evangelizing Microsoft high availability and disaster recovery solutions for both on premise and cloud deployments. He lives in New Jersey with his wife and three kids where he a school board member, scout leader and musical director of an 8-piece jazz band, M-Town.

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.

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.

Jeffrey Garbus

LinkedIn: Jeffrey Garbus

Contact: http://mssqlperformance.blogspot.com/

In addition to hands-on consulting, he speaks at SQLSaturdays several times/year, has a youtube channel with free training, and has written 20 books on database management systems.

His latest book is “Transact SQL the Definitive Guide.”

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.

Christopher Price

Contact: http://bluewatersql.wordpress.com/

Richie Rump

Twitter: - @jorriss

LinkedIn: Richie Rump

Contact: http://jorriss.net

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).

Jim Murphy

Twitter: - http://www.twitter.com/sqlmurph

LinkedIn: Jim Murphy

Contact: http://sqlwatchmen.com/blogs/jim/

Jim Murphy has been using Microsoft SQL Server since version 6.0 back in the 90#39;s. He is the CEO of SQLWatchmen, LLC., a managed DBA service provider. He runs the Austin SQL Server User Group: CACTUSS Central. He has been a professional DBA and developer for over 25 years and has run a consulting company full time since 2001.

Stacia Varga

Twitter: - @StaciaV

LinkedIn: Stacia Varga

Contact: http://blog.datainspirations.com

Herve Roggero

Twitter: - @hroggero

Contact: http://geekswithblogs.net/hroggero

Herve Roggero, Microsoft Azure MVP, is the founder of Enzo Unified (www.enzounified.com). Herve’s experience includes software development, architecture, database administration and senior management with both global corporations and startup companies. He holds multiple certifications, including an MCDBA, MCSE, MCSD. He is a Pluralsight author, runs the Azure Florida Association, and co-authored two Azure book with Apress.

Michael Antonovich

Twitter: - @SharePointMikeA

LinkedIn: Michael Antonovich

Contact: http://sharepointmike.wordpress.com

Jen Underwood

Twitter: - @idigdata

LinkedIn: Jen Underwood

Contact: http://www.impactanalytix.com/

Jen Underwood, a Senior Director at DataRobot, has held worldwide analytics product management roles at Microsoft and served as a technical lead for system implementation firms. She has over 20 years of experience launching new products and turning around failed projects in enterprise data warehousing, reporting, and advanced analytics. Today she designs product and helps analytics professionals learn how to solve complex problems with machine learning in the emerging citizen data science segment.

Jen has a Bachelor of Business Administration – Marketing, Cum Laude from the University of Wisconsin, Milwaukee and a post-graduate certificate in Computer Science – Data Mining from the University of California, San Diego.

Jorge Novo

Contact: http://etldevelopernotes.blogspot.com/

Diana Betancourt

Twitter: - dianabeta

LinkedIn: Diana Betancourt

Former graduate of the quot;Universidad Santa Maria La Antiguaquot; School of Computer Science. I have been involved in the IT world since 1992, since then I have been working with many OS platforms, development languages and databases, among them Unix, Oracle, SUN, Informix, FoxPro, Microsoft SQL Server, just to mention a few. Diana enjoys solving complex performance tuning issues, examining your data using Databricks, designing in Azure SQL Datawarehouse, developing cool visuals using Power Bi, or evangelizing about Microsoft Data technologies at community events like SQLSaturday and local user group meetings.

Mark Tabladillo

Twitter: - https://twitter.com/MarkTabNet

LinkedIn: Mark Tabladillo

Contact: http://marktab.net

SQLSaturday #226 - South Florida 2013

Sessions

Title: Into the Wild,Taming Unstructured Data

Title: SSAS Tabular and PowerPivot - Choose Your Own Adve

Title: Changing Data Is Easy, Managing Data Change is Hard!

Title: Discover, Document, Diagnose Your Servers on Your Coffee Break

Title: Putting Quality Back Into Your Data Analysis

Title: Implementing a HIPAA Compliance Strategy with SQL Server

Title: Code Paradigms in BIDS

Title: SQL Server 2012 ColumnStore Indexes

Title: Building a SQL Server for Optimal Performance

Title: Introducing Cube World To Users From Flat Table Land

Title: Moving Big Data - SSIS, Pig, and Sqoop

Title: HDInsight: What’s all the Hadoopla about Big Data?

Title: Tuning Analysis Services Processing Performance

Title: Applied Enterprise Semantic Mining

Title: Building Your Own SQL Server Virtual Playground

Title: PowerShell Working with XML and SMO

Title: Unit Testing SSIS Packages

Title: Social Marketing 2013 for Microsoft Professionals

Title: Data Mining Innovation with SQL Server 2012

Title: AlwaysOn - Finally, A usable ‘mirror’!

Title: Whats New in T-SQL With SQL Server 2012

Title: A Balanced BI Approach (Self-Service Corporate)

Title: Introduction to SQL Server Replication

Title: TempDB under the hood

Title: Column Level Encryption

Title: SQL Server 2012 AlwaysOn Step-by-Step

Title: Dealing With Errors in SSIS 2012

Title: The T-SQL Features in SQL Server 2012 You Can’t Ignore

Title: Database Design Disasters: Common Mistakes Found in the Wild

Title: SQL Server 2012 IaaS and SQL Database In Depth

Title: SSIS - Integrating PowerShell in a ScriptTask component

Title: SQL Server 2012 Column Store Index

Title: Getting started with Master Data Services 2012

Title: High Performance SANLess Clustering

Title: Agile BI with SQL Server 2012 and TFS 2012

Title: Fundamentals of Join Operations

Title: Self-Service Visualization with Power View

Title: SQL Server 2012 AlwaysOn for HA and DR

Title: ETL Automation Using SSIS

Title: How to be a GREAT DBA

Title: MDS in Practice: An Integrated Approach

Title: Indexing for performance

Title: A Big Data Primer

Title: Best Practice Data Visualization

Title: SSIS Programming using .Net

Title: Exploring The Microsoft Reporting Technologies

Title: Wrangling performance with Resource Governor

Title: Dashboard Do’s and Don’ts

Title: Keynote - Women in Technology Panel

Speakers

Sponsors