sqlsathistory

Nr: 410

Back to Main list

SQLSaturday #410 - Chattanooga 2015

Start Time (24h)	Speaker	Track	Title
00:00:00	Dan Evans	BI	Self-Service BI with SSAS
09:00:00	Gene Webb	BigData	Introduction to Master Data Management (MDM) with SQL Server Master Data Services (MDS) for Beginner
09:00:00	William Wolf	DBA/Administration	Tame the sibling rivalry
09:00:00	Robert Verell	Other	Know Your Role(s)!
09:00:00	Tim Radney	Management/Personal	Getting involved and Getting ahead
09:00:00	Mark Tabladillo	BigData	Primer on Power BI
09:00:00	Vladimir Oselsky	DBA/Developer	Crash course on becoming better SQL Developer.
09:00:00	Annelies Beaty	BI	Data Mining with SQL Server Data Tools
10:45:00	Dan Evans	BI	Self-Service BI with Big Data
10:45:00	Ed Watson	DBA/Administration	Performance Tuning for Mere Mortals Part I
10:45:00	Geoff Hiten	DBA/Administration	What’s your Imperative doing in my Declarative?
10:45:00	Dave Mattingly	Management/Personal	Achievement Unlocked: How to Get Promoted
10:45:00	Warren Sifre	BigData	Introduction to Azure Machine Learning
10:45:00	Kerry Tyler	BI	45 Minutes to Your First SSAS Tabular Model
13:15:00	Daniel Glenn	Other	Tuning SQL Server for SharePoint
13:15:00	Mike Lawell	DBA/Administration	Performance Tuning for Mere Mortals Part II
13:15:00	Kevin Boles	Other	SQL Server 2014 Column Store Index vNEXT
13:15:00	Robert Verell	DBA/Administration	Getting Started With SQL Server Replication
13:15:00	Kerry Tyler	BI	Manageable SSAS Deployment Strategies
13:15:00	Aaron Nelson	Other	PowerShell for Data Professionals
15:00:00	Dave Mattingly	BigData	The Next Dimension of Data
15:00:00	Louis Davidson	DBA/Developer	How In-Memory Database Objects Affect Database Design
15:00:00	Doug Purnell	DBA/Administration	Are Availability Groups a good fit for your database?
15:00:00	Lindsay Clark	DBA/Administration	Beginners SQL Server Security the Low Hanging Fruit
15:00:00	Rick Lowe	DBA/Administration	Why should I care about the plan cache?
16:15:00	Ed Watson	DBA/Administration	Backup Strategies are for Losers...of Data!
16:15:00	Kevin Feasel	BigData	Much Ado About Hadoop
16:15:00	Mike Lawell	DBA/Administration	Execution Plans for Mere Mortals
16:15:00	Wes Springob	BI	Querying Active Directory From SSRS To Secure Reports And Enhance The User Experience
16:15:00	Kevin Boles	DBA/Administration	SQL Server 2014 New Features
16:15:00	Robert Cain	Other	Zero to Hero with PowerShell and SQL Server

SessionID: 13429

Self-Service BI with SSAS

Back to calendar

Event Date: 27-06-2015 - Session time: 00:00:00 - Track: BI

Speaker: Dan Evans

Title: Self-Service BI with SSAS

Abstract:

Now with SQL 2014 you can perform visual data exploration with Power View on traditional Multi-Dimensional models. See how to build out these types of analysis using Excel and SharePoint. Get insight into tips/tricks and lessons learned from the field to increase the value of your BI SQL investments and leverage new capabilities in PowerPivot, Tabular and Power BI. Also leverage the new capabilities with the Power BI Preview and create real-time dashboards and interactive reports on any device.

SessionID: 14453

Introduction to Master Data Management (MDM) with SQL Server Master Data Services (MDS) for Beginner

Back to calendar

Event Date: 27-06-2015 - Session time: 09:00:00 - Track: BigData

Speaker: Gene Webb

Title: Introduction to Master Data Management (MDM) with SQL Server Master Data Services (MDS) for Beginner

Abstract:

What is master data management and why should I care about it?

What does the master data services components of SQL Server do for me? Overview of all features of MDS How to build out an MDM subject area How to use MDS for reference data management How to use MDS for data quality How to use MDS with a data warehouse to improve data quality

SessionID: 22096

Tame the sibling rivalry

Back to calendar

Event Date: 27-06-2015 - Session time: 09:00:00 - Track: DBA/Administration

