sqlsathistory

Nr: 595

Back to Main list

SQLSaturday #595 - Cleveland 2017

Start Time (24h)	Speaker	Track	Title
08:30:00	Vladimir Oselsky	Application Database Development	Crash Course on Better SQL Development
08:30:00	Kevin Feasel	Strategy and Architecture	Big Data, Small Data, and Everything In Between
08:30:00	Slava Murygin	Enterprise Database Administration Deployment	SQL Server on Linux for SQL DBA.
08:30:00	Ginger Grant	BI Information Delivery	Power BI Administration and Best Practices Implementation Techniques
08:30:00	Jeremy Frye	BI Platform Architecture, Development Administration	SSIS Incremental Loading: The Tortoise and The Hare
08:30:00	Anders Pedersen	Enterprise Database Administration Deployment	I/O Tuning 101
09:45:00	Vishal Pawar	Analytics and Visualization	Create lightning fast Dashboard with Power BI and its Components
09:45:00	Matt Gordon	Enterprise Database Administration Deployment	Top 5 Tips to Keep Always On Always Humming and Users Happy
09:45:00	Delora Bradish	Strategy and Architecture	Beyond the Basics of Multidimensional vs Tabular in SQL 2016
09:45:00	Dave Bland	Enterprise Database Administration Deployment	Extended Events: What are they and How do I use them
09:45:00	Eric Blinn	Application Database Development	SSMS Tips and Tricks
09:45:00	Frank Gill	Enterprise Database Administration Deployment	Anatomy of a Transaction
11:00:00	Jonathan Stewart	BI Platform Architecture, Development Administration	Data Visualization: How to truly tell a great story!
11:00:00	Janis Griffin	Enterprise Database Administration Deployment	Does your performance tuning need a 12-step program?
11:00:00	Adam Machanic	Application Database Development	Don't Let History Be a Mystery! Temporal Data in SQL Server 2016
11:00:00	Kathi Kellenberger	Application Database Development	Introduction to Window Functions
11:00:00	Konstantin Melamud	Application Database Development	In-Memory OLTP for Developers: What You Need to Know
11:00:00	Pat Phelan	Application Database Development	Relational Data Architecture 101
13:30:00	Wylie Blanchard	BI Information Delivery	Analyzing SQL Server Data using PowerPivot in MS Excel
13:30:00	Drew Furgiuele	Enterprise Database Administration Deployment	SQL Server Transactional Replication: A Deep Dive
13:30:00	David Maxwell	Enterprise Database Administration Deployment	Wait Statistics - The Top 5 Waits You Should Know
13:30:00	Aaron Cutshall	Professional Development	How To Give a Technical Presentation
13:30:00	Andy Yun	Application Database Development	Performance Pitfalls from Code Reuse
13:30:00	Dustin Prescott	Enterprise Database Administration Deployment	Hacking SQL Server - A Peek into the Dark Side
14:45:00	William E Pearson III	BI Platform Architecture, Development Administration	Seeking the Perfect Hybrid: On-Prem Data with Reports and Dashboards in Power BI
14:45:00	Eugene Meidinger	Application Database Development	Execution Plans 101
14:45:00	Greg Deckler	Advanced Analysis Techniques	It's a Machine World - Predictive Analytics with Azure Machine Learning
14:45:00	Thomas Chan	Enterprise Database Administration Deployment	Secure/Encrypt SQL Server Database With TDE
14:45:00	Erin Stellato	Enterprise Database Administration Deployment	Ensuring Plan Stability with Query Store
14:45:00	Frank Gill	Cloud Application Development Deployment	Creating an Azure SQL Database Using PowerShell
16:15:00	Michael Schulte	Analytics and Visualization	Extending SQL Server with Advanced Analytics and R
16:15:00	Jared Karney	Application Database Development	Introduction to Indexes and SARGability
16:15:00	Wendy Pastrick	Application Database Development	Why NULL is not a value (and other SQL gotchas)
16:15:00	Rick Lowe	Enterprise Database Administration Deployment	Why should I care about ... the plan cache?
16:15:00	Andy Mallon	Application Database Development	Demystifying Data Compression
16:15:00	Peter Shore	Enterprise Database Administration Deployment	Got stress? Sometimes the SQL Server needs some too

SessionID: 56328

Crash Course on Better SQL Development

