Nr: 226
SQLSaturday #226 - South Florida 2013
SessionID: 10663
Event Date: 29-06-2013 - Session time: 00:00:00 - Track: DBA Performance (1054)
Speaker: Brandon Leach
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.
SessionID: 10664
Implementing a HIPAA Compliance Strategy with SQL Server
Event Date: 29-06-2013 - Session time: 00:00:00 - Track: DBA Auditing (1053)
Speaker: Brandon Leach
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.
SessionID: 11917
Into the Wild,Taming Unstructured Data
Event Date: 29-06-2013 - Session time: 00:00:00 - Track: DBA Performance (1054)
Speaker: Christopher Price
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.
SessionID: 11919
MDS in Practice: An Integrated Approach
Event Date: 29-06-2013 - Session time: 00:00:00 - Track: Business Analytics (3033)
Speaker: Christopher Price
Title: MDS in Practice: An Integrated Approach
Abstract:
SessionID: 12394
SQL Server 2012 AlwaysOn Step-by-Step
Event Date: 29-06-2013 - Session time: 00:00:00 - Track: DBA Track SQL2012 (1047)
Speaker: David Bermingham
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.
SessionID: 12415
Event Date: 29-06-2013 - Session time: 00:00:00 - Track: Auditorium (1124)
Speaker: Sios Technology and Allan Hirt
Abstract:
SessionID: 12944
Dealing With Errors in SSIS 2012
Event Date: 29-06-2013 - Session time: 00:00:00 - Track: BI Track (3030)
Speaker: David Dye
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.
SessionID: 12945
Whats New in T-SQL With SQL Server 2012
Event Date: 29-06-2013 - Session time: 00:00:00 - Track: DBA Track SQL2012 (1047)
Speaker: David Dye
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.
SessionID: 12947
Column Level Encryption
Event Date: 29-06-2013 - Session time: 00:00:00 - Track: DBA Auditing (1053)
Speaker: David Dye
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.
SessionID: 13248
Keynote - Women in Technology Panel
Event Date: 29-06-2013 - Session time: 00:00:00 - Track: Auditorium (1124)
Speaker: Diana Betancourt
Title: Keynote - Women in Technology Panel
Abstract:
Diana Betancourt will be moderating this discussion with a guided Q/A format with interaction from our audience.
SessionID: 13380
Exploring The Microsoft Reporting Technologies
Event Date: 29-06-2013 - Session time: 00:00:00 - Track: BI Reporting (3031)
Speaker: David Ortiz
Title: Exploring The Microsoft Reporting Technologies
Abstract:
SessionID: 14312
Code Paradigms in BIDS
Event Date: 29-06-2013 - Session time: 00:00:00 - Track: DEV Programming (1052)
Speaker: Frank Quintana
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.
SessionID: 15022
SQL Server 2012 IaaS and SQL Database In Depth
Event Date: 29-06-2013 - Session time: 00:00:00 - Track: Database Developers (1049)
Speaker: Herve Roggero
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.
SessionID: 16317
How to be a GREAT DBA
Event Date: 29-06-2013 - Session time: 00:00:00 - Track: Auditorium (1124)
Speaker: Jeffrey Garbus
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.
SessionID: 16319
Event Date: 29-06-2013 - Session time: 00:00:00 - Track: DBA Performance (1054)
Speaker: Jeffrey Garbus
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
SessionID: 16513
Best Practice Data Visualization
Event Date: 29-06-2013 - Session time: 00:00:00 - Track: BI Track (3030)
Speaker: Jen Underwood
Title: Best Practice Data Visualization
Abstract:
SessionID: 16804
AlwaysOn - Finally, A usable 'mirror'!
Event Date: 29-06-2013 - Session time: 00:00:00 - Track: DBA Track (1048)
Speaker: Jim Murphy
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.
SessionID: 16974
Changing Data Is Easy, Managing Data Change is Hard!
Event Date: 29-06-2013 - Session time: 00:00:00 - Track: Business Analytics (3033)
Speaker: James McAuliffe
Title: Changing Data Is Easy, Managing Data Change is Hard!
Abstract:
SessionID: 17196
Moving Big Data - SSIS, Pig, and Sqoop
Event Date: 29-06-2013 - Session time: 00:00:00 - Track: DEV Programming (1052)
Speaker: John Welch
Title: Moving Big Data - SSIS, Pig, and Sqoop
Abstract:
SessionID: 17197
Unit Testing SSIS Packages
Event Date: 29-06-2013 - Session time: 00:00:00 - Track: DEV Programming (1052)
Speaker: John Welch
Title: Unit Testing SSIS Packages
Abstract:
SessionID: 17198
Event Date: 29-06-2013 - Session time: 00:00:00 - Track: DBA Performance (1054)
Speaker: John Welch
Abstract:
SessionID: 17359
SSIS Programming using .Net
Event Date: 29-06-2013 - Session time: 00:00:00 - Track: Database Developers (1049)
Speaker: Jorge Novo
Title: SSIS Programming using .Net
Abstract:
SessionID: 17363
ETL Automation Using SSIS
Event Date: 29-06-2013 - Session time: 00:00:00 - Track: BI Track (3030)
Speaker: Jorge Novo
Title: ETL Automation Using SSIS
Abstract:
SessionID: 17438
The T-SQL Features in SQL Server 2012 You Can't Ignore
Event Date: 29-06-2013 - Session time: 00:00:00 - Track: Database Developers (1049)
Speaker: Richie Rump
Title: The T-SQL Features in SQL Server 2012 You Can't Ignore
Abstract:
SessionID: 17439
Database Design Disasters: Common Mistakes Found in the Wild
Event Date: 29-06-2013 - Session time: 00:00:00 - Track: Database Developers (1049)
Speaker: Richie Rump
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.
SessionID: 18060
Discover, Document, Diagnose Your Servers on Your Coffee Break
Event Date: 29-06-2013 - Session time: 00:00:00 - Track: DBA Auditing (1053)
Speaker: Kendal Van Dyke
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
SessionID: 18061
Building Your Own SQL Server Virtual Playground
Event Date: 29-06-2013 - Session time: 00:00:00 - Track: DBA Auditing (1053)
Speaker: Kendal Van Dyke
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.
SessionID: 18988
Getting started with Master Data Services 2012
Event Date: 29-06-2013 - Session time: 00:00:00 - Track: BI Reporting (3031)
Speaker: Luis Figueroa
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.
SessionID: 19892
PowerShell Working with XML and SMO
Event Date: 29-06-2013 - Session time: 00:00:00 - Track: DBA Track (1048)
Speaker: Maximo Trinidad
Title: PowerShell Working with XML and SMO
Abstract:
SessionID: 19893
SSIS - Integrating PowerShell in a ScriptTask component
Event Date: 29-06-2013 - Session time: 00:00:00 - Track: BI Track (3030)
Speaker: Maximo Trinidad
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.
SessionID: 20016
Agile BI with SQL Server 2012 and TFS 2012
Event Date: 29-06-2013 - Session time: 00:00:00 - Track: BI Reporting (3031)
Speaker: Mohamed Kabiruddin
Title: Agile BI with SQL Server 2012 and TFS 2012
Abstract:
SessionID: 20032
SQL Server 2012 ColumnStore Indexes
Event Date: 29-06-2013 - Session time: 00:00:00 - Track: DBA Track (1048)
Speaker: Gareth Swanepoel
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.
SessionID: 20033
Event Date: 29-06-2013 - Session time: 00:00:00 - Track: DBA Performance (1054)
Speaker: Gareth Swanepoel
Abstract:
SessionID: 20486
Introducing Cube World To Users From Flat Table Land
Event Date: 29-06-2013 - Session time: 00:00:00 - Track: Business Dev (3032)
Speaker: Michael Antonovich
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.
SessionID: 20487
Putting Quality Back Into Your Data Analysis
Event Date: 29-06-2013 - Session time: 00:00:00 - Track: Business Dev (3032)
Speaker: Michael Antonovich
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.
SessionID: 22958
HDInsight: What’s all the Hadoopla about Big Data?
Event Date: 29-06-2013 - Session time: 00:00:00 - Track: Self Service BI (3034)
Speaker: Rafael Salas
Title: HDInsight: What’s all the Hadoopla about Big Data?
Abstract:
SessionID: 23891
TempDB under the hood
Event Date: 29-06-2013 - Session time: 00:00:00 - Track: DBA Track (1048)
Speaker: Sam Mesel
Title: TempDB under the hood
Abstract:
SessionID: 24690
A Big Data Primer
Event Date: 29-06-2013 - Session time: 00:00:00 - Track: Self Service BI (3034)
Speaker: Stacia Varga
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.
SessionID: 24691
Dashboard Do's and Don'ts
Event Date: 29-06-2013 - Session time: 00:00:00 - Track: Business Analytics (3033)
Speaker: Stacia Varga
Title: Dashboard Do's and Don'ts
Abstract:
SessionID: 24920
SQL Server 2012 AlwaysOn for HA and DR
Event Date: 29-06-2013 - Session time: 00:00:00 - Track: DBA Track SQL2012 (1047)
Speaker: Chad Churchwell
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
SessionID: 24921
Introduction to SQL Server Replication
Event Date: 29-06-2013 - Session time: 00:00:00 - Track: DBA Auditing (1053)
Speaker: Chad Churchwell
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.
SessionID: 26155
SQL Server 2012 Column Store Index
Event Date: 29-06-2013 - Session time: 00:00:00 - Track: DBA Track SQL2012 (1047)
Speaker: Kevin Boles
Title: SQL Server 2012 Column Store Index
Abstract:
SessionID: 26156
Fundamentals of Join Operations
Event Date: 29-06-2013 - Session time: 00:00:00 - Track: DEV Programming (1052)
Speaker: Kevin Boles
Title: Fundamentals of Join Operations
Abstract:
SessionID: 34714
Social Marketing 2013 for Microsoft Professionals
Event Date: 29-06-2013 - Session time: 00:00:00 - Track: Business Dev (3032)
Speaker: Mark Tabladillo
Title: Social Marketing 2013 for Microsoft Professionals
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.
SessionID: 34715
Applied Enterprise Semantic Mining
Event Date: 29-06-2013 - Session time: 00:00:00 - Track: BI Reporting (3031)
Speaker: Mark Tabladillo
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.
SessionID: 34717
Data Mining Innovation with SQL Server 2012
Event Date: 29-06-2013 - Session time: 00:00:00 - Track: BI Track (3030)
Speaker: Mark Tabladillo
Title: Data Mining Innovation with SQL Server 2012
Abstract:
SessionID: 9903
SSAS Tabular and PowerPivot - Choose Your Own Adve
Event Date: 29-06-2013 - Session time: 00:00:00 - Track: Business Analytics (3033)
Speaker: Anthony Sammartino
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.
SessionID: 9904
Self-Service Visualization with Power View
Event Date: 29-06-2013 - Session time: 00:00:00 - Track: Self Service BI (3034)
Speaker: Anthony Sammartino
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.
SessionID: 9905
A Balanced BI Approach (Self-Service Corporate)
Event Date: 29-06-2013 - Session time: 00:00:00 - Track: Self Service BI (3034)
Speaker: Anthony Sammartino
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.