sqlsathistory

Nr: 651

Back to Main list

SQLSaturday #651 - Houston 2017

Start Time (24h) Speaker Track Title
08:30:00 William Assaf Application Database Development SQL Server Permissions and Security Principals
08:30:00 Brent Ozar Enterprise Database Administration Deployment What to Do When SQL Server is Slow
08:30:00 Thomas LeBlanc BI Platform Architecture, Development Administration Business Analytics in SQL Server 2016
08:30:00 Ryan Adams Enterprise Database Administration Deployment Install an AlwaysOn Failover Cluster and Availability Group
08:30:00 Phillip Labry Cloud Application Development Deployment Analysis Services is in Azure? Seriously!? Let's build a model!
08:30:00 Rick Lowe Application Database Development Why should I care about ... the plan cache?
09:45:00 Roberto Cavalcanti Cloud Application Development Deployment Azure SQL Database - Lessons learned from the trenches
09:45:00 Mike Byrd Application Database Development A Rocket Scientist View on Indexes
09:45:00 Robert Bishop Application Database Development You want me to Isolate what? An introduction into data integrity and Isolation Levels of SQL Server
09:45:00 Trayce Jordan Enterprise Database Administration Deployment Finding root cause for unexplained Availability Group failover
09:45:00 Tim Mitchell BI Platform Architecture, Development Administration Exploring the All-New SSRS 2016
09:45:00 Bob Ward Enterprise Database Administration Deployment Inside SQL Server Machine Learning Services: Database Intelligence at Scale
11:00:00 Kevin Hill Other Backups for non-DBAs...the Why, not the How
11:00:00 Christopher Sims Application Database Development I like big data for $400 - Exploring quiz show questions using Angular, DocumentDB and Azure Search
11:00:00 Russel Loski Cloud Application Development Deployment Querying Semistructured Data in Azure Data Lake with USQL
11:00:00 David Stein BI Platform Architecture, Development Administration Agile Data Warehouse and ETL Design with Biml
11:00:00 Lance Tidwell Enterprise Database Administration Deployment Introduction to Execution Plans
11:00:00 Kris Hokanson Application Database Development Random Acts of Senseless Databasing
12:30:00 Brent Ozar Enterprise Database Administration Deployment Free Scripts to Troubleshoot SQL Server: sp_Blitz, sp_BlitzCache, and More
12:30:00 Robyn Fuentes Application Database Development DevOps for Migratory Deployments
13:30:00 Steven Tidwell Application Database Development Dynamic SQL: Tables, Pivots
13:30:00 Shawn Weisfeld Cloud Application Development Deployment Intro to Azure SQL Data Warehouse
13:30:00 Jennifer McCown Application Database Development Beginning T-SQL
13:30:00 Vicky Harp Enterprise Database Administration Deployment Introduction to SQL 2016 Temporal Tables
13:30:00 Robert Stewart BI Platform Architecture, Development Administration Data Warehousing 101
13:30:00 Amy Herold Enterprise Database Administration Deployment Deadlock, Block Two Smoking Barrels: Breaking Down Blocking and Deadlocks
14:45:00 Bob Ward Enterprise Database Administration Deployment Inside SQL Server In-Memory OLTP
14:45:00 John Cook Application Database Development SQL Server Graph Database
14:45:00 Dane Schilling Application Database Development MS SQL - Review, Renew, and Reveal
14:45:00 Lori Edwards Professional Development Do More Than Just Talk
14:45:00 John Harp Enterprise Database Administration Deployment Crappy Queries: A Beginner's Guide to Hunting in the Field
14:45:00 Chris Hyde BI Platform Architecture, Development Administration Python in SQL Server 2017
16:00:00 Naomi Williams Enterprise Database Administration Deployment SQL Server Internals
16:00:00 Thomas Norman Application Database Development Database Project Makes Deployment Consistent
16:00:00 Jamey Johnston BI Platform Architecture, Development Administration Code Like a Pirate ... Intro to R and Data Science Tools in MS
16:00:00 Sean McCown Enterprise Database Administration Deployment Loading SQL Server Data with Powershell
16:00:00 John Sterrett Enterprise Database Administration Deployment Table Partitioning: the Secret Weapon for Your Big Data Problems
16:00:00 Anthony {Tex} Moreign Cloud Application Development Deployment [Big

SessionID: 63544

SQL Server Permissions and Security Principals

Back to calendar

Event Date: 17-06-2017 - Session time: 08:30:00 - Track: Application Database Development

Speaker: William Assaf

Title: SQL Server Permissions and Security Principals

Abstract:

A ground-floor introduction to SQL Server permissions starting with the basics and moving into the security implications behinds stored procedures, views, database ownership, application connections, consolidated databases, application roles and more. This class is perfect for DBA's, developers and system admins, and includes information on securing Azure SQL databases!

SessionID: 63546

What to Do When SQL Server is Slow

Back to calendar

Event Date: 17-06-2017 - Session time: 08:30:00 - Track: Enterprise Database Administration Deployment

Speaker: Brent Ozar

Title: What to Do When SQL Server is Slow

Abstract:

Someone comes running in and asks, "Are you doing something on the SQL Server right now? Can you take a look at it? It seems really slow."

It's one of the most common complaints we get about our databases - and yet, most of us don't have a written plan with what steps to take, in order.

I do this for a living, so I've had to make a written checklist to handle it. I'll give you the exact same checklist I use, then walk you through several performance emergencies. I'll show you how I use open source scripts like sp_WhoIsActive, sp_BlitzFirst, sp_BlitzCache, and more to find the root cause fast. We won't cover performance tuning - our goal in this hour is just to have a written triage process so we don't look like bumbling idiots. Let's get good at this!

SessionID: 63571

Business Analytics in SQL Server 2016

Back to calendar

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

Speaker: Thomas LeBlanc

Title: Business Analytics in SQL Server 2016

Abstract:

Ever wonder what’s going on with Microsoft Business Intelligence features? Is everything going to the Cloud, or can I still rely on my own servers to design systems? Well, this session is for you.

We are going to spend hours on looking at the new features of SQL Server 2016 that will help you create on premise solutions for you company or clients that complement the solutions you have already built. SQL Server 2016 not only gives you new tools like R integration and Mobile Reporting, but enhances Analysis Services and Reporting Services you have been using for years.

You will leave with a comforting feeling that Microsoft is not leaving you behind if you do not or cannot go to the Cloud. Perhaps we shall see the thunder of BI love to what we know best and to succeed in the future.

SessionID: 63850

Install an AlwaysOn Failover Cluster and Availability Group

Back to calendar

Event Date: 17-06-2017 - Session time: 08:30:00 - Track: Enterprise Database Administration Deployment

Speaker: Ryan Adams

Title: Install an AlwaysOn Failover Cluster and Availability Group

Abstract:

You have decided to install and deploy a Failover Cluster Instance and an Availability Group but don't know where to start. This complicated architecture has many moving parts (including Windows Clustering), and you are overwhelmed. How do you install these features? This session walks you through a complete AlwaysOn environment, in which we install and configure an AlwaysOn Failover Cluster Instance and an AlwaysOn Availability Group across 5 nodes. We use both the GUI and T-SQL so that you know how, why, and when to use each method.

SessionID: 64120

Analysis Services is in Azure? Seriously!? Let's build a model!

Back to calendar

Event Date: 17-06-2017 - Session time: 08:30:00 - Track: Cloud Application Development Deployment

Speaker: Phillip Labry

Title: Analysis Services is in Azure? Seriously!? Let's build a model!

Abstract:

Have you used SSAS before? Have you created reports using T-SQL and Group by? Are you interested in Power BI? Do you you have a need for analysis services but don't want to have to deal with the hassle of buying and installing a server? Is your organization using Office 365? If you answered yes to any of these questions, you might need Azure Analysis Services. The wait is almost over! Azure Analysis services is the platform as a service version of the wildly popular Analysis Services Tabular product. Join Phillip as he builds and deploys an Azure Analysis services solution.

SessionID: 64410

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

Back to calendar

Event Date: 17-06-2017 - Session time: 08:30:00 - Track: Application Database Development

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

Azure SQL Database - Lessons learned from the trenches

Back to calendar

Event Date: 17-06-2017 - Session time: 09:45:00 - Track: Cloud Application Development Deployment

Speaker: Roberto Cavalcanti

Title: Azure SQL Database - Lessons learned from the trenches

Abstract:

In this session you will learn the best practices, tips and tricks on how to successfully use Azure SQL Database on production environments. You will learn how to monitor and improve Azure SQL Database query performance. I will cover how Microsoft CSS has been using Query Store, Extended Events, DMVs to help customers monitor and improve query response times when running their databases in the Microsoft Azure cloud. These learnings are fruit of Microsoft CSS support cases, and customer field engagements. This session includes several demos.

SessionID: 63549

A Rocket Scientist View on Indexes

Back to calendar

Event Date: 17-06-2017 - Session time: 09:45:00 - Track: Application Database Development

Speaker: Mike Byrd

Title: A Rocket Scientist View on Indexes

Abstract:

Indexes can be a boon or decrement for query performance. This presentation will present what they are (in layman’s terms) and how they may affect query performance – both from a read (SELECT) viewpoint as well as a data modification aspect (INSERT, UPDATE, DELETE). This session will concentrate with a deep dive into clustered indexes and nonclustered indexes, their syntax and utilization, and their effect on performance in transaction and data warehouse databases. Covering nonclustered indexes will also be examined in detail and the scenarios they should be applied. There will be many query demos illustrating index utilization using statistics and query plans. Attendee should have some TSQL and Management Studio experience.

SessionID: 63584

You want me to Isolate what? An introduction into data integrity and Isolation Levels of SQL Server

Back to calendar

Event Date: 17-06-2017 - Session time: 09:45:00 - Track: Application Database Development

Speaker: Robert Bishop

Title: You want me to Isolate what? An introduction into data integrity and Isolation Levels of SQL Server

Abstract:

Isolation Levels in SQL Server can benefit your application and help control data integrity by managing concurrency effects but can also hurt your application if you are unaware of what they are and how they are used. A review of SQL Concurrency issues and how SQL Isolation Levels can help eliminate them and keep the integrity of your data. This presentation will demonstrate with queries what causes concurrency issues and what isolation levels will prevent them.

SessionID: 63589

Finding root cause for unexplained Availability Group failover

Back to calendar

Event Date: 17-06-2017 - Session time: 09:45:00 - Track: Enterprise Database Administration Deployment

Speaker: Trayce Jordan

Title: Finding root cause for unexplained Availability Group failover

Abstract:

In this session, we will walk you step by step showing how we determine root cause analysis of an unexplained failure in an Availability Group. Whether the databases simply became unavailable, synchronization stopped, or there was an unexplained failover. We will show you specifically what we look for in the OS Cluster logs, SQL error logs, Extended Events and other sources of information.

SessionID: 63616

Exploring the All-New SSRS 2016

Back to calendar

Event Date: 17-06-2017 - Session time: 09:45:00 - Track: BI Platform Architecture, Development Administration

Speaker: Tim Mitchell

Title: Exploring the All-New SSRS 2016

Abstract:

You will learn:

The scope of changes to the new SSRS in 2016 See these new features in action with several realistic demos. How the all-new SSRS fits in with Datazen, PowerBI, and other Microsoft reporting

SessionID: 63726

Inside SQL Server Machine Learning Services: Database Intelligence at Scale

Back to calendar

Event Date: 17-06-2017 - Session time: 09:45:00 - Track: Enterprise Database Administration Deployment

Speaker: Bob Ward

Title: Inside SQL Server Machine Learning Services: Database Intelligence at Scale

Abstract:

You are a DBA of SQL Server deploying or considering SQL Server 2016 or SQL Server 2017. Your manager says that Data Science is the “new thing” and there are Data Scientists in your company that need your help. SQL Server 2016 introduced a new capability called SQL Server R Services and you need to evaluate whether this feature is something your company can trust to deploy in production for an enterprise environment. SQL Server 2017 expands this feature to include Python and what we now called SQL Server Machine Learning Services. We will explore and understand exactly how SQL Server Machine Learning Services works behind the scenes so you know how to install it, manage it, optimize it, and have confidence to use this in real prediction analytic workloads. We will use demos so you understand all the components and look at a real enterprise customer case study as part of this talk.

SessionID: 63590

Backups for non-DBAs...the Why, not the How

Back to calendar

Event Date: 17-06-2017 - Session time: 11:00:00 - Track: Other

Speaker: Kevin Hill

Title: Backups for non-DBAs...the Why, not the How

Abstract:

Join me and get some new perspective on what your DBA is doing, and why!

Targeted at the non-DBA such as BI/DW folks, Application Developers, Managers, and System Admins, this session will go over the reasons we back up our databases, our systems, etc. Considerations such as Single points of failure, High Availability/Disaster recovery, Business Continuity and others will be discussed in this interactive conversation. It will be conversation heavy, with supporting slides to download, and one Database backup demo at the end if time permits.

Everyone involved in a technical role needs to at least know that the things they have created will be recoverable in the event of a disaster, or even just an "oops" moment. The CIO/CTO should know how long critical systems will be down when bad things happen. Backups are everyone's responsibility...whether asking the right questions or implementing the process.

SessionID: 63691

I like big data for $400 - Exploring quiz show questions using Angular, DocumentDB and Azure Search

Back to calendar

Event Date: 17-06-2017 - Session time: 11:00:00 - Track: Application Database Development

Speaker: Christopher Sims

Title: I like big data for $400 - Exploring quiz show questions using Angular, DocumentDB and Azure Search

Abstract:

In this talk, we will explore two powerful technologies from the Microsoft Azure Stack: DocumentDB and Azure Search. DocumentDB is Microsoft's NoSQL service for building globally scalable schema-free applications. Azure Search allows you to integrate the power of Microsoft's search and natural language processing abilities to explore your complex data stores. During this talk we will cover the benefits of implementing a schema-free database, we will learn how to replicate your data at a global scale with the ease of a simple configuration and we will cover various techniques of querying that data using SQL and the DocumentDB API. Once we have a large datastore in place (we will use 200k+ Jeopardy questions), we will apply the powerful natural language querying capabilities and faceted search features of Azure Search to quickly create an searchable data repository. All of this will be built and exposed using a cross-platform application built in Angular on the Electron framework.

SessionID: 64358

Querying Semistructured Data in Azure Data Lake with USQL

Back to calendar

Event Date: 17-06-2017 - Session time: 11:00:00 - Track: Cloud Application Development Deployment

Speaker: Russel Loski

Title: Querying Semistructured Data in Azure Data Lake with USQL

Abstract:

Data is exploding across enterprises. Much of it is semi-structured junk. Or is it junk? What are you going to do with it until you can find out? Microsoft’s Azure Data Lake is a cloud storage and analytical service for parking a variety of data. When you are ready, you can query that semi-structured data using an ANSI SQL language called U-SQL. In this session I will demonstrate the similarities and differences between U-SQL and T-SQL. I will demonstrate how easy it is to build a query against 21 GB of CSV files. Such queries can help you determine whether you have a gold mine in your data or a bunch of garbage before investing in a full data warehouse build.

SessionID: 64403

Agile Data Warehouse and ETL Design with Biml

Back to calendar

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

Speaker: David Stein

Title: Agile Data Warehouse and ETL Design with Biml

Abstract:

Business Intelligence Markup Language is literally changing the way we think about Data Warehouse design and ETL. In this interactive presentation you'll see how you can rapidly iterate through the Data Warehouse Development Cycle and provide ROI almost immediately. Learn how you can use BimlScript to automatically create staging tables, SSIS Packages, and other necessary objects during the modeling process.

SessionID: 64442

Introduction to Execution Plans

Back to calendar

Event Date: 17-06-2017 - Session time: 11:00:00 - Track: Enterprise Database Administration Deployment

Speaker: Lance Tidwell

Title: Introduction to Execution Plans

Abstract:

In this session we will take a look at the basics of execution plans. We will discuss what they are, how they are made, and how they are used. We will explore some of the common operators seen in execution plans and their functions. Next we will look at the differences between estimated and actual execution plans. Throughout, you will be getting insight on how to read execution plans to help tune your queries.

SessionID: 65390

Random Acts of Senseless Databasing

Back to calendar

Event Date: 17-06-2017 - Session time: 11:00:00 - Track: Application Database Development

Speaker: Kris Hokanson

Title: Random Acts of Senseless Databasing

Abstract:

After years of snake oil salesmen and good-meaning but part-time developers, Acme Oil Gas company’s databases have become something Rube Goldberg would be proud of and they've hired you to sort everything out. What are some of the things you can expect to find and how can you fix them? From spaghetti code that references views inside of views nested in other views, to overly indexed tables that generate 10x the disk IO and contention they should, we’ll talk about database development, administration, and plenty of things in between.

SessionID: 63550

Free Scripts to Troubleshoot SQL Server: sp_Blitz, sp_BlitzCache, and More

Back to calendar

Event Date: 17-06-2017 - Session time: 12:30:00 - Track: Enterprise Database Administration Deployment

Speaker: Brent Ozar

Title: Free Scripts to Troubleshoot SQL Server: sp_Blitz, sp_BlitzCache, and More

Abstract:

You inherited a SQL Server and a bunch of databases from The Last Guy, and you're pretty sure he was drinking on the job. You need to find out just how big of a mess he left you, and what you need to focus on fixing first. You don't want a generic health check - you only wanna fix things that users are going to notice.

In this all-demo no-slides session, you'll learn how to use the open source First Responder Kit: sp_Blitz, sp_BlitzCache, sp_BlitzIndex, sp_BlitzFirst, sp_BlitzWho, and more. Brent Ozar, one of the script authors, will show you what each script does and how to read the results. It's all completely free, maintained by community volunteers, no strings attached. Come see what the community has been working on lately!

SessionID: 65237

DevOps for Migratory Deployments

Back to calendar

Event Date: 17-06-2017 - Session time: 12:30:00 - Track: Application Database Development

Speaker: Robyn Fuentes

Title: DevOps for Migratory Deployments

Abstract:

In an automated world, it’s easy to feel like we are losing the tight control we used to have on some of our daily processes. Other processes have remained manual out of fear of losing that same control. What if there was a way to keep the control and automate the process at the same time? In this session, I go over my experiences with different ways of managing schema changes over the life of a project and explore a controlled and automated approach.

SessionID: 63587

Dynamic SQL: Tables, Pivots

Back to calendar

Event Date: 17-06-2017 - Session time: 13:30:00 - Track: Application Database Development

Speaker: Steven Tidwell

Title: Dynamic SQL: Tables, Pivots

Abstract:

Dynamic SQL is a scripting language that helps you design flexibility into your code. It allows you to design solutions, pass parameters and allows you build a single query on values passed. Dynamic SQL has both pros and cons to it's design, but can also be a helpful tool. This presentation will walk through the steps of building dynamic tables, aggregating data in a pivot format and give you the first steps of writing a Dynamic Query. There are hundreds of task that will benefit from the use of Dynamic SQL. From parameter based searches to building dynamic SELECT statements at run time.

SessionID: 63588

Intro to Azure SQL Data Warehouse

Back to calendar

Event Date: 17-06-2017 - Session time: 13:30:00 - Track: Cloud Application Development Deployment

Speaker: Shawn Weisfeld

Title: Intro to Azure SQL Data Warehouse

Abstract:

In this session we will introduce Azure SQL Data Warehouse and provide the basics you need to get started. Azure SQL Data Warehouse combines the SQL Server relational database with Azure cloud scale-out capabilities. Built on our massively parallel processing (MPP) architecture, SQL Data Warehouse can handle your enterprise workload.

SessionID: 63778

Beginning T-SQL

Back to calendar

Event Date: 17-06-2017 - Session time: 13:30:00 - Track: Application Database Development

Speaker: Jennifer McCown

Title: Beginning T-SQL

Abstract:

If you work with SQL Server at all, you need to know Transact-SQL, the SQL Server programming language. During this session, we’ll design and create our own table to demonstrate key concepts, query syntax, and more. If you’ve been meaning to learn T-SQL, here’s your chance!

SessionID: 64022

Introduction to SQL 2016 Temporal Tables

Back to calendar

Event Date: 17-06-2017 - Session time: 13:30:00 - Track: Enterprise Database Administration Deployment

Speaker: Vicky Harp

Title: Introduction to SQL 2016 Temporal Tables

Abstract:

SQL Server 2016 introduces the concept of temporal tables, also called system-versioned tables. This new feature allows SQL Server to automatically keep track of the history of rows in any table for which it is enabled. In this session we'll cover the basics on how to create and work with temporal tables, including the new FOR SYSTEM_TIME query clause, and we'll discuss some of the ways that they may or may not fill a need in your environment.

SessionID: 64178

Data Warehousing 101

Back to calendar

Event Date: 17-06-2017 - Session time: 13:30:00 - Track: BI Platform Architecture, Development Administration

Speaker: Robert Stewart

Title: Data Warehousing 101

Abstract:

In this session, we will cover the basics of building a data warehouse. We will look at the Kimball and Inman methodologies and see what will fit the situations in building a data warehouse most effectively. We will also cover doing a slowly changing dimension that will load in seconds instead of hours.

SessionID: 64337

Deadlock, Block Two Smoking Barrels: Breaking Down Blocking and Deadlocks

Back to calendar

Event Date: 17-06-2017 - Session time: 13:30:00 - Track: Enterprise Database Administration Deployment

Speaker: Amy Herold

Title: Deadlock, Block Two Smoking Barrels: Breaking Down Blocking and Deadlocks

Abstract:

While blocking and deadlocks are part of the territory for a DBA, dealing with them can be another story. In this session we will break down locking types, capturing and identifying deadlocks and the code behind them, and things you can do to resolve and prevent blocking and deadlocks. If you are frequently dealing with deadlocks in your databases this session is for you.

SessionID: 63725

Inside SQL Server In-Memory OLTP

Back to calendar

Event Date: 17-06-2017 - Session time: 14:45:00 - Track: Enterprise Database Administration Deployment

Speaker: Bob Ward

Title: Inside SQL Server In-Memory OLTP

Abstract:

Based on the successful 500 Level talk at PASS 2016, this session will provide an internals view of how In-Memory OLTP works for SQL Server 2016. Because this session is Advanced, it is intended for those that understand the basic fundamentals of In-Memory OLTP but want to learn how the "Hekaton" engine works behind the scenes to deliver the amazing 30x performance improvements seen for customers moving to In-Memory OLTP. This session will include a look behind the scenes at threads, data and index design, transactions and concurrency, logging, storage, and natively compiled procedures. And since this will be an advanced level session, of course the demonstration of the looking at the Hekaton engine with the debugger is a must.

SessionID: 63797

SQL Server Graph Database

Back to calendar

Event Date: 17-06-2017 - Session time: 14:45:00 - Track: Application Database Development

Speaker: John Cook

Title: SQL Server Graph Database

Abstract:

The next version of SQL Server will run on either Windows or Linux and includes new functionality including graph database features. Graph databases are ideal for those cases where there is a relationship that exists but it doesn't fit the rigid hierarchy of a relational table. Graph databases easily manage data where there are differing degrees of separation - the so-called Kevin Bacon problem. The degrees of separation problem is highly relevant to important real world problems such as root cause analysis, bill of materials, parts explosion, where used queries, route planning, and fraud detection just to name a few. New syntax exists is take advantage of storing and processing relationships. Learn how this transformative technology works and then update your resume!

SessionID: 63816

MS SQL - Review, Renew, and Reveal

Back to calendar

Event Date: 17-06-2017 - Session time: 14:45:00 - Track: Application Database Development

Speaker: Dane Schilling

Title: MS SQL - Review, Renew, and Reveal

Abstract:

We will begin the session by reviewing a few things about MS SQL T-SQL that you should know (CTE's, window functions, etc). Our next step will be to explore some of the newer features within the SQL verse and how we can use them to write cleaner and more explicit T-SQL (date and string functions + more). We will close out the session exploring some of the newest features released with MS SQL Server 2016.

SessionID: 64328

Do More Than Just Talk

Back to calendar

Event Date: 17-06-2017 - Session time: 14:45:00 - Track: Professional Development

Speaker: Lori Edwards

Title: Do More Than Just Talk

Abstract:

Most of us can talk - we've been doing it since we were young. Unfortunately there can be a huge gap between talking and effective communication. While not all of us will be chosen for TED talks, there are methods we can use to keep our audience engaged and help our message to be understood whether you're asking your boss for a raise or presenting a session at the PASS Summit. Understand the barriers to effective communication and learn to use words, tone, expression and behavior to enhance your communicate skills.

SessionID: 64346

Crappy Queries: A Beginner's Guide to Hunting in the Field

Back to calendar

Event Date: 17-06-2017 - Session time: 14:45:00 - Track: Enterprise Database Administration Deployment

Speaker: John Harp

Title: Crappy Queries: A Beginner's Guide to Hunting in the Field

Abstract:

When all you have is a hammer, everything looks like a nail. But what if you had two hammers? Or three? Let John add just a couple of native tools to your belt in this session, and you should have a better starting ability to distinguish a criminally crappy query from an innocent one, a perpetrator from a victim. We'll delve into some older technology like SQL tracing, its much newer, hotter sibling Extended Events, and even leverage some native DMVs in a hunt to pin down a few T-SQL malefactors.

SessionID: 65108

Python in SQL Server 2017

Back to calendar

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

Speaker: Chris Hyde

Title: Python in SQL Server 2017

Abstract:

SQL Server 2017 is right around the corner, bringing with it a host of exciting new features. Of particular interest to BI practitioners and data scientists is the integration of the Python programming language into the SQL ecosystem. This integration opens up a number of possibilities for in-database analytics and intelligent database applications, so let's get started!

In this introductory session we'll briefly introduce the Python language and then look at how to install and administer Machine Learning Services. We'll start to demonstrate the power of Python by showing you how to create and run simple scripts from within T-SQL. We'll then discuss some of the powerful open source packages that are available to aid your data analyses. Finally, we'll go through some examples of how to use Python to integrate data analytical methods in real-world situations, and wow your customers with the power of analytics!

SessionID: 63514

SQL Server Internals

Back to calendar

Event Date: 17-06-2017 - Session time: 16:00:00 - Track: Enterprise Database Administration Deployment

Speaker: Naomi Williams

Title: SQL Server Internals

Abstract:

How does SQL do what it does? Take a look under the hood at how the SQL database engine works with the storage engine. What causes those waits and where do we look to resolve them!

SessionID: 63529

Database Project Makes Deployment Consistent

Back to calendar

Event Date: 17-06-2017 - Session time: 16:00:00 - Track: Application Database Development

Speaker: Thomas Norman

Title: Database Project Makes Deployment Consistent

Abstract:

The deployment process is frustrating; an object is missing, an object is deployed in the wrong order or an incorrect version. Deploying to multiple environments like Dev, QA, UAT and Prod is a challenge whither on premise or in the cloud. Source controlling database objects is paramount. Team development is required. Database code will only be deployed when changed. Proper security deployment will be repeatable per environment. Together, let us discover how using Database Project will help us with consistent releases. Deployments can cause you trouble but we will share a reliable deployment and version control process. Let’s see how Database Project can help us accomplish this goal.

SessionID: 63723

Code Like a Pirate ... Intro to R and Data Science Tools in MS

Back to calendar

Event Date: 17-06-2017 - Session time: 16:00:00 - Track: BI Platform Architecture, Development Administration

Speaker: Jamey Johnston

Title: Code Like a Pirate ... Intro to R and Data Science Tools in MS

Abstract:

Come to this session to get an introduction to the R language including:

We will finish with a brief introductions of how R integrates in Azure ML, Power BI, and SQL Server 2016 using real demos.

The focus of the session will be primarily on the introduction to the R language and getting attendees comfortable with using R to start the journey into Data Science!

SessionID: 63782

Loading SQL Server Data with Powershell

Back to calendar

Event Date: 17-06-2017 - Session time: 16:00:00 - Track: Enterprise Database Administration Deployment

Speaker: Sean McCown

Title: Loading SQL Server Data with Powershell

Abstract:

Powershell has become the defacto standard for scripting Microsoft products. However, putting data in text files doesn’t scale. Here I’m going to show you the ins and outs of loading data into SQL Server using Powershell for the purpose of centralizing collections. We’re going to cover RBAR as well as bulk operations and the types of things you need to take into consideration in an enterprise setting. This is a no holds barred session taught by an enterprise SQL Server scripting expert. You can’t afford to miss this session if you do any level of scripting in your shop.

SessionID: 64259

Table Partitioning: the Secret Weapon for Your Big Data Problems

Back to calendar

Event Date: 17-06-2017 - Session time: 16:00:00 - Track: Enterprise Database Administration Deployment

Speaker: John Sterrett

Title: Table Partitioning: the Secret Weapon for Your Big Data Problems

Abstract:

Is big data starting to slow you down? Is data growth putting your maintenance tasks in danger of not meeting your service level agreements? Do you wish you could archive old data with minimal impact to your tables during the archive process? Do you wish you could eliminate the majority of the data in your tables when you query them? If so, it's time you consider implementing table partitioning to help with your general performance and to reduce your maintenance window for completing your maintenance tasks.

In this session, you will learn how table partitioning works and when it should be implemented. You will be able to understand how to initially configure partition functions and partition schemes to have a rock solid partitioned table. You learn how to implement new features added in SQL Server 2014 to improve table partitioning. Finally, you will learn how to implement an automated sliding window to maintain your partitioned tables for ensuring optimal performance.

SessionID: 64365

Big|Small|Tiny Data + The Hybrid Cloud

Back to calendar

Event Date: 17-06-2017 - Session time: 16:00:00 - Track: Cloud Application Development Deployment

Speaker: Anthony {Tex} Moreign

Title: Big|Small|Tiny Data + The Hybrid Cloud

Abstract:

CRUX: The focus of this talk is Data (Big Data, Small Data, Tiny Data, Micro Data) –and– The Hybrid Cloud (Microsoft non-Microsoft) Offerings available as of this point-in-time (Jun-2017). Pre-requisites required: none, other than just your interest.

AUDIENCE: This talk is for anyone, irrespective of whether you are — just entering the industry, updating/expanding your skills, or just seeking answers to questions like:

  1. Big Data? Small Data? Tiny Data?
  2. Cloud? Hybrid Cloud? Global Hybrid Cloud?
  3. Why should I care? What’s in it for me? Where do I go from here?

NOTE: The presenters, Tex (20+ year technologist) Sons (Valentino Zane, budding technologists), are with Hybrid Decisions® Corp and are presenting on behalf of www.HCCUG.org (Houston Cloud Computing User Group) «±»

This site is open source. Improve this page.