Back to calendar

Event Date: 04-02-2017 - Session time: 08:30:00 - Track: Application Database Development

Speaker: Vladimir Oselsky

Title: Crash Course on Better SQL Development

Abstract:

SQL Development is a broad subject with many roads to choose from. Often times SQL Developers feel overwhelmed and unsure which areas they need to focus on. The purpose of this session is to give a high-level overview and present paths for further study and growth. Subjects reviewed in this session will include coding patterns, error handling, and execution plans. Demonstrations of free tools will also help developers find ways of simplifying their daily tasks. Attendees will leave this session empowered with knowledge and directions for further growth.

SessionID: 56342

Big Data, Small Data, and Everything In Between

Back to calendar

Event Date: 04-02-2017 - Session time: 08:30:00 - Track: Strategy and Architecture

Speaker: Kevin Feasel

Title: Big Data, Small Data, and Everything In Between

Abstract:

The breadth of options available to data professionals today is staggering: between relational, object, graph, and document databases, we have a wide array of storage options, as well as a huge number of access and analysis tools. This talk will walk you through data platform, data analysis, and data processing options. We’ll discuss when to use (and when not to use) Spark, R, Storm, and SSAS, as well as a range of other tools and technologies. By the end of this talk, you may not have MongoDB or Neo4J, but you will know where they might fit.

SessionID: 56937

SQL Server on Linux for SQL DBA.

Back to calendar

Event Date: 04-02-2017 - Session time: 08:30:00 - Track: Enterprise Database Administration Deployment

Speaker: Slava Murygin

Title: SQL Server on Linux for SQL DBA.

Abstract:

For the last 25 years SQL Server DBAs administered SQL databases using only Windows GUI.

For majority of them even Windows Core is too hard to accept. In the situation, when Microsoft invaded Linux territory with it's flagship product, as SQL DBA, you must not outsource SQL Server administration to some Linux geeks. You can do it yourself! Your way! And I show you how to do it.

SessionID: 57151

Power BI Administration and Best Practices Implementation Techniques

Back to calendar

Event Date: 04-02-2017 - Session time: 08:30:00 - Track: BI Information Delivery

Speaker: Ginger Grant

Title: Power BI Administration and Best Practices Implementation Techniques

Abstract:

Power BI is becoming more and more widely used in various organizations. As it’s adoption grows there are a number of decisions and practices, which if made early in the process can prevent problems. Attendees to this session will learn the best practice methods for administering Power BI from visualization creation to deployment. These concepts will assist to provide a successful implementation which will scale from a management perspective to encompass both the non-technical users who are starting to clamor for better analysis tools while providing a framework for managing the data from an IT perspective. This session will also cover an in-depth dive to the administration and security features of Power BI ensuring attendees will know exactly how Power BI can be managed and secured in their environments.

SessionID: 57311

SSIS Incremental Loading: The Tortoise and The Hare

Back to calendar

Event Date: 04-02-2017 - Session time: 08:30:00 - Track: BI Platform Architecture, Development Administration

Speaker: Jeremy Frye

Title: SSIS Incremental Loading: The Tortoise and The Hare

Abstract:

Extracting, transforming and loading data has become a major component to satisfying business requirements and needs. Depending on the size of the data you are working with, the way you design your SSIS packages can have an impact on performance and run times. In this session, we will cover a variety of incremental design approaches centered around large data sets using SSIS. We will look at the pros and cons of each ETL strategy and generate specific use cases to decide which strategy yields optimal results.

SessionID: 57499

I/O Tuning 101

Back to calendar

Event Date: 04-02-2017 - Session time: 08:30:00 - Track: Enterprise Database Administration Deployment

Speaker: Anders Pedersen

Title: I/O Tuning 101

Abstract:

One of the most common problems I have encountered as a DBA is the complaints from users that a particular query is slow, just one query. Many times one that used to run in acceptable time, but that over time has slowed down substantially.

In this session we will show some of the causes for this, with emphasis on I/O requests being too high for the query.

First part of the session will explain how to find these numbers, looking at a few queries with some major performance issues, including explaining why they have a problem.

The second part will focus on how to reduce I/O requests.

All of this can be done without the need for any 3rd party tools, all within the scope of what is available to SQL Server, all versions, all editions, including Azure.

SessionID: 56343

