Nr: 383
SQLSaturday #383 - Rochester 2015
SessionID: 35927
Possible Musics: SSAS Multidimensional vs Tabular
Event Date: 16-05-2015 - Session time: 00:00:00 - Track: Track 2
Speaker: William E Pearson III
Title: Possible Musics: SSAS Multidimensional vs Tabular
Abstract:
The Analysis Services 2012 Business Intelligence Semantic Model (BISM) unifies Multidimensional (OLAP) and Tabular (relational) options for organizational BI. BI professionals can implement Multidimensional cubes, or they can deploy Tabular models developed by business users to a dedicated server. Those new to Tabular, or those embarking upon BI for the first time with SSAS 2012, may find it difficult to choose between the two paths. In this session, BI Architect, SQL Server MVP and SSAS Maestro Bill Pearson overviews the nature and design goals of each option, comparing Multidimensional and Tabular features. He then offers guidance on selecting the appropriate model, providing examples to illustrate approaches for given scenarios.
SessionID: 11784
So you want to be a Database Administrator...
Event Date: 16-05-2015 - Session time: 08:30:00 - Track: Track 5
Speaker: Colleen Morrow
Title: So you want to be a Database Administrator...
Abstract:
SessionID: 15736
Query Tuning - Get it Right the First Time
Event Date: 16-05-2015 - Session time: 08:30:00 - Track: Track 6
Speaker: Janis Griffin
Title: Query Tuning - Get it Right the First Time
Abstract:
SQL Server query tuning is often more art than science and it can quickly eat up a lot of DBA and/or Developer time. This presentation will outline a method for determining the best approach for tuning queries by utilizing response time analysis and SQL diagramming techniques. Regardless of the complexity of the statement, this quick, systematic approach will lead you down the correct tuning path with no guessing. If you are a beginner or expert, this approach will save you countless hours tuning a query.
SessionID: 25728
Fixing Page Life Expectancy
Event Date: 16-05-2015 - Session time: 08:30:00 - Track: Track 4
Speaker: Steve Hood
Title: Fixing Page Life Expectancy
Abstract:
Starting with what Page Life Expectancy really means to query, server, and disk performance, we’ll get a firm understanding of what this counter means to you. After that we can start talking about if and how you want to raise it. It’s important to know that this is just a counter and there are situations where you don’t care about it nearly as much as you’d expect. It’s also important to know what effect a drop in PLE mid-day really means beyond query performance, including a possible impact on other, unrelated servers.
SessionID: 27648
The Use Cases for In-Memory OLTP
Event Date: 16-05-2015 - Session time: 08:30:00 - Track: Track 3
Speaker: Warner Chaves
Title: The Use Cases for In-Memory OLTP
Abstract:
In this session, we will do a short introduction to the In-Memory OLTP feature before diving straight into the use cases where the new lockless/latchless concurrency control and native compilation really shines. Demos will cover PAGELATCH contention, use of In-Memory for ETL and In-Memory tables as 'shock absorbers' for high throughput environments. For each case we will do a comparison of "Classic" vrs In-Memory, what gains can the audience expect and what patterns will yield the biggest benefits.
SessionID: 9009
Availability Groups 101: An Introduction
Event Date: 16-05-2015 - Session time: 08:30:00 - Track: Track 7
Speaker: Adam Belebczuk
Title: Availability Groups 101: An Introduction
Abstract:
SessionID: 9560
Easing Into Scripting with Windows PowerShell
Event Date: 16-05-2015 - Session time: 08:30:00 - Track: Track 2
Speaker: Andy Levy
Title: Easing Into Scripting with Windows PowerShell
Abstract:
You've been hearing about Windows PowerShell, but you're wondering if it's something you should be working with. Or maybe you’re just looking for a way to make those boring, repetetive chores take care of themselves. In this introductory session, we'll talk about what PowerShell is, how to use it, and where it’s going. Whether you're a junior DBA or seasoned veteran, you'll find ways that PowerShell can make your life easier.
SessionID: 11288
The Spy Who Loathed Me - An Intro to SQL Security
Event Date: 16-05-2015 - Session time: 09:45:00 - Track: Track 1
Speaker: Chris Bell
Title: The Spy Who Loathed Me - An Intro to SQL Security
Abstract:
You have lots of data you have painstakingly collected over the years. How do you ensure that data is protected from hackers, spies and other ne’er-do-wells? Understanding the vast array of security features available in SQL Server is the first step in helping you determine what actions you need to take now to protect your data.
SessionID: 11783
Enterprise-level auditing on a Standard Edition budget
Event Date: 16-05-2015 - Session time: 09:45:00 - Track: Track 5
Speaker: Colleen Morrow
Title: Enterprise-level auditing on a Standard Edition budget
Abstract:
SessionID: 15735
Event Date: 16-05-2015 - Session time: 09:45:00 - Track: Track 6
Speaker: Janis Griffin
Abstract:
SessionID: 20663
Advanced Troubleshooting Your SQL Connections
Event Date: 16-05-2015 - Session time: 09:45:00 - Track: Track 4
Speaker: Mike Hays
Title: Advanced Troubleshooting Your SQL Connections
Abstract:
Often in supporting SQL Server, we are asked to troubleshoot why a user or application cannot connect. It becomes more challenging when we find nothing is wrong with the way SQL Server is running. In this session we review common mistakes to the configuration of network settings. We’ll also show how to troubleshoot the SQL Server Browser. We’ll cover how to test for firewall issues. Finally we’ll discuss why SQL Server is blamed for dropping its connections.
SessionID: 26129
SQL Server Storage Engine under the hood
Event Date: 16-05-2015 - Session time: 09:45:00 - Track: Track 2
Speaker: Thomas Grohser
Title: SQL Server Storage Engine under the hood
Abstract:
How is SQL Server really accessing the data and log files on the disk? What's done asynchronous and what's synchronous and what impact does that have on our queries and DML statements.
Which impact have features like database mirroring and replication, what's different when SQL Server is starting up.
Which I/O Subsystems (including SSD) are best for which type of data and what's the impact if you choose a different one. Which files can be placed on the same volume and which should not.
SessionID: 27647
Level Up: Understanding Azure's SQL Database Service Tiers
Event Date: 16-05-2015 - Session time: 09:45:00 - Track: Track 3
Speaker: Warner Chaves
Title: Level Up: Understanding Azure's SQL Database Service Tiers
Abstract:
As part of Microsoft's aggressive cloud strategy, the SQL Database as a service has been getting new releases and new features at a rapid pace.
The biggest change so far has been the introduction of three service tiers: Basic, Standard and Premium.
Gone is the pay for database size system and it has been replaced by a system where we also pay for the performance characteristics and recovery features of our database.
Come learn the differences between the tiers, measuring performance and how to optimize the use of your cloud SQL power.
SessionID: 9010
XML Without Xanax: How to Handle XML in SQL Server
Event Date: 16-05-2015 - Session time: 09:45:00 - Track: Track 7
Speaker: Adam Belebczuk
Title: XML Without Xanax: How to Handle XML in SQL Server
Abstract:
Do you cringe whenever you have to look at an XML document? Does the very thought of XML data living in your database make you scream? Do you have a panic attack any time you have to parse XML? If you answered yes to any of these questions, then this session is for you!
We'll start with reasons why having XML in SQL Server might be a good thing, then we'll face our fears and turn tabular data into XML, and finally we'll confront the true source of our anxiety by parsing XML back into tabular data using xQuery.
If you survive this session, you'll have faced your fears about XML in SQL Server, you'll have a solid understanding of creating XML from tabular data, and you'll know how to use xQuery to parse XML.
SessionID: 11286
Hacking Exposé - Using SSL to Protect SQL Connections
Event Date: 16-05-2015 - Session time: 11:00:00 - Track: Track 3
Speaker: Chris Bell
Title: Hacking Exposé - Using SSL to Protect SQL Connections
Abstract:
Are you someone (A DBA, Developer, etc) that connects to SQL Server to use data?
You probably hear a lot about how protected your database can be when at rest. But what about when you connect to SQL and start running some queries?
Using a simple hacking technique we will dig into some packets on our network and see what's in them. You may be shocked! Then we will create a self-signed SSL certificate, use it to encrypt our connections on the SQL Server, and see the actual changes in the packet as hackers would.
*Warning - do not try some of these demos at work without proper permissions as hacking techniques are used.
SessionID: 13745
SQL Server and Networking High Availability/Disaster Recovery Best Practices
Event Date: 16-05-2015 - Session time: 11:00:00 - Track: Track 6
Speaker: Edwin M Sarmiento
Title: SQL Server and Networking High Availability/Disaster Recovery Best Practices
Abstract:
Do you think you can handle Failover Clustering and Availability Groups? Think again. Your job description as a SQL Server DBA has just changed. In this demo-centric session, you’ll see how networking aspects such as Active Directory and DNS play very important roles when implementing a SQL Server high availability and disaster recovery (HA/DR) solution. You will want to be confident enough to have a conversation with your Domain Administrator to make sure your SQL Server databases meet their recovery objectives and service level agreements.
SessionID: 14202
APPLY Yourself
Event Date: 16-05-2015 - Session time: 11:00:00 - Track: Track 5
Speaker: Kevin Feasel
Title: APPLY Yourself
Abstract:
SessionID: 14545
SQL Server 2014 New Features
Event Date: 16-05-2015 - Session time: 11:00:00 - Track: Track 1
Speaker: George Walters
Title: SQL Server 2014 New Features
Abstract:
SQL Server 2014 will have a number of new features to help with specific situations in OLTP and OLAP queries. In-Memory tables and queries, SSD Buffer Pool, Columnstore Indexing, and AlwaysOn Improvements will be covered
SessionID: 16999
Software as a service
Event Date: 16-05-2015 - Session time: 11:00:00 - Track: Track 4
Speaker: John Miner
Title: Software as a service
Abstract:
Abstract:
Are you tired of installing, configuring and patching Microsoft SQL Server? Microsoft Azure SQL database maybe a way to
move some of your infrastructure to the cloud. Depending upon your companies philosophy, it might be great for development,
testing, and possibly production environments.
The exciting thing about this service is that new features will be released on this platform first before trickling down
to the on-premise editions.
Coverage:
1 - The Azure Portal
2 - Identifying your database server
3 - Adding IP Rules for clients
4 - Capturing a connection string
5 - Using SSMS and/or SQLCMD for development
6 - Creating a database from TSQL
7 - Executing CRUD statements
8 - Migrating old database using wizard
9 - What SQL Azure database still lacks.
SessionID: 19692
The BI Power Hour
Event Date: 16-05-2015 - Session time: 11:00:00 - Track: Track 2
Speaker: Markus Ehrenmueller-Jensen
Title: The BI Power Hour
Abstract:
Imagine a world in that end-user can collect data from your data warehouse, from operational databases, flat files, excel files and even external data sources like a web page or a data market. Imagine that those users can cleanse the data by themselves, manage calculations, and refresh the data through a tool they are already familiar with. Imagine that they also can build nice and crisp interactive reports (tables, charts maps) by just a few mouse clicks or by natural language.
SessionID: 26128
Event Date: 16-05-2015 - Session time: 11:00:00 - Track: Track 2
Speaker: Thomas Grohser
Abstract:
Join Thomas in an almost Powerpoint free session where he shows how to write a reusable code library using TSQL, stored procedures, tables and functions and shows how to integrate it into multiple database projects with a few mouse clicks.
He will also share Tips and Tricks for using Visual Studio more effective.
SessionID: 35926
Getting Started with MDX
Event Date: 16-05-2015 - Session time: 11:00:00 - Track: Track 7
Speaker: William E Pearson III
Title: Getting Started with MDX
Abstract:
In this session, led by Microsoft BI Architect and SQL Server MVP Bill Pearson, we will concentrate largely upon crafting simple MDX expressions and queries whose purposes, for the most part, are to return a set of data. We will overview the structure of a cube, using as a basis the sample Adventure Works cube that is available to anyone installing SQL Server Analysis Services 2008 R2. We will then outline the components of simple MDX syntax, and get started writing basic expressions and queries. We will expose basic member functions, introduce filters (or “slicers”), and begin exploring core MDX functionality, including calculated members, and named sets. This session applies equally to Analysis Services 2008, 2008R2 and 2012.
SessionID: 13746
Event Date: 16-05-2015 - Session time: 13:30:00 - Track: Track 6
Speaker: Edwin M Sarmiento
Abstract:
SessionID: 13861
(a Few of) My Favorite DMVs
Event Date: 16-05-2015 - Session time: 13:30:00 - Track: Track 7
Speaker: Edward Pollack
Title: (a Few of) My Favorite DMVs
Abstract:
We will dig into some of the most useful DMVs available and review some real-world code examples that illustrate what they can do for you.
SessionID: 14203
Much Ado About Hadoop
Event Date: 16-05-2015 - Session time: 13:30:00 - Track: Track 5
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: 14547
SQL Server AlwaysOn Availability Groups
Event Date: 16-05-2015 - Session time: 13:30:00 - Track: Track 2
Speaker: George Walters
Title: SQL Server AlwaysOn Availability Groups
Abstract:
Need HA and DR? Tired of Mirroring or Log Shipping restrictions? Reporting queries slowing down your production system? The AlwaysOn Availability Groups feature is a high-availability and disaster-recovery solution, which is an enterprise-level alternative to database mirroring. How, and why to use this will be covered.
SessionID: 17014
Basic Database Design
Event Date: 16-05-2015 - Session time: 13:30:00 - Track: Track 1
Speaker: John Miner
Title: Basic Database Design
Abstract:
Abstract:
You just found out that a client needs a SQL database to be designed from scratch. However, you existing DBA has given two week notice.
This presentation is meant for the Accidental DBA that has little to no experience with creating a database from the group up.
Topics are focused on data storage structures, security, and integrity.
After this presentation, will be ready to meet that clients need.
Coverage:
1 - Files File Groups
2 - Logins Users
3 - Security using schemas
4 - Database roles for access.
5 - Table design via SSMS or TSQL.
6 - Default, Check, and NULL constraints
7 - Handling table relationships (PK vs FK).
8 - To index or not to index?
9 - Testing database integrity using DML.
SessionID: 19690
Event Date: 16-05-2015 - Session time: 13:30:00 - Track: Track 2
Speaker: Markus Ehrenmueller-Jensen
Abstract:
SessionID: 35625
The Quest for the Golden Record: MDM Best Practices
Event Date: 16-05-2015 - Session time: 13:30:00 - Track: Track 4
Speaker: Brian Benzel
Title: The Quest for the Golden Record: MDM Best Practices
Abstract:
In this session, we will focus on how to formulate a Master Data Management (MDM) strategy and build a solution to find the single version of the truth, aka the Golden Record. While these techniques can apply to any domain, we will demonstrate building a sample customer domain in this session, showing how to leverage SQL Server Master Data Services(MDS) and other tools for data quality, matching, and de-duplication across multiple data sources.
SessionID: 11681
Rethink Your ETL with BIML
Event Date: 16-05-2015 - Session time: 14:45:00 - Track: Track 4
Speaker: Chris Schmidt
Title: Rethink Your ETL with BIML
Abstract:
SessionID: 12603
Right-Sizing Your SQL Server Virtual Machine
Event Date: 16-05-2015 - Session time: 14:45:00 - Track: Track 6
Speaker: David Klee
Title: Right-Sizing Your SQL Server Virtual Machine
Abstract:
The methods for understanding the performance of your mission-critical SQL Servers gathered over the past ten years of SQL Server virtualization will be addressed, and valuable processes for performance statistic collection and analysis will be displayed. Come learn how to properly ‘right-size’ the resources allocated to a VM, improve the performance of your SQL Servers, and keep it maximized well into the future.
SessionID: 13334
The usual SUSPECTs: When good databases go bad.
Event Date: 16-05-2015 - Session time: 14:45:00 - Track: Track 3
Speaker: David Maxwell
Title: The usual SUSPECTs: When good databases go bad.
Abstract:
You just restarted SQL Server, but some of your databases aren't coming online. Maybe
you see a database marked SUSPECT, or RECOVERY PENDING. What do you do? In this session
we'll cover the various states that a database can be in, how they get into those states, and
learn the proper techniques to bring your data safely back online.
SessionID: 15621
What exactly is big data and why should I care?
Event Date: 16-05-2015 - Session time: 14:45:00 - Track: Track 7
Speaker: James Serra
Title: What exactly is big data and why should I care?
Abstract:
You may understand what a data warehouse is, but what is big data? And why should I care about it? How will it help me? I’ll talk about the things to look at to understand if you have big data, and cover those buzz words you may have heard but don’t know what they mean (data scientist, Hadoop, Internet of Things, data lake, modern data warehouse). I’ll also give examples of how big data is making companies make better business decisions.
SessionID: 18081
Transactional Replication: Architecture, Setup, and Monitoring
Event Date: 16-05-2015 - Session time: 14:45:00 - Track: Track 5
Speaker: Kendal Van Dyke
Title: Transactional Replication: Architecture, Setup, and Monitoring
Abstract:
At some point in every DBA's career they'll be probably be asked to work with transactional replication. While it may seem scary at first, it's not that complicated once you understand how all the parts and pieces work together. In this session we'll cover the fundamentals of how transactional replication works, walk through setting up a working replication topology, and learn how to keep an eye on things to make sure everything is working properly.
Session Goals:
• Understand core concepts of transactional replication including: replication topologies, publishers, distributors, agents, agent profiles.
• Learn how to configure a working replication topology
• Learn how to how to monitor transactional replication performance
SessionID: 18448
Introduction to Window Functions
Event Date: 16-05-2015 - Session time: 14:45:00 - Track: Track 2
Speaker: Kathi Kellenberger
Title: Introduction to Window Functions
Abstract:
This session will teach you how to avoid cursor solutions, and create simpler code by using the window functions that have been introduced between 2005 and 2012. You'll learn how to use the new functions and how to apply them to several design patterns that are commonly found in the real world.
SessionID: 19846
Getting started with SSIS
Event Date: 16-05-2015 - Session time: 14:45:00 - Track: Track 1
Speaker: Matt Nelson
Title: Getting started with SSIS
Abstract:
SessionID: 12604
The Many Paths of Consulting
Event Date: 16-05-2015 - Session time: 16:00:00 - Track: Track 6
Speaker: David Klee
Title: The Many Paths of Consulting
Abstract:
People often dream of becoming a consultant, but what does that actually mean? Is consulting really the right path for you? Many choices are available when deciding to become a consultant, but these options can be overlooked. Contracting, consulting for an established team, going out on your own, or looking to build a larger business are all great options, depending on your vision and future goals.
This session will help you ask the right questions to better chose and prepare for your path. We then explore the various realities and strategies of each path. Real-life experiences will be shared to help you make the most informed decision on which path is best for you, and how to accelerate your career as a consultant.
SessionID: 13333
DBA 911 - Database Corruption
Event Date: 16-05-2015 - Session time: 16:00:00 - Track: Track 3
Speaker: David Maxwell
Title: DBA 911 - Database Corruption
Abstract:
SessionID: 13864
Query Optimization Crash Course
Event Date: 16-05-2015 - Session time: 16:00:00 - Track: Track 1
Speaker: Edward Pollack
Title: Query Optimization Crash Course
Abstract:
Do you have users complaining that applications are running "too slow"? Do your DB traces look like a short story written by monkeys at typewriters?
This is a fun, fast-paced walkthrough of the most effective strategies for query tuning. We'll investigate the most common causes of sub-optimal queries (and some quite unusual ones) while building a foundation for solving any optimization problem that the application throws your way!
SessionID: 15620
How does Microsoft solve Big Data?
Event Date: 16-05-2015 - Session time: 16:00:00 - Track: Track 7
Speaker: James Serra
Title: How does Microsoft solve Big Data?
Abstract:
SessionID: 18082
Transactional Replication: Tuning and Troubleshooting
Event Date: 16-05-2015 - Session time: 16:00:00 - Track: Track 5
Speaker: Kendal Van Dyke
Title: Transactional Replication: Tuning and Troubleshooting
Abstract:
At some point in every DBA's career they'll be probably be asked to work with transactional replication but most DBAs don't look under the covers once they're done walking through the setup wizards. In this session we'll take a deeper look at setting up, monitoring, and calibrating transactional publications plus share some tricks and tips gleaned from years of experience working with high volume, multiple datacenter topologies.
Session Goals:
• Learn how to baseline performance metrics by gleaning information from the distribution database
• Show how to tune replication agent performance with agent profiles
• Demonstrate advanced troubleshooting techniques to apply when problems occur
SessionID: 18449
Event Date: 16-05-2015 - Session time: 16:00:00 - Track: Track 2
Speaker: Kathi Kellenberger
Abstract:
SessionID: 19847
Building dynamic SSIS packages for more flexibility
Event Date: 16-05-2015 - Session time: 16:00:00 - Track: Track 4
Speaker: Matt Nelson
Title: Building dynamic SSIS packages for more flexibility
Abstract:
After building a handful of SSIS packages, you probably want to have more flexibility to make the package execution more dynamic. In this session, we will learn how to use variables, expressions, and loops to do things like: extract data to a file with today's date in the file name, load all files in a directory at the same time, and loop through a set of servers to gather data. For this session, you should already be familiar with how to create SSIS packages to load data from flat files and extract data to flat files.