sqlsathistory

Nr: 399

SQLSaturday #399 - Sacramento 2015

Start Time (24h)	Speaker	Track	Title
00:00:00	Ben Miller	DB Developer	SQL Server Encryption
00:00:00	Paul Turley	Business Intelligence	Tabular Models: Easier Faster Than Cubes; Really?
00:00:00	Andy Galbraith	Database Administrator	Performing a SQL Server Health Check
00:00:00	Andy Galbraith	Database Administrator	Are You Maintaining Your SQL Servers?
07:30:00	Mitchell Bottel	Non-Session	Registration
07:30:00	Mitchell Bottel	Non-Session	Event Registration
08:30:00	Andrew Eichenbaum	Professional Development	Big Data Data Science, How to Get Past the Hype and Into a Team
08:30:00	Prakash Heda	Database Administrator	Standardized SQL Installations – Script Review Demo
08:30:00	Michael Fal	Other	Powershell Tips and Tricks for SQL Server Administration
08:30:00	Eric Bragas	Business Intelligence	Automating Power BI Creations
08:30:00	Andy Galbraith	Database Administrator	Getting Started with Extended Events
09:45:00	Chris Hyde	Professional Development	Becoming Certified In Microsoft SQL Server
09:45:00	Deji Akomolafe	Other	Successfully Virtualizing SQL Server on vSphere - Straight from the Source
09:45:00	John McAllister	DB Developer	Master Data Management - Getting Started with SQL Server MDS
09:45:00	Mitchell Bottel	Database Administrator	Everything SQL Server - Lightning Talks with Sacramento SQL UG
09:45:00	Tom Keller	Business Intelligence	Best Practices for Excel Pivot Tables
11:00:00	Ben Miller	DB Developer	TSQL Best Practices for SQL Engine Kindness
11:00:00	Benjamin Nevarez	Professional Development	Query Processing in In-Memory OLTP (Hekaton)
11:00:00	Eric Courville	Other	Intro to PowerShell by example
11:00:00	Jonathan Shaulis	Database Administrator	Introduction to Wait Types and Response Time Analysis
11:00:00	Peter Myers	Business Intelligence	Big Data Analytics with Excel
12:00:00	Mitchell Bottel	Non-Session	Lunch Sessions
12:15:00	SQLSAT399 Sponsor	Lunch	Dell: How SharePlex Replicates from Oracle to SQL Server 8 Other Targets
12:15:00	SQLSAT399 Sponsor	Lunch	Microsoft
12:15:00	SQLSAT399 Sponsor	Lunch	Micron: Choosing the Right SSD for Your Application
12:15:00	SQLSAT399 Sponsor	Lunch	Tegile
12:15:00	SQLSAT399 Sponsor	Lunch	Profisee: Accelerate SQL Server Master Data Services with Profisee Maestro
13:45:00	Keith Tate	Database Administrator	SQL Server Backups and Restores A to Z
13:45:00	Ted Stathakis	Business Intelligence	Getting Started with Reporting Services
13:45:00	Kalen Delaney	Database Administrator	Are You Optimistic About Concurrency?
13:45:00	Peter Myers	Other	Azure Machine Learning: From Design to Integration
13:45:00	Pravina Parthasarthy	Business Intelligence	SSAS: Zero to Cube in Sixty Minutes
15:00:00	Robert Davis	Other	SQL Server Mythconceptions and Mythteries
15:00:00	Mickey Stuewe	Business Intelligence	Techniques for Dynamic SSRS Reports
15:00:00	Ted Stathakis	Business Intelligence	Take your Reporting Services Implementation to a New Level
15:00:00	Brandon Leach	Database Administrator	Data Pages, Allocation Units, IAM chains... Oh My!
15:00:00	Michael Fal	Other	Powershell and the Art of SQL Server Deployment
16:15:00	Bert Scalzo	Other	Flash Disk Alternatives for SQL Server Databases
16:15:00	Robert Davis	Database Administrator	Diagnosing Performance with Wait Statistics
16:15:00	Paul Turley	Business Intelligence	Power BI Hands-On Micro-Workshop
16:15:00	Ami Levin	DB Developer	Physical Join Operators
16:15:00	Eric Freeman	DB Developer	CTE's and Recursion in T-SQL
17:30:00	Mitchell Bottel	Non-Session	Raffle