Create lightning fast Dashboard with Power BI and its Components

Back to calendar

Event Date: 04-02-2017 - Session time: 09:45:00 - Track: Analytics and Visualization

Speaker: Vishal Pawar

Title: Create lightning fast Dashboard with Power BI and its Components

Abstract:

Every data has meaning, but we had limitation to use data through big long running process Extraction, Transformation and Representation, but now Power BI solves your problem to kick start having Data extraction in Power Query, Data Modelling and Transformation in Power Pivot and reach data representation using power view and power map on demand any nearby device on your fingertips, You will learn all latest and greatest features of Power BI.

SessionID: 56349

Top 5 Tips to Keep Always On Always Humming and Users Happy

Back to calendar

Event Date: 04-02-2017 - Session time: 09:45:00 - Track: Enterprise Database Administration Deployment

Speaker: Matt Gordon

Title: Top 5 Tips to Keep Always On Always Humming and Users Happy

Abstract:

Have you ever wondered what it takes to keep an Always On availability group running and the users and administrators who depend on it happy? Let my experience maintaining several production Always On Availability Groups provide you some battle-tested information and hopefully save you some sleepless nights. From security tips to maintenance advice, come hear about some less than obvious tips that will keep users happy and the DBA’s phone quiet.

SessionID: 56970

Beyond the Basics of Multidimensional vs Tabular in SQL 2016

Back to calendar

Event Date: 04-02-2017 - Session time: 09:45:00 - Track: Strategy and Architecture

Speaker: Delora Bradish

Title: Beyond the Basics of Multidimensional vs Tabular in SQL 2016

Abstract:

This session is all about hands-on experience and information sharing of SQL 2016 MultiD vs Tabular differences that are not articulated in common Internet blogs and MSDN comparison charts. You will be seeing VS examples of many-to-many, date calculation strategies, role playing dimensions, hierarchies and we'll be talking a lot about available properties. We'll be covering storage and query engines, performance tuning and extended events. If you are evaluating either of these SSAS tools for your BI project, come spend an hour digging into the detail which will help you make a more informed project decision.

SessionID: 57368

Extended Events: What are they and How do I use them

Back to calendar

Event Date: 04-02-2017 - Session time: 09:45:00 - Track: Enterprise Database Administration Deployment

Speaker: Dave Bland

Title: Extended Events: What are they and How do I use them

Abstract:

Since Extended Events are replacing Profiler, every DBA should know what they are and how to use them. This session will cover the basics of Extended events as well as an introduction to the system_health session. This session will give someone who has never used Extended events before the skills to start using them!

SessionID: 57450

SSMS Tips and Tricks

Back to calendar

Event Date: 04-02-2017 - Session time: 09:45:00 - Track: Application Database Development

Speaker: Eric Blinn

Title: SSMS Tips and Tricks

Abstract:

Most of us do not have a lot of spare time at work. In this session we will share favorite shortcuts, tips, and tricks for using SQL Server and Management Studio. Learn how to manage your server and write code quickly to help you save a few minutes every day.

SessionID: 57770

Anatomy of a Transaction

Back to calendar

Event Date: 04-02-2017 - Session time: 09:45:00 - Track: Enterprise Database Administration Deployment

Speaker: Frank Gill

Title: Anatomy of a Transaction

Abstract:

In SQL Server, the transaction log is the most important file in any database. All changes to the data and schema are tracked in the transaction log. Join me to learn how to read the transaction log, how to follow a transaction as is processes, and how SQL Server handles a transaction rollback. You will also learn how to identify the resources and objects SQL Server accesses during the course of the transaction. Finally, you will see how SQL Server processes transactions for In-Memory tables.

SessionID: 56364

Data Visualization: How to truly tell a great story!

Back to calendar

Event Date: 04-02-2017 - Session time: 11:00:00 - Track: BI Platform Architecture, Development Administration

Speaker: Jonathan Stewart

Title: Data Visualization: How to truly tell a great story!

Abstract:

We have more information available to us today than ever before. So much so that we run the risk of not being able to tell concise stories. There's a lot more to creating that story than just getting the correct information. Come learn not just the do's and don'ts, but the whys…

SessionID: 56554

Does your performance tuning need a 12-step program?

Back to calendar

Event Date: 04-02-2017 - Session time: 11:00:00 - Track: Enterprise Database Administration Deployment

Speaker: Janis Griffin

Title: Does your performance tuning need a 12-step program?

Abstract:

Performance tuning can be complex.It's often hard to know which knob to turn or button to press to get the biggest performance boost. In this presentation, Janis Griffin, Database Performance Evangelist, SolarWinds, will detail 12 steps to quickly identify performance issues and resolve them. Attendees at this session will learn how to:

1. Quickly fine tune a SQL statement
2. Identify performance inhibitors to help avoid future performance issues
3. Recognize and understand how new SQL Server features can help improve query
   performance

SessionID: 57337

Don't Let History Be a Mystery! Temporal Data in SQL Server 2016

Back to calendar

Event Date: 04-02-2017 - Session time: 11:00:00 - Track: Application Database Development

Speaker: Adam Machanic

Title: Don't Let History Be a Mystery! Temporal Data in SQL Server 2016

Abstract:

It's been said that the only constant is change, and no truism better defines the average database workload. With data constantly shifting in form and focus, DBAs and developers find themselves fielding myriad questions about whens and whys: When did this fact get updated? Why is data quality lower than it was last week? And where did my sales figures go?!? Solutions such as Change Tracking, Change Data Capture, and hand-rolled triggers can each be leveraged to help in this scenario, but with various ugly tradeoffs. SQL Server 2016 introduces Temporal Tables, a new technology that finally gets us what we've needed all along. In this session you'll learn how to enable seamless and automatic history collection, take control of a great query experience, and build on a solid platform to help your users understand data history. By taking advantage of this fantastic feature, you'll approach your next project ready to answer all of the questions that constant change brings to the table.

SessionID: 57381

Introduction to Window Functions

Back to calendar

Event Date: 04-02-2017 - Session time: 11:00:00 - Track: Application Database Development

Speaker: Kathi Kellenberger

Title: Introduction to Window Functions

Abstract:

SQL Server 2005 and later versions introduced several T-SQL features that are like power tools in the hands of T-SQL developers. If you aren’t using these features, you’re probably writing code that doesn’t perform as well as it could.

This session will teach you how to avoid cursor solutions, and create simpler code by using the window functions that have been introduced between 2005 and 2012. You'll learn how to use the new functions and how to apply them to several design patterns that are commonly found in the real world.

SessionID: 57391

In-Memory OLTP for Developers: What You Need to Know

Back to calendar

Event Date: 04-02-2017 - Session time: 11:00:00 - Track: Application Database Development

Speaker: Konstantin Melamud

Title: In-Memory OLTP for Developers: What You Need to Know

Abstract:

With the significant improvements made to in-memory OLTP in SQL Server 2016, it’s natural to expect significant increases in query performance. But what do we do when queries which utilize in-memory tables actually start to perform same or, in some cases, even worse than their equivalent disk based table predecessors?

In this session, we are going to take a look at in-memory tables, their best use cases as well as development best practices. We will also look at the changes to the indexing design for inMemory-based objects and how it differs from existing disk-based table indexing. Finally, we are going to cover how to build fast, scalable applications which utilize inMemory objects, as well as choosing the appropriate indexes for your inMemory objects to give you the performance boost that you have been expecting.

SessionID: 57437

Relational Data Architecture 101

Back to calendar

Event Date: 04-02-2017 - Session time: 11:00:00 - Track: Application Database Development

Speaker: Pat Phelan

Title: Relational Data Architecture 101

Abstract:

This presentation is a quick introduction for the DBA or developer who was just told that their boss promised a major new customer a scalable, well designed database. The customer will pay a lot of cash and years of ongoing business using this database… If you deliver it this week!

You’ll get a big bonus if you build this right, but you also remember what your co-workers did to the person who bungled the last database design… and wonder if that designer ever recovered! This session will introduce you to the fundamentals of Datatypes, Relational Algebra, and Normalization to help you avoid the major pitfalls and maybe get some sleep too!

This presentation is a survey of Data Architecture for the Intermediate DBA, it is not intended for experienced Data Modelers.

SessionID: 56345

Analyzing SQL Server Data using PowerPivot in MS Excel

Back to calendar

Event Date: 04-02-2017 - Session time: 13:30:00 - Track: BI Information Delivery

Speaker: Wylie Blanchard

Title: Analyzing SQL Server Data using PowerPivot in MS Excel

Abstract:

Your end users want to analyze data in your data warehouse. They could deal with the learning curve of SSAS but they'd prefer to utilize a familiar application like MS Excel. Welcome PowerPivot, a tool that retrieves data from your data warehouse by combining the power of SSAS models and your SQL Server Data warehouse within the familiar interface of MS Excel. In this presentation well explore SSAS BI Semantic model, PowerView, PowerPivot in Excel.

SessionID: 56616

SQL Server Transactional Replication: A Deep Dive

Back to calendar

Event Date: 04-02-2017 - Session time: 13:30:00 - Track: Enterprise Database Administration Deployment

Speaker: Drew Furgiuele

Title: SQL Server Transactional Replication: A Deep Dive

Abstract:

Ah, SQL Server Transactional Replication. The technology everyone loves to hate. But for all the notoriety, there's some interesting technology to be had in it that might you might want to leverage. In this session, we'll explore what happens when you create a new transactional publication: what happens during a snapshot, how data gets delivered to subscribers, and how you can monitor, tweak, and tune your publications. We'll also see some common trouble spots and how to identify them. There will be plenty of examples and demos and, yes, even some PowerShell!

SessionID: 56675

Wait Statistics - The Top 5 Waits You Should Know

Back to calendar

Event Date: 04-02-2017 - Session time: 13:30:00 - Track: Enterprise Database Administration Deployment

Speaker: David Maxwell

Title: Wait Statistics - The Top 5 Waits You Should Know

Abstract:

Wait statistics are a great tool for troubleshooting performance problems in SQL Server. However, there are so many different wait types in SQL Server, it can be challenging to determine what to focus on and what can be ignored. Even after discovering that SQL Server is waiting for something, most DBAs don't know where to look next. In this session, we'll examine 5 of the most frequently seen wait types in SQL Server and how to troubleshoot each of them. You'll learn how to determine the root cause of a particular wait type, and how to avoid common mistakes made when troubleshooting with wait statistics.

SessionID: 56677

How To Give a Technical Presentation

Back to calendar

Event Date: 04-02-2017 - Session time: 13:30:00 - Track: Professional Development

Speaker: Aaron Cutshall

Title: How To Give a Technical Presentation

Abstract:

Most people don't like to speak in public and technical folks are certainly no exception. Yet, you've got some ideas for a great presentation but just don't know how to go about putting it all together. On top of that, how do you go about giving the presentation itself? This session will cover how to pull your material together in an organized fashion and present it such that your audience can follow along and get the message you want to relay. We'll also discuss how to deal with issues that cause presenters stress to help you to make the process enjoyable and rewarding for all.

SessionID: 57301

Performance Pitfalls from Code Reuse

Back to calendar

Event Date: 04-02-2017 - Session time: 13:30:00 - Track: Application Database Development

Speaker: Andy Yun

Title: Performance Pitfalls from Code Reuse

Abstract:

Have you ever found yourself deconstructing endless layers of nested code? Is your T-SQL codebase written in an object-oriented format with functions views? Did you know that object-oriented code reuse can come at a significant penalty?

Come to this session and learn why applying object-oriented principles can be extremely detrimental to your T-SQL's performance. You will learn how T-SQL is not like other common programming languages. We will peek inside the Query Optimizer to see how it handles these scenarios. Through extensive demos, we will explore solutions to maximize performance. You will be introduced to a T-SQL tool that will aid you in unraveling nested code. Alternate design patterns will be shown to help you mitigate these performance pitfalls.

SessionID: 57510

Hacking SQL Server - A Peek into the Dark Side

Back to calendar

Event Date: 04-02-2017 - Session time: 13:30:00 - Track: Enterprise Database Administration Deployment

Speaker: Dustin Prescott

Title: Hacking SQL Server - A Peek into the Dark Side

Abstract:

The best defense is a good offense. Learn how to practice hacking without going to jail or getting fired. In this presentation we'll be demonstrating how to exploit weak SQL servers with actual tools of the penetration testing trade. You will learn why the SQL Service is a popular target on your network and how to defend against basic attacks.

SessionID: 56378

Seeking the Perfect Hybrid: On-Prem Data with Reports and Dashboards in Power BI

Back to calendar

Event Date: 04-02-2017 - Session time: 14:45:00 - Track: BI Platform Architecture, Development Administration

Speaker: William E Pearson III

Title: Seeking the Perfect Hybrid: On-Prem Data with Reports and Dashboards in Power BI

Abstract:

For many new Power BI implementations, initial self-service and team objectives are soon met, and the natural evolution of Power BI turns to an organizational focus. In other scenarios, the enterprise seeks to preserve its investments in "classic BI" by integrating Power BI with Analysis Services and the underlying data warehouse.

In this session, Data Platform (SQL Server / BI) MVP and SSAS Maestro Bill Pearson explores the construction of organizational BI solutions, wedding the "traditional" solutions with the reporting and analysis power of Power BI. We'll focus upon the components of a "traditional" solution, up to the semantic model (with SQL Server Analysis Services as an example), and then explore paths to the implementation of an end-to-end enterprise solution that uses Power BI as the presentation layer. This session applies, in most respects, to Analysis Services 2012 and above.

SessionID: 56487

Execution Plans 101

Back to calendar

Event Date: 04-02-2017 - Session time: 14:45:00 - Track: Application Database Development

Speaker: Eugene Meidinger

Title: Execution Plans 101

Abstract:

Do you have a query that you want to tune, but don't know where to start? Execution plans can be a great starting point for understanding what your query is doing under the hood. This course covers the bare bones basics: what an execution plan is, how to run them, how to read them, and additional features.

SessionID: 56629

It's a Machine World - Predictive Analytics with Azure Machine Learning

Back to calendar

Event Date: 04-02-2017 - Session time: 14:45:00 - Track: Advanced Analysis Techniques

Speaker: Greg Deckler

Title: It's a Machine World - Predictive Analytics with Azure Machine Learning

Abstract:

Introduces Microsoft Azure Machine Learning, explaining what Azure Machine Learning is and how it functions. Attendees are walked through a real world scenario of building and using a predictive analytics model with Azure Machine Learning. At the end of this session, attendees will understand fundamental Azure Machine Learning terminology, how to build, train and use a predictive analytics model and the key concepts around the various components used within predictive models.

SessionID: 57487

Secure/Encrypt SQL Server Database With TDE

Back to calendar

Event Date: 04-02-2017 - Session time: 14:45:00 - Track: Enterprise Database Administration Deployment

Speaker: Thomas Chan

Title: Secure/Encrypt SQL Server Database With TDE

Abstract:

TDE, Transparent Database Encryption, is a Microsoft built-in solution to protect sensitive information by encrypting entire SQL Server database. TDE encrypts and decrypts the data on the fly with minimum overhead and no code change at all on the development or application side.

SessionID: 57497

Ensuring Plan Stability with Query Store

Back to calendar

Event Date: 04-02-2017 - Session time: 14:45:00 - Track: Enterprise Database Administration Deployment

Speaker: Erin Stellato

Title: Ensuring Plan Stability with Query Store

Abstract:

SQL Server 2016 introduced Query Store, a new feature which tracks query metrics and can be used for troubleshooting, testing, and proactively monitoring a workload. Query Store also provides the ability to force a plan for particular query, which means you may no longer need to use those tricky plan guides.

In this session, we'll start with a quick review of how Query Store works. Then we'll examine plan forcing in depth, including why a forced plan will fail and how plan forcing compares to using plan guides. Expect a lot of demos as we investigate how Query Store can help you do more than just troubleshoot issues, but also manage query performance.

SessionID: 57771

Creating an Azure SQL Database Using PowerShell

Back to calendar

Event Date: 04-02-2017 - Session time: 14:45:00 - Track: Cloud Application Development Deployment

Speaker: Frank Gill

Title: Creating an Azure SQL Database Using PowerShell

Abstract:

Azure SQL Database provides an environment to quickly build SQL Server databases. This allows for testing of new versions and functionality with minimal effort. PowerShell provides cmdlets that create, configure and deploy an Azure SQL Database quickly and easily. Additionally, cmdlets exist to tear the environment down once you are done with it, Join me to learn more about the options available for scripting and automating the build of an Azure SQL Database.

SessionID: 56354

Extending SQL Server with Advanced Analytics and R

Back to calendar

Event Date: 04-02-2017 - Session time: 16:15:00 - Track: Analytics and Visualization

Speaker: Michael Schulte

Title: Extending SQL Server with Advanced Analytics and R

