sqlsathistory

Nr: 461

Back to Main list

SQLSaturday #461 - Austin 2016

Start Time (24h) Speaker Track Title
09:00:00 Thomas LaRock Enterprise Database Administration Deployment From Here to Azure
09:00:00 Michael Bourgon Enterprise Database Administration Deployment Know what your machines are doing besides SQL Server - WMI, WQL, and PoSH
09:00:00 Ryan Adams Enterprise Database Administration Deployment Enforce Best Practices with CMS and Policy Based Management
09:00:00 Ginger Grant BI Information Delivery Using Power BI when Implementing Data Analytics Management Practices
09:00:00 Steve Jones Professional Development Branding Yourself for a Dream Job
09:00:00 Jennifer McCown Application Database Development Designing Stored Procedure Solutions
10:10:00 Kevin Hazzard Enterprise Database Administration Deployment Introducing Azure Data Factory
10:10:00 Peter Myers Advanced Analysis Techniques Introduction to Time Series Forecasting
10:10:00 Nancy Hidy Wilson Enterprise Database Administration Deployment SQL Server Deprecated and Discontinued Features
10:10:00 Christopher Wolff Application Database Development Continuous Deployments using SSDT
10:10:00 Joe Hellsten Enterprise Database Administration Deployment Fun Facts about Availability Groups
10:10:00 Conor Cunningham DBA Track Introducing SQL Server 2016 (Part One)
11:20:00 Michael Corey Enterprise Database Administration Deployment Database Virtualization (Monster VM) – Vsphere 6
11:20:00 Amy Herold Professional Development Making the Leap from Developer to DBA
11:20:00 Lance Tidwell Application Database Development Parameter Sniffing the Good, the Bad and the Ugly
11:20:00 Tim Mitchell BI Platform Architecture, Development Administration Testing SSIS Packages
11:20:00 Sean McCown Enterprise Database Administration Deployment Monster Text Manipulation: Regular Expressions for the DBA
11:20:00 Conor Cunningham DBA Track Introducing SQL Server 2016 (Part Two)
13:00:00 Bryan Walsh Other Transform SQL Server Agility with XtremIO
14:00:00 Reinaldo Kibel Application Database Development SQL Server 2014/2016 In Memory Technologies - OLTP (aka Hekaton) ColumnSt
14:00:00 Jayaprakash Jothiraman BI Platform Architecture, Development Administration ColumnStore Index: Microsoft SQL Server 2014 and Beyond
14:00:00 Peter Myers Advanced Analysis Techniques Azure Machine Learning: From Design to Integration
14:00:00 Stan Geiger BI Platform Architecture, Development Administration The Data Warehouse of the Future
14:00:00 Ryan Adams Enterprise Database Administration Deployment Backup and Restore Tips and Tricks
14:00:00 Karen Lopez Application Database Development Database Design Throwdown
15:10:00 Suresh Kandoth Enterprise Database Administration Deployment Configuring SQL Server for Mission Critical and Scalable Deployments
15:10:00 Jim Murphy Enterprise Database Administration Deployment Mission Possible: Interactive Performance Troubleshooting - Index
15:10:00 Jeremy Frye BI Platform Architecture, Development Administration "Can I Get A Report of This?": Introduction to SSRS
15:10:00 Jamey Johnston Enterprise Database Administration Deployment Overview of Security Investments in SQL Server 2016 and Azure SQL Database
15:10:00 John Sterrett Enterprise Database Administration Deployment Make Your SQL Server Queries Go Faster
15:10:00 Mickey Stuewe Application Database Development Changing Your Habits to Improve the Performance of Your T-SQL
16:20:00 Robert Davis Enterprise Database Administration Deployment Strategies for Working with Texas-sized Databases
16:20:00 Mike Byrd Application Database Development SS2014 In-Memory Tables: Formula 1 Performance Unleashed!
16:20:00 Daniel Janik Advanced Analysis Techniques Analyze your query plan like a Microsoft Engineer!
16:20:00 Ben Miller Enterprise Database Administration Deployment SQL Server Database Encryption (TDE)
16:20:00 William Wolf Application Database Development Service Broker: Coach your processes asynchronously
16:20:00 Tim Mitchell BI Platform Architecture, Development Administration Introduction to Biml

SessionID: 40468

From Here to Azure

Back to calendar

Event Date: 30-01-2016 - Session time: 09:00:00 - Track: Enterprise Database Administration Deployment

Speaker: Thomas LaRock

Title: From Here to Azure

Abstract:

As the concept of Hybrid Datacenter becomes more mainstream data professionals will need to understand how to effectively manage and migrate data between on-premises and cloud servers. Attend this interactive session and learn how to create, deploy, and migrate data from your on-premises instance of SQL Server to Microsoft Azure Virtual Machines and Microsoft Azure SQL Database.

Attendees of this session will learn (1) How to decide if IaaS of PaaS is the right option, (2) How to prepare your database for migration to SQL Azure, (3) How to best migrate data to Microsoft Azure.

SessionID: 41854

Know what your machines are doing besides SQL Server - WMI, WQL, and PoSH

Back to calendar

Event Date: 30-01-2016 - Session time: 09:00:00 - Track: Enterprise Database Administration Deployment

Speaker: Michael Bourgon

Title: Know what your machines are doing besides SQL Server - WMI, WQL, and PoSH

Abstract:

There's far more happening on your Windows servers than just SQL Server, and looking at ERRORLOG won't show you the whole story: other applications stealing your memory, OS issues, hardware errors, and more. We'll start by looking at different ways to collect Event Logs. From there we'll delve into WMI and WQL, which allow us to query servers (remotely or locally) to get information such as performance statistics, System and Event Logs, and even changes within SQL Server.

We'll finish it off with two immediately-usable implementations you can set up on Monday.

SessionID: 41862

Enforce Best Practices with CMS and Policy Based Management

Back to calendar

Event Date: 30-01-2016 - Session time: 09:00:00 - Track: Enterprise Database Administration Deployment

Speaker: Ryan Adams

Title: Enforce Best Practices with CMS and Policy Based Management

Abstract:

You have a lot of servers and need to make sure you have consistent settings configured like disabling auto shrink, disabling extended stored procedures, or enabling database mail. I'll show you how to check those settings across all your servers with Central Management Server and how you can manage a disperse environment. You will learn how to leverage the power of Policy Based Management to enforce those settings and standards in your enterprise. Best of all, you will see how to get alerts sent to you when one of your settings is changed.

SessionID: 41901

Using Power BI when Implementing Data Analytics Management Practices

Back to calendar

Event Date: 30-01-2016 - Session time: 09:00:00 - Track: BI Information Delivery

Speaker: Ginger Grant

Title: Using Power BI when Implementing Data Analytics Management Practices

Abstract:

Providing the tools to implement data analytics is only one part of a successful project. Collaboration policies, data management roles, security, and training are all necessary to ensure the wide adoption of data based decision making throughout your organization. Business Analytics projects regularly require interaction with the technical teams who are responsible for ensuring the security, access and storage of the data. During this session we will discuss practices and methods learned to foster and continue good collaborative relationships between technical and analytics teams. The Power BI collaboration tools are used to illustrate the methods needed to encourage users to adopt data driven decision making in your organization. Attendees will leave the session with a methodology which they can implement in their environments to promote successful data based decision making based on proven methods provided to a number of clients in a number of industries.

SessionID: 41979

Branding Yourself for a Dream Job

Back to calendar

Event Date: 30-01-2016 - Session time: 09:00:00 - Track: Professional Development

Speaker: Steve Jones

Title: Branding Yourself for a Dream Job

Abstract:

Everyone wants a dream job that they enjoy going to each week. However finding that job, and getting yourself hired can be hard for most people. Steve Jones will give you practical tips and suggestions in this session that show you how to better market yourself, how to get the attention of employers, and help improve the chances that the job you want will get offered to you. Learn about networking, blogging, and more.