Speaker: William Wolf

Title: Tame the sibling rivalry

Abstract:

Deadlocks present a problem to many DBAs. Deadlocks can be minor occurrences or major issues making SQL Server continually choose a victim like constantly quarreling siblings.

We will review locking, blocking and deadlocking. We will also review how to identify deadlocks and how to lessen the family fighting.

SessionID: 35847

Know Your Role(s)!

Back to calendar

Event Date: 27-06-2015 - Session time: 09:00:00 - Track: Other

Speaker: Robert Verell

Title: Know Your Role(s)!

Abstract:

Developers and DBAs naturally conflict with each other over permissions since developers want to be able to fix their code and research issues, but DBAs are the gatekeepers. In this session we will discuss Microsoft recommended best practices for setting up users and service account permissions. We will go over common server and database roles and what they actually allow, including roles that should be avoided as potential security loopholes. He will also look into alternatives for elevated database roles, and easier ways of setting up users across an enterprise environment, all as part of how to consolidate your development servers into fewer instances.

SessionID: 36108

Getting involved and Getting ahead

Back to calendar

Event Date: 27-06-2015 - Session time: 09:00:00 - Track: Management/Personal

Speaker: Tim Radney

Title: Getting involved and Getting ahead

Abstract:

Learn how getting involved in the SQL Community can help you get ahead within your organization, improve you skill set as well as help provide career stability. PASS and other organizations practically give you all the tools you need to succeed in the DBA field, learn about the events that help make this possible as well as how you can get involved to help others who are starting out. The rewards of the SQL Community are endless.

SessionID: 37278

Primer on Power BI

Back to calendar

Event Date: 27-06-2015 - Session time: 09:00:00 - Track: BigData

Speaker: Mark Tabladillo

Title: Primer on Power BI

Abstract:

Power BI (Business Intelligence) is a new and emerging self-service business intelligence and business analytics framework that brings together and enhances a few key Microsoft technologies. We will answer the following questions:

◾What makes Power BI different from the Microsoft Office I have known for years?

◾What are the major Power BI features in Excel 2013 and 2010?

◾What are the major features for Power BI for Office 365?

◾How can our team license Power BI?

SessionID: 37298

Crash course on becoming better SQL Developer.

Back to calendar

Event Date: 27-06-2015 - Session time: 09:00:00 - Track: DBA/Developer

Speaker: Vladimir Oselsky

Title: Crash course on becoming better SQL Developer.

Abstract:

Crash course on becoming better SQL developer by focusing on common mistakes and how to overcome it. What does one need to know to become better SQL Developer? What tools can make your job easier and how to use them? How can I modular code to make it reusable? These and many other questions will be answered by reviewing mistakes, showcasing free tools and going over bad code.

SessionID: 37871

Data Mining with SQL Server Data Tools

Back to calendar

Event Date: 27-06-2015 - Session time: 09:00:00 - Track: BI

Speaker: Annelies Beaty

Title: Data Mining with SQL Server Data Tools

Abstract:

Geared towards folks who are starting to dip their toes into data mining and analytics, but don't know where to start - this session will go over the data mining tools baked into the Sql Server/Analysis Services tool suite. During the session we will review the basic algorithms available out of the box, demo how to set them up and interpret their results.

SessionID: 13428

Self-Service BI with Big Data

Back to calendar

Event Date: 27-06-2015 - Session time: 10:45:00 - Track: BI

Speaker: Dan Evans

Title: Self-Service BI with Big Data

Abstract:

Now with SQL 2014 Data Platform you can perform visual data exploration with unstructured data sets using Hadoop and other MapReduce data sets. See how to build out these types of analysis using existing tools like Excel, SharePoint and O365. Get insight into tips/tricks and lessons learned from the field to increase the value of your existing big data investments and leverage new capabilities in Power Query, PowerPivot Power View, Power Map and Power BI!.

SessionID: 13708

Performance Tuning for Mere Mortals Part I

Back to calendar

Event Date: 27-06-2015 - Session time: 10:45:00 - Track: DBA/Administration

Speaker: Ed Watson

Title: Performance Tuning for Mere Mortals Part I

Abstract:

In this first part of a two part series, we look at performance tuning from the very beginning. You're a new DBA, you want to be a DBA, or you've been declared an "Accidental DBA" and the phone rings. Someone tells you that they believe SQL Server is having a performance issue, what now? The application is running slowly. Can you help them? Do you even know where to begin to help them? In this session we'll cover how to handle performance tuning from the very beginning, when the user says "The database is slow."