Abstract:

The Microsoft SQL Server stack provides an excellent set of tools for storing, visualizing, and analyzing data, but sometimes we want to do more. In this session, we’ll take a look at the various ways that we can apply advanced analytics by using the R programming language on top of SQL Server. We#39;ll consider the advantages and capabilities of SQL Server R Services and look at how to set up a development environment. Along the way, we will discuss the data science workflow and consider some examples of advanced analytics that are commonly used.

SessionID: 56460

Introduction to Indexes and SARGability

Back to calendar

Event Date: 04-02-2017 - Session time: 16:15:00 - Track: Application Database Development

Speaker: Jared Karney

Title: Introduction to Indexes and SARGability

Abstract:

Did you know that there is more than one type of index? Do you know the differences between them? Do you know when SQL Server flat out can’t use an index? Join Jared Karney as he explains the differences between the types of indexes and when they can and cannot be used (SARGability). He will talk about the different ways they are used and how you can make good indexes even better. You will leave this session understanding the basics of indexes and how they work, which is crucial to making your queries and servers perform well.

SessionID: 56523

Why NULL is not a value (and other SQL gotchas)

Back to calendar

Event Date: 04-02-2017 - Session time: 16:15:00 - Track: Application Database Development

Speaker: Wendy Pastrick

Title: Why NULL is not a value (and other SQL gotchas)

Abstract:

Allowing NULL "values" in your database is simple, but managing them is a whole different story. Learn what NULL really means and why you may want to avoid it in your systems. I will share techniques for overcoming NULL and other SQL idiosyncrasies leading to bad data or incorrect query results.

SessionID: 57469

Why should I care about ... the plan cache?

Back to calendar

Event Date: 04-02-2017 - Session time: 16:15:00 - Track: Enterprise Database Administration Deployment

Speaker: Rick Lowe

Title: Why should I care about ... the plan cache?

Abstract:

SQL Server is a huge product, with many different places a DBA can go to look for information on how the server is performing. So many in fact that they can often overlap, which sometimes makes it hard to understand why tackling a new tool is worth the effort. In this installment of Rick's "Why should I care" series, he lays out a case for why working knowledge of the plan cache is critical for performance tuning efforts in real world environments. A review of relevant views and functions is included for the (newly?) motivated audience.

Perfect for those who are relatively new to performance tuning concerns, or advanced DBAs trying to figure out how to have a similar conversation with their less experienced peers, or developers who are curious as to why their DBAs drink in the morning (allegedly). This is not a deep dive into the cache, it really is primarily a session exploring why these DMOs are worth slogging through.

SessionID: 57511

Demystifying Data Compression

Back to calendar

Event Date: 04-02-2017 - Session time: 16:15:00 - Track: Application Database Development

Speaker: Andy Mallon

Title: Demystifying Data Compression

Abstract:

SQL Server 2016 SP1 makes data compression available in all editions. Data compression can reduce storage costs, and provide a performance boost—and now compression is available without the added cost of Enterprise Edition. Whether you are a developer or a DBA, it's important to know how to use compression to save money and improve speed.

Come learn about how data compression actually works, the differences between ROW and PAGE compression, and learn how to pick the best compression level for your data. This session will cover the details of the compression algorithms, and the costs and benefits associated with each type of compression.

By the end of this session, you'll have a better idea of how the different compression algorithms work, when compression is the right solution, as well as what type of compression to use.

SessionID: 57533

Got stress? Sometimes the SQL Server needs some too

Back to calendar

Event Date: 04-02-2017 - Session time: 16:15:00 - Track: Enterprise Database Administration Deployment

Speaker: Peter Shore

Title: Got stress? Sometimes the SQL Server needs some too

Abstract:

We hear it in every session and every webinar “…test…” regardless of it being upgrades, new code, performance tuning or any of a thousand changes. Once we confirm nothing breaks., we don’t need to check anything else, nothing could possibly change the results, right? What about load on the database(s) in question or the server as a whole? In this session four readily available tools, distributed replay, Hammer DB, SQL Query Stress and oStress will be introduced. The session will cover how to use the tools as well as which situations they shine in. Once introductions are made, we will spend a little time with two of my favorites, HammerDB and SQL Query Stress. Join me as we apply a little heat to our SQL Servers.

This site is open source. Improve this page.