SessionID: 10298

SQL Server Encryption

Back to calendar

Event Date: 25-07-2015 - Session time: 00:00:00 - Track: DB Developer

Speaker: Ben Miller

Title: SQL Server Encryption

Abstract:

What encryption is available in your version of SQL Server? This session will cover how to set up the Encryption Hierarchy and the requirements for the new Backup with Encryption in SQL 2014. We will also cover end to end Transparent Database Encryption (TDE). This session will go over all the steps and caveats that go with this technology. Encryption is here to stay so jump on and let's take it for a ride.

SessionID: 21871

Tabular Models: Easier Faster Than Cubes; Really?

Back to calendar

Event Date: 25-07-2015 - Session time: 00:00:00 - Track: Business Intelligence

Speaker: Paul Turley

Title: Tabular Models: Easier Faster Than Cubes; Really?

Abstract:

The future of data analysis is the new, in-memory xVelocity Tabular analytic engine but is this new product ready for enterprise solutions? Is it easier to build Tabular models than multidimensional cubes in SQL Server 2012? Maybe… It depends on what you need to do. Is it faster? Heck, yea. Taking off the Microsoft BI marketing hat, let’s take a tabular journey together and learn some lessons from the first generation of real, enterprise-scale solutions: The Good, the Bad, the Ugly and the Beautiful.

SessionID: 9625

Performing a SQL Server Health Check

Back to calendar

Event Date: 25-07-2015 - Session time: 00:00:00 - Track: Database Administrator

Speaker: Andy Galbraith

Title: Performing a SQL Server Health Check

Abstract:

How often do you review your SQL Servers for basic security, maintenance, and performance issues? If you say never, I'm not surprised - many of the servers I "inherit" as a managed services provider have many gaping holes. It is not unusual to find databases that are never backed up, constant login failures (is it an attack or a bad connection string?), and servers that need more RAM/CPU/etc. (or sometimes that have too much!)

Come learn how to use freely available tools to check your servers for basic issues like backups and CheckDB as well as for more advanced issues like page life expectancy and indexing. If you are responsible in any way for a Microsoft SQL Server (DBA, Windows Admin, even a Developer) you will see value in this session!

SessionID: 9626

Are You Maintaining Your SQL Servers?

Back to calendar

Event Date: 25-07-2015 - Session time: 00:00:00 - Track: Database Administrator

Speaker: Andy Galbraith

Title: Are You Maintaining Your SQL Servers?

Abstract:

Are you performing all of the regular maintenance you should on your servers? Do you not run CHECKDB because "it takes too long"? How about Index Maintenance - does that take too long? Do you really have the appropriate backups in place?Do you have benchmark numbers in place to compare when your server is "slow"? Come discuss the answers to these and other questions - we will discuss the free Maintenance Solution scripted tools from Ola Hallengren and how they can help you fix these and other problems with a little easy coding you can do yourself. We will also discuss other tips and tricks to help you maintain and troubleshoot your SQL Server instances.

SessionID: 38057

Registration

Back to calendar

Event Date: 25-07-2015 - Session time: 07:30:00 - Track: Non-Session

Speaker: Mitchell Bottel

Title: Registration

Abstract:

Registration

SessionID: 38140

Event Registration

Back to calendar

Event Date: 25-07-2015 - Session time: 07:30:00 - Track: Non-Session

Speaker: Mitchell Bottel

Title: Event Registration

Abstract:

Event Registration

SessionID: 35601

Big Data Data Science, How to Get Past the Hype and Into a Team

Back to calendar

Event Date: 25-07-2015 - Session time: 08:30:00 - Track: Professional Development

Speaker: Andrew Eichenbaum

Title: Big Data Data Science, How to Get Past the Hype and Into a Team

Abstract:

Big Data and Data Science are two of the most hyped areas in high tech today. But what do Big Data and Data Science really mean, and how can you move into these hot career paths? In the discussion we will: Discuss the different roles in Big Data and Data Science teams; talk about the qualifications around each of the roles. Andrew will also provide starting points and pointers on how to get started in these fields.

SessionID: 37173

Standardized SQL Installations – Script Review Demo

Back to calendar

Event Date: 25-07-2015 - Session time: 08:30:00 - Track: Database Administrator

Speaker: Prakash Heda

Title: Standardized SQL Installations – Script Review Demo

Abstract:

This session is mostly demo-focused. I will cover prerequisites for scripts and show how to do multiple SQL Server installations using scripts and demonstrate how to Streamline SQL Server implementations.

You’ll take-away script to install different versions of SQL Server on supported OS systems. This script allows anyone in IT to install SQL systems with best practices baked into it which ensure all SQL installation can be streamlined.

You’ll see PowerShell scripts where a single line script can install any of these combinations: • Windows 2008R2/2012/2012R2 • SQL 2014/2012/2008R2 (Enterprise/Standard/Developer editions) • Implement best practices and configuration based on available resources for dedicated SQL Server environments

SessionID: 37486

Powershell Tips and Tricks for SQL Server Administration

Back to calendar

Event Date: 25-07-2015 - Session time: 08:30:00 - Track: Other

Speaker: Michael Fal

Title: Powershell Tips and Tricks for SQL Server Administration

Abstract:

Have you dipped your toe into the Powershell pool, but are still lost on how you can make it work for you? Maybe you're just looking for a few more tools to help you better manage SQL Server administration? In this session, we will cover a handful of useful scripts and patterns in Powershell that will ease your management of SQL Server. Backups, file management, instance configuration, and several other areas will be covered. By attending this session, you will learn more about how you can use Powershell effectively in your environment.

SessionID: 38839

Automating Power BI Creations

Back to calendar

Event Date: 25-07-2015 - Session time: 08:30:00 - Track: Business Intelligence

Speaker: Eric Bragas

Title: Automating Power BI Creations

Abstract:

Come learn how to build and automate data sets and data models in Excel using the Power BI toolset. We'll pull data from a variety of on-premise and cloud data sources to familiarize yourself with the latest capabilities of Power Query and Power Pivot. Then we'll review the software required to automate your Power BI analysis whether you are trying to refresh your Excel workbooks on a file server, in SharePoint Online, or SharePoint on-premise.

SessionID: 9627

Getting Started with Extended Events

Back to calendar

Event Date: 25-07-2015 - Session time: 08:30:00 - Track: Database Administrator

Speaker: Andy Galbraith

Title: Getting Started with Extended Events

Abstract:

Few subjects in Microsoft SQL Server inspire the same amount of Fear, Uncertainty, and Doubt (FUD) than Extended Events. Many DBA's continue to use Profiler and SQL Trace even though they have been deprecated for years. Why is this?

Extended Events started out in SQL Server 2008 with no user interface and only a few voices in the community documenting the features as they found them. Since then it has blossomed into a full feature of SQL Server and an amazingly low-impact replacement for Profiler and Trace.

Come learn how to get started - the basics of sessions, events, actions, targets, packages, and more. We will look at some base scenarios where Extended Events can be very useful as well as considering a few gotchas along the way. You may never go back to Profiler again!

SessionID: 11524

Becoming Certified In Microsoft SQL Server

Back to calendar

Event Date: 25-07-2015 - Session time: 09:45:00 - Track: Professional Development

Speaker: Chris Hyde

Title: Becoming Certified In Microsoft SQL Server

Abstract:

Becoming certified in SQL Server is a great career enhancement for a database professional. This session will provide you with an overview of the SQL Server Certification program, including the numerous changes made to the program for SQL 2012. You'll discover several reasons why you should become certified, and some of the best ways in which to do so. You'll also leave the session armed with some tips and tricks for passing the exams that the presenter has used over the last thirteen years.

SessionID: 11785

Successfully Virtualizing SQL Server on vSphere - Straight from the Source

Back to calendar

Event Date: 25-07-2015 - Session time: 09:45:00 - Track: Other

