Nr: 380
SQLSaturday #380 - New York City 2015
SessionID: 10161
Inside the Query Optimizer
Event Date: 30-05-2015 - Session time: 09:15:00 - Track: Other
Speaker: Bradley Ball
Title: Inside the Query Optimizer
Abstract:
When it comes to SQL Server one of the biggest request you hear is “How can I make my Query Run FASTER!?”. The answer understanding the first step in that process Is understanding the Query Optimizer. Understanding the Optimizer beings with knowing the Rules. The way our queries are written reflect directly on the output that we get. In this session we will look at the rules in SQL Server, write queries to show those rules in action, and walk out with a better understanding of how the Optimizer works.
SessionID: 13992
Building ETL Frameworks using SSIS Programming
Event Date: 30-05-2015 - Session time: 09:15:00 - Track: Other
Speaker: Jorge Novo
Title: Building ETL Frameworks using SSIS Programming
Abstract:
SessionID: 14375
Event Date: 30-05-2015 - Session time: 09:15:00 - Track: Other
Speaker: Jean Joseph
Abstract:
SessionID: 14789
Automating Your Database Deployments
Event Date: 30-05-2015 - Session time: 09:15:00 - Track: CI / DevOps / Automation
Speaker: Grant Fritchey
Title: Automating Your Database Deployments
Abstract:
Deploying your database changes to production can be nerve-wracking. We'll discuss methods that take the stress out of the process by ensuring that you practice your deployments using continuous integration before you ever get near production. Automating the deployment and testing processes through various pre-production environments can make the whole experience of production deployments more repeatable, more reliable and more robust.
In this session, we'll explore the concepts of continuous integration and continuous delivery for databases – what to consider, the challenges, the benefits, the testing, and the crucial approval gates necessary for a reliable production deployment. We'll discuss these and other release strategies as you think about how to evolve your deployment pipeline towards a more automated approach, starting with continuous integration and ending at your production systems.
SessionID: 14985
Replication Technologies
Event Date: 30-05-2015 - Session time: 09:15:00 - Track: Other
Speaker: Hilary Cotter
Title: Replication Technologies
Abstract:
SessionID: 17795
Analysis Services Security
Event Date: 30-05-2015 - Session time: 09:15:00 - Track: BI / SSAS / DW
Speaker: Jens Vestergaard
Title: Analysis Services Security
Abstract:
Being able to accomodate the most demanding requirements on security is more important now than ever. This session will take you through a variety of approaches on how to implement basic to complex security on dimensions in SSAS. A quick intro through the GUI will bring us to AMO through PowerShell as the weapon of choice. Different concepts on hierarchy security models will also be demonstrated.
SessionID: 19097
Learning Entity Framework 6
Event Date: 30-05-2015 - Session time: 09:15:00 - Track: Other
Speaker: Leonard Lobel
Title: Learning Entity Framework 6
Abstract:
We’ll begin with a quick introduction to ORM and EF, and then explain many of the special ORM features in EF6, such as the Entity Data Model, and table splitting, inheritance, entity splitting, and many-to-many relationships. With the basics covered, Lenni will then dive right into live demos that show what EF can do for you as a data access layer, using database-first, model-first, and code-first approaches with both direct SQL and stored procedures. We’ll also discuss new features introduced in EF6, and show how to use EF in N-Tier scenarios.
SessionID: 22855
Event Date: 30-05-2015 - Session time: 09:15:00 - Track: CI / DevOps / Automation
Speaker: Regis Baccaro
Abstract:
In this session we are going to focus on the interaction between SSDT and Team Foundation Server. Developing locally and publishing the changes to an on-premises instance of SQL Server. We will look at how we can do continuous integration between development and other environments pushing the schema changes and upgrading the version numbers in a seamless manner upon successful build of the solution.
SessionID: 25768
Introducing the Azure Data Factory
Event Date: 30-05-2015 - Session time: 09:15:00 - Track: Virtualization / Cloud
Speaker: Steve Hughes
Title: Introducing the Azure Data Factory
Abstract:
SessionID: 27521
Extended Properties and how to automate DB Documenting process.
Event Date: 30-05-2015 - Session time: 09:15:00 - Track: SQL Developer
Speaker: Slava Murygin
Title: Extended Properties and how to automate DB Documenting process.
Abstract:
Do you know what Extended Properties are?
Do you use Extended Properties for your database objects?
Do you know how to simplify the process of setting Extended Properties for automated Documenting of your Database?
If any of your answers is "NO" then you have to attend this session.
SessionID: 35683
Basic Monitoring with Perfmon
Event Date: 30-05-2015 - Session time: 09:15:00 - Track: Other
Speaker: Rick Heiges
Title: Basic Monitoring with Perfmon
Abstract:
SessionID: 36551
Event Date: 30-05-2015 - Session time: 09:15:00 - Track: Other
Speaker: Ravi Kumar
Abstract:
SessionID: 14000
Win or lose: predicting customer response using Azure Machine Learning
Event Date: 30-05-2015 - Session time: 10:35:00 - Track: Virtualization / Cloud
Speaker: Kevin Feit
Title: Win or lose: predicting customer response using Azure Machine Learning
Abstract:
SessionID: 15612
Enhancing your career: Building your personal brand
Event Date: 30-05-2015 - Session time: 10:35:00 - Track: Career / Soft Skills
Speaker: James Serra
Title: Enhancing your career: Building your personal brand
Abstract:
In three years I went from a complete unknown to a popular blogger, speaker at PASS Summit, and a SQL Server MVP. Along the way I saw my yearly income triple. Is it because I know some secret? Is it because I am a genius? No! It is just about laying out your career path, setting goals, and doing the work. It's about building your personal brand and stepping out of your comfort zone. It's about overcoming your fear of taking risks. If you can do those things, you will be rewarded. I will discuss how you too can go from unknown to well-known. I will talk about building your community presence by blogging, presenting, writing articles and books, twitter, LinkedIn, certifications, interviewing, networking, and consulting and contracting. Your first step to enhancing your career will be to attend this session!
SessionID: 16706
Event Date: 30-05-2015 - Session time: 10:35:00 - Track: BI / SSAS / DW
Speaker: Jen Underwood
Abstract:
SessionID: 19100
Geospatial Data Types in SQL Server 2012
Event Date: 30-05-2015 - Session time: 10:35:00 - Track: Other
Speaker: Leonard Lobel
Title: Geospatial Data Types in SQL Server 2012
Abstract:
The geospatial capabilities in SQL Server are not only powerful, but easy and fun to use! In this session, Lenni shows you how to integrate location-awareness into your own applications with the geometry and geography data types. We’ll explore the planar and geodetic spatial models, spatial markup languages such as WKT and GML, and then put these concepts to use as we build several useful demos, (e.g., Bing Maps integration). Demos show how to use the geospatial methods to easily calculate area, length, and distance, and project new shapes based on intersection and overlap. Attend this session and embrace spatial programming today!
SessionID: 19565
Lock, Block and Two Smoking Barrels - Inside SQL Server Concurrency
Event Date: 30-05-2015 - Session time: 10:35:00 - Track: Other
Speaker: Mark Broadbent
Title: Lock, Block and Two Smoking Barrels - Inside SQL Server Concurrency
Abstract:
SQL Server is a high performance relational engine and provides a highly scalable database platform but due to its complexity, bad programming practices, poor indexing and configuration can be prone to serious concurrency problems, unexpected behaviors, lost updates and much more! In SQL Server 2005, two optimistic concurrency mechanisms were introduced and touted as the solution to all our problems. Now in SQL Server 2012 and SQL 2014 even more have followed including latch free data-structures, but many challenges and problems still remain. Let’s take a long look into the world of SQL Server concurrency and investigate Pessimistic and Optimistic isolation understanding how they work, when you should use them, and more importantly when they can go very wrong. Don't be staring down the wrong end of SQL Server's two Smoking Barrels and join me for this revealing and thought provoking presentation.
SessionID: 23558
DBA for Dummies
Event Date: 30-05-2015 - Session time: 10:35:00 - Track: Career / Soft Skills
Speaker: Robert Pearl
Title: DBA for Dummies
Abstract:
SessionID: 24435
SQL Server Agent: The life preserver for the drowning DBA
Event Date: 30-05-2015 - Session time: 10:35:00 - Track: Other
Speaker: Lance Tidwell
Title: SQL Server Agent: The life preserver for the drowning DBA
Abstract:
Automation is a key part to becoming a great DBA. Without automation a DBA can start to drown in a sea of repeating tasks. The SQL Server Agent can serve as the much-needed life preserver to pull your head above the water.
In this session you will learn at how to setup the SQL Agent as well as creating jobs and alerts within the agent to help you automate daily, monthly, yearly tasks.
In addition we will look into how to monitor the jobs and alerts created. Lastly we will talk about some common pitfalls to watch out for when dealing with the SQL Server Agent.
SessionID: 26833
Audit Solutions using SQL Azure Database Audit the SQL Server Audit Feature
Event Date: 30-05-2015 - Session time: 10:35:00 - Track: Other
Speaker: Timothy McAliley
Title: Audit Solutions using SQL Azure Database Audit the SQL Server Audit Feature
Abstract:
SessionID: 28342
Version control with GIT for the DBA
Event Date: 30-05-2015 - Session time: 10:35:00 - Track: CI / DevOps / Automation
Speaker: Justin Dearing
Title: Version control with GIT for the DBA
Abstract:
What does this mean to a DBA? Well. whether or not you use SSDT, you should be storing your database schema in version control. In addition, your utility scripts certainly belong in VCS.
In my session. We will cover:
What is version control?
How does a distributed version control system differ from traditional version control like Visual Sourcesafe, TFS, and SVN?
How do I setup git for internal use in my company?
How do I host public and private repositories on github.
How do pull requests work?
How do I fork a SVN repo to github?
We will be covering using git from both the command line and Vis
SessionID: 34763
Accounting Basics for Database Developers
Event Date: 30-05-2015 - Session time: 10:35:00 - Track: Other
Speaker: Mark Frawley
Title: Accounting Basics for Database Developers
Abstract:
Many database developers sooner or later need to consume from or feed data to an accounting application such as the
General Ledger. Not being trained as bookkeepers, we may find bookkeeping conventions confusing at best and mystical at
worst. When is a credit negative, and a debit positive ? The subject also has a reputation for being dull.
But not really understanding the concepts and semantics seriously impedes unit testing, effective communication with the business, and excessive dependence on business analysts as intermediaries. We can do better ! This session will focus on demystifying the concepts and terms, facilitating further study if you are so inclined, and enabling you to understand the requirements and be proactive in testing.
The session will conclude with a brief demo showing how SQL Server's Analysis Services directly supports some bookkeeping concepts.
SessionID: 35595
Efficient table design
Event Date: 30-05-2015 - Session time: 10:35:00 - Track: SQL Developer
Speaker: Alex Grinberg
Title: Efficient table design
Abstract:
SessionID: 35596
Top 10 Clustering Dos and Don'ts
Event Date: 30-05-2015 - Session time: 10:35:00 - Track: Other
Speaker: Allan Hirt
Title: Top 10 Clustering Dos and Don'ts
Abstract:
Clustering SQL Server still vexes many in one way or another. For some, it is even worse now that both AlwaysOn features - clustered instances (FCIs) and availability groups (AGs) - require an underlying Windows Server failover cluster. Storage, networking, Active Directory quorum, and more are topics that come up quite often. Learn from one of the world's experts on clustering SQL Server some the most important items - both good and bad - that you need to do to be successful whether you are creating an FCI, AG, or combining both together in one solution.
SessionID: 35630
Event Date: 30-05-2015 - Session time: 10:35:00 - Track: Other
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: 35714
Flash SQL Server— Re-Thinking Best Practices
Event Date: 30-05-2015 - Session time: 10:35:00 - Track: Other
Speaker: J May
Title: Flash SQL Server— Re-Thinking Best Practices
Abstract:
SessionID: 18127
Autogenerating a process data warehouse
Event Date: 30-05-2015 - Session time: 12:15:00 - Track: Other
Speaker: Kennie Pontoppidan
Title: Autogenerating a process data warehouse
Abstract:
In many data warehouses we model fact tables with measures based on attributes which we can count and do arithmetic upon. It is more difficult to handle fact tables with measures based on length of intervals of events happening in the source systems. So questions like "What are the typical waiting times in our order process?" are seldomly modelled in the data warehouse. Especially if the event data comes from different source systems.
In this talk I will show you how Rehfeld has overcome this difficult problem using an autogenerated datawarehouse based on metadata on the objects in the EDW/DM layers. In this approach you can autogenerate the process data warehouse if only you have the timestamps present in the EDW layer and are able to correlate them. The talk will consist of slides and demos.
SessionID: 37585
Ask the Microsoft Engineer
Event Date: 30-05-2015 - Session time: 12:15:00 - Track: Other
Speaker: Simon Facer
Title: Ask the Microsoft Engineer
Abstract:
Do you have questions about your SQL Server installation? Want to know what a PAGEIOLATCH_EX means? Come along and ask your questions. This is a QA session, we're not going to solve your SQL dumps, but the limit to the questions is the time we have and the areas we cover.
SessionID: 37587
Master Data Management with SQL MDS and Maestro
Event Date: 30-05-2015 - Session time: 12:15:00 - Track: Other
Speaker: Dennis Messina
Title: Master Data Management with SQL MDS and Maestro
Abstract:
SessionID: 37597
SQL 2016... What does it give you?
Event Date: 30-05-2015 - Session time: 12:15:00 - Track: BI / SSAS / DW
Speaker: George Walters
Title: SQL 2016... What does it give you?
Abstract:
SessionID: 37615
E-discovery and kCura - Building an e-discovery community on SQL Server
Event Date: 30-05-2015 - Session time: 12:15:00 - Track: Career / Soft Skills
Speaker: Scott Ellis
Title: E-discovery and kCura - Building an e-discovery community on SQL Server
Abstract:
Scott Ellis discusses big data, e-discovery, entrepreneurship, SQL, and the importance of culture to growth, sustainability, and healthy competition on a field of big players.
SessionID: 13176
The Quest for the Golden Record:MDM Best Practices
Event Date: 30-05-2015 - Session time: 13:05:00 - Track: Other
Speaker: Dennis Messina
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 strategy and build a solution to find the single version of the truth, aka the Golden Record. We will demonstrate building a sample customer domain in this session, showing how to use various tools including MDS for data quality, matching, and deduplication across multiple data sources.
SessionID: 13868
Dynamic SQL: Writing Efficient Queries on the Fly
Event Date: 30-05-2015 - Session time: 13:05:00 - Track: SQL Developer
Speaker: Edward Pollack
Title: Dynamic SQL: Writing Efficient Queries on the Fly
Abstract:
Explore the many uses for dynamic SQL as well as best practices for writing, testing, debugging, and maintaining it, with the bonus of helping to improve the sanity of your coworkers (and your own) in the process!
SessionID: 14791
Execution Plans: What Can You Do With Them?
Event Date: 30-05-2015 - Session time: 13:05:00 - Track: Other
Speaker: Grant Fritchey
Title: Execution Plans: What Can You Do With Them?
Abstract:
SessionID: 17534
Show me whatcha workin' with: Big Data Edition
Event Date: 30-05-2015 - Session time: 13:05:00 - Track: NoSQL / Big Data
Speaker: Josh Luedeman
Title: Show me whatcha workin' with: Big Data Edition
Abstract:
SessionID: 18356
Advanced SQL Server Analysis Services
Event Date: 30-05-2015 - Session time: 13:05:00 - Track: BI / SSAS / DW
Speaker: Kevin Goff
Title: Advanced SQL Server Analysis Services
Abstract:
This session will go well beyond creating SSAS cubes with the cube wizard. I'll cover topics such as the pros and cons of ROLAP, XMLA Processing options, Many to Many Bridge Tables and the use of the DefaultMember and IsAggregatable properties, SSAS Report Actions, Dynamic SSAS Roles with custom MDX code, Advanced MDX in SSRS, Partitioning and Aggregations, Data Driven KPIs, and Dimension Attribute Discretization.
SessionID: 18574
Event Date: 30-05-2015 - Session time: 13:05:00 - Track: SQL Developer
Speaker: Konstantin Melamud
Abstract:
SessionID: 19610
Architecting Real-Time Data Warehouses with SQL Server
Event Date: 30-05-2015 - Session time: 13:05:00 - Track: BI / SSAS / DW
Speaker: Mark Murphy
Title: Architecting Real-Time Data Warehouses with SQL Server
Abstract:
Most data warehouses are scheduled to update periodically, such as once nightly. Others need to be refreshed in real-time, providing business users with up to the minute reports and analytics. This session will review the architecture required to construct a dimensional data warehouse, source it with real-time ETL using Change Data Capture (CDC), and query it efficiently from various reporting tools. It will cover advanced topics such as managing concurrent reads/writes using RCSI, storing real-time aggregates using indexed views, avoiding deadlocks using application locking, and other real-world construction/tuning/maintenance issues inherent in a real-time system.
SessionID: 21812
ETL not ELT! Common mistakes and misconceptions about SSIS
Event Date: 30-05-2015 - Session time: 13:05:00 - Track: Other
Speaker: Paul Rizza
Title: ETL not ELT! Common mistakes and misconceptions about SSIS
Abstract:
SessionID: 22080
Common Coding Mistakes and how to Mitigate them
Event Date: 30-05-2015 - Session time: 13:05:00 - Track: SQL Developer
Speaker: William Wolf
Title: Common Coding Mistakes and how to Mitigate them
Abstract:
There are several programming design patterns that work great in object orientated code that doesn’t scale well inside of SQL Server. In this session we will focus some of these patterns and show you how to make them scale in the database engine. We will touch on Scalar-Value functions, Union, CTE, RBAR and more.
SessionID: 23912
SSIS Data Flow Engine: Under the Hood
Event Date: 30-05-2015 - Session time: 13:05:00 - Track: Other
Speaker: Samuel Vanga
Title: SSIS Data Flow Engine: Under the Hood
Abstract:
A data flow task moves data from point A to point B, but how does it work behind the scenes? Understanding the internals of data flow engine can help you make correct package design choices in the first place and identify issues when your data loads run forever.
Using simple analogies, you'll see how data flow engine moves data through each component, uses buffers, builds execution trees, and transforms data in the pipeline. Along the way, you'll learn corresponding options and tips that make your packages run as fast as possible. This demo-filled session is for SSIS developers who're comfortable with creating packages but not so comfortable figuring out why data flow is slow and when or how to parallelize the data flows. Open the hood, you need to know how data flow engine works to make it
work for you in an efficient and optimal way.
SessionID: 24291
Monster Text Manipulation: Regular Expressions for the DBA
Event Date: 30-05-2015 - Session time: 13:05:00 - Track: SQL Developer
Speaker: Sean McCown
Title: Monster Text Manipulation: Regular Expressions for the DBA
Abstract:
SessionID: 25648
Business Analytics with SQL Server Power Map:Everything you want to know but were afraid to ask
Event Date: 30-05-2015 - Session time: 13:05:00 - Track: BI / SSAS / DW
Speaker: Steve Simon
Title: Business Analytics with SQL Server Power Map:Everything you want to know but were afraid to ask
Abstract:
In the hands-on presentation we shall be constructing a few simple analytic reports (from background financial data). More importantly we shall see how our conclusions help us target new prospective business opportunities.
SessionID: 35824
But it worked great in Dev! Perfomance for Devs
Event Date: 30-05-2015 - Session time: 13:05:00 - Track: SQL Developer
Speaker: Randy Knight
Title: But it worked great in Dev! Perfomance for Devs
Abstract:
If you've ever found yourself stating the above, this session is for you. For many developers, writing T-SQL that works is not the challenge. But too often, functional T-SQL is not the same as good T-SQL. In this session, we will examine why "SQL that works" is not good enough. Understanding indexes, exectuion plans, sargability, and more are all critical to writing good T-SQL. We will also examine several real-world examples of T-SQL that "worked great in dev" but caused major issues when it hit production.
SessionID: 35921
The Life Cycle of a Query in VR
Event Date: 30-05-2015 - Session time: 13:05:00 - Track: Other
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: 15870
Dimensional Modeling Design Patterns: Beyond Basics
Event Date: 30-05-2015 - Session time: 14:25:00 - Track: BI / SSAS / DW
Speaker: Jason Horner
Title: Dimensional Modeling Design Patterns: Beyond Basics
Abstract:
This session will provide 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. This session promises to be very interactive and engaging, bring your toughest Dimensional Modeling quandaries.
SessionID: 16100
Comprehensive Indexing with Automated Execution Plan Analysis
Event Date: 30-05-2015 - Session time: 14:25:00 - Track: Other
Speaker: Joe Chang
Title: Comprehensive Indexing with Automated Execution Plan Analysis
Abstract:
SessionID: 16237
Building Perfect SQL Servers, Every Time
Event Date: 30-05-2015 - Session time: 14:25:00 - Track: CI / DevOps / Automation
Speaker: Joseph D'Antoni
Title: Building Perfect SQL Servers, Every Time
Abstract:
One of the biggest challenges in any large SQL environment is maintaining consistent configurations and meeting the pressures from the business for rapid server deployments. Additionally by default, SQL Server does not install with the best practices for every environment. You will learn best practices for system settings, file system layout and scheduling maintenance tasks. You will learn about what the best practices are for most SQL Server configurations, and how to automate your SQL Server builds in both a physical and virtual world. You will learn about the tradeoffs and benefits to completely automating the build process. You were hear about lessons learned building a private cloud at a Fortune 100 telecommunications company. You will also learn how use these same methods to ensure consistency with your servers whether they are in the cloud, or on-premises.
SessionID: 16504
Introduction to Powershell cmdlets for DBAs
Event Date: 30-05-2015 - Session time: 14:25:00 - Track: Other
Speaker: Jennifer McCown
Title: Introduction to Powershell cmdlets for DBAs
Abstract:
SessionID: 18128
SQL anti patterns
Event Date: 30-05-2015 - Session time: 14:25:00 - Track: SQL Developer
Speaker: Kennie Pontoppidan
Title: SQL anti patterns
Abstract:
You can learn SQL in three days but it'll take you 10 years to become good at it. In this session we will have a look at some basic design errors and get a notion of the things that absolutely doesn't work. Antipatterns is a way of naming common design errors in order to make them easier to remember - even if you haven't done them yet.
We will become acquainted with antipatterns on a physical level, a logical level and an sql-queries and application level, and spice it up with some seriously foolish errors made by me and my colleagues. The session is relevant for developers and DBAs.
SessionID: 18349
T-SQL for Application Developers - Attendees chose
Event Date: 30-05-2015 - Session time: 14:25:00 - Track: SQL Developer
Speaker: Kevin Goff
Title: T-SQL for Application Developers - Attendees chose
Abstract:
That's right, attendees choose! I'll show 30 possible topics on the screen, and the attendees vote on which topics I'll cover. Everything from isolation levels to ranking...everything from GUIDs to table-valued functions....everything from querying temporal data to instances where subqueries are necessary....everything from update triggers to reading execution plans. The good news is that you'll walk away with 30 code samples, even though we'll only cover a portion of them in the presentation. This has always been a very popular session.
SessionID: 20238
Database Virtualization and Drinking out of the Fire Hose
Event Date: 30-05-2015 - Session time: 14:25:00 - Track: Virtualization / Cloud
Speaker: Michael Corey
Title: Database Virtualization and Drinking out of the Fire Hose
Abstract:
A database by its very nature is one of the most resource intensive applications you will ever virtualize. This is even more difficult to do correctly in the context of a virtualized infrastructure that is a shared resource environment. We will look at every possible dynamic to virtualizing a database from Design, Storage, Memory and Network considerations. This presentation is based upon material given at VMworld from a presentation that was in the top 10 out of all presentation given.
SessionID: 24301
Top Ten SQL Server Flameouts- how to detect, fix and avoid them.
Event Date: 30-05-2015 - Session time: 14:25:00 - Track: Other
Speaker: Scott Ellis
Title: Top Ten SQL Server Flameouts- how to detect, fix and avoid them.
Abstract:
In this session. We will discuss and review the top ten most common SQL system outages I've experienced in the last 5 years as a production troubleshooter working with the nations largest law firms and consulting firms.
We will discuss the causes, prevention, rapid diagnosis, monitoring techniques, and the fastest fixes for each. You are troubleshooting a production system and you need tactics and tools.
SessionID: 24812
Querying Active Directory From SSRS To Secure Reports And Enhance The User Experience
Event Date: 30-05-2015 - Session time: 14:25:00 - Track: Other
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: 27645
The Best Practices for Columnstore Indexes
Event Date: 30-05-2015 - Session time: 14:25:00 - Track: Other
Speaker: Warner Chaves
Title: The Best Practices for Columnstore Indexes
Abstract:
SessionID: 35655
SSIS-restart, scale up/out, load balance.
Event Date: 30-05-2015 - Session time: 14:25:00 - Track: Other
Speaker: Daniel Bowlin
Title: SSIS-restart, scale up/out, load balance.
Abstract:
This presentation is a journey through some of the common challenges facing DBAs and SSIS developers: scaling up and/or out to increase throughput, load balancing, recoverability and restartability, basic process auditing, multiple job dependency checking. Next we will review the essential elements to building a framework based on the work pile design pattern that will help resolve many of the issues these challenges may bring. The end goal is a framework that will manage a set of jobs that can recover from common errors, be spread across multiple servers, check load consistency and make sure that nothing runs unless the appropriate upstream data is available.
SessionID: 35692
Basic Database Design
Event Date: 30-05-2015 - Session time: 14:25:00 - Track: SQL Developer
Speaker: John Miner
Title: Basic Database Design
Abstract:
You just found out that a client needs a SQL database to be designed from scratch. However, your existing DBA has given two weeks 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, you will be ready to meet that clients need.
SessionID: 35814
Securing a Multi-Database Applications
Event Date: 30-05-2015 - Session time: 14:25:00 - Track: Other
Speaker: Sebastian Meine
Title: Securing a Multi-Database Applications
Abstract:
It is difficult enough to implement database security when dealing with only a single database. If multiple databases are involved, the task of providing a security model that follows industry best practices seems insurmountable.
In this session, we will do a quick review of access security best practices and then dive into the four different methods a DBA can use to tighten cross database access security. For each one we will walk through a demo and talk about how to implement it in your own environment. We will close the session with a discussion about the advantages and disadvantages of the four methods.
SessionID: 12407
Everything you were afraid to ask about cluster quorums, explained
Event Date: 30-05-2015 - Session time: 15:45:00 - Track: Other
Speaker: David Bermingham
Title: Everything you were afraid to ask about cluster quorums, explained
Abstract:
In this deep dive Cluster MVP Dave Bermingham will take a look at cluster quorum options and how they have evolved over the years. Starting with Disk only quorums and ending with Cloud Witness, by the end of this session you should understand this most commonly misunderstood cluster concept and be ready to tackle your next AlwaysOn Availability Groups deployment or AlwaysOn Failover Cluster Instance implementation. Multisite and SANLess clusters will be discussed as well as the implications of Dynamic Quorum and Dynamic Witness.
SessionID: 13075
DevOps for the DBA - Bridging the Gap Between Infrastructure, Administration, and Development
Event Date: 30-05-2015 - Session time: 15:45:00 - Track: CI / DevOps / Automation
Speaker: Denis McDowell
Title: DevOps for the DBA - Bridging the Gap Between Infrastructure, Administration, and Development
Abstract:
SessionID: 13212
Advanced SSIS Techniques
Event Date: 30-05-2015 - Session time: 15:45:00 - Track: Other
Speaker: David Dye
Title: Advanced SSIS Techniques
Abstract:
As an ETL developer using SQL Server Integration Services have you ever wondered how to:
- Import all .csv files from a folder
- Replace dynamic SQL using variables in SSIS
- How to configure the data flow buffer
- Create custom logging solutions
- Use a script component as a data flow transformation
This session focuses on advanced techniques that are used in SSIS and is meant for the experienced SSIS developer. We will focus on tasks and techniques that are native to SSIS 2005-2014 as well as some of the more advanced and vague properties.
Attendees must have a good working knowledge of SSIS as well as familiarity with VB.NET or C# as some time will be taken looking at extending SSIS with script tasks and components.
Upon completion of this workshop attendees will be able to:
- Import/export multiple sources/destinations
- Use an execute SQL task with variables to replace dynamic SQL within a package
- Dynamically handle errors within any part of a package
SessionID: 14549
SQL Server 2014 New Features
Event Date: 30-05-2015 - Session time: 15:45:00 - Track: Other
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: 15510
Guerilla MDM via MDS/SSIS Implementation
Event Date: 30-05-2015 - Session time: 15:45:00 - Track: Other
Speaker: Ira Warren
Title: Guerilla MDM via MDS/SSIS Implementation
Abstract:
I have implemented at several client. In implementing MDS I have extensive experience in creating data quality, data governance and MDM/MDS accelerators I published many articles.
Accelerators can take many forms generally there either software products that accelerate development and/or techniques that embody data aware and code generation capabilities.
In developing the MDS application extracting data, applying data quality, loading MDS entities, and extracting data from MDS, we have applied these techniques, that I have published articles on.
Specifically we've created an
SSIS/MDS application architecture is highly reusable and can easily be used to Quickstart other MDS projects requiring minimal change and leaving the best practices for MDS architecture, as I understand them. The basic principle we applied this to be a data aware (data profiling)and create SSIS code that will self generate loan pr
SessionID: 17241
How to get Microsoft Certified
Event Date: 30-05-2015 - Session time: 15:45:00 - Track: Career / Soft Skills
Speaker: John Deardurff
Title: How to get Microsoft Certified
Abstract:
This session focuses on what you need to know to get Microsoft Certified on SQL Server. The session is led by an expert Microsoft Certified Trainer (MCT) who regularly teaches the SQL Server certification courses. The presenter walks you through the certifications, exams, and resources available to get you ready for certification.
SessionID: 18597
Azure Big Data Solution – automation of deployment
Event Date: 30-05-2015 - Session time: 15:45:00 - Track: NoSQL / Big Data
Speaker: Kenneth Nielsen
Title: Azure Big Data Solution – automation of deployment
Abstract:
By now you’ve probably heard about Big Data 1.000 times or more so why a new session about big data you might ask.
Show how to make creation and deletion of AZURE elements automatically as part of your ETL process or by Powershell, automate the trivial procedures and work on the interesting parts
This session will show you how :
• Downloads and prepares several years of demo data and storing it in a dedicated Azure Blob Storage account.
• Create a storage account and container for the HDInsight Cluster.
• Create a SQL database server instance and a SQL database for the Hive Metastore. We will also setup the necessary firewall rules so that you can access the server directly.
• The HDInsight cluster is provisioned and configured for access to the sample data.
• A partitioned Hive table is created over top of the sample data
• Exploration of the result
• And how to automate these task either in Powershell or SSIS.
SessionID: 19150
Securing the Cube; SSAS security framework
Event Date: 30-05-2015 - Session time: 15:45:00 - Track: BI / SSAS / DW
Speaker: Daniel Lewandowski
Title: Securing the Cube; SSAS security framework
Abstract:
Secure, Enable, Maintain, Sustain. In depth discussion on SSAS dynamic security and security frameworks and SSIS maintenance toolkits for the cube. Create security roles in the cube that enable the business based on underlying data patterns. Presentation covers theory and demo of roles creation in the cube, dynamic MDX security, creating SSIS roles with a toolkit based on the adventureworks db model and cube and integrated security model. Using integrated security, service accounts and data sources in the presentation layers this we walk through a security model for end-to-end security as can be implemented in sharepoint integrated solutions and/or standalone reports. This presentation provides real world application and an SSIS toolkit to take away and implement in your solutions.
SessionID: 21008
Tips that have saved my bacon
Event Date: 30-05-2015 - Session time: 15:45:00 - Track: Other
Speaker: Greg Moore
Title: Tips that have saved my bacon
Abstract:
SessionID: 26125
Automated Installing and Configuration of SQL2014/SQL2012 AlwaysOn Across Multiple Datacenters
Event Date: 30-05-2015 - Session time: 15:45:00 - Track: CI / DevOps / Automation
Speaker: Thomas Grohser
Title: Automated Installing and Configuration of SQL2014/SQL2012 AlwaysOn Across Multiple Datacenters
Abstract:
The whole process is presented as a live demo
SessionID: 35598
Making the Leap from Developer to DBA
Event Date: 30-05-2015 - Session time: 15:45:00 - Track: Other
Speaker: Amy Herold
Title: Making the Leap from Developer to DBA
Abstract:
You are a Developer (.NET, SQL or otherwise) but you have been doing some DBA work and have now decided that is all you want to do - how do you make the transition? What do you need to know? This session will cover this topic from first-hand experience.
SessionID: 8925
T-SQL : Bad Habits Best Practices
Event Date: 30-05-2015 - Session time: 15:45:00 - Track: SQL Developer
Speaker: Aaron Bertrand
Title: T-SQL : Bad Habits Best Practices
Abstract:
Bad habits: we all have them. SELECT * is the obvious one; but in this session you will learn about various other habits and why they can be bad for performance or maintainability. You will also learn about best practices that will help you avoid falling into some of these bad habits. Come learn how these habits develop, what kind of problems they can lead to, and how you can avoid them - leading to more efficient code, a more productive work environment, and - in a lot of cases – both.