SessionID: 41993

Designing Stored Procedure Solutions

Back to calendar

Event Date: 30-01-2016 - Session time: 09:00:00 - Track: Application Database Development

Speaker: Jennifer McCown

Title: Designing Stored Procedure Solutions

Abstract:

With a little T-SQL experience, you can create a stored procedure that completes a task. But it's harder to formulate a stored procedure solution with the big picture in mind. In this session, we will work through a real world scenario to develop a thorough solution. You will learn about:

Asking the right questions to set yourself up for success Making the case for stored procedures over ad hoc code and other objects Pro tips for standardization and cross-version compliance Reevaluating and expanding on your solution Limiting inputs to reduce unexpected behaviors and errors Choosing between alternate solutions Evaluating for performance

This session is for data professionals who can write T-SQL, but haven't spent a lot of time in SQL development.

SessionID: 39001

Introducing Azure Data Factory

Back to calendar

Event Date: 30-01-2016 - Session time: 10:10:00 - Track: Enterprise Database Administration Deployment

Speaker: Kevin Hazzard

Title: Introducing Azure Data Factory

Abstract:

SessionID: 40628

Introduction to Time Series Forecasting

Back to calendar

Event Date: 30-01-2016 - Session time: 10:10:00 - Track: Advanced Analysis Techniques

Speaker: Peter Myers

Title: Introduction to Time Series Forecasting

Abstract:

Imagine taking historical sales data and using data science to accurately predict future sales values. This is precisely the objective of time series forecasting – to predict future values based on previously observed values.

This session will introduce time series forecasting, and describe how different Microsoft BI products enable forecasting for various audiences, including the business analysts, IT developer, and even the Information Worker.

Topics will include Analysis Services forecasting by using the Microsoft Time Series algorithm with the Excel add-ins (Table Analysis Tools and the Client Tools), SQL Server Data Tools (SSDT) and script. This session will also introduce and describe the impressive new forecasting capabilities delivered in Power View with Office 365. As part of Microsoft’s new approach to simplify complex Machine Learning technology, forecasting in Power View enables powerful forecasting capabilities for the unspecialized Information Worker.

SessionID: 41048

SQL Server Deprecated and Discontinued Features

Back to calendar

Event Date: 30-01-2016 - Session time: 10:10:00 - Track: Enterprise Database Administration Deployment

Speaker: Nancy Hidy Wilson

Title: SQL Server Deprecated and Discontinued Features

Abstract:

Support for SQL Server 2005 ends in April 2016 - do you still need to upgrade? Each version of SQL Server provides a list of features which are deprecated – meaning they will be removed in a future version – and a list of features previously deprecated which are discontinued in that version. This session will discuss the deprecated\discontinued features starting with SQL 2008 and will show you how to identify deprecated features so that you can upgrade with ease when those features are discontinued in the version to which you are upgrading.

SessionID: 41415

Continuous Deployments using SSDT

Back to calendar

Event Date: 30-01-2016 - Session time: 10:10:00 - Track: Application Database Development

Speaker: Christopher Wolff

Title: Continuous Deployments using SSDT

Abstract:

DevOps is a word that gets thrown around a lot these days and is the way most shops will operate in the future. In my presentation I'll show you how to fast forward to the future by automating your deployments from SSDT using Powershell and SQLPackage.exe.

SessionID: 41868

Fun Facts about Availability Groups

Back to calendar

Event Date: 30-01-2016 - Session time: 10:10:00 - Track: Enterprise Database Administration Deployment

Speaker: Joe Hellsten

Title: Fun Facts about Availability Groups

Abstract:

Discussion regarding "Fun Facts" pertaining to AGs

For Example "max worker threads" minus 40 or Cross database ownership chaining support in AGs

SessionID: 45750

Introducing SQL Server 2016 (Part One)

Back to calendar

Event Date: 30-01-2016 - Session time: 10:10:00 - Track: DBA Track

Speaker: Conor Cunningham

Title: Introducing SQL Server 2016 (Part One)

Abstract:

SQL Server 2016 is one of the largest SQL Server releases of all time. This talk will give an overview of the features we are introducing to give you a primer on how this release of SQL can help you and your business succeed.

SessionID: 40213

Database Virtualization (Monster VM) – Vsphere 6

Back to calendar

Event Date: 30-01-2016 - Session time: 11:20:00 - Track: Enterprise Database Administration Deployment

Speaker: Michael Corey

Title: Database Virtualization (Monster VM) – Vsphere 6

Abstract:

This presentation is based upon a top 10 presentation “Virtualizing Databases: Doing IT Right given” at VMworld last year in Barcelona and the US. . In this presentation we will teach you how to properly virtualize any business critical application with specifics on databases and VMware newest release vSphere 6.0. A database is a very resource intensive by its very nature a monster VM and one of the most resource intensive applications you will ever virtualize. If it is not done correctly you will not be successful. This presentation will teach you how to do it right. We will discuss why you virtualize a database, using the right hypervisor, installation, Architecting for performance, the storage layer, the processor, Memory considerations, the network layer. Topics include NUMA, Memory reservations, Network details to how to avoid common mistakes.

SessionID: 41857

Making the Leap from Developer to DBA

Back to calendar

Event Date: 30-01-2016 - Session time: 11:20:00 - Track: Professional Development

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

Parameter Sniffing the Good, the Bad and the Ugly

Back to calendar

Event Date: 30-01-2016 - Session time: 11:20:00 - Track: Application Database Development

Speaker: Lance Tidwell

Title: Parameter Sniffing the Good, the Bad and the Ugly

Abstract:

Parameter sniffing is something that more than often helps performance on your servers; however, there are times when it can hinder performance as well. In this session we will define exactly what parameter sniffing is, and examine when it is good and when it is bad. Lastly, we will explore the different options available to fix bad parameter sniffing. After this session, you will be able to locate and fix bad parameter sniffing when it occurs on your servers.

SessionID: 41989

Testing SSIS Packages

Back to calendar

Event Date: 30-01-2016 - Session time: 11:20:00 - Track: BI Platform Architecture, Development Administration

Speaker: Tim Mitchell

Title: Testing SSIS Packages

Abstract:

Senior developer: “How do you test your code?” Junior developer: “I compile it.” It’s an old joke, but too often this reflects the reality of testing. If the code compiles, it has passed its test. Sadly, this principle is sometimes applied to Extract-Transform-Load (ETL) processes as well: “When the SSIS package runs without error, testing is complete.”

As in software development, testing of SQL Server Integration Services (SSIS) packages should not end at when the package executes successfully. You must also confirm that the package does what it was intended to do without placing an undue performance burden on the system.

This session walks through design patterns for testing SSIS packages during and after the development process. The session covers topics such as these:

SessionID: 41999

Monster Text Manipulation: Regular Expressions for the DBA

Back to calendar

Event Date: 30-01-2016 - Session time: 11:20:00 - Track: Enterprise Database Administration Deployment

Speaker: Sean McCown

Title: Monster Text Manipulation: Regular Expressions for the DBA

Abstract:

Regular expressions can help you perform incredible tasks with very little effort. Need to create 1700 logins from an email request? Developers give you a single script with 300 stored procedures filled with table variables instead of temp tables? Need to move 500 databases to a different drive? Any of these tasks can take a long time to code, but regular expressions cuts that work from hours to seconds. I use regular expressions all the time and I have taken many tasks down from several days to just a few minutes. Stop writing code manually and let regular expressions do it for you.

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

Introducing SQL Server 2016 (Part Two)

Back to calendar

Event Date: 30-01-2016 - Session time: 11:20:00 - Track: DBA Track

Speaker: Conor Cunningham

Title: Introducing SQL Server 2016 (Part Two)

Abstract:

SQL Server 2016 is one of the largest SQL Server releases of all time. This talk will give an overview of the features we are introducing to give you a primer on how this release of SQL can help you and your business succeed.

SessionID: 45908

Transform SQL Server Agility with XtremIO

Back to calendar

Event Date: 30-01-2016 - Session time: 13:00:00 - Track: Other

Speaker: Bryan Walsh

Title: Transform SQL Server Agility with XtremIO

Abstract:

All-Flash Arrays deliver IOPS in abundance. XtremIO goes further to provide predictable, consistent sub-millisecond latency and unleash agility for your SQL Server databases. Our unique XtremIO Virtual Copies (XVC) capabilities allow for fully writable copies for production, test/dev, reporting/analytics workloads on our market leading consolidation platform. This allows for consolidation of your SQL Server based environments onto a single array to maximize efficiency.

SessionID: 39077

SQL Server 2014/2016 In Memory Technologies - OLTP (aka Hekaton) ColumnSt

Back to calendar

Event Date: 30-01-2016 - Session time: 14:00:00 - Track: Application Database Development

Speaker: Reinaldo Kibel

Title: SQL Server 2014/2016 In Memory Technologies - OLTP (aka Hekaton) ColumnSt

Abstract:

With the advent of new hardware servers with hundreds of Gigabytes of RAM memory and incredibly faster CPUs with multi-core dies Microsoft has catapulted SQL Server above competitors with some new In Memory technologies. Did you ever want to have no locking, no blocking, no latch? For highly transactional systems, In Memory OLTP can boost performance 10x by hosting a table in memory and compiling the stored procedure in C code/DLL. Did you ever wanted to have queries return blazing fast for slow changing data? Updatable ColumnStore index allows for quick results to be returned as massive compression on the column exist and data is kept in RAM.

Having participated in SQL14/SQL15/Hekaton TAP, I'll be showing demo on both of these technologies, gotchas, best practices.

SessionID: 39269

ColumnStore Index: Microsoft SQL Server 2014 and Beyond

Back to calendar

Event Date: 30-01-2016 - Session time: 14:00:00 - Track: BI Platform Architecture, Development Administration

Speaker: Jayaprakash Jothiraman

Title: ColumnStore Index: Microsoft SQL Server 2014 and Beyond

Abstract:

Column store technology was first introduced in SQL Server 2012 and has been significantly enhanced for SQL Server 2014 and SQL Server 2016. Column store indexes can not only accelerate data warehouse workloads by an order of magnitude but also reduce storage requirements by an order of magnitude. Column store indexes are a hybrid technology leveraging the best of disk in-memory capabilities. In this session we cover how to take advantage of column store capabilities in your applications and dive into the internals of how column store works in following areas.

Business Rationale , Overview, Data Compression, Query Performance, Clustered Column Store Index, Supportability: DMVs, Perfmon, XEvents, High Availability/Supportability,

You will also learn what is available new in SQL Server 2012, SQL Server 2014 and SQL Server 2016.

SessionID: 40624

Azure Machine Learning: From Design to Integration

Back to calendar

Event Date: 30-01-2016 - Session time: 14:00:00 - Track: Advanced Analysis Techniques

Speaker: Peter Myers

Title: Azure Machine Learning: From Design to Integration

Abstract:

Machine Learning is a subfield of computer science concerned with systems that learn from data. In this session, learn how a Microsoft Azure Machine Learning solution comes to life: From the creation of a workspace, to the preparation of data, to experimentation with machine learning algorithms, and then finally to the integration and integration of predictive insights.

This session has been specifically designed to describe machine learning fundamentals, and to help enable and inspire existing developers taking their first steps to leverage cloud-based predictive models delivered with Azure Machine Learning. It is guaranteed to thrill you with potential, and excite you with the relative ease in which it can be accomplished.

SessionID: 41392

The Data Warehouse of the Future

Back to calendar

Event Date: 30-01-2016 - Session time: 14:00:00 - Track: BI Platform Architecture, Development Administration