Speaker: Deji Akomolafe

Title: Successfully Virtualizing SQL Server on vSphere - Straight from the Source

Abstract:

Over the years, virtualization has matured from the exotic black magic realm to become a mainstream standard IT practice. "Virtualize First" is now a well-accepted default practice in most enterprises and any deviation is now considered an anomaly. In spite of this trend, many IT administrators and architects still have some reservations about virtualizing SQL Server workloads. They consider SQL too "critical" to be virtualized; they wonder and worry about scale about performance; they are looking for guidance and reassurance. If this is where you (or your clients) are today, be sure to attend this session. You will gain valuable insights from what others have done to successfully undertake similar tasks in their environments. We will talk about configuration pitfalls to avoid and also review the configuration and current performance data for some of the most demanding applications in customers environments.

SessionID: 35720

Master Data Management - Getting Started with SQL Server MDS

Back to calendar

Event Date: 25-07-2015 - Session time: 09:45:00 - Track: DB Developer

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: 37302

Everything SQL Server - Lightning Talks with Sacramento SQL UG

Back to calendar

Event Date: 25-07-2015 - Session time: 09:45:00 - Track: Database Administrator

Speaker: Mitchell Bottel

Title: Everything SQL Server - Lightning Talks with Sacramento SQL UG

Abstract:

Come see the Sacramento SQL Server User Group board present their lightning talks. We will be different features of SQL server in this fun, quick paced, multi session of SQL goodies. It is promised to be entertaining and enlightening!

Agenda Dan Hess talking about Signing stored procedures with certificates: Server security groups before SQL Server 2012 Dilip Nayak Discussing Auditing your actions using SQL Audit Glenn Burnett talking about SQL Server Query Store in SQL 2016 Mitch Bottel will be talking SQL Server Management Studio Tips and Tricks

Come have fun with this session!

SessionID: 37741

Best Practices for Excel Pivot Tables

Back to calendar

Event Date: 25-07-2015 - Session time: 09:45:00 - Track: Business Intelligence

Speaker: Tom Keller

Title: Best Practices for Excel Pivot Tables

Abstract:

The benefit of a direct-connected pivot table for the SQL Admin/Developer is: you no longer have to write and constantly tweak reports! Just give your users permission to run a stored procedure, and they can satisfy all their reporting needs through self-service.

Benefits for your business user: they can always drill down to the detail, be confident that it was not changed after retrieval from the database, and change parameters and refresh whenever they want, even after rearranging the report.

It requires no client software besides Excel, and has worked similarly since Excel 97. Nothing is required on the server except any version of SQL. (You can also connect to any data source with an ODBC driver!)

Although the concept is straightforward, there are some stumbling blocks to avoid. I will cover all the important points for setting up this solution, including:

Making the Connection
Configuring and Arranging the Table
Allowing Users to Change Parameters

SessionID: 10299

TSQL Best Practices for SQL Engine Kindness

Back to calendar

Event Date: 25-07-2015 - Session time: 11:00:00 - Track: DB Developer

Speaker: Ben Miller

Title: TSQL Best Practices for SQL Engine Kindness

Abstract:

This session will take a look at things that you should regularly know and use when coding TSQL. How can you be really friendly to SQL? The items covered will show you things that will help ensure that your code is readable, efficient and maintainable. We will look at query semantics, datatypes, things to avoid as well as how to be super friendly to the SQL Engine and allow things to work well.

SessionID: 10365

Query Processing in In-Memory OLTP (Hekaton)

Back to calendar

Event Date: 25-07-2015 - Session time: 11:00:00 - Track: Professional Development

Speaker: Benjamin Nevarez

Title: Query Processing in In-Memory OLTP (Hekaton)

Abstract:

In-Memory OLTP (code name: Hekaton) is the most important new feature in SQL Server 2014, and this session will teach you how query processing and optimization work with this new database engine. After explaining the basics, we will discuss how the query optimizer is used in In-Memory OLTP by both natively compiled stored procedures and by traditional stored procedures accessing memory-optimized tables through the query interop functionality. We will also take a look at how the new hash and range indexes are used, as well as how their performance implications are also covered along with the process of translating the plan created by the query optimizer into C code. Finally, some limitations with the current release will also be explained.

SessionID: 36242

Intro to PowerShell by example

Back to calendar

Event Date: 25-07-2015 - Session time: 11:00:00 - Track: Other

Speaker: Eric Courville

Title: Intro to PowerShell by example

Abstract:

We will review the bear minimum PowerShell CmdLets you should learn when you start learning PowerShell which will give you a good primer for exploring other more specific CmdLets. You will learn what makes up PowerShell CmdLets, and basic syntax for using them, and how to dissect the .NET Objects that are returned by them.

SessionID: 36664

Introduction to Wait Types and Response Time Analysis

Back to calendar

Event Date: 25-07-2015 - Session time: 11:00:00 - Track: Database Administrator

Speaker: Jonathan Shaulis

Title: Introduction to Wait Types and Response Time Analysis

Abstract:

SessionID: 37471

Big Data Analytics with Excel

Back to calendar

Event Date: 25-07-2015 - Session time: 11:00:00 - Track: Business Intelligence

Speaker: Peter Myers

Title: Big Data Analytics with Excel

Abstract:

This introductory session describes and demonstrates how to create a big data analytics solution with structured data by using Azure HDInsight and Excel 2013. This session will be of interest to those new to the concept of big data, new to self-service data modeling with Power Pivot, and for those interested to understand how big data can play a role in a self-service BI solution. Demonstrations will reinforce the introductory theory by showing how to store data files, and how to use Pig to transform data, and Hive to query data. The “big data” will then be retrieved and queried by using Power BI add-ins in Excel 2013, including Power Query, Power Pivot and Power View.

SessionID: 38139

Lunch Sessions

Back to calendar

Event Date: 25-07-2015 - Session time: 12:00:00 - Track: Non-Session

Speaker: Mitchell Bottel

Title: Lunch Sessions

Abstract:

Lunch Sessions from Event Sponsors

SessionID: 38776

Dell: How SharePlex Replicates from Oracle to SQL Server 8 Other Targets

Back to calendar

Event Date: 25-07-2015 - Session time: 12:15:00 - Track: Lunch

Title: Dell: How SharePlex Replicates from Oracle to SQL Server 8 Other Targets

Abstract:

Grab your lunch and join Trent Mera and Susan Wong in the Dell room for an informative presentation while you eat!

How SharePlex Replicates from Oracle to SQL Server and Eight Other Targets

Replicate from Oracle to a more economical and potentially easier-to-manage platform like SQL Server and experience less frustration when support is required. Offloading database activities to a SQL Server replica will leave more processing power and faster response times for your Oracle users. Users on the SQL Server target will enjoy near-real-time data on an instance that is tuned specifically for the purpose of reporting, analytics and other database activities while the Oracle production system remains tuned for online transaction processing (OLTP). In addition, SharePlex can be used to completely migrate an Oracle database to SQL Server without taking users offline during the migration process. A SQL Server target replica could be used to accomplish archiving or serve as a data warehouse

SessionID: 38777

Microsoft

Back to calendar

Event Date: 25-07-2015 - Session time: 12:15:00 - Track: Lunch

Title: Microsoft

Abstract:

Grab your lunch and join us in the Microsoft room for an informative presentation while you eat!

SessionID: 38778

Micron: Choosing the Right SSD for Your Application

Back to calendar

Event Date: 25-07-2015 - Session time: 12:15:00 - Track: Lunch

Title: Micron: Choosing the Right SSD for Your Application

Abstract:

Grab your lunch and join Justin Strong in the Micron room for an informative presentation while you eat!

Choosing the Right SSD for Your Application

This presentation is a case study of an IT manager’s decision process in choosing SSDs for server side storage to run Microsoft SQL.

SessionID: 38779

Tegile

Back to calendar

Event Date: 25-07-2015 - Session time: 12:15:00 - Track: Lunch

Title: Tegile

Abstract:

Grab your lunch and join us in the Tegile room for an informative presentation while you eat!

SessionID: 38780

Profisee: Accelerate SQL Server Master Data Services with Profisee Maestro

Back to calendar

Event Date: 25-07-2015 - Session time: 12:15:00 - Track: Lunch

Title: Profisee: Accelerate SQL Server Master Data Services with Profisee Maestro

Abstract:

Grab your lunch and join John McAllister in the Profisee room for an informative presentation while you eat!

Accelerate SQL Server Master Data Services with Profisee Maestro

SQL Server Master Data Services (MDS) is a robust platform for master data and hierarchy management that provides master data capabilities such as business rules, a managed schema, hierarchies, versioning, workflow, and Excel Integration. Profisee Maestro slashes your time to deployment on MDS by providing an alternate UI for data Stewards and Application owners. Maestro adds data modeling, a first-rate user experience, ER-Win Integration, Simplified Import/Export to simplify getting MDM in the hands of your users. Maestro also adds data quality, matching, harmonization, address corrections, an API, web parts and CRM integration.
Come see how Profisee Maestro can take your MDS implementation from the department to the enterprise.

SessionID: 18864

SQL Server Backups and Restores A to Z

Back to calendar

Event Date: 25-07-2015 - Session time: 13:45:00 - Track: Database Administrator

Speaker: Keith Tate

Title: SQL Server Backups and Restores A to Z

Abstract:

Have you become the de facto DBA? Have you been tasked with the responsibility of backing up your databases? Do you feel that your database maintenance plan is adequate, but may be lacking in what it can do? If these scenarios sound familiar, you’ll want to join this session, where Microsoft Certified Master (MCM) Keith Tate will walk you through the basics of backup and restore options.

The session will begin with the reasons why databases must be backed up (hint: to restore them). Then, discuss the different recovery models and how they affect your backup strategy. Next, explore ways to automate backup and restore strategies, and review ways to improve the speed of your backups and restores. Finally, put it all together and you’ll be on your way to a disaster proof backup and restore strategy.

SessionID: 36566

Getting Started with Reporting Services

Back to calendar

Event Date: 25-07-2015 - Session time: 13:45:00 - Track: Business Intelligence

Speaker: Ted Stathakis

Title: Getting Started with Reporting Services

Abstract:

Do you wish you could quickly and easily get some or your data into the hands of your end users? Well… SQL Server Reporting Services (SSRS) is part of SQL: You’ve already paid for it, so put it to use! In this introductory level session designed for users with no exposure to SSRS we will cover the basics of developing, publishing and using SQL Server Reporting Services. From building a dataset through automating report delivery you will learn how you can return to the office and present meaningful data to your end users with minimal time and effort. Come learn how this very powerful and easy to use tool can relieve you from data delivery tasks and thrill your end users all at the same time.

SessionID: 37352

Are You Optimistic About Concurrency?

Back to calendar

Event Date: 25-07-2015 - Session time: 13:45:00 - Track: Database Administrator

Speaker: Kalen Delaney

Title: Are You Optimistic About Concurrency?

Abstract:

What exactly does it mean to have optimistic concurrency? What is the alternative? Is SQL Server 2012's SNAPSHOT Isolation optimistic? How can SQL Server 2014's In-Memory OLTP provide truly optimistic concurrency?

In this session, we'll look at what guarantees the various isolation levels provide, the difference between pessimistic and optimistic concurrency, and the new data structures in SQL Server 2014 that allow the enormous benefits of having totally in-memory storage with no waiting!

SessionID: 37470

Azure Machine Learning: From Design to Integration

Back to calendar

Event Date: 25-07-2015 - Session time: 13:45:00 - Track: Other

Speaker: Peter Myers

Title: Azure Machine Learning: From Design to Integration

Abstract:

Machine Learning is a subfield of computer science concerned with systems that learn from data. In this session, learn how a Microsoft Azure Machine Learning solution comes to life: From the creation of a workspace, to the preparation of data, to experimentation with machine learning algorithms, and then finally to the integration and integration of predictive insights.

This session has been specifically designed to describe machine learning fundamentals, and to help enable and inspire existing developers taking their first steps to leverage cloud-based predictive models delivered with Azure Machine Learning. It is guaranteed to thrill you with potential, and excite you with the relative ease in which it can be accomplished.

SessionID: 38051

SSAS: Zero to Cube in Sixty Minutes

Back to calendar

Event Date: 25-07-2015 - Session time: 13:45:00 - Track: Business Intelligence

Speaker: Pravina Parthasarthy

Title: SSAS: Zero to Cube in Sixty Minutes

Abstract:

For data sets ranging from a few gigabytes to tens of terabytes, Microsoft’s SSAS can be the tool of choice. In this session, we start off by covering basic terminologies and the usage of the SSAS tool to build cubes, analyze datasets and build up to the usage of SSAS on terabyte sized datasets. We further focus on some of the surprisingly straightforward techniques while dealing with such large datasets. Finally, we cover the ease of use of the SSAS tool and its inherent advantages while interoperating with reporting tools.

SessionID: 11459

SQL Server Mythconceptions and Mythteries

Back to calendar

Event Date: 25-07-2015 - Session time: 15:00:00 - Track: Other

Speaker: Robert Davis

Title: SQL Server Mythconceptions and Mythteries

Abstract:

There are a lot of misconceptions and mysteries in SQL Server due in large part to there be no single right answer for just about any question you have. How many times have you heard, ‘It Depends’ as the answer to a complex SQL Server question? So often that it has almost become a joke. When it’s your SQL Server, it’s no joke.

Why won't that query go parallel? Why won't the optimizer use that index? Why did rebuilding that index improve performance 10 times over?

Sometimes misconceptions become accepted as fact, and they spread. Occasionally, these mistold tales come from very reliable sources. It can be extremely difficult to tell what is fact and what is fable.

In this session, we will explore some of these misconceptions and mysteries turned myths and bust out the truth. We will prove the right answer and free you from these myths that have taken on a life of their own.

SessionID: 20403

Techniques for Dynamic SSRS Reports

Back to calendar

Event Date: 25-07-2015 - Session time: 15:00:00 - Track: Business Intelligence

Speaker: Mickey Stuewe

Title: Techniques for Dynamic SSRS Reports

Abstract:

If you answered yes to any of these questions, then join me in this demo heavy session. Not only will we address the questions above, but we’ll talk about providing different layouts to the data in the same report, minimizing data based on the user’s credentials, and even techniques for colorizing various parts of a report using VBA code. These techniques will help make your reports user friendly and help you look like a reporting superhero.

SessionID: 36567

Take your Reporting Services Implementation to a New Level

Back to calendar

Event Date: 25-07-2015 - Session time: 15:00:00 - Track: Business Intelligence

Speaker: Ted Stathakis

Title: Take your Reporting Services Implementation to a New Level

Abstract:

Are you already using Reporting Services (SSRS) but just not loving it? Has it become clumsy, hard to manage or just plain not great? In this session designed for intermediate users with some SSRS knowledge you will see how you can simplify and unify your implementation making your reports pop with polish while shortening your development time and maintenance efforts. An exploration of Shared Data Sets will show how to reduce data discrepancies and improve performance. Learn how to leverage the power of Linked Reports to reduce the number of reports needed and to streamline report publication. Come discover how the ultimate Report Footer can tell you all you need to know about that report, its performance and the users who are running it.

SessionID: 37401

Data Pages, Allocation Units, IAM chains... Oh My!

Back to calendar

Event Date: 25-07-2015 - Session time: 15:00:00 - Track: Database Administrator

Speaker: Brandon Leach

Title: Data Pages, Allocation Units, IAM chains... Oh My!

Abstract:

Understanding how SQL Server organizes your data under the hood can seem like a daunting task. In this session we’ll take a look at how objects such as tables and indexes are stored in the data file. We’ll also look at how these concepts tie in to your work as a DBA or developer. We’ll see these concepts in action using demos and see how we can use this knowledge to better design solutions. We’ll start off by looking at the structure of a row and then move on the concept of a data page. From there we’ll cover a few special page types like the index allocation map. Then we’ll look at index structures and talk about the differences between heaps and clustered indexes.

SessionID: 37487

Powershell and the Art of SQL Server Deployment

Back to calendar

Event Date: 25-07-2015 - Session time: 15:00:00 - Track: Other

Speaker: Michael Fal

Title: Powershell and the Art of SQL Server Deployment

Abstract:

In today’s tech world, IT professionals are being driven to perform tasks faster and more consistently. Automation is the watchword for our success, whether we are deploying SQL Server to private virtual clouds or public platforms such as Azure IaaS. This session will focus on rapidly creating and configuring SQL Servers using Powershell and Desired State Configuration. You will see practical examples of how you can create repeatable builds of SQL Server that can be deployed in a matter of minutes. We will also review how these techniques can be applied to both public and private cloud platforms, ensuring your success for any situation.

SessionID: 10392

Flash Disk Alternatives for SQL Server Databases

Back to calendar

Event Date: 25-07-2015 - Session time: 16:15:00 - Track: Other

Speaker: Bert Scalzo

Title: Flash Disk Alternatives for SQL Server Databases

Abstract:

Flash disk and/or SSD technology options have been creeping into SQL Server database deployments more frequently. Knowing what options are out there and how they differ is key to successful deployments because the flash revolution is here to stay, and not all flash is created the same. Oracle ACE Bert Scalzo will present the many significantly different alternatives for utilizing flash disk and/or SSD in SQL Server deployments. Additionally, he will review SQL Server 2012 and 2014 features that support or best utilize flash.

SessionID: 11460

Diagnosing Performance with Wait Statistics

Back to calendar

Event Date: 25-07-2015 - Session time: 16:15:00 - Track: Database Administrator

Speaker: Robert Davis

Title: Diagnosing Performance with Wait Statistics

Abstract:

Wait statistics get more complaints about a lack of documentation than just about anything in SQL Server. The documentation that is available is not always very clear. Let's clear up these gray areas once and for all.

This session will cover what you need to know about wait stats like the best way to investigate them, how to interpret their meanings, and which wait types are important and which can be ignored.

SessionID: 21870

Power BI Hands-On Micro-Workshop

Back to calendar

Event Date: 25-07-2015 - Session time: 16:15:00 - Track: Business Intelligence

Speaker: Paul Turley

Title: Power BI Hands-On Micro-Workshop

Abstract:

Bring your laptop and let's build a BI solution using the components of Power BI! You'll need Office 2013 ProPlus (you can install the trial) and the Power Query add-in. I'll provide everything else. This 95% demo and uber-fast hands-on lab session will show you how to cleanse and transform data from multiple sources with Power Query, model data for reporting with Power Pivot and then explore the model and build interactive dashboards with Power View. You'll leave with a working BI solution.

Office ProPlus 60 day trial: http://www.microsoft.com/en-us/evalcenter/evaluate-office-professional-plus-2013 Power Query add-in: http://www.microsoft.com/en-us/download/details.aspx?id=39379

SessionID: 36952

Physical Join Operators

Back to calendar

Event Date: 25-07-2015 - Session time: 16:15:00 - Track: DB Developer

Speaker: Ami Levin

Title: Physical Join Operators

Abstract:

SessionID: 37607

CTE's and Recursion in T-SQL

Back to calendar

Event Date: 25-07-2015 - Session time: 16:15:00 - Track: DB Developer

Speaker: Eric Freeman

Title: CTE's and Recursion in T-SQL

Abstract:

In this session you will learn various uses of Common Table Expressions, how to declare, stack CTE's, and how to use recursive CTE's. Examples will be shared of how they can be used in useful and not so useful (but informative) ways. This session is intended for those comfortable using T-SQL but wanting to learn more about what is available. My intention is to heavily cover recursive CTE’s in this session. We will also go over windowed functions which will be used in some CTE examples.

SessionID: 38056

Raffle

Back to calendar

Event Date: 25-07-2015 - Session time: 17:30:00 - Track: Non-Session

Speaker: Mitchell Bottel

Title: Raffle

Abstract:

End of Day Raffle

This site is open source. Improve this page.