Nr: 441
SQLSaturday #441 - Denver 2015
Start Time (24h) |
Speaker |
Track |
Title |
09:00:00 |
Lance Tidwell |
Application Database Development |
Parameter Sniffing the Good and the Bad |
09:00:00 |
Reeves Smith |
BI Platform Architecture, Development Administration |
Data Integration with Master Data Services |
09:00:00 |
Todd Kleinhans |
Professional Development |
The Life Cycle of a Query in VR |
09:00:00 |
Jason Kassay |
Enterprise Database Administration Deployment |
Getting Started with Execution Plans |
09:00:00 |
Shannon Holck |
BI Information Delivery |
Power BI Desktop - Intro |
09:00:00 |
Wendy Pastrick |
Enterprise Database Administration Deployment |
Transactional Replication 101 |
10:10:00 |
Michael Sexton |
BI Platform Architecture, Development Administration |
The Augean Stables: Data Cleansing in the Modern Enterprise |
10:10:00 |
Chris Shaw |
Enterprise Database Administration Deployment |
Tips for SQL Server Performance and Resiliency |
10:10:00 |
Jason Horner |
BI Platform Architecture, Development Administration |
Dimensional Modeling Design Patterns: Beyond Basics |
10:10:00 |
Carlos Bossy |
BI Information Delivery |
Use Hive and Hadoop for High Performance Data Warehousing |
10:10:00 |
Melody Zacharias |
Application Database Development |
Distributed Replay: Testing With Your Data, Your Way! |
10:10:00 |
Andre DuBois |
Enterprise Database Administration Deployment |
15 Things to ensure survivability of your database |
11:20:00 |
Chris Hyde |
BI Information Delivery |
Row-Based Security in SSRS and SSAS |
11:20:00 |
Keith Tate |
Enterprise Database Administration Deployment |
Profiler is Dead! Long Live Extended Events! |
11:20:00 |
Russ Thomas |
Professional Development |
Stress Inoculation: Maintaining Performance Under Pressure |
11:20:00 |
Leslie Weed |
BI Platform Architecture, Development Administration |
Source Control practices for your BI World |
11:20:00 |
Eric Peterson |
Enterprise Database Administration Deployment |
Very Large Databases in your future |
11:20:00 |
Amy Herold |
Enterprise Database Administration Deployment |
Deadlock, Block Two Smoking Barrels: Breaking Down Blocking and Deadlocks |
12:30:00 |
John McAllister |
BI Platform Architecture, Development Administration |
Accelerate SQL Server Master Data Services with Profisee Maestro |
12:30:00 |
Trent Sherman |
Enterprise Database Administration Deployment |
Advanced Performance Tuning Tips with Database Performance Analyz |
12:30:00 |
Bob Pusateri |
Application Database Development |
Keeping Your SQL Under Control: Version Controlling Your Database |
12:30:00 |
Matt White |
BI Information Delivery |
Light up your SQL investment with Pyramid Analytics |
12:30:00 |
Kevin Cox |
BI Platform Architecture, Development Administration |
Modern BI Solutions based on Lambda Architecture |
13:30:00 |
Ginger Grant |
BI Information Delivery |
Predicting the future with Machine Learning |
13:30:00 |
Michelle Poolet |
Enterprise Database Administration Deployment |
An Unexpected Journey: SQL Server 2000 to 2014 |
13:30:00 |
Tim Gorman |
Enterprise Database Administration Deployment |
Accelerating DevOps Using Data Virtualization |
13:30:00 |
Meagan Longoria |
BI Platform Architecture, Development Administration |
Building your ETL Framework with BIML |
13:30:00 |
Michael Fal |
Enterprise Database Administration Deployment |
SQL Server Benchmarking: The Powershell Speedometer |
13:30:00 |
TJay Belt |
Application Database Development |
Hadoop, and Hive, and Json and Data! Oh my! |
14:40:00 |
Marc Beacom |
BI Platform Architecture, Development Administration |
Getting started with Dimensional Modeling |
14:40:00 |
Justin Hudnall |
BI Information Delivery |
Abstraction Techniques for SQL Server Reporting Services |
14:40:00 |
Glenn Berry |
Enterprise Database Administration Deployment |
Analyzing I/O Subsystem Performance |
14:40:00 |
Bob Pusateri |
Enterprise Database Administration Deployment |
SQL Server Security Basics |
14:40:00 |
Jeff Renz |
Application Database Development |
Introduction to Microsoft Azure DocumentDB |
14:40:00 |
Hope Foley |
BI Platform Architecture, Development Administration |
Don't Rely on Magic - Tabular Performance Troubleshooting |
15:50:00 |
Phillip Labry |
BI Information Delivery |
Exploring the BI Universe |
15:50:00 |
David Klee |
Enterprise Database Administration Deployment |
Achieving Peak Performance from your Virtual SQL Servers |
15:50:00 |
Konstantin Melamud |
Enterprise Database Administration Deployment |
Performance Tuning: Index Optimization |
15:50:00 |
Bill Fellows |
BI Platform Architecture, Development Administration |
2014 SSIS Project Deployment Model: Deployment and Maintenance |
15:50:00 |
Rick Lowe |
Enterprise Database Administration Deployment |
Why should I care about the plan cache? |
15:50:00 |
Andy Vold |
Application Database Development |
Develop your Database using “Database Projects” from SQL Server Data Tools |
SessionID: 36779
Parameter Sniffing the Good and the Bad
Event Date: 19-09-2015 - Session time: 09:00:00 - Track: Application Database Development
Speaker: Lance Tidwell
Title: Parameter Sniffing the Good and the Bad
Abstract:
SessionID: 38998
Data Integration with Master Data Services
Event Date: 19-09-2015 - Session time: 09:00:00 - Track: BI Platform Architecture, Development Administration
Speaker: Reeves Smith
Title: Data Integration with Master Data Services
Abstract:
Master Data Services (MDS) enables the management of non-transactional data that defines business entities within the enterprise. Get a good business and technical understanding of how MDS can help obtain better business clarity across the organization through a Data Governance strategy. Data Governance is a methodology that represents quality, policies, and process management, in relation to handling your enterprise data.
The session will demonstrate the architecture of a Master Data Management solution and the data integration required to implement it within the enterprise.
In this session, you will learn:
- A brief introduction to Master Data Management and Data Governance
- Master Data Management staging architecture
- Data integration with the entity-based staging tables
- Batch processing to move data in the MDS specific tables
- Publishing data to external systems with subscription views and web services
SessionID: 39203
The Life Cycle of a Query in VR
Event Date: 19-09-2015 - Session time: 09:00:00 - Track: Professional Development
Speaker: Todd Kleinhans
Title: The Life Cycle of a Query in VR
Abstract:
Have you ever wondered what really happens behind the scenes when you execute a query? In this unique demonstration, Todd will use a video game engine (Unreal Engine 4) and will dramatically show The Life Cycle of a Query in VR. We will follow a query from beginning to end and "runthrough" the various SQL Server components all queries must use including the Protocol Layer, Relational Engine, Storage Engine, Buffer Pool and then back out to the client. A volunteer at the end will then don an Oculus Rift DK2 Virtual Reality headset and then race through the sections in under a minute to win a prize. Participants will leave with a better understanding of the major components and with a conceptual framework to explore the components more in-depth.
SessionID: 39302
Getting Started with Execution Plans
Event Date: 19-09-2015 - Session time: 09:00:00 - Track: Enterprise Database Administration Deployment
Speaker: Jason Kassay
Title: Getting Started with Execution Plans
Abstract:
There are times when you are able to be proactive and tune existing queries. Sometimes, you will receive a phone call from your manager telling you that a certain web page or report is timing out and your users are furious. You need to quickly diagnose what the problem is. Where do you turn to first? When a query is underperforming, hogging resources or timing out, one of the first things you want to examine is the query execution plan. An execution plan provides a wealth of information that can help you quickly diagnose what is wrong. In this beginner level session you will learn what an execution plan is, how to find it, and how to interpret it to see what the query optimizer is doing and find the major pain points.
SessionID: 39306
Power BI Desktop - Intro
Event Date: 19-09-2015 - Session time: 09:00:00 - Track: BI Information Delivery
Speaker: Shannon Holck
Title: Power BI Desktop - Intro
Abstract:
SessionID: 40324
Transactional Replication 101
Event Date: 19-09-2015 - Session time: 09:00:00 - Track: Enterprise Database Administration Deployment
Speaker: Wendy Pastrick
Title: Transactional Replication 101
Abstract:
Replication simplified! Learn the basic parts that make up replication, what tools are included to help you along plus a look into monitoring. We will cover the players in the game: Pubishers, Subscribers and Distributors, then delve into the data delivery process with Publications, Subscriptions and Articles, finishing up with the Log Reader and how to make sure everything is working and running smoothly.
SessionID: 36777
The Augean Stables: Data Cleansing in the Modern Enterprise
Event Date: 19-09-2015 - Session time: 10:10:00 - Track: BI Platform Architecture, Development Administration
Speaker: Michael Sexton
Title: The Augean Stables: Data Cleansing in the Modern Enterprise
Abstract:
Unfortunately we’ve only seen this ideal in textbooks and sample databases designed by vendors.
The databases we see in the real world are… less than ideal shall we say. Of course, we use other phrases for what we see but human resources frowns on such terms and this is, after all, a family friendly presentation.
Database professionals in Greece circa 600 BCE may have access to the Alpheus and Peneus rivers to cleanse their particular stables but we modern folks need to rely on the tools on our own computers such as SQL and SSIS. Mike will review various techniques and tools for data cleansing that will help you wash away the muck to get to the data gold standard.
SessionID: 36786
Event Date: 19-09-2015 - Session time: 10:10:00 - Track: Enterprise Database Administration Deployment
Speaker: Chris Shaw
Abstract:
After working 20 years in the industry on hundreds of SQL Servers clear patterns emerge. These observations of patterns and best practices directly relate to the health of the server.#160; During this session we will review the patterns of healthy SQL Servers and identify unhealthy behavior that clearly shows servers that are at risk.#160;
We will review shared patterns, configuration and practices.#160;#160; Which of these repeating patterns represent healthy Servers and which of these patterns are#160; shared with servers that are having issues daily.#160;
These patterns are so clear in fact that I many SQL Servers will benefit from the application of at least one if not more of the tips we will cover.#160; At the end of this session attendees will have the tools to identify and correct common issues that impact SQL Servers Performance and Resiliency.
SessionID: 38497
Dimensional Modeling Design Patterns: Beyond Basics
Event Date: 19-09-2015 - Session time: 10:10:00 - Track: BI Platform Architecture, Development Administration
Speaker: Jason Horner
Title: Dimensional Modeling Design Patterns: Beyond Basics
Abstract:
Dimensional modeling is arguably one of the most important
fundamentals of business intelligence. It is still relevant even as
new technologies like PowerPivot and SSAS Tabular Models are becoming
more popular. Correctly modeling your organization's data not only
protects the most important asset your company has but ensures that
your data mart or data warehouse will be responsive and capable of
accommodating emerging requirements.
This session provides a deeper dive into
the art of dimensional modeling. We will look at the different types of fact tables and dimension tables, how and when to use them. We will also some approaches to creating rich hierarchies that make reporting a snap. Finally we will cover physical design choices.This case study and demo based session promises to be very interactive and engaging, bring your toughest Dimensional Modeling quandaries.
SessionID: 39152
Event Date: 19-09-2015 - Session time: 10:10:00 - Track: BI Information Delivery
Speaker: Carlos Bossy
Abstract:
Big Data has moved beyond the hype and entered the mainstream as a tool for managing large and unstructured data sets, giving data architects more options for managing data. The Hadoop ecosystem has become the tool of choice and Microsoft has entered this arena with HDInsight in the cloud. For DBAs this means having a place to store data that can be accessed using a highly parallel framework. In this session you’ll see how to use the numerous tools available to store data in Hadoop, process it, manage it, and retrieve it. We’ll explore Sqoop and how its many options can be configured to import data by taking advantage of Hadoop’s massive parallelism. We will develop and run Map\Reduce code, with an emphasis on understanding what belongs in a mapper function versus what belongs in a reducer function, while demonstrating Hadoop Streaming with languages such as R and C#. Finally, Hive will be shown to exhibit the use of a high-level query language in Hadoop for those who prefer SQL.
SessionID: 39162
Distributed Replay: Testing With Your Data, Your Way!
Event Date: 19-09-2015 - Session time: 10:10:00 - Track: Application Database Development
Speaker: Melody Zacharias
Title: Distributed Replay: Testing With Your Data, Your Way!
Abstract:
SessionID: 39294
15 Things to ensure survivability of your database
Event Date: 19-09-2015 - Session time: 10:10:00 - Track: Enterprise Database Administration Deployment
Speaker: Andre DuBois
Title: 15 Things to ensure survivability of your database
Abstract:
Survivability of data should be the #1 priority for any database administrator. Corruption can happen to any database at any time. How soon corruption is detected and a quick response is key to minimize lost data and recovery in a timely manner. Have a plan ready when it happens, as this is one time you don’t want to “learn on the job”. In addition to daily and monthly maintenance that should be performed, other topics discussed will include e-mail notification when data becomes corrupt and Service Level Agreements.
SessionID: 36771
Row-Based Security in SSRS and SSAS
Event Date: 19-09-2015 - Session time: 11:20:00 - Track: BI Information Delivery
Speaker: Chris Hyde
Title: Row-Based Security in SSRS and SSAS
Abstract:
It is relatively straight-forward to grant a user access to a particular SSRS report, multi-dimensional cube, or tabular model table, but what happens when the user needs access to the object but should be denied access to view certain rows of data? In this session we'll investigate a real-world solution to this common BI problem.
SessionID: 38197
Profiler is Dead! Long Live Extended Events!
Event Date: 19-09-2015 - Session time: 11:20:00 - Track: Enterprise Database Administration Deployment
Speaker: Keith Tate
Title: Profiler is Dead! Long Live Extended Events!
Abstract:
That new tool is Extended Events (XE). Not only has it replaced Profiler, and can be used to capture information on all new features, but it is a substantially better tool!
In this session we will discuss the architecture of Extended Events, how to setup a new trace from scratch or convert an existing Profiler trace, and the new abilities that never existed in Profiler. We will also cover the difference in overhead cost of Profiler and Extended Events.
Profiler was a friend of mine, but it is time to embrace the new king!
SessionID: 38740
Stress Inoculation: Maintaining Performance Under Pressure
Event Date: 19-09-2015 - Session time: 11:20:00 - Track: Professional Development
Speaker: Russ Thomas
Title: Stress Inoculation: Maintaining Performance Under Pressure
Abstract:
Stress is a natural reaction to demanding events for which our natural resources to cope or react are low. Initial effects might be increased energy and focus but can quickly give way to inaction and costly mistakes.
This course presents a variety of simple yet highly actionable techniques borrowed from some of the most stressful fields on earth. In this course, you learn to apply the same methods that doctors, military, law enforcement, and paramedics learn to cope and perform under high-stress situations. Discover how easily these techniques translate to almost any career or endeavor.
Whether you regularly support a multi-million dollar data center on a 24-hour on-call rotation or are asked to restore production while three levels of management look over your shoulder, counting the dollars lost per minute, everyone is susceptible to stress. Some people just have a higher immunity. Attend this inoculation session and get caught up on your boosters.
SessionID: 39190
Source Control practices for your BI World
Event Date: 19-09-2015 - Session time: 11:20:00 - Track: BI Platform Architecture, Development Administration
Speaker: Leslie Weed
Title: Source Control practices for your BI World
Abstract:
SessionID: 39238
Very Large Databases in your future
Event Date: 19-09-2015 - Session time: 11:20:00 - Track: Enterprise Database Administration Deployment
Speaker: Eric Peterson
Title: Very Large Databases in your future
Abstract:
Your databases may not be terabyte-sized yet, but they're probably growing every day. We'll look at lessons learned
from working with multi-terabyte, very large databases (VLDBs) in the real world. Topics include storage layout
decisions, unique tuning challenges, HA/DR implications, and database restores, along with shoehorning backups, re-
indexing and DBCC checks into itty-bitty maintenance windows. As a bonus, many of the techniques also apply to smaller databases and consolidated servers that run hundreds of databases.
SessionID: 39279
Deadlock, Block Two Smoking Barrels: Breaking Down Blocking and Deadlocks
Event Date: 19-09-2015 - Session time: 11:20:00 - Track: Enterprise Database Administration Deployment
Speaker: Amy Herold
Title: Deadlock, Block Two Smoking Barrels: Breaking Down Blocking and Deadlocks
Abstract:
While blocking and deadlocks are part of the territory for a DBA, dealing with them can be another story. In this session we will break down locking types, capturing and identifying deadlocks and the code behind them, and things you can do to resolve and prevent blocking and deadlocks. If you are frequently dealing with deadlocks in your databases this session is for you.
SessionID: 40663
Accelerate SQL Server Master Data Services with Profisee Maestro
Event Date: 19-09-2015 - Session time: 12:30:00 - Track: BI Platform Architecture, Development Administration
Speaker: John McAllister
Title: Accelerate SQL Server Master Data Services with Profisee Maestro
Abstract:
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: 40675
Event Date: 19-09-2015 - Session time: 12:30:00 - Track: Enterprise Database Administration Deployment
Speaker: Trent Sherman
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. Regardless of the complexity of the statement, this quick, systematic approach will lead you down the correct tuning path.
SessionID: 40689
Keeping Your SQL Under Control: Version Controlling Your Database
Event Date: 19-09-2015 - Session time: 12:30:00 - Track: Application Database Development
Speaker: Bob Pusateri
Title: Keeping Your SQL Under Control: Version Controlling Your Database
Abstract:
Source control isn't just for application development anymore; your database code needs it just as much!
This session will cover the fundamentals of source control systems and how getting your database under version control is an excellent way to collaborate with team members, communicate changes, and keep an audit trail. You'll see how Redgate SQL Source Control makes it incredibly easy and intuitive to maintain your database in nearly any source control system, and how the universe of development pipelines and continuous integration is easily accessible from there.
SessionID: 40691
Light up your SQL investment with Pyramid Analytics
Event Date: 19-09-2015 - Session time: 12:30:00 - Track: BI Information Delivery
Speaker: Matt White
Title: Light up your SQL investment with Pyramid Analytics
Abstract:
SessionID: 40729
Modern BI Solutions based on Lambda Architecture
Event Date: 19-09-2015 - Session time: 12:30:00 - Track: BI Platform Architecture, Development Administration
Speaker: Kevin Cox
Title: Modern BI Solutions based on Lambda Architecture
Abstract:
SessionID: 36804
Predicting the future with Machine Learning
Event Date: 19-09-2015 - Session time: 13:30:00 - Track: BI Information Delivery
Speaker: Ginger Grant
Title: Predicting the future with Machine Learning
Abstract:
Machine Learning is Microsoft’s big entry in to the predictive analytics arena. . In this introductory session we will discuss the growing new field of predictive analytics and how Machine Learning is used to predict future results. Instead of staring into crystal balls, Machine Learning provides the ability to experiment to determine which algorithm or R code best analyzes the data to determine if past performance is indicative of the future or use scoring to find a more appropriate model.
SessionID: 36886
An Unexpected Journey: SQL Server 2000 to 2014
Event Date: 19-09-2015 - Session time: 13:30:00 - Track: Enterprise Database Administration Deployment
Speaker: Michelle Poolet
Title: An Unexpected Journey: SQL Server 2000 to 2014
Abstract:
As a DBA yourself, I’m sure you’ve encountered instances where the SQL Server has been running fine, there’ve been no changes for ages, everything is stable, there’s no exposure to the outside world, and the last time anyone updated or applied a patch to the server was in February 2004… …and then the world intruded, and all of a sudden you’ve been given a directive to “bring that system up to date!” Now what? You’re faced with upgrading not only the SQL Server, but the Windows server as well (and a bunch of other applications), because Microsoft has announced that ALL support for Windows Server 2003 will be going away (far away!) this summer! And some clever person upstairs decided that it would be A GOOD THING to have this SQL Server exposed to the outside…and has commissioned the web dev team to build a whole suite of apps that WILL MAKE THE COMPANY MILLIONS! Where to start…
SessionID: 37813
Accelerating DevOps Using Data Virtualization
Event Date: 19-09-2015 - Session time: 13:30:00 - Track: Enterprise Database Administration Deployment
Speaker: Tim Gorman
Title: Accelerating DevOps Using Data Virtualization
Abstract:
DevOps is the melding of application development, testing, and IT operations. All tasks from infrastructure to coding to testing to transition into production must be automated so that new features and fixes can be continuously delivered.
Constraining DevOps is data. Databases and applications have grown enormous and complex. "Storage is cheap" is a lie. Provisioning a full environment for each developer or tester on each task of each project appears unrealistic, when each might require several terabytes of storage. And so everyone is limited to working in a small handful of shared environments that are refreshed only every few months, and code quality suffers.
Data virtualization is the solution. Virtual databases and file-systems only consume space from deltas, so it is possible to provision multiple terabytes for megabytes. Coders and testers have full environments fast in which to develop and test, improving code quality. Learn about the technical details behind this solution.
SessionID: 37816
Building your ETL Framework with BIML
Event Date: 19-09-2015 - Session time: 13:30:00 - Track: BI Platform Architecture, Development Administration
Speaker: Meagan Longoria
Title: Building your ETL Framework with BIML
Abstract:
SessionID: 38887
SQL Server Benchmarking: The Powershell Speedometer
Event Date: 19-09-2015 - Session time: 13:30:00 - Track: Enterprise Database Administration Deployment
Speaker: Michael Fal
Title: SQL Server Benchmarking: The Powershell Speedometer
Abstract:
SessionID: 40754
Hadoop, and Hive, and Json and Data! Oh my!
Event Date: 19-09-2015 - Session time: 13:30:00 - Track: Application Database Development
Speaker: TJay Belt
Title: Hadoop, and Hive, and Json and Data! Oh my!
Abstract:
Tips and Tricks and Painful lessons learned as I have ventured into the world of Hadoop, JSon and Hive. Our data has made the move from a relational database to a JSon structure, and reporting across the entire enterprise of data has changed. We have introduced Hadoop batch processing to our ETL processes to collect and process data from various locations, depositing them in various other locations. Along the way, various brick walls were surmounted. We will discuss some of these brick walls. Some of the oddities encountered in this journey. and hopefully prepare you for a similar trip, without all the pain we suffered.
SessionID: 36776
Getting started with Dimensional Modeling
Event Date: 19-09-2015 - Session time: 14:40:00 - Track: BI Platform Architecture, Development Administration
Speaker: Marc Beacom
Title: Getting started with Dimensional Modeling
Abstract:
Technology has revolutionized the way organizations run today. Rather than a few file cabinets, organizations use many different software packages and applications that are mission critical to running their business. These systems gather a large amount of valuable data that must be used in decision making to maintain a competitive advantage. However, we've all heard and likely been around when mission critical systems have been rendered useless due to long running reports. To solve this and a host of other source system reporting issues we have proven Data Warehousing techniques to store the data in a report friendly way. Dimensional modeling is one of the most widely used set of techniques that will provide source system relief for reporting. In this session, we will take a look at what Dimensional Modeling is along with some key terms and techniques.
SessionID: 37265
Abstraction Techniques for SQL Server Reporting Services
Event Date: 19-09-2015 - Session time: 14:40:00 - Track: BI Information Delivery
Speaker: Justin Hudnall
Title: Abstraction Techniques for SQL Server Reporting Services
Abstract:
As enterprise Reporting Services solutions mature, maintenance and change requests of existing reports often result in environment inconsistencies and bottleneck new development. Establishing proper abstraction between data and presentation layers can greatly reduce maintenance tasks and ensure development consistency.
In this session we’ll review the following abstraction techniques and how they can ease maintenance burden and promote consistency across your reporting infrastructure.
• Keep SQL within the Database not SSRS
• One size fits all for parameter aliases
• Combine available and default data sets into one procedure
SessionID: 37651
Event Date: 19-09-2015 - Session time: 14:40:00 - Track: Enterprise Database Administration Deployment
Speaker: Glenn Berry
Abstract:
SessionID: 38161
SQL Server Security Basics
Event Date: 19-09-2015 - Session time: 14:40:00 - Track: Enterprise Database Administration Deployment
Speaker: Bob Pusateri
Title: SQL Server Security Basics
Abstract:
The past few years seem to have had more than their fair share of high-profile data breaches, not all of which were caused by sophisticated hacking attempts. This session explains basic methods for securing your SQL Server by making sure you're not leaving the proverbial front door unlocked (or in some cases, wide open). We will discuss the different levels and methods that can be used for granting and restricting rights, and the pros and cons of each. You'll learn steps you can take to design databases with securability in mind from the beginning so you can better protect your data later on down the road. We'll also demonstrate scripts that can help audit user rights and make sure logins don't have any more permissions than they need. Security doesn't have to be scary! Attend this session and gain a solid foundation to build your DBA career on.
SessionID: 39191
Introduction to Microsoft Azure DocumentDB
Event Date: 19-09-2015 - Session time: 14:40:00 - Track: Application Database Development
Speaker: Jeff Renz
Title: Introduction to Microsoft Azure DocumentDB
Abstract:
In this session I will demonstrate how to create a DocumentDB instance in Azure, how to work with JSON documents, create Ad hoc queries with familiar SQL syntax, create application logic as stored procedures, triggers and user defined functions (UDFs) using standard JavaScript.
Goals:
#1 Show how to create validate JSON strings using Notepad++, validate the JSON against a schema using C# Newtonsoft dll. Demonstrate how to work with JSON in SQL Server as a reference on how hard it is to work with JSON when it is not natively stored.
#2 Demo the basics of DocumentDB - Create the database, collections and documents using the web interface. Demo how to perform basic selects, joins and filtering. Review java script basics as java script is fundamental in creating stored procedures
#3 Demo of how to work with DocumentDB in a C# by creating collections, documents and querying the database using lync and SQL syntax.
SessionID: 39283
Event Date: 19-09-2015 - Session time: 14:40:00 - Track: BI Platform Architecture, Development Administration
Speaker: Hope Foley
Abstract:
SessionID: 37095
Exploring the BI Universe
Event Date: 19-09-2015 - Session time: 15:50:00 - Track: BI Information Delivery
Speaker: Phillip Labry
Title: Exploring the BI Universe
Abstract:
Business Intelligence has received a great deal of attention over the last few years and there are numerous, often confusing products, strategies and offerings. With so many technologies to choose from it can be very difficult to decide where to start and what technology is the right fit(or more importantly, the wrong fit). Join Phillip as he guides you through the rapidly expanding BI universe. This session is intended for those curious about BI technology who have limited or no experience with it.
SessionID: 37320
Event Date: 19-09-2015 - Session time: 15:50:00 - Track: Enterprise Database Administration Deployment
Speaker: David Klee
Abstract:
Your SQL Servers are probably virtualized by now, but are they running at their absolute peak performance? How can you tell? When properly configured and maintained, a virtualized SQL Server will be at least as fast as the system that it came from, if not better. If not properly configured, silent performance killers can wreck your virtualization experience. This session will give you tips and tricks to maximize performance while giving you talking points so you can convince your infrastructure engineers to design the virtualization stack your way. This session goes deep into the architecture and methodology for squeezing the best possible performance from your virtualized SQL Server, and includes valuable tips on topics such as host-level over-commitment, storage performance, In-memory OLTP, and more!
SessionID: 38343
Event Date: 19-09-2015 - Session time: 15:50:00 - Track: Enterprise Database Administration Deployment
Speaker: Konstantin Melamud
Abstract:
As our data size grows larger the need for optimal indexing within our databases becomes even more important than before. This session will help you understand how choose appropriate indexes to streamline our DML operations in our enterprise. You will learn the optimal strategy for selecting both clustered and non-clustered indexes in your database. Along the way, we will discuss how column and index statistics can affect the performance in your queries. Finally, we will take a look at the benefits and pitfalls of using filtered, full-text search and composite indexes, their best practices, and exceptions to the rules.
SessionID: 38643
2014 SSIS Project Deployment Model: Deployment and Maintenance
Event Date: 19-09-2015 - Session time: 15:50:00 - Track: BI Platform Architecture, Development Administration
Speaker: Bill Fellows
Title: 2014 SSIS Project Deployment Model: Deployment and Maintenance
Abstract:
The 2014 SQL Server Integration Services (SSIS) Project Deployment Model introduces new opportunities for the delivery of SSIS solutions. Gone are decisions about logging providers, configuration approaches, and deployment targets. Now, you need to focus on the creation of an .ispac, the approaches to deploying the project, and applying configurations to ensure expected behavior.
This session begins by exploring mapping between elements in an SSIS project and their counterparts in the compiled file, the .ispac. The session then covers three approaches for automating the deployment of this unit into SSISDB We then cover the administration side of the SSIS Catalog. You create SSIS environment variables and apply them to configure run-time behaviour. Finally, you work through the native tooling to troubleshoot failed SSIS packages. We'll cover SQL Server Management Studio (SSMS) reports, Catalog views, and data taps for run-time collection of values.
SessionID: 38917
Why should I care about the plan cache?
Event Date: 19-09-2015 - Session time: 15:50:00 - Track: Enterprise Database Administration Deployment
Speaker: Rick Lowe
Title: Why should I care about the plan cache?
Abstract:
SessionID: 39200
Event Date: 19-09-2015 - Session time: 15:50:00 - Track: Application Database Development
Speaker: Andy Vold
Abstract:
SQL Server Data Tools changes traditional database development by introducing a declarative, model-based experience that supports both online and offline (project-based) database development. In this presentation you will learn how to use this tool for either a new or existing database project. We will also highlight and demonstrate key built-in features like refactoring, pre and post deployment scripts, publish, and schema compare.