Nr: 289
SQLSaturday #289 - Orange County, CA 2014
SessionID: 10153
Trimming Indexes Getting Your Database In Shape
Event Date: 26-04-2014 - Session time: 00:00:00 - Track: Track 1
Speaker: Bradley Ball
Title: Trimming Indexes Getting Your Database In Shape
Abstract:
Indexes are a wonderful thing. We should be using them, and we should be maintaining them. But over time our production databases start to look a little pudgy around the mid-section. Maybe they are a little bloated with Unused Indexes, maybe they have Duplicate Indexes, and possibly even Reverse Indexes. The first step to fixing these problems it so see if you have them, and if you do the second is to set about fixing them. You could be costing yourself CPU cycles, I/Op’s, and space and never even know it.
SessionID: 10155
SQL Server 2014: A First Look at What’s New!
Event Date: 26-04-2014 - Session time: 00:00:00 - Track: Track 1
Speaker: Bradley Ball
Title: SQL Server 2014: A First Look at What’s New!
Abstract:
Microsoft has announced that our next version of SQL Server will be SQL Server 2014. SQL Server 2012 had some major upgrades in AlwaysOn Availability Groups, ColumnStore Indexes, and Resource Governor. SQL 2014 takes those features to the next level and introduces a whole lot more! Rebuild Indexes and Statistics by Partition? Yes! A new Optimizer/Cardinality Estimator that you can choose for your Queries? Yes! Hekaton in memory data tables that exist separate to the buffer pool and use HASH indexes instead of B-TREE? YES! Plus SSD Buffer Pool Extensions, Read-Write ColumnStore Indexes and much more!
SessionID: 10352
Defeating the Limitations of the Query Optimizer
Event Date: 26-04-2014 - Session time: 00:00:00 - Track: Track 2
Speaker: Benjamin Nevarez
Title: Defeating the Limitations of the Query Optimizer
Abstract:
SessionID: 10353
Understanding Parameter Sniffing
Event Date: 26-04-2014 - Session time: 00:00:00 - Track: Track 4
Speaker: Benjamin Nevarez
Title: Understanding Parameter Sniffing
Abstract:
SessionID: 10709
Faster Leaner: Optimize DW Solution Delivery with Power Pivot and AS Tabular
Event Date: 26-04-2014 - Session time: 00:00:00 - Track: Track 4
Speaker: Brent Greenwood
Title: Faster Leaner: Optimize DW Solution Delivery with Power Pivot and AS Tabular
Abstract:
You may not see this in the marketing materials, but the reality is PowerPivot and AS Tabular together provide some powerful options for Data Warehousing professionals. This session is for DW dimensional modeling pros interested in streamlining optimizing the design delivery process for enterprise-quality data marts dimensional semantic models.
We'll touch on Agile Lean disciplines, how they can be applied to DW solution delivery. Then we’ll walk through demos of practical applications in the form of PowerPivot POCs prototypes that can be promoted to AS Tabular models and refitted to the finished DW structures once delivered. We’ll focus on key DW challenges and how these technologies and techniques can be used to speed and improve effectiveness of requirements gathering and user testing, optimize sequencing of deliverables, minimize risk of rework and ultimately deliver quality DW solutions successfully.
SessionID: 12141
SQL Server 2014 for Hybrid Cloud
Event Date: 26-04-2014 - Session time: 00:00:00 - Track: Track 7
Speaker: Dania Jones
Title: SQL Server 2014 for Hybrid Cloud
Abstract:
The cloud is here and Hybrid cloud can help you get started and move forward! Cloud computing brings a new paradigm shift in computing and organizations continue to realize the potential cost benefits of running their database applications in the cloud with greater scale and flexibility. Take almost any application scenario, from the largest public websites to small departmental applications, and you will find the vast majority of organizations look to take advantage of cloud computing, the availability of cloud-enabled database systems will be critical to their success. This session looks at the Microsoft vision of relational database management systems in the context of cloud computing. It is a hybrid IT vision that gains leverage from the industry-standard Microsoft SQL Server technology set and makes it available across the spectrum of deployment approaches organizations can take today.
SessionID: 12808
Turbo Charged SQL Development With SQL#
Event Date: 26-04-2014 - Session time: 00:00:00 - Track: Track 3
Speaker: David Sumlin
Title: Turbo Charged SQL Development With SQL#
Abstract:
Turbo charge your SQL Server development with the amazing SQL# CLR library. We will do a quick overview of the SQL# library and then jump into examining a few real world implementations of some of the functions and procedures. Some examples will include string manipulation, file handling, as well as some RegEx usage. There are over 225 procedures and functions, user defined aggregates, and user defined types ... and counting. Come explore some of the interesting problems that SQL# can solve. If you'd like to download and view the CLR library ahead of the presentation, you can get most of the CLR features for free at www.sqlsharp.com.
SessionID: 13418
SQL Server Security 101
Event Date: 26-04-2014 - Session time: 00:00:00 - Track: Track 6
Speaker: Diana Dee
Title: SQL Server Security 101
Abstract:
However, behind this simple statement lies much complexity. In practice, it is easy for the novice database administrator to get lost in the hierarchy of principals, securables and permissions that comprise the SQL Server security architecture. The most common result is the path of least resistance, where people end up with "too many privileges."
My primary goals are to provide a simple, concise description of how the SQL Server permission hierarchy works, and then demonstrate, step by step, how to implement the "Principle of Least Privilege" in securing SQL Server.
I will also mention security-related items that are new to SQL Server 2014.
SessionID: 15818
Advanced Spatial Analysis: Beyond Bubble Charts
Event Date: 26-04-2014 - Session time: 00:00:00 - Track: Track 3
Speaker: Jason Horner
Title: Advanced Spatial Analysis: Beyond Bubble Charts
Abstract:
Are you finally ready to unlock the power in your spatial data? In this session, we will explore some advanced spatial analysis techniques, including clustering, binning, and the basic use of spatial statistics. We will then discuss several options for visualizing the results in SQL Server Reporting Services and PowerPivot. Get ready to go beyond bars and bubble charts!
SessionID: 16328
Event Date: 26-04-2014 - Session time: 00:00:00 - Track: Track 6
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: 16331
How to be a GREAT DBA
Event Date: 26-04-2014 - Session time: 00:00:00 - Track: Track 6
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: 16811
AlwaysOn - Finally, A usable 'mirror'!
Event Date: 26-04-2014 - Session time: 00:00:00 - Track: Track 7
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: 16812
Event Date: 26-04-2014 - Session time: 00:00:00 - Track: Track 7
Speaker: Jim Murphy
Abstract:
SessionID: 16813
Event Date: 26-04-2014 - Session time: 00:00:00 - Track: Track 7
Speaker: Jim Murphy
Abstract:
SessionID: 17608
Huhadoop?
Event Date: 26-04-2014 - Session time: 00:00:00 - Track: Track 2
Speaker: Joe Rossi
Title: Huhadoop?
Abstract:
A session focused on ramping you up on what Hadoop is, how its works and what it's capable of. We will also look at what Hadoop 2.0 and YARN brings to the table and some future projects in the Hadoop space to keep an eye on.
SessionID: 17872
10 Things I Hate About Interviewing with You
Event Date: 26-04-2014 - Session time: 00:00:00 - Track: Track 4
Speaker: Karen Lopez
Title: 10 Things I Hate About Interviewing with You
Abstract:
Join Thomas LaRock and Karen Lopez for valuable interviewing tips from both sides of the desk. Based on Tom's blog posts of 10 Things I Hate About Interviewing You and 10 Things I Hate About Interviewing With You, this session will be packed with valuable insight and tips to help you sail through your next job interview
SessionID: 17874
Database Design Contentious Issues
Event Date: 26-04-2014 - Session time: 00:00:00 - Track: Track 1
Speaker: Karen Lopez
Title: Database Design Contentious Issues
Abstract:
A highly interactive and popular session where attendees evaluate the options and best practices of common and advanced design issues, such as: * Natural vs. Surrogate keys * NULL/NOTNULL * Classwords and other Naming Standards * Varchar Minimums *the CLOUD * Who Calls the Shots and Who Does What? ...and others. Bring your votes, your debates, and your opinions.
SessionID: 19243
Practical Big Data Solutions
Event Date: 26-04-2014 - Session time: 00:00:00 - Track: Track 2
Speaker: Lakshmi Randall
Title: Practical Big Data Solutions
Abstract:
Session Abstract:
The purpose of this presentation is to provide a practical checklist for planning your Big Data deployment. This session presents guidelines and architectural patterns for big data deployment options such as Cloud Vs. On-premise. My session objectives are:
•Provide a comprehensive approach to planning your Big Data Deployment
• Illustrate how to bring Big Data into the Enterprise Workflow
• Share a few real-world Big data deployment scenarios
SessionID: 19244
Under the hood of Power BI - Part I
Event Date: 26-04-2014 - Session time: 00:00:00 - Track: Track 2
Speaker: Lakshmi Randall
Title: Under the hood of Power BI - Part I
Abstract:
This session will cover the following aspects of Power BI
• Architecture overview of Power BI
• The Data Steward Experience
• The Analyst Experience
SessionID: 19245
Under the hood of Power BI - Part II
Event Date: 26-04-2014 - Session time: 00:00:00 - Track: Track 2
Speaker: Lakshmi Randall
Title: Under the hood of Power BI - Part II
Abstract:
This session will cover the following aspects of Power BI
• The IT Pro experience
• Practical solutions with Power BI
SessionID: 19753
The 10 Commandments of ETL
Event Date: 26-04-2014 - Session time: 00:00:00 - Track: Track 5
Speaker: Martin Schoombee
Title: The 10 Commandments of ETL
Abstract:
In this session I will share the 10 basic principles I follow when developing ETL processes, and also show how the different choices can affect performance. Following these simple guidelines have resulted in many successful projects and happy customers. I'm sure it will work for you too!!
SessionID: 19754
Designing and Loading Slowly Changing Dimensions
Event Date: 26-04-2014 - Session time: 00:00:00 - Track: Track 5
Speaker: Martin Schoombee
Title: Designing and Loading Slowly Changing Dimensions
Abstract:
The first part of this session takes a look at all the different design elements and considerations of SCD's. We'll look at whether it is feasible to create a snowflake, how to deal with relationships between dimensions as well as 1:1 and many:many relationships with fact tables.
Afterwards, we will walk through a practical and effective method (with code) to load SCD's with T-SQL.
SessionID: 20394
Creating SSRS Reports Efficiently Through Best Practices
Event Date: 26-04-2014 - Session time: 00:00:00 - Track: Track 3
Speaker: Mickey Stuewe
Title: Creating SSRS Reports Efficiently Through Best Practices
Abstract:
Reports don’t stop changing once they’re released into production, and some reports are phased out over time. Wouldn’t it be great to have a way to keep track of the changes a report takes on in production over time? We’ll talk about how to keep track of change requests, how to analyze the utilization of existing reports, and how to track changes in users for the reports in production.
SessionID: 20395
Event Date: 26-04-2014 - Session time: 00:00:00 - Track: Track 2
Speaker: Mickey Stuewe
Abstract:
SessionID: 21024
SQL Server's In Memory Database Objects
Event Date: 26-04-2014 - Session time: 00:00:00 - Track: Track 1
Speaker: Denny Cherry
Title: SQL Server's In Memory Database Objects
Abstract:
SQL Server 14 is continuing to expand on the in memory database features that were first introduced in SQL Server 2012. During this session we will explore the new in memory database tables which were developed under the code name project hekaton. During this presentation the scope of the feature will be discussed as well as reviewing the use cases and best practices for using in memory database tables and when the in memory database tables shouldn’t be used.
SessionID: 21027
Storage For the DBA
Event Date: 26-04-2014 - Session time: 00:00:00 - Track: Track 1
Speaker: Denny Cherry
Title: Storage For the DBA
Abstract:
SessionID: 22916
Battle of the Finch Bots
Event Date: 26-04-2014 - Session time: 00:00:00 - Track: Track 7
Speaker: Jeff Renz
Title: Battle of the Finch Bots
Abstract:
SQL Azure, Robots, and Twitter! In an ongoing battle our two finch robots DEV (represents developers) and DBA (represents DBAs) will compete against each other. You the audience will help determine the winner of the finch robot race by voting real time on twitter. Participants will leave with an understanding of how leverage SQL Azure to collect data, how robots can help children of all ages learn programming concepts and most importantly which finch robot will reign supreme… the DBA or Developer
SessionID: 23160
Column Store Index: Practical analytics on a relational database
Event Date: 26-04-2014 - Session time: 00:00:00 - Track: Track 5
Speaker: Robert Hatton
Title: Column Store Index: Practical analytics on a relational database
Abstract:
One dirty little secret of Business Intelligence is that relational databases just haven’t been fast enough to support ad hoc analysis with response times that end users expect. Column store indexes change all of that. Come learn how to build a lean BI solution or supercharge your existing system with minimal effort.
SessionID: 25147
Database Design: Size DOES Matter
Event Date: 26-04-2014 - Session time: 00:00:00 - Track: Track 1
Speaker: Thomas LaRock
Title: Database Design: Size DOES Matter
Abstract:
SessionID: 25793
Using PowerPivot to Drive Quality into ETL Processes
Event Date: 26-04-2014 - Session time: 00:00:00 - Track: Track 4
Speaker: Steve Hughes
Title: Using PowerPivot to Drive Quality into ETL Processes
Abstract:
Throughout the past year, we have effectively used PowerPivot, Data Explorer, and Power View to map, evaluate, and measure our ETL processes. In this session, you will learn how PowerPivot can be a key component in verifying data quality. You will also see how Data Explorer can help you shape data for test harnesses and test plans. Finally, you will see how Power View in Excel 2013 can be used to easily share results of ETL projects, especially during the development process.
SessionID: 25795
A Window into Your Data: Using SQL Window Function
Event Date: 26-04-2014 - Session time: 00:00:00 - Track: Track 4
Speaker: Steve Hughes
Title: A Window into Your Data: Using SQL Window Function
Abstract:
Window functions are an underused feature in T-SQL. These functions can help you solve complex business problems such as running totals and ranking. If you have never used these functions or are looking to solve ranking and aggregate types of calculations without using GROUP BY, join us for a demo filled session on SQL window functions.
SessionID: 26008
45 min to build your first SSRS report
Event Date: 26-04-2014 - Session time: 00:00:00 - Track: Track 7
Speaker: Tamera Clark
Title: 45 min to build your first SSRS report
Abstract:
Does this sound like you? You were just given access to SSRS and you want to make a report. Or, you're a DBA and could use a daily report. Either way, I've got your back! You will learn everything you need to know to get that first report out the door quickly and how to tweak it once it’s deployed. We’ll even look at the differences between building a report in BIDS (Business Intelligence Development Studio) and Report Builder 3.0. We’ll use SSRS (SQL Server Reporting Services) 2012. The query makes no difference, this time it's all about the output.
SessionID: 26571
Baseline, Like a Boss
Event Date: 26-04-2014 - Session time: 00:00:00 - Track: Track 4
Speaker: Tim Hidalgo
Title: Baseline, Like a Boss
Abstract:
SessionID: 27451
Testing with SSIS
Event Date: 26-04-2014 - Session time: 00:00:00 - Track: Track 6
Speaker: Virginia Mushkatbat
Title: Testing with SSIS
Abstract:
SessionID: 34668
Master Data Services - 4 Key Features in 60 Minutes
Event Date: 26-04-2014 - Session time: 00:00:00 - Track: Track 3
Speaker: John McAllister
Title: Master Data Services - 4 Key Features in 60 Minutes
Abstract:
SessionID: 34669
Master Data Management - Getting Started with SQL Server MDS
Event Date: 26-04-2014 - Session time: 00:00:00 - Track: Track 3
Speaker: John McAllister
Title: Master Data Management - Getting Started with SQL Server MDS
Abstract:
This session will provide an introduction to Master Data Management (MDM). We explore the basic concepts, types of MDM solution, and the basics for a successful MDM Implementation. With a working definition in hand, we'll discuss strategies for beginning a successful MDM pilot in your organization and look at some of the pitfalls to avoid. We'll wrap the business discussion up with some tips for selecting the right domains to solve and some tips for managing the politics of MDM.
After we've set the stage for what, how and why you need MDM, we'll take a brief look at SQL Server MDS through the Excel add-in and talk about the Architecture of MDS.
SessionID: 9083
Manageable SSAS Deployment Strategies
Event Date: 26-04-2014 - Session time: 00:00:00 - Track: Track 5
Speaker: Kerry Tyler
Title: Manageable SSAS Deployment Strategies
Abstract:
If you've answered "yes" to any of these questions, and are in search of a better way, I have the solution! In this demo-heavy session, we will look at five steps to more robust, controllable, and flexible Tabular and Multidimensional SSAS deployments.
SessionID: 9557
Powershell for the Enterprise
Event Date: 26-04-2014 - Session time: 00:00:00 - Track: Track 3
Speaker: Andrew Nakamura
Title: Powershell for the Enterprise
Abstract:
SessionID: 9845
New Job! New Environment! Where to Start!
Event Date: 26-04-2014 - Session time: 00:00:00 - Track: Track 5
Speaker: Thomas Norman
Title: New Job! New Environment! Where to Start!
Abstract:
SessionID: 9846
Converting Unreliable Deployments Into Consistent Releases
Event Date: 26-04-2014 - Session time: 00:00:00 - Track: Track 5
Speaker: Thomas Norman
Title: Converting Unreliable Deployments Into Consistent Releases
Abstract:
The deployment process is frustrating; an object is missing, an object is
deployed in the wrong order or the incorrect version. Each database is
made up of a lot of objects in different environments. When you create an
object like a table or stored procedure, you need to get this object deployed
into each environment. Together we will discover how to separate each
object for proper order deployment while releasing only objects which have
changed. Deployments can cause you trouble but we will provide a reliable
deployment and version control process.