Speaker: Stan Geiger

Title: The Data Warehouse of the Future

Abstract:

So you think you have the ultimate Data Warehouse...well think again. The landscape or should I say the data lake is changing constantly. We are getting data from all over the place. How do we make it available and relevant for the consumers of a data warehouse. Is Kimbell obsolete now, what about unstructured data, how about the gazillioin rows of click data, etc. So the data and BI architects are all on suicide watch. Well its not really that bad. Microsoft has woken up and seen all that is going and has brought functionality to SQL Server to solve some of these issues. This presentation provides an overview of technologies such as Polybase, Temoporal Tables, Columnstore Index, In memory tables, JSON support, etc. that can be utilized to build the data warehouse of the future.

SessionID: 41863

Backup and Restore Tips and Tricks

Back to calendar

Event Date: 30-01-2016 - Session time: 14:00:00 - Track: Enterprise Database Administration Deployment

Speaker: Ryan Adams

Title: Backup and Restore Tips and Tricks

Abstract:

Do you need to devise a backup and restore plan to meet the Recovery Point Objective (RPO) and Recovery Time Objective (RTO) of your business? I'll show you how to pick the right backup type, method, and recovery model to meet your business needs. You'll learn how the network and drive format can have an effect on your backups and avoid the pitfalls that slow down your backup and restore plan. You'll also learn how to keep your transaction log from growing uncontrollably while speeding up your backups and restores using the native tools without any added cost!

SessionID: 42371

Database Design Throwdown

Back to calendar

Event Date: 30-01-2016 - Session time: 14:00:00 - Track: Application Database Development

Speaker: Karen Lopez

Title: Database Design Throwdown

Abstract:

Everyone agrees that great database performance starts with a great database design. Unfortunately, not everyone agrees which design options are best. Data architects and DBAs have debated database design best practices for decades. Systems built to handle current workloads are unable to maintain performance as workloads increase.

Attend this new and improved session and join the debate about the pros and cons of database design decisions. This debate includes topics such as logical design, datatypes, primary keys, indexes, refactoring, code-first generators, and even the cloud. Learn about the contentious issues that most affect your end users and how to avoid them.

SessionID: 40609

Configuring SQL Server for Mission Critical and Scalable Deployments

Back to calendar

Event Date: 30-01-2016 - Session time: 15:10:00 - Track: Enterprise Database Administration Deployment

Speaker: Suresh Kandoth

Title: Configuring SQL Server for Mission Critical and Scalable Deployments

Abstract:

SQL Server offers various configuration settings and tuning parameters. As hardware capabilities increase rapidly, choosing the proper configuration settings is extremely important to scale SQL Server for the required application throughput rates. In the last two years, SQL Server Escalation Team has helped many systems administrators and database administrators scale their SQL Server with several configuration parameters and application patterns. In this session you will hear directly from an experienced member of the Microsoft SQL Server escalation team [Suresh Kandoth], about these specific learnings, configurations and approaches for scaling SQL Server on the largest hardware systems available on the planet.

The goal of this session to help you and guide you to perform successful deployment of SQL Server for your largest SQL Server installations.

SessionID: 41072

Mission Possible: Interactive Performance Troubleshooting - Index

Back to calendar

Event Date: 30-01-2016 - Session time: 15:10:00 - Track: Enterprise Database Administration Deployment

Speaker: Jim Murphy

Title: Mission Possible: Interactive Performance Troubleshooting - Index

Abstract:

Performance troubleshooting is detective work. We'll have a lab system being assaulted by PowerShell scripts (to simulate live users), and simulated performance problems like those that can make your on-call cell phone ring too much! Do you think you have what it takes to find these "needle in the haystack" issues and resolve them quickly? This will be a highly interactive session where we will locate the rogue queries together, work through solutions, implement them and measure the results. In this episode we'll focus primarily on improper indexing as a common underlying problem and all will walk away with much better troubleshooting skills and an upgraded knowledge of performance tuning!

SessionID: 41844

"Can I Get A Report of This?": Introduction to SSRS

Back to calendar

Event Date: 30-01-2016 - Session time: 15:10:00 - Track: BI Platform Architecture, Development Administration

Speaker: Jeremy Frye

Title: "Can I Get A Report of This?": Introduction to SSRS

Abstract:

In the day-to-day operations of business, how often have we heard or even asked someone the question ourselves, “Can I get a report of this?” Regardless of your area of expertise, reporting has become a necessity and requirement among businesses and is impacting our roles as IT professionals. With the huge wave of trendy reporting tools and software surrounding the BI industry, many people are unaware or often overlook SSRS as a reporting solution. In this session, we will look at the features and capabilities of SSRS, as well as supply you with the tools to begin fulfilling basic report requests. At the conclusion of this session, you will know the difference between Report Builder and SQL Server Data Tools to determine which one is suitable for your needs. You will also be able to create and deploy a basic report consisting of a data source, data set, a parameter and a row group.

SessionID: 41931

Overview of Security Investments in SQL Server 2016 and Azure SQL Database

Back to calendar

Event Date: 30-01-2016 - Session time: 15:10:00 - Track: Enterprise Database Administration Deployment

Speaker: Jamey Johnston

Title: Overview of Security Investments in SQL Server 2016 and Azure SQL Database

Abstract:

Join me for an overview of the most recent security investments for SQL Server 2016 and Azure SQL Database in the areas of encryption, data filtering and data masking. I will showcase a real-life user scenario with examples and demos of Always Encrypted, Row Level Security and Dynamic Data Masking. The demos include a real working .NET application with source code for testing. This is based on the session and demos I co-presented with Microsoft at SQL Summit 2015 so if you missed Summit or the presentation and are interested in learning what Microsoft is doing in the area of security in SQL Server 2016 and Azure SQL DB then this is the session for you.

SessionID: 41961

Make Your SQL Server Queries Go Faster

Back to calendar

Event Date: 30-01-2016 - Session time: 15:10:00 - Track: Enterprise Database Administration Deployment

Speaker: John Sterrett

Title: Make Your SQL Server Queries Go Faster

Abstract:

Have you ever developed slowly running queries and wondered how to make your own SQL Server queries go faster? In this session you will learn some T-SQL performance tuning tips that can be used on Monday back at the office. You will learn how to identify top offender queries, be able to benchmark queries, and apply proper indexes while avoiding common mistakes. Finally we will cover coding patterns that are developer friendly but are not SQL Server database engine friendly and show you how to rewrite them so they can run faster.

SessionID: 42021

Changing Your Habits to Improve the Performance of Your T-SQL

Back to calendar

Event Date: 30-01-2016 - Session time: 15:10:00 - Track: Application Database Development

Speaker: Mickey Stuewe

Title: Changing Your Habits to Improve the Performance of Your T-SQL

Abstract:

Do you dread handing your T-SQL over for code review? Do your queries run slower than you expect? Does the DBA always want to tweak your T-SQL? In this demo heavy session, we’ll take a look at various ways to improve your T-SQL. You’ll learn about formatting T-SQL for readability and why top down design is not the best solution for writing T-SQL. You’ll learn why implicit conversions slow queries down and how to leverage simple techniques for minimizing the performance impact of explicit conversions. By changing some of your T-SQL writing habits you can improve performance of queries from the very beginning.

SessionID: 38606

Strategies for Working with Texas-sized Databases

Back to calendar

Event Date: 30-01-2016 - Session time: 16:20:00 - Track: Enterprise Database Administration Deployment

Speaker: Robert Davis

Title: Strategies for Working with Texas-sized Databases

Abstract:

Very large databases (VLDBs), or just "databases" as they're known in Texas, are just like regular databases, right? There's just more of them to love.

Working with very large databases can be difficult and tricky at times. Everything takes longer, there's more locking, more logging, and minor issues become major very quickly. In this session you will learn some strategies for working with VLDBs such as how to speed up backups and restores, how to fit index maintenance and integrity checks into a thin maintenance window, and how to efficiently and quickly set up failover partners and replicas.