SessionID: 14509

What’s your Imperative doing in my Declarative?

Back to calendar

Event Date: 27-06-2015 - Session time: 10:45:00 - Track: DBA/Administration

Speaker: Geoff Hiten

Title: What’s your Imperative doing in my Declarative?

Abstract:

T-SQL is one of a minority of computer languages where you describe the results rather than code an algorithm. Unfortunately, many people use habits and constructions learned in imperative languages such as C# or Java when writing T-SQL Code. In this all-demo session we will explore several such commonly used constructions that are detrimental to SQL Server performance and scalability.

SessionID: 36564

Achievement Unlocked: How to Get Promoted

Back to calendar

Event Date: 27-06-2015 - Session time: 10:45:00 - Track: Management/Personal

Speaker: Dave Mattingly

Title: Achievement Unlocked: How to Get Promoted

Abstract:

Have you ever felt like an extra in Office Space? You've got the skills. You've got the big brain. You feel like you have a higher calling, but those other guys get picked instead. What's the deal?

In this session, you'll learn how to promote yourself, how to speak confidently, how to build your personal brand, how to demonstrate value, and how to interview.

SessionID: 36904

Introduction to Azure Machine Learning

Back to calendar

Event Date: 27-06-2015 - Session time: 10:45:00 - Track: BigData

Speaker: Warren Sifre

Title: Introduction to Azure Machine Learning

Abstract:

We will discuss what is Azure Machine Learning, how it works, what it can do, and why would you use it. This session includes demonstration and use case scenarios. The goal of this session it to provide an understand of what Azure ML can do and how it may apply to business use cases.

SessionID: 36929

45 Minutes to Your First SSAS Tabular Model

Back to calendar

Event Date: 27-06-2015 - Session time: 10:45:00 - Track: BI

Speaker: Kerry Tyler

Title: 45 Minutes to Your First SSAS Tabular Model

Abstract:

Have you heard about SSAS Tabular, maybe even know a couple things about it, but haven't had a chance to dive in and figure out how to develop one yourself? Now is the time!

SSAS Tabular is a new form of business intelligence model released with SQL Server 2012, intended as an alternative to more traditional Multidimensional cubes. In this session, we will talk briefly about what Tabular is and what it does, before exploring the development process of creating a tabular model ready for ad-hoc querying.

SessionID: 12177

Tuning SQL Server for SharePoint

Back to calendar

Event Date: 27-06-2015 - Session time: 13:15:00 - Track: Other

Speaker: Daniel Glenn

Title: Tuning SQL Server for SharePoint

Abstract:

We will discuss SQL and SharePoint integration concepts, walk through the different types of SharePoint databases, and get you more comfortable with the SharePoint platform.

Some of the topics covered will include: the configuration steps and settings needed for SQL Server to properly host SharePoint databases, database size considerations, the SQL permissions your SharePoint administrators REALLY need, and why SharePoint databases have a GUID in their name (and how to avoid them!).

SessionID: 20604

Performance Tuning for Mere Mortals Part II

Back to calendar

Event Date: 27-06-2015 - Session time: 13:15:00 - Track: DBA/Administration

Speaker: Mike Lawell

Title: Performance Tuning for Mere Mortals Part II

Abstract:

This is part two of a two part series, looking at performance tuning (i.e. performance troubleshooting) from the beginning. Part II is about the next steps after taking a look at some of the free performance analysis tools. This session will go into more detail about how to capture the current transactions with tools like sp_WhoIsActive stored procedure, Wait Stats, performance counters and Extended Events.

This is a very demo intensive session some basic issues and performance analysis that will be used as a starting point for performance tuning.

There will be homework!

SessionID: 26420

SQL Server 2014 Column Store Index vNEXT

Back to calendar

Event Date: 27-06-2015 - Session time: 13:15:00 - Track: Other

Speaker: Kevin Boles

Title: SQL Server 2014 Column Store Index vNEXT

Abstract:

The Column Store Index functionality released in SQL 2012 did allow for stunning performance gains for OLAP-style queries, but as a v1.0 release it suffered from a number of caveats, limitations, provisos, etc. The one BIGGIE was that it made it's underlying table NON-UPDATABLE. Well, that often implementation-killing restriction has been addressed, along with a huge number of other fixes and enhancements. We will cover what those are and also see actual usage with some nice demos.

SessionID: 35846

Getting Started With SQL Server Replication

Back to calendar

Event Date: 27-06-2015 - Session time: 13:15:00 - Track: DBA/Administration

Speaker: Robert Verell

Title: Getting Started With SQL Server Replication

Abstract:

In this session we will examine how SQL Server replication works. A technology that has been around, this tool is not going anywhere anytime soon. It's an excellent way to keep a subset of data synched with another database without having to synch the entire thing (although you could if you wanted to!). We will examine terms, internals, and walk through the setup of transactional and snapshot replication pieces so you can implement this technology in your environment and use it as a valuable tool in your personal knowledge book.

SessionID: 36930

Manageable SSAS Deployment Strategies

Back to calendar

Event Date: 27-06-2015 - Session time: 13:15:00 - Track: BI

Speaker: Kerry Tyler

Title: Manageable SSAS Deployment Strategies

Abstract:

When it comes to making changes to your production Analysis Services databases, do you simply open the SSAS DB in SQL Server Data Tools (or BIDS) and click through creating the changes? Does this method lead to problems keeping everything in sync and the right changes deployed to the right environment at the right time? Have you, the BI developer, had to fight to get Production access to do your own deployments?

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

PowerShell for Data Professionals

Back to calendar

Event Date: 27-06-2015 - Session time: 13:15:00 - Track: Other

Speaker: Aaron Nelson

Title: PowerShell for Data Professionals

Abstract:

You’ve heard it said, “If you have to do it twice, automate it.” Cut the learning curve and get a real handle on this powerful automation tool. This session walks you through a dozen scripts to simplify and easily automate time-consuming and tedious elements of your day to day job. This isn’t stuff you’ll use SOMEDAY, these are scripts you can use when you get home tonight. Harness the power of Power Shell to easily find Servers short on space. Script out tables and constraints across all of your databases at once. Backup databases and restore them to a different environment. These tricks and many others will allow PowerShell to simplify your job like no other tool.

SessionID: 12260

The Next Dimension of Data

Back to calendar

Event Date: 27-06-2015 - Session time: 15:00:00 - Track: BigData

Speaker: Dave Mattingly

Title: The Next Dimension of Data

Abstract:

Send your data on a journey through space and time, while engaging your audience’s senses to tell its story. MS SQL Server’s geospatial datatype offers pinpoint accuracy and many advanced location-aware capabilities, such as shapes, overlaps, distances, and direction. The Power Map feature in Office 2013 can turn your addresses and supporting figures into a movie. Turn your facts and figures into a compelling story by entering geospace: the final frontier.

SessionID: 13486

How In-Memory Database Objects Affect Database Design

Back to calendar

Event Date: 27-06-2015 - Session time: 15:00:00 - Track: DBA/Developer

Speaker: Louis Davidson

Title: How In-Memory Database Objects Affect Database Design

Abstract:

With SQL Server 2014, Microsoft has added a major new feature to help optimize OLTP database implementations by persisting your data primarily in RAM. Of course it isn't that simple, internally everything that uses this new feature is completely new. While the internals of this feature may be foreign to you, accessing the data that uses the structures very much resembles T-SQL as you already know it. As such, the first important question for the average developer will be how to adapt an existing application to make use of the technology to achieve enhanced performance. In this session, I will start with a normalized database, and adapt the logical and physical database model/implementation in several manners, performance testing the tables and code changes along the way.

SessionID: 35667

Are Availability Groups a good fit for your database?

Back to calendar

Event Date: 27-06-2015 - Session time: 15:00:00 - Track: DBA/Administration

Speaker: Doug Purnell

Title: Are Availability Groups a good fit for your database?

Abstract:

How do you know if Availability Groups are the correct high availability solution for your business application? We’ll cover some common business problems that Availability Groups can solve and go through a quick demo where we’ll cover some pre and post checklist items to help you understand the requirements for a successful implementation.

SessionID: 37259

Beginners SQL Server Security the Low Hanging Fruit

Back to calendar

Event Date: 27-06-2015 - Session time: 15:00:00 - Track: DBA/Administration

Speaker: Lindsay Clark

Title: Beginners SQL Server Security the Low Hanging Fruit

Abstract:

Security is not for the faint of heart and this session is just the tip of the iceberg. Those new to the DBA role and of course the Accidental DBA's can take away a few nuggets to get them started securing their SQL Servers and raising awareness to the importance of securing the data we have been sworn to protect. Let this session jump start your journey to learning why DBA's are called the gatekeepers and increase your value in the office while getting noticed for caring enough to stop intrusions to your SQL Servers.

SessionID: 37420

Why should I care about the plan cache?

Back to calendar

Event Date: 27-06-2015 - Session time: 15:00:00 - Track: DBA/Administration

Speaker: Rick Lowe

Title: Why should I care about the plan cache?

Abstract:

SQL Server is a huge product, with many different places a DBA can go to look for information on how the server is performing. So many in fact that they can often overlap, which sometimes makes it hard to understand why tackling a new tool is worth the effort. In this first (and hopefully not last) installment of Rick's "Why should I care" series a case for why working knowledge of how to query the plan cache is critical for performance tuning efforts in real world environments, followed by a review of relevant DMV's for the newly motivated audience. Perfect for those who are relatively new to performance tuning concerns, or advanced DBAs trying to figure out how to have a similar conversation with their less experienced peers, or developers who are curious as to why DBAs drink in the morning (allegedly).

SessionID: 13709

Backup Strategies are for Losers...of Data!

Back to calendar

Event Date: 27-06-2015 - Session time: 16:15:00 - Track: DBA/Administration

Speaker: Ed Watson

Title: Backup Strategies are for Losers...of Data!

Abstract:

Every company has a backup strategy. That backup strategy is worthless and will cause your business to fail miserably while losing valuable customer data and more importantly you will lose my order of chicken wings! In this session you will learn why backup strategies are for losers, what can I do to keep from being a loser, and how can I build a winning strategy!

SessionID: 14229

Much Ado About Hadoop

Back to calendar

Event Date: 27-06-2015 - Session time: 16:15:00 - Track: BigData

Speaker: Kevin Feasel

Title: Much Ado About Hadoop

Abstract:

Hadoop is a hot topic right now, and Microsoft is betting that Hadoop and SQL Server will go together like peanut butter and chocolate. This presentation will spend a little bit of time on the theory behind Hadoop, but the rest will be a demo-driven look at how to get a handle on Hadoop before somebody introduces it into your enterprise.

SessionID: 20603

Execution Plans for Mere Mortals

Back to calendar

Event Date: 27-06-2015 - Session time: 16:15:00 - Track: DBA/Administration

Speaker: Mike Lawell

Title: Execution Plans for Mere Mortals

Abstract:

This is a beginner session that will look at the graphical execution plan, and the important operators, properties and what to look for in an execution plan. It will discuss the ways to determine a poor cardinality estimate, parameter sniffing and spill to tempdb.

SessionID: 24818

Querying Active Directory From SSRS To Secure Reports And Enhance The User Experience

Back to calendar

Event Date: 27-06-2015 - Session time: 16:15:00 - Track: BI

Speaker: Wes Springob

Title: Querying Active Directory From SSRS To Secure Reports And Enhance The User Experience

Abstract:

As SSRS report developers, we take for granted the security that is built in to Reporting Services. This Session explores the possibilities available to us by querying AD.

SessionID: 26418

SQL Server 2014 New Features

Back to calendar

Event Date: 27-06-2015 - Session time: 16:15:00 - Track: DBA/Administration

Speaker: Kevin Boles

Title: SQL Server 2014 New Features

Abstract:

There is MUCH more to SQL Server 2014 than just Hekaton and Updatable Column Store Indexes!! This session will be a medium-to-high-level overview of many of the new features and enhancements coming in SQL Server 2014. When I thought of doing this session I initially wanted to have some demos, but there are SOOO many things to cover I couldn't fit in any demos in a 1 hour session!

SessionID: 9753

Zero to Hero with PowerShell and SQL Server

Back to calendar

Event Date: 27-06-2015 - Session time: 16:15:00 - Track: Other

Speaker: Robert Cain

Title: Zero to Hero with PowerShell and SQL Server

Abstract:

PowerShell is everywhere, and that includes SQL Server. In this session we'll look at using PowerShell with both the SQL Server provider and the SMO (SQL Management Objects) library. Learn how to handle common DBA tasks, such as checking the status of various services, validating backups, and checking for disk usage. You'll also see how to perform developer tasks such as creating tables, inserting records, and querying data. Perhaps most importantly, you will learn how to read and understand the SMO object model, and translate it into PowerShell commands. Come see how to become a hero with SQL Server and PowerShell.

This site is open source. Improve this page.