Nr: 390
SQLSaturday #390 - Philadelphia 2015
SessionID: 12412
Everything you were afraid to ask about cluster quorums, explained
Event Date: 06-06-2015 - Session time: 00:00:00 - Track: BI 1
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: 14224
APPLY Yourself
Event Date: 06-06-2015 - Session time: 00:00:00 - Track: Dev 2
Speaker: Kevin Feasel
Title: APPLY Yourself
Abstract:
SessionID: 14991
Replicaton Technologies
Event Date: 06-06-2015 - Session time: 00:00:00 - Track: BI 1
Speaker: Hilary Cotter
Title: Replicaton Technologies
Abstract:
SessionID: 17216
What's your Character Type?
Event Date: 06-06-2015 - Session time: 00:00:00 - Track: Advanced
Speaker: John Deardurff
Title: What's your Character Type?
Abstract:
This session focuses on what you need to know about working with SQL Server Data Types. The session is led by an expert Microsoft Certified Trainer (MCT) who regularly teaches the SQL Server certification courses. The presenter will focus on the differences between character data types, working with implicit vs. explicit conversions and using conversion functions.
SessionID: 18346
Absolute Introductory Session on SQL Server 2014 In-Memory Optimized Databases (Hekaton)
Event Date: 06-06-2015 - Session time: 00:00:00 - Track: BI 1
Speaker: Kevin Goff
Title: Absolute Introductory Session on SQL Server 2014 In-Memory Optimized Databases (Hekaton)
Abstract:
SessionID: 23555
HealthySQL III
Event Date: 06-06-2015 - Session time: 00:00:00 - Track: Advanced
Speaker: Robert Pearl
Title: HealthySQL III
Abstract:
SessionID: 23915
Automating Your SSIS Design Pattern for Faster Development
Event Date: 06-06-2015 - Session time: 00:00:00 - Track: Dev 1
Speaker: Samuel Vanga
Title: Automating Your SSIS Design Pattern for Faster Development
Abstract:
Once you finish designing the SSIS packages needed for your project, the process of creating those packages is mostly redundant and time-consuming. As the source or target systems go through changes (even as small as a column rename), you’re forced to modify the packages.
BI Markup Language (BIML), which is a free plugin, removes the pain-points involved in manual development by programmatically generating packages. In this session, you’ll learn the basics of BIML and see how you can use it along with metadata to create packages automatically. You’ll also see how easy it is to regenerate the packages when the system changes. You’ll leave the session with knowledge of BIML’s building blocks and a principle I call “D[ee]MOB” that helps you automate SSIS development in your environment.
SessionID: 27774
Table Vars Temp Tables - What you NEED to Know!
Event Date: 06-06-2015 - Session time: 00:00:00 - Track: BI 2
Speaker: Wayne Sheffield
Title: Table Vars Temp Tables - What you NEED to Know!
Abstract:
Almost every SQL Developer is familiar with Table Variables and Temporary Tables. While each of these objects represent temporary storage, there are also substantial differences between them. Understanding the differences between Table Variables and Temporary Tables, and the ramifications that those differences cause, is essential to being able to properly select the appropriate object for use in your development tasks. In this code filled session, we’ll discover the differences and similarities of Temporary Tables and Table Variables, dispel some widespread myths about each, and answer the most important questions of them all, "When do I use one or the other and what are the various impacts of doing so?"
SessionID: 35780
Maximizing Failure with Continuous Integration
Event Date: 06-06-2015 - Session time: 00:00:00 - Track: BI 1
Speaker: Mark Wojciechowicz
Title: Maximizing Failure with Continuous Integration
Abstract:
Continuous Integration (CI) is an Agile methodology which enables teams to quickly find bugs in their code and fix them before they reach production. The goal of CI is to always have a working product that can be deployed at any time. Through its practice, developers fail faster and more often than ever before, allowing the developer to fix problems while they are fresh in the mind. This session will cover the basics of CI and show how this can be implemented in a Business Intelligence environment.
SessionID: 10103
To SSAS or not to SSAS, that is the question
Event Date: 06-06-2015 - Session time: 08:30:00 - Track: Dev 1
Speaker: Ayman El-Ghazali
Title: To SSAS or not to SSAS, that is the question
Abstract:
Have you every wondered if you should be using SSAS? Are you curious about learning the basics? Then this is the talk for you! Join us as we explore the basics of Multi-Dimensional and Tabular SSAS solutions. We will connect solutions with Excel and demonstrate how Power View and other data visualizations work. After this session you will feel more comfortable starting your own solutions with SSAS.
SessionID: 14989
Stress testing SQL Server
Event Date: 06-06-2015 - Session time: 08:30:00 - Track: BI 2
Speaker: Hilary Cotter
Title: Stress testing SQL Server
Abstract:
SessionID: 24554
Continuous Integration for Databases
Event Date: 06-06-2015 - Session time: 08:30:00 - Track: BI 1
Speaker: Steve Jones
Title: Continuous Integration for Databases
Abstract:
SessionID: 27651
The Restore Cookbook
Event Date: 06-06-2015 - Session time: 08:30:00 - Track: BI 2
Speaker: Warner Chaves
Title: The Restore Cookbook
Abstract:
How do you restore a database that has lost a file? How do you recover from a lost transaction log? How do you get rid of corruption in the fastest time?
At some point in time, these and other destructive scenarios will happen to your databases. And people will look at you and expect you to react swiftly and confidently.
Come see the scenarios and demos so you'll be prepared with the right ingredients to cook up your RESTORE recipe!
SessionID: 35686
Interviews and Resumes
Event Date: 06-06-2015 - Session time: 08:30:00 - Track: BI 1
Speaker: Rick Heiges
Title: Interviews and Resumes
Abstract:
Whether you are in the hunt for a new job or looking for a new employee to fit in, this session is for you. We will cover common interview techniques used today. We will discuss the goals of these techniques from the interviewer point of view and how you should respond from a job seeker point of view. We will also cover resumes and their purpose. Your resume is your first impression; make it count.
SessionID: 36037
Automate Your ETL Infrastructure with SSIS and PowerShell
Event Date: 06-06-2015 - Session time: 08:30:00 - Track: BI 2
Speaker: Allen White
Title: Automate Your ETL Infrastructure with SSIS and PowerShell
Abstract:
Much of your ETL process flow consists of packages that are very similar in structure, capturing data from a single source and transferring that to a single destination. Creating the individual packages can be tedious and it's easy to miss something in the process of generating the same basic package over and again. BI Markup Language makes it easy to build new packages, and PowerShell makes creating the BIML scripts easy. In this session we'll show you how to use PowerShell to generate dozens of SSIS packages doing similar tasks from a defined set of ETL sources.
SessionID: 36097
Agile Data Warehouse Development
Event Date: 06-06-2015 - Session time: 08:30:00 - Track: BI 1
Speaker: Bob Blackburn
Title: Agile Data Warehouse Development
Abstract:
Long gone are the days when we had two to five years to deliver a Data Warehouse. Business Units want, need, and demand faster turnaround to start collecting on ROI. How can we take the Agile Methodology and apply it to Data Warehouse development? We will discuss how to apply it at the project level and then take a look at some data warehouse specific practices.
SessionID: 37775
Minion Maintenance and Backup Solutions
Event Date: 06-06-2015 - Session time: 08:30:00 - Track: BI 1
Speaker: Sean McCown
Title: Minion Maintenance and Backup Solutions
Abstract:
The new Minion solutions are taking the SQL community by storm, and no wonder: they’re free, simple to use, and deeply configurable.
In this session I’ll show you the benefits to Minion Reindex and Minion Backup:
• Simple installation and configuration for all shops, large or small
• Single or multi-server installation script
• Table-based configuration eliminates the need for excessive jobs
• Highly customizable options
• Flexible include and exclude options, including the use of regular expressions
• “Statement only” option generates statements without running them
• Extensive logging
• Live insight into the current maintenance operation
Minion Backup also provides a truly superb specialty: dynamic backup tuning.
Minion Reindex and Minion Backup scale to the size of your enterprise, from one to thousands of instances. With Minion’s true configurability and enterprise features, you can do things never before possible in your maintenance routines.
SessionID: 14563
Hybrid Cloud Scenarios with SQL Server 2014
Event Date: 06-06-2015 - Session time: 09:45:00 - Track: BI 1
Speaker: George Walters
Title: Hybrid Cloud Scenarios with SQL Server 2014
Abstract:
SQL 2014 has significant changes to allow seamless hybrid cloud scenarios. This session will talk about "why cloud" as well as the options available with backup, deployment, and new development scenarios with SQL 2014 and Azure.
SessionID: 18340
Change Data Capture in SQL Server 2008/2012
Event Date: 06-06-2015 - Session time: 09:45:00 - Track: DBA 2
Speaker: Kevin Goff
Title: Change Data Capture in SQL Server 2008/2012
Abstract:
SessionID: 23554
Social DBA
Event Date: 06-06-2015 - Session time: 09:45:00 - Track: BI 1
Speaker: Robert Pearl
Title: Social DBA
Abstract:
SessionID: 27538
Get Familiar with Spatial Data
Event Date: 06-06-2015 - Session time: 09:45:00 - Track: Dev 2
Speaker: Slava Murygin
Title: Get Familiar with Spatial Data
Abstract:
You've never worked with spatial data and would like to know how to do it.
We'll go through very basic SQL Server Spatial data functionality and draw some Spatial pictures using Management Studio.
SessionID: 35710
Flash and SQL Server— Re-Thinking Best Practices
Event Date: 06-06-2015 - Session time: 09:45:00 - Track: BI 2
Speaker: J May
Title: Flash and SQL Server— Re-Thinking Best Practices
Abstract:
SessionID: 35781
Punishing Yourself with Continuous Delivery
Event Date: 06-06-2015 - Session time: 09:45:00 - Track: BI 1
Speaker: Mark Wojciechowicz
Title: Punishing Yourself with Continuous Delivery
Abstract:
Do you deploy code once every couple of months, or quarters…. or years? Is deployment terrifying and fraught with catastrophes? Then why not do it more often? Continuous Delivery (CD) takes deployment to the next level, turning the terror of pushing out code into happiness, sunshine and butterflies. CD is the practice of maintaining the deployment pipeline so that new features can be delivered quickly and with fewer failures. This session will cover how to do CD in a Business Intelligence Environment.
SessionID: 36307
Master Data Services– Integration through SSIS
Event Date: 06-06-2015 - Session time: 09:45:00 - Track: DBA 2
Speaker: Christopher Exley
Title: Master Data Services– Integration through SSIS
Abstract:
SessionID: 36418
Beginning PowerShell Scripting
Event Date: 06-06-2015 - Session time: 09:45:00 - Track: Advanced
Speaker: Justin Dearing
Title: Beginning PowerShell Scripting
Abstract:
This is a beginers powershell talk. While we will be talking about how to query and administrate SQL server with powershell, it will be a more generic talk about using PowerShell.
SessionID: 15648
Building an Effective Data Warehouse Architecture
Event Date: 06-06-2015 - Session time: 11:00:00 - Track: BI 1
Speaker: James Serra
Title: Building an Effective Data Warehouse Architecture
Abstract:
SessionID: 18343
Beginner TSQL
Event Date: 06-06-2015 - Session time: 11:00:00 - Track: Advanced
Speaker: Kevin Goff
Title: Beginner TSQL
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: 20997
Data Meaning
Event Date: 06-06-2015 - Session time: 11:00:00 - Track: Dev 2
Speaker: Judith Moffitt
Title: Data Meaning
Abstract:
SessionID: 21078
Storage For the DBA
Event Date: 06-06-2015 - Session time: 11:00:00 - Track: BI 2
Speaker: Denny Cherry
Title: Storage For the DBA
Abstract:
SessionID: 24403
SQL Server 2014 Optimizer “Goodies”
Event Date: 06-06-2015 - Session time: 11:00:00 - Track: Dev 2
Speaker: Sharon Dooley
Title: SQL Server 2014 Optimizer “Goodies”
Abstract:
SessionID: 28346
Version control with GIT for the DBA
Event Date: 06-06-2015 - Session time: 11:00:00 - Track: BI 1
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: 35919
A "101" Overview of Microsoft Power BI for Office 365
Event Date: 06-06-2015 - Session time: 11:00:00 - Track: BI 1
Speaker: Timothy McAliley
Title: A "101" Overview of Microsoft Power BI for Office 365
Abstract:
SessionID: 37662
Connecting Power BI to On-Prem SSAS Tabular
Event Date: 06-06-2015 - Session time: 11:00:00 - Track: Dev 1
Speaker: Kerry Tyler
Title: Connecting Power BI to On-Prem SSAS Tabular
Abstract:
If you've ever looked at the visualizations available in Power BI for Office 365 or the robust sharing capabilities available with the cloud service, but the requirement of uploading/storing data in the cloud was a deal-breaker, there is a new option available for you in the current Power BI Preview. The new Power BI Analysis Services Connector allows you to directly query on-premises SSAS Tabular data for display in Power BI. In this session, we'll go through installation and configuration of this Connector which can open all-new data sources for use in the cloud.
SessionID: 37455
Clusters Your Way: #SANLess Clusters for Physical, Virtual Cloud Environ.
Event Date: 06-06-2015 - Session time: 12:30:00 - Track: Advanced
Speaker: SIOS Technology
Title: Clusters Your Way: #SANLess Clusters for Physical, Virtual Cloud Environ.
Abstract:
SessionID: 22092
Common Coding Mistakes and how to Mitigate them
Event Date: 06-06-2015 - Session time: 13:30:00 - Track: Dev 2
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: 35656
Event Date: 06-06-2015 - Session time: 13:30:00 - Track: BI 2
Speaker: Danette Riviello
Abstract:
SessionID: 35695
Azure SQL Database (Software As A Service)
Event Date: 06-06-2015 - Session time: 13:30:00 - Track: BI 1
Speaker: John Miner
Title: Azure SQL Database (Software As A Service)
Abstract:
Are you tired of installing, configuring and patching Microsoft SQL Server? Azure SQL database maybe a way to move some of your existing 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.
The demonstration will show how to create and load a new database from scratch using the Azure Portal, SSMS and BCP.
SessionID: 35966
SQL Server Cryptology - A Primer
Event Date: 06-06-2015 - Session time: 13:30:00 - Track: BI 1
Speaker: Sebastian Meine
Title: SQL Server Cryptology - A Primer
Abstract:
So, you got told you need to encrypt "the database". Now what?
Join this session by security expert Sebastian Meine (Ph.D.) for an introduction to the fascinating world of cryptology. In this session, geared towards the DBA, you will learn the difference between symmetric and asymmetric encryption, discover what a cryptographic one-way hash function is and probe into cryptographically secure pseudo random number generation. After exploring the different definitions, you will be able to observe how to implement encryption, decryption, transparent data encryption (TDE) and hashing in SQL Server. We will pay special attention to areas where the choice of encryption technology affects your database maintenance and recovery strategies. After attending the session, you will be able to identify the right technology to use in your specific use case and you will have the basic knowledge to start implementing it immediately.
SessionID: 36062
Getting to Know Your DB
Event Date: 06-06-2015 - Session time: 13:30:00 - Track: BI 2
Speaker: Jason Brimhall
Title: Getting to Know Your DB
Abstract:
SessionID: 36414
What's an execution plan and why does it matter?
Event Date: 06-06-2015 - Session time: 13:30:00 - Track: Advanced
Speaker: Sharon Dooley
Title: What's an execution plan and why does it matter?
Abstract:
SessionID: 36415
What's New in SQL Server vNext
Event Date: 06-06-2015 - Session time: 13:30:00 - Track: BI 1
Speaker: Bill Emmert
Title: What's New in SQL Server vNext
Abstract:
In this session, I will share the roadmap of SQL Server vNext. This will be a fast paced overview of what's coming both in SQL Server on-premise and Azure SQL Database. Hold your questions until the end so we can get through the feature list.
SessionID: 37776
Monster Text Manipulation: Regular Expressions for the DBA
Event Date: 06-06-2015 - Session time: 13:30:00 - Track: BI 2
Speaker: Sean McCown
Title: Monster Text Manipulation: Regular Expressions for the DBA
Abstract:
Here you’ll learn:
• The most useful regular expression commands.
• The appropriate times to use regular expressions.
• How to use regular expressions to write code for you.
• How to incorporate regular expressions into large tasks and combine them with other methods.
SessionID: 37901
Panel: Will the DBA Job of the Future Still Involve DBAs?
Event Date: 06-06-2015 - Session time: 13:30:00 - Track: DBA 1
Speaker: Karen Lopez
Title: Panel: Will the DBA Job of the Future Still Involve DBAs?
Abstract:
But in the last few years, NoSQL technologies ("it's schemaless!"), cloud ("our databases are managed elsewhere!") and recent SQL Server features ("it's new and improved!") will have an impact on DBA jobs, tasks and careers.#160;
Our panel of SQL Server experts will share their #160;current experiences in the data profession.#160; They will share what they believe you should be working towards now and in the future.
SessionID: 11300
Optimizing Protected Indexes
Event Date: 06-06-2015 - Session time: 14:45:00 - Track: BI 1
Speaker: Chris Bell
Title: Optimizing Protected Indexes
Abstract:
As a SQL Server DBA I see my role having 2 main focuses. First is to protect the data and second is to ensure performance is maximized. More often than not companies forget about data security when they focus on performance tuning. In this presentation I will mention a few cases where encryption could have saved a lot of hassle. I will then demo a method that can be used to "index" commonly searched on encrypted values (ex: SSNs, Credit Card, etc) helping reduce the impact on the performance of a query.
SessionID: 21807
Shortcuts to Building SSIS in .Net
Event Date: 06-06-2015 - Session time: 14:45:00 - Track: BI 1
Speaker: Paul Rizza
Title: Shortcuts to Building SSIS in .Net
Abstract:
Using an Open Source project API Library this session will show how SSIS Packages can be created as easily in C# .Net as they are in BIDS. During the session real world examples will be used to show how SSIS Code can be created in BULK.
SessionID: 27576
Leveraging CDC and SSIS for ODS/DM/DW Loads
Event Date: 06-06-2015 - Session time: 14:45:00 - Track: DBA 2
Speaker: Warren Sifre
Title: Leveraging CDC and SSIS for ODS/DM/DW Loads
Abstract:
SessionID: 27775
Crazy Things Developers Do
Event Date: 06-06-2015 - Session time: 14:45:00 - Track: Dev 2
Speaker: Wayne Sheffield
Title: Crazy Things Developers Do
Abstract:
Throughout my career, I've seen developers do some pretty crazy things to databases (and truth be told, I've done some of these myself!). Come to this session to learn about SQL Injection attacks and how SQL can use Referential Integrity to optimze queries. Trust me... your DBA will love you for making these changes.
SessionID: 36076
DBA 911 - Database Corruption
Event Date: 06-06-2015 - Session time: 14:45:00 - Track: BI 1
Speaker: David Maxwell
Title: DBA 911 - Database Corruption
Abstract:
Database corruption is simply a fact of a DBA's life - if you haven't seen it yet, you will. Success or failure depends on having a solid plan to deal with different types of corruption. In this session, we will discuss usage of related DBCC commands such as DBINFO, CHECKDB and PAGE. You'll learn how to monitor for corruption with SQL Server Agent Alerts and Jobs, and when it's time to restore instead of repair. After attending this session, you will be able to check for issues such as page corruption or data purity problems, and take the appropriate measures to deal with them.
SessionID: 36109
Creating a Solid Data Model for PowerPivot
Event Date: 06-06-2015 - Session time: 14:45:00 - Track: DBA 2
Speaker: Dan Clark
Title: Creating a Solid Data Model for PowerPivot
Abstract:
A solid BI Analysis starts with the model it is based on. This session looks at best practices and avoiding common mistakes when creating the data model on which your PowerPivot and Power View reports are based. Using PowerPivot takes a change in mindset from the traditional pivot table connected to an excel sheet or SSAS cube. You will walk away with a better understanding of how to build your models and how to approach your data analysis when using PowerPivot.
SessionID: 36334
60 Reporting Tips in 60 Minutes
Event Date: 06-06-2015 - Session time: 14:45:00 - Track: Dev 1
Speaker: Ike Ellis
Title: 60 Reporting Tips in 60 Minutes
Abstract:
This session will be rapid fire, fast-paced experience, focusing on all sorts of reporting tips. This session is for the YouTube generation. Do you have a short attention span? Are 15-second commercials too long to sit through? Do you want the very best reporting tips collected from watching hundreds of videos and reading a library of books, plus years of reporting experience? Come to this session. We have tips on Excel, data visualization, interviewing stake holders, organizing reporting teams, securing reports, consolidation, dashboard design, SSRS, SSIS, and T-SQL authoring. You're guaranteed to learn something actionable that will make you more effective in your career.
SessionID: 23917
From Zero to Loading a Data Warehouse
Event Date: 06-06-2015 - Session time: 16:00:00 - Track: DBA 2
Speaker: Samuel Vanga
Title: From Zero to Loading a Data Warehouse
Abstract:
You're tasked to create the ETL process for a brand-new data warehouse. Where do you start? Data warehouse ETL boils down to three specific problems: Staging, Dimensions, and Facts. This session will show you solutions to these three problems. You'll first learn the fundamentals of a data warehouse before diving into creating packages and leveraging common patterns. You'll see both simple and advanced scenarios such as incrementally loading staging tables, processing type1 and type2 slowly changing dimensions, early arriving facts, snapshot fact tables, and bridge tables. If you want to create scalable and efficient SSIS packages to load a data warehouse, this session is for you.
SessionID: 35740
Event Date: 06-06-2015 - Session time: 16:00:00 - Track: BI 1
Speaker: Konstantin Melamud
Abstract:
In this presentation, we will identify what indexes are being used by the SQL Optimizer, the different type of index operations that are performed by SQL Server and which operations are generally considered the preferred method of data retrieval. We will discuss how to determine if the indexes used by the Optimizer are optimal, according to best practices, and the exceptions to those cases. Finally, we will cover the relationships between different types of index operations and joins within SQL Server, including how the SQL Optimizer determines which join type it will use, along with the pros and cons of each join operation
SessionID: 35830
But it worked great in Dev! Perfomance for Devs
Event Date: 06-06-2015 - Session time: 16:00:00 - Track: BI 1
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: 36267
The Ticking Timebombs in Your Databases
Event Date: 06-06-2015 - Session time: 16:00:00 - Track: Beginner
Speaker: Karen Lopez
Title: The Ticking Timebombs in Your Databases
Abstract:
You've worked hard to build the best systems you can, and then one night you get called in to resolve a production incident. As you peer into your database, you see it: something so bad it sends shivers down your spine. How did that get in there? Who did that? Why? And how do you fix it?
In this session, we look at the workarounds, technical debt and clever designs that can cause you grief when you least expect it. We will also include perfectly fine features that can haunt you later. We will discuss how these things happen and give you tools to identify the ones that cause the most pain.
Join us: you'll keep your job, have happier users and get more rest.
SessionID: 36309
Visual Studio Online for cost effective code and Project Mgmt
Event Date: 06-06-2015 - Session time: 16:00:00 - Track: Dev 1
Speaker: Ravi Gudlavalleti
Title: Visual Studio Online for cost effective code and Project Mgmt
Abstract:
Whether you are working on side project or an Enterprise grade solution, VSO is a cost effective cloud-based option that is hard to beat.
We'll look at what it is, licensing, pricing and features for developers, project managers and stake holders.
SessionID: 36422
You Want Me To Do What? SQL Security Basics
Event Date: 06-06-2015 - Session time: 16:00:00 - Track: Advanced
Speaker: Chris Bell
Title: You Want Me To Do What? SQL Security Basics
Abstract:
You've done it! You have a database now! Maybe not of your own choice, but you have one. What do you do now to get it secured properly? Come learn the basics of SQL Security to start down the path of proper database protection.
SessionID: 8998
Availability Groups 101: An Introduction
Event Date: 06-06-2015 - Session time: 16:00:00 - Track: BI 1
Speaker: Adam Belebczuk
Title: Availability Groups 101: An Introduction
Abstract: