Nr: 721
SQLSaturday #721 - Raleigh 2018
SessionID: 77751
Linux Power Pre-Con For The DBA (Paid Pre-Con)
Event Date: 14-04-2018 - Session time: 08:30:00 - Track: Design
Speaker: Kellyn Pot'Vin-Gorman
Title: Linux Power Pre-Con For The DBA (Paid Pre-Con)
Abstract:
In this pre-con, attendees will arrive with their laptops with Docker and the Linux image of SQL Server 2017 ready to go. The image and instructions can be found at https://docs.microsoft.com/en-us/sql/linux/quickstart-install-connect-docker.
We'll use Docker and the newest SQL Server 2017 image to go from the A to Z of Linux, learning how to navigate, manage and manipulate Linux. We'll learn best practices surrounding file systems, security and database management.
Once we've become comfortable with the basics, we'll move onto more advance features and tools that have become the savior of DBAs working on Linux/Unix system for decades.
To register for this paid Pre-Con:
https://www.eventbrite.com/e/linux-power-pre-con-for-the-dba-kellyn-potvin-gorman-sql-saturday-raleigh-tickets-42733262338
SessionID: 77753
Architecting a Data Lake (Paid Pre-Con)
Event Date: 14-04-2018 - Session time: 08:30:00 - Track: Design
Speaker: Melissa Coates
Title: Architecting a Data Lake (Paid Pre-Con)
Abstract:
To register for this paid Pre-Con:
https://www.eventbrite.com/e/architecting-a-data-lake-with-melissa-coates-raleigh-sql-saturday-tickets-42691287791
SessionID: 70984
SQL Server and PowerShell: Let's Get Serious
Event Date: 14-04-2018 - Session time: 08:30:00 - Track: Innovate
Speaker: Drew Furgiuele
Title: SQL Server and PowerShell: Let's Get Serious
Abstract:
Whether you’ve dabbled in PowerShell or wondered what all the fuss is about, make no mistake: PowerShell isn’t going away. It is definitely something worth learning to make your life as a SQL Server professional easier, and allow you to advance in your career as a DBA.
In this session, you’ll see practical, real-world examples of how you can blend SQL Server and PowerShell together. You’ll also get a look at the SQL Server PowerShell provider and how you can incorporate it into your automation scripts.
Instead of focusing on syntax, the session will plunge straight into examples and highlight various snippets of code and how they work. You can expect to see code examples on how PowerShell can do anything from comparing tables across servers, automating and centralizing your backups, and even doing in-depth security audits.
SessionID: 70988
SQL Server Basic Backups for Beginners
Event Date: 14-04-2018 - Session time: 08:30:00 - Track: Support
Speaker: Mark Gordon
Title: SQL Server Basic Backups for Beginners
Abstract:
If you just started using SQL Server and may be unsure of the need for backups or even how to do them, this is for you. It is very basic and will cover Recovery Models, Backup Types. In addition, I will demonstrate backups and a restore.
SessionID: 72861
How can containers for my database help me?
Event Date: 14-04-2018 - Session time: 08:30:00 - Track: Design
Speaker: Carlos L Chacon
Title: How can containers for my database help me?
Abstract:
It seems like web apps are getting all the love and at first glance it may be hard to identify a good way to use the database in containers. This session will review the concept of containers and attempt to identify ways we might benefit from this new technology as we support our users.
SessionID: 73775
Event Date: 14-04-2018 - Session time: 08:30:00 - Track: Perform
Speaker: Jeffrey Garbus
Abstract:
Learn all you wanted to know about index design, but were afraid to ask. This session focuses on physical index structures as well as how the server chooses indexes. Note: Join optimization is a separate session
SessionID: 74292
Create SQL Server Test Premise Environment in Azure Cloud
Event Date: 14-04-2018 - Session time: 08:30:00 - Track: Build
Speaker: Michael Wharton
Title: Create SQL Server Test Premise Environment in Azure Cloud
Abstract:
Why create a SQL Server Test premise environment in Azure cloud? One of the first steps into moving to Azure cloud, is building an environment that looks a feels like premise but only in the cloud. This session is an overview of getting started with basics of Azure environment, such as Accounts, virtual networks, Storage and creating virtual machines.. Once we fly by reviewing several building blocks, we then build Active Directory VM, SQL Server VM and App Server Tier VM using Azure portal and PowerShell.
SessionID: 74341
The Amazing Utility of ROW_NUMBER()
Event Date: 14-04-2018 - Session time: 08:30:00 - Track: Build
Speaker: Brian Hansen
Title: The Amazing Utility of ROW_NUMBER()
Abstract:
When it was introduced way back in SQL Server 2005, the lowly ROW_NUMBER() function at first seemed to have little functionality other than simply counting rows. However, over time we have come to see this humble function is actually surprisingly useful in often unexpected ways. In this session we will discover the creative uses of ROW_NUMBER() in ways that you may likely not have yet considered. This session will be filled with little goodies that can you can use, whether you are a writing SQL for application code or for administrative functionality.
SessionID: 80656
Alexa – Skills Development, Data, and Continuous Improvement
Event Date: 14-04-2018 - Session time: 08:30:00 - Track: Build
Speaker: Shannon Lowder
Title: Alexa – Skills Development, Data, and Continuous Improvement
Abstract:
SessionID: 70993
Applying Row Level Security In Power BI
Event Date: 14-04-2018 - Session time: 09:45:00 - Track: Analyze
Speaker: Wes Springob
Title: Applying Row Level Security In Power BI
Abstract:
Power BI allows us to easily apply Row Level Security (RLS) to our published reports, streamlining report development for individuals or groups within your organization. This session shows you how to set up a report to apply RLS as well as how to model your data to support users dynamically.
SessionID: 71039
The Right HA/DR Solution
Event Date: 14-04-2018 - Session time: 09:45:00 - Track: Design
Speaker: Doug Purnell
Title: The Right HA/DR Solution
Abstract:
So you have a good backup strategy in place, but now you have to think about recovery. Where do you start and what are your options? SQL Server offers several options, but then how do you choose the right one to meet your business requirements? In this session, we will go over some of the common HA/DR options including log shipping, replication, mirroring, clustering, and availability groups. Then we will talk about how to choose the best one to meet your business needs.
SessionID: 71311
SSRS – Clean while you migrate
Event Date: 14-04-2018 - Session time: 09:45:00 - Track: Support
Speaker: George Maxson
Title: SSRS – Clean while you migrate
Abstract:
Is it time to migrate your SSRS to the latest version? Do you really want to migrate everything or only those reports and objects actually in use? We will walk through some migration methods and find the data available to help manage report lifecycle (age, permissions, use, data sources).
SessionID: 71382
Event Date: 14-04-2018 - Session time: 09:45:00 - Track: Build
Speaker: Melissa Coates
Abstract:
SessionID: 72970
I/O Tuning 101
Event Date: 14-04-2018 - Session time: 09:45:00 - Track: Perform
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: 73379
The function of Windowing Functions
Event Date: 14-04-2018 - Session time: 09:45:00 - Track: Build
Speaker: Kevin Wilkie
Title: The function of Windowing Functions
Abstract:
What is a windowing function?
What do I do with them?
Are they actually useful?
By the end of the class, you'll be asking yourself -
Why haven't I used these before?
How can I use them more often?
Learn more about the class of functions that are known as "windowing functions" and why you should get to know them more!
SessionID: 73608
SQL Server and Docker
Event Date: 14-04-2018 - Session time: 09:45:00 - Track: Build
Speaker: Azhagappan Arunachalam
Title: SQL Server and Docker
Abstract:
Containers are everywhere. If server virtualization dominated the past decade, then this decade belongs to the containers. Name any product, and there is a container image of that product ready to be deployed at a moment's notice. Containers can be used for hosting any type of application, and in this session, we'll take a look at what you need to know to get started with containers with respect to SQL Server, and address some of the common questions that come up during this setup.
SessionID: 70979
Using the New SSRS PowerBI Server
Event Date: 14-04-2018 - Session time: 11:00:00 - Track: Innovate
Speaker: George Walkey
Title: Using the New SSRS PowerBI Server
Abstract:
Power BI SSRS Server allows you to internally host On-Prem classic RDL Paginated Reports, KPIs, Mobile Reports and now Power BI reports, allowing you to create real-time Dashboards on data behind the firewall. This session will be a complete tutorial from setup, config and PBI Desktop publish from Start To Finish.
SessionID: 72047
Faster SSIS
Event Date: 14-04-2018 - Session time: 11:00:00 - Track: Scale
Speaker: Andy Leonard
Title: Faster SSIS
Abstract:
Ever wonder why SSIS runs so slow? Watch SSIS author Andy Leonard as he runs test loads using sample and real-world data and shows you how to tune SQL Server 2016 Integration Services (SSIS 2016) packages.
We'll start by experimenting with SSIS design patterns to improve performance loading AdventureWorks data. We will implement different change detection patterns and compare execution performance for each. Then, we'll explain a Data Flow Task's bottleneck when loading binary large objects - or Blobs.
Finally, we'll demonstrate a design pattern that uses a Script Component in a Data Flow to boost load performance to MySql, whether on-premises or in the cloud.
SessionID: 72490
Cloudy with a Chance of Data
Event Date: 14-04-2018 - Session time: 11:00:00 - Track: Evolve
Speaker: Rick Heiges
Title: Cloudy with a Chance of Data
Abstract:
The 'Cloud" is here. With it, there are many options for storing and processing data. What does it mean? Why should you be interested in this conversation? How can a cloud solution compare to an "on-prem" solution? We will discuss these questions and more. The focus of this session will be on the options available in Azure from Azure SQL DB to Azure SQL Data Lake, but we will also touch on AWS and Google Cloud options to put the options in context.
SessionID: 72971
Applications of Hashbytes and Compress Functions
Event Date: 14-04-2018 - Session time: 11:00:00 - Track: Scale
Speaker: Jeff Nowiski
Title: Applications of Hashbytes and Compress Functions
Abstract:
SessionID: 73657
Monitoring with sp_WhoIsActive, PowerShell and PowerBI
Event Date: 14-04-2018 - Session time: 11:00:00 - Track: Support
Speaker: Jana Sattainathan
Title: Monitoring with sp_WhoIsActive, PowerShell and PowerBI
Abstract:
SessionID: 74352
Clusters! From the ground up, let us build one together
Event Date: 14-04-2018 - Session time: 11:00:00 - Track: Build
Speaker: Paul Popovich Jr
Title: Clusters! From the ground up, let us build one together
Abstract:
You're looking to protect your SQL instance from a machine failure. Or maybe your storage budget and tight and you don't want to have your databases in two places with one of the other highly available options that SQL provides. Let's learn what a cluster is and why it might be the right thing for you. We'll explore the system, network, storage and database administration sides of the equation. And, when it's all said and done we'll even have built a SQL clustered instance!
SessionID: 80103
REST Easy - Instant APIs for Your Database
Event Date: 14-04-2018 - Session time: 11:00:00 - Track: Vendor Session
Speaker: Jerod Johnson
Title: REST Easy - Instant APIs for Your Database
Abstract:
API-driven data consumption platforms and services highlight the need for RESTful access to SQL server data. The existing options for REST access to SQL Server data or using web development frameworks to convert relational data to JSON objects soak up time, resources, and energy on software development and maintenance that enterprises could be using to drive business.
With the CData API Server, users can rapidly create RESTful APIs for SQL Server data using a point-and-click interface. API Server includes everything needed to create, run, manage, and secure APIs for your SQL Server data. In this talk, we will walk through creating an OData API for SQL Server data and demonstrate connectivity using modern web development frameworks
SessionID: 71331
SQL Server Then and Now: Changing the State of Long-held Beliefs
Event Date: 14-04-2018 - Session time: 13:15:00 - Track: Design
Speaker: Maxwell Myrick
Title: SQL Server Then and Now: Changing the State of Long-held Beliefs
Abstract:
We’ve all heard the rules for SQL Server like separate your data from your log, watch for a disk queue length over 2, and a low Page Life Expectancy always means memory pressure. All of these used to be true, but on today’s hardware and SQL Server versions – they are dangerously outdated. In this session, we will take on a bunch of these old “givens” of SQL Server that everybody has heard and followed, the underlying technological reasons they were true then, how today’s technology has rendered them obsolete, and what the new rules are that you need to know. So whether you are one of the old guard looking to refresh your set of working SQL Server rules or a member of the up-and-comers looking for the facts to win over the old guard, this session is for you.
SessionID: 72056
Locks, Blocks, and Deadlocks; Tame the Sibling Rivalry
Event Date: 14-04-2018 - Session time: 13:15:00 - Track: Perform
Speaker: William Wolf
Title: Locks, Blocks, and Deadlocks; Tame the Sibling Rivalry
Abstract:
Like parents having to break up a fight between battling siblings, SQL Server must do the same for conflicting transactions. We call these Deadlocks and they can present a problem to many DBAs. Deadlocks can be minor fights or major issues making SQL Server continually choose a side like constantly quarreling siblings.
To understand how Deadlocking occurs, we must understand what caused the fight . Learning about basic locking and blocking of SQL Server is a great place to start.
By the end of this session you will walk away with the knowledge of how the locking/blocking mechanism works, the basics of deadlocking, and what Isolation Levels are . You will know how these can help or hurt your situation. Finally you will have the power to capture, report, and stop the family fighting.
SessionID: 72630
Linux for the SQL Server DBA
Event Date: 14-04-2018 - Session time: 13:15:00 - Track: Support
Speaker: Dave Walden
Title: Linux for the SQL Server DBA
Abstract:
Linux is a very compelling choice for SQL Server, and may of us may find ourselves supporting it very soon.
We'll arm you with the information you'll need to start supporting Linux, even if you've never touched it before - Including Linux equivalents of standard Windows administration tasks, and an introduction to using PowerShell on Linux. We'll also cover best practices for SQL Server on Linux, including kernel tuning
SessionID: 74375
Event Date: 14-04-2018 - Session time: 13:15:00 - Track: Perform
Speaker: Jared Poché
Abstract:
SessionID: 77549
DAX 101
Event Date: 14-04-2018 - Session time: 13:15:00 - Track: Analyze
Speaker: Belinda Allen
Title: DAX 101
Abstract:
SessionID: 78697
Getting Started with Power Query
Event Date: 14-04-2018 - Session time: 13:15:00 - Track: Build
Speaker: Shawn Dorward
Title: Getting Started with Power Query
Abstract:
SessionID: 80420
#GetModern With Dell EMC
Event Date: 14-04-2018 - Session time: 13:15:00 - Track: Vendor Session
Speaker: Michael Wells
Title: #GetModern With Dell EMC
Abstract:
SessionID: 71027
Screw DevOps, Let's Talk DataOps
Event Date: 14-04-2018 - Session time: 14:30:00 - Track: Evolve
Speaker: Kellyn Pot'Vin-Gorman
Title: Screw DevOps, Let's Talk DataOps
Abstract:
DevOps is the new hot topic for IT, but only answers part of the problem. This session and demo will discuss why data creates continual friction in the DevOps environment and how it must be incorporated into the solution.
Reasons for this solution is required: -Data is getting bigger and more complex -Security concerns around critical data is becoming more evident every day -Data is created in silos in many sources, yet consumed in just as many locations, including on-premises and in the cloud.
We'll discuss the tech, the politics and the challenges of bringing data into DevOps and how to do so more successfully with culture changes, tools, scripting, and virtualization.
Takeaways from this session:
- Learn the five principles of Data Ops 2. How embracing a dynamic data platform can eliminate challenges and provide automation. 3. Learn the difference between containers, packages and data pods. 4. Learn how to bridge the gap between data and people, eliminating culture from the scene
SessionID: 71138
Laying the Foundations for GDPR Compliance.
Event Date: 14-04-2018 - Session time: 14:30:00 - Track: Design
Speaker: John Martin
Title: Laying the Foundations for GDPR Compliance.
Abstract:
GDPR is coming, no matter where you are if you are handling data on European data subjects. Laying a solid foundation of data security practices is vital to avoid the potential fines and damage to reputation that being non-compliant can bring.
Practicing good data hygiene is vital to meeting compliance requirements, whether it is GDPR, PCI-DSS, HIPAA or other standards. The fundamentals around data identification, classification, and management are universal. Together we will look at some of the key areas that you can address to speed up your readiness for meeting GDPR requirements. Including what data is covered, principals for gaining consent, data access requests as well as other key recommended practices.
By the end of this session you will be able to start the groundwork on getting your organization in shape for its journey to compliance.If you want to avoid the big fines, up to EUR 20 million or 4% of global turnover whichever is higher, it is important to act early.
SessionID: 71919
SQL Server Containers
Event Date: 14-04-2018 - Session time: 14:30:00 - Track: Innovate
Speaker: Andrew Pruski
Title: SQL Server Containers
Abstract:
This session aims to take attendees through what containers are and what benefits they bring.
After this demo based session, attendees will be able to go back to their respective companies and be able to evaluate container technology to determine whether or not it will be of benefit.
Attendees will be taken through the following: -
The definition of containers
Virtual Machines vs Containers
Container networking fundamentals
Installing the docker engine
Pulling SQL images from the docker repository
Running SQL Server containers
Creating custom container images
Persisting data in SQL Server containers
A real world implementation of containers
SessionID: 72422
A Beginner's Guide To Plan Guides
Event Date: 14-04-2018 - Session time: 14:30:00 - Track: Perform
Speaker: Brian Carrig
Title: A Beginner's Guide To Plan Guides
Abstract:
Even with the increased simplicity of plan forcing using Query Data Store in SQL Server 2016 and above, plan guides remain a very powerful but often overlooked feature of SQL server. There is a misconception in the community that plan guides are really only useful for situations where the DBA "cannot change the code" but actually plan guides have much broader applicability than simply fixing problems with poorly designed ISV code. However, for the DBA, working with plan guides can often be a confusing and frustrating experience.
In this session we will cover what plan guides are, how they work and demonstrate scenarios where they can be successfully used to solve a number of problems DBAs experience on a day to day basis.
SessionID: 72766
HDInsight > Hadoop
Event Date: 14-04-2018 - Session time: 14:30:00 - Track: Innovate
Speaker: Mark Hudson
Title: HDInsight > Hadoop
Abstract:
Some people think of Azure HDInsight as Microsoft’s Hadoop in The Cloud. That thought is only partially correct. With storage separate from compute, HDInsight flexibility offers Hadoop with Pig and Hive options as well as HBase, Storm, Spark, R Server, and Kafka … all priced a la carte and on-demand. Join me as I explain what HDInsight is and is not along with some live demos of HDInsight’s capabilities.
SessionID: 74072
Event Date: 14-04-2018 - Session time: 14:30:00 - Track: Build
Speaker: Shannon Lowder
Abstract:
With that schema, automatically generating your extract package is a matter of seconds! Join me while I share my interrogator project with you and start saving hours at work today!
SessionID: 71062
Environmental SQL Server Troubleshooting
Event Date: 14-04-2018 - Session time: 15:45:00 - Track: Perform
Speaker: Jeff Mlakar
Title: Environmental SQL Server Troubleshooting
Abstract:
In this session we will discuss both performance pitfalls and optimizations that can be made to the system outside of code changes. We will diagnose configurations commonly misapplied and review best practices in SQL Server, Windows Server, and VMware!
SessionID: 71243
Automated SQL Server installation and configuration using PowerShell
Event Date: 14-04-2018 - Session time: 15:45:00 - Track: Build
Speaker: Jamie Wick
Title: Automated SQL Server installation and configuration using PowerShell
Abstract:
Using the SQL setup wizard and management studio (SSMS) to install and configure a new SQL server is a time-intensive process. PowerShell scripts can greatly reduce the time required to complete the process. They can also ensure build standardization throughout your SQL environment. In this session we will look at PowerShell scripting, including the basic syntax and commandlets needed to automate the installation and post-install configuration of a SQL Server.
SessionID: 71846
Getting the Skinny on Minimally Logged Operations
Event Date: 14-04-2018 - Session time: 15:45:00 - Track: Perform
Speaker: Andrew Kelly
Title: Getting the Skinny on Minimally Logged Operations
Abstract:
SessionID: 72193
Controlling Competing Workloads with SQL Server Resource Governor
Event Date: 14-04-2018 - Session time: 15:45:00 - Track: Perform
Speaker: Brian Carrig
Title: Controlling Competing Workloads with SQL Server Resource Governor
Abstract:
SessionID: 74208
Lost in Translation: ༂རཱི⿻�〄ポשׁ�ꬤﾫ◬Ꮡ�☠o̐̈́̈́̈́͢ㅴ
Event Date: 14-04-2018 - Session time: 15:45:00 - Track: Design
Speaker: Solomon Rutzky
Title: Lost in Translation: ༂རཱི⿻�〄ポשׁ�ꬤﾫ◬Ꮡ�☠o̐̈́̈́̈́͢ㅴ
Abstract:
String data is far more complex than most people are aware of. The US English alphabet and punctuation (i.e. standard ASCII) are relatively simple, but they make up a very small portion of the alphabets and non-language symbols that can be represented. Given the increasing need to handle multiple languages, it is important to understand collations and encodings before getting collation mismatch errors or losing data.
In this presentation we will cover: the actual differences between VARCHAR and NVARCHAR, what Collations are and can do, binary collations (and why they aren't truly case sensitive), SQL Server vs Windows collations, supplementary characters and surrogate pairs, Collation Precedence, Code Pages, ASCII / Unicode / UTF-8 / UTF-16 / UCS-2 encodings, combining characters, what server-level and database-level default collations do, ramifications of changing a database's collation, multi-byte character sets, NVARCHAR to VARCHAR "best fit" mappings, and other fascinating topics.
SessionID: 74350
Query Store Primer
Event Date: 14-04-2018 - Session time: 15:45:00 - Track: Analyze
Speaker: Tracy Boggiano
Title: Query Store Primer
Abstract:
SessionID: 80498
Building the HASSP: Putting SQL Server In Space
Event Date: 14-04-2018 - Session time: 15:45:00 - Track: Design
Speaker: Drew Furgiuele
Title: Building the HASSP: Putting SQL Server In Space
Abstract:
In today's world, technology is a pervasive part of our lives. We have "smart" appliances everywhere: from cars, thermostats, and even refrigerators contain built-in systems to collect, store, and transmit data. Small embedded devices can also be used for scientific purposes as well, offering new and exciting ways to collect data for studies or projects at home.
The High-Altitude SQL Server Project, or HASSP, is one such project.
The HASSP team has created a high-altitude balloon that uses sensors to collect various data points and store the results in an embedded version of SQL Server!
In this session, you'll hear about how this is possible: we'll discuss the hardware used, the custom device that we built, and the software used to make it all work together. Best of all, you'll see how to recreate (and hopefully improve!) the project on your own.