SessionID: 38759

SS2014 In-Memory Tables: Formula 1 Performance Unleashed!

Back to calendar

Event Date: 30-01-2016 - Session time: 16:20:00 - Track: Application Database Development

Speaker: Mike Byrd

Title: SS2014 In-Memory Tables: Formula 1 Performance Unleashed!

Abstract:

Query performance is what it is all about. SQL Server 2014 now has the new in-memory functionality that takes a completely different approach to data access and manipulation. Google “In-Memory Tables” and you’ll get a myriad of results from white papers, blogs, webinars, etc. This session will consolidate the relevant information from all these sources so the production DBA/Developer will be able to understand, create, use, maintain, and trouble-shoot in-memory table functionality. This session will also examine several demo scripts showing performance gains using the in-memory tables over equivalent disk based tables.

This session is all about when and how to apply in-memory tables in a production environment. After this session you will

  1. Understand what in-memory tables are and how to create and maintain them including their limitations
  2. Be able to identify performance gains over equivalent disk back tables
  3. Comprehend the new data monitoring needed for in-memory table

SessionID: 39158

Analyze your query plan like a Microsoft Engineer!

Back to calendar

Event Date: 30-01-2016 - Session time: 16:20:00 - Track: Advanced Analysis Techniques

Speaker: Daniel Janik

Title: Analyze your query plan like a Microsoft Engineer!

Abstract:

This session is a deep dive into query plans and is presented by a former Microsoft PFE (Field Engineer). Learn how a Microsoft Engineer looks at plans and go beyond the typical! There will be plenty of demos and a lot to learn. Join me as I cover the "noteworthy" query plan patterns that go beyond the normal areas that customer tend to investigate. This session covers SQL Server 2005 forward and includes the new SQL Server 2016 Query Store and Live Query Statistics.

SessionID: 39789

SQL Server Database Encryption (TDE)

Back to calendar

Event Date: 30-01-2016 - Session time: 16:20:00 - Track: Enterprise Database Administration Deployment

Speaker: Ben Miller

Title: SQL Server Database Encryption (TDE)

Abstract:

Have you ever wanted to know how Transparent Database Encryption (TDE) works or how you set it up? This session will go over all the steps and caveats that go with this technology. This is a topic that is an Enterprise Feature, but allows you to have your database encrypted on disk. We will discuss the Encryption Hierarchy which is used for encryption in SQL Server. Become a SQL Server Encryption Master when you are done with this session.

SessionID: 41145

Service Broker: Coach your processes asynchronously

Back to calendar

Event Date: 30-01-2016 - Session time: 16:20:00 - Track: Application Database Development

Speaker: William Wolf

Title: Service Broker: Coach your processes asynchronously

Abstract:

This session is an introduction to Service Broker basics. Service Broker is your way to process your data asynchronously in a single instance setting as well as use as a near real time ETL. At the end of this session, you will have the knowledge to use Service Broker for batch processing, ETL or even an alternative to replication.

SessionID: 41990

Introduction to Biml

Back to calendar

Event Date: 30-01-2016 - Session time: 16:20:00 - Track: BI Platform Architecture, Development Administration

Speaker: Tim Mitchell

Title: Introduction to Biml

Abstract:

Have you ever needed to generate dozens (or even hundreds) of similar SSIS packages? Do you ever find yourself needing to regenerate a lot of packages when some piece of the upstream data format changes? Using native SSIS, this can be a tedious and error prone exercise. However, using Biml (Business Intelligence Markup Language) can greatly increase your productivity as an ETL developer.

In this session, we'll cover the essentials of Biml. I'll discuss what it is and what it can do for SSIS, demonstrating how it can easily generate dozens or even hundreds of packages in just a few minutes. I'll also demonstrate some realistic examples and discuss how Biml fits into the enterprise ETL picture.

This site is open source. Improve this page.