sqlsathistory

Nr: 547

Back to Main list

SQLSaturday #547 - Columbus, GA 2016

Start Time (24h)	Speaker	Track	Title
09:00:00	Sven Aelterman	Cloud Anything	Azure SQL Database: Deployment and Development of Your First DB
09:00:00	Rob Volk	Enterprise Database Administration Deployment	Revenge: The SQL!
09:00:00	Ed Watson	BI Platform Architecture, Development, Delivery, Administration	Introduction to SQL Server Integration Services
09:00:00	Jon Boulineau	BI Platform Architecture, Development, Delivery, Administration	Introducing Hadoop to SQL Server Pros
10:15:00	Rob Volk	Enterprise Database Administration Deployment	Azure, PowerShell, and SQL Server Virtual Machines
10:15:00	Mark Tabladillo	Analytics and Visualization	Microsoft Technologies for Data Science
10:15:00	Julie Smith	Cloud Anything	Cloud Cloud. Cloud cloud cloud cloud cloud.....also Azure.
10:15:00	Aaron Nelson	Enterprise Database Administration Deployment	Do Awesome Things with PowerShell in 5 minutes or Less
11:30:00	Sven Aelterman	Cloud Anything	Azure SQL Database: 12 Things To Know
11:30:00	Jon Boulineau	Application Database Development	How Queries Work
11:30:00	William E Pearson III	Analytics and Visualization	Pragmatic Power BI: Working with Data Sources
11:30:00	Robert Cain	Enterprise Database Administration Deployment	Zero to Hero with PowerShell and SQL Server
13:30:00	Ed Watson	Enterprise Database Administration Deployment	Performance Tuning for Mere Mortals Part I
13:30:00	Rodney Landrum	Application Database Development	A Quick Peek into the 4th Dimension with T-SQL
13:30:00	Cornell Emile	Analytics and Visualization	Enhancing Data and Predictive Analytics with Azure HDInsight
13:30:00	Theresa Eller	Application Database Development	Using SQL to Avoid the SharePoint List Threshold
13:30:00	Rodney Landrum	Enterprise Database Administration Deployment	I See What You Did There– Automating Auditing in SQL Server
14:45:00	Damu Venkatesan	BI Platform Architecture, Development, Delivery, Administration	Self-Service ETL with Microsoft Power Query
14:45:00	Mike Lawell	Enterprise Database Administration Deployment	Execution Plans for Mere Mortals
14:45:00	Kevin Feasel	Application Database Development	APPLY Yourself
14:45:00	Paco Gonzalez	Analytics and Visualization	Enterprise Machine Learning with R and SQL Server

SessionID: 48903

Azure SQL Database: Deployment and Development of Your First DB

Back to calendar

Event Date: 27-08-2016 - Session time: 09:00:00 - Track: Cloud Anything

Speaker: Sven Aelterman

Title: Azure SQL Database: Deployment and Development of Your First DB

Abstract:

Azure SQL Database offers compelling features for developers, especially those creating cloud applications. In this session, you'll learn about the Azure SQL Database platform and the tools provided for deployment and management of your databases. Demos will provide step-by-step examples of creating a SQL Server and Azure SQL Database, deploying a database using various methods and then managing that database.

SessionID: 48905

Revenge: The SQL!

Back to calendar

Event Date: 27-08-2016 - Session time: 09:00:00 - Track: Enterprise Database Administration Deployment

Speaker: Rob Volk

Title: Revenge: The SQL!

Abstract:

Pop quiz DBA: Your developers are running rampant in production. Logic, reason, and threats have all failed. You're on the edge. What do you do? WHAT DO YOU DO?

Hint: You attend Revenge: The SQL!

This session will show you how to "correct" all those bad practices. Everyone logging in as sa? Running huge cursors? Using SELECT * and ad-hoc SQL? Stop them dead, without actually killing them. Ever dropped a table, or database, or WHERE clause? You can prevent that! And if you’re tired of folks ignoring your naming conventions, make them behave with Unicode…and take your revenge!

Revenge: The SQL! is fun and educational and may even have some practical use, but you’ll want to attend simply to indulge your Dark Side. Revenge: The SQL! assumes no liability and is not available in all 50 states. Do not taunt Revenge: The SQL! or Happy Fun Ball.

SessionID: 48947

Introduction to SQL Server Integration Services

Back to calendar

Event Date: 27-08-2016 - Session time: 09:00:00 - Track: BI Platform Architecture, Development, Delivery, Administration

Speaker: Ed Watson

Title: Introduction to SQL Server Integration Services

Abstract:

Take an introductory journey into the world of SSIS through the eyes of a SQL Server DBA as he navigates the Business Intelligence waters. This is an introductory course for beginners or users without any SSIS experience. Come learn how to SSIS with me!

SessionID: 48964

Introducing Hadoop to SQL Server Pros

Back to calendar

Event Date: 27-08-2016 - Session time: 09:00:00 - Track: BI Platform Architecture, Development, Delivery, Administration

Speaker: Jon Boulineau

Title: Introducing Hadoop to SQL Server Pros

Abstract:

Finding any IT industry publication that does not frequently reference Hadoop and Big Data is nearly impossible. Even so, to many SQL Server professionals it remains a mystery. 'Introducing Hadoop to SQL Server Pros' is designed to bridge the gap between knowledge of SQL Server and an understanding of Hadoop by comparing similarities in key functionality. Equally important is understanding how Hadoop is different and the use cases in which it compliments SQL Server. Of special note are the ways Microsoft is integrating Hadoop in its data strategy and related products. Perhaps 2016, Hadoop's 10th birthday year, is the time for SQL Server Pros to become familiar with this platform and how to prepare for it's introduction into our work as data professionals.

SessionID: 48904

Azure, PowerShell, and SQL Server Virtual Machines

Back to calendar

Event Date: 27-08-2016 - Session time: 10:15:00 - Track: Enterprise Database Administration Deployment

Speaker: Rob Volk

Title: Azure, PowerShell, and SQL Server Virtual Machines

Abstract:

While the web portal makes it easy to deploy SQL Server on Azure Virtual Machines, there are a number of benefits to using PowerShell to do the job. This session will introduce Azure PowerShell command-lets and how to create a basic Azure infrastructure to support a SQL Server VM. We'll include the Azure Resource Manager, how to use ARM VM templates and Custom Script Extension, and how users can modify an existing Azure Gallery template. Desired State Configuration (DSC) will be covered to complete the Azure Powershell automation toolkit, allowing attendees to automate the deployment of dozens or more SQL Server virtual machines. Finally, we will configure Availability Groups and explain their eccentricities in the Azure environment as well as how to make them work effectively.

SessionID: 48986

Microsoft Technologies for Data Science

Back to calendar

Event Date: 27-08-2016 - Session time: 10:15:00 - Track: Analytics and Visualization

Speaker: Mark Tabladillo

Title: Microsoft Technologies for Data Science

Abstract:

Microsoft provides several technologies in and around SQL Server which can be used for casual to serious data science. This presentation provides an authoritative overview of five major options: SQL Server Analysis Services, Excel Add-in for SSAS, Semantic Search, Microsoft Azure Machine Learning, and F#. Also included are tips on working with Python and R. These technologies have been used by the presenter in various companies and industries. Bring your beginner to advanced questions!

SessionID: 49070

Cloud Cloud. Cloud cloud cloud cloud cloud.....also Azure.

Back to calendar

Event Date: 27-08-2016 - Session time: 10:15:00 - Track: Cloud Anything

Speaker: Julie Smith

Title: Cloud Cloud. Cloud cloud cloud cloud cloud.....also Azure.

Abstract:

How much Azure can you Azure? How many cloud can you cloud? Hear the lessons learned from an attempt at an “All Azure” BI Project. We’ll explore Azure SQL Database, Azure Data Factory and Power BI as pieces of the solution and learn where On Prem had to be used to fill in the gaps in the solution.

SessionID: 50517

Do Awesome Things with PowerShell in 5 minutes or Less

Back to calendar

Event Date: 27-08-2016 - Session time: 10:15:00 - Track: Enterprise Database Administration Deployment

Speaker: Aaron Nelson

Title: Do Awesome Things with PowerShell in 5 minutes or Less

Abstract:

What if you could import 25 million rows of CSV data in less than 2 minutes? Or regain lost sysadmin access to your SQL Server in 20 seconds? Need to check which of your 200 servers has misconfigured max memory, calculate the proper memory and then set it? No problem, couple of minutes, tops.

PowerShell can do amazing things for database administrators. It can automate your complex, onerous tasks. It can also automate the boring yet vital tasks like testing backups, and it can do it faster than you think. Even better, it is easier to learn than you might expect.

Get Better, Faster, Stronger with PowerShell SQL Server.

SessionID: 48902

Azure SQL Database: 12 Things To Know

Back to calendar

Event Date: 27-08-2016 - Session time: 11:30:00 - Track: Cloud Anything

Speaker: Sven Aelterman

Title: Azure SQL Database: 12 Things To Know

Abstract:

Up and running with Azure SQL Database already? This session will provide a grab bag of 12 how-to items you'll need to know to successfully keep your database running. Among those, we'll cover PowerShell for Azure SQL DB, geo-replica and other disaster recovery features and monitoring.

SessionID: 48965

How Queries Work

Back to calendar

Event Date: 27-08-2016 - Session time: 11:30:00 - Track: Application Database Development

Speaker: Jon Boulineau

Title: How Queries Work

Abstract:

If you've been writing T-SQL code for a while, but have never delved into what happens after you submit your queries there is a whole world that you are missing. Taking the next step as a T-SQL developer requires understanding the basics of the SQL Server architecture and what it means to use a declarative language. Have you ever wondered why cursors are so slow, why query performance can be unpredictable, or how you can begin to analyze your queries more deeply? In this session we will cover what SQL Server has to do to turn your T-SQL code into the results you expect and how you can use this knowledge to make your code better.

SessionID: 49520

Pragmatic Power BI: Working with Data Sources

Back to calendar

Event Date: 27-08-2016 - Session time: 11:30:00 - Track: Analytics and Visualization

Speaker: William E Pearson III

Title: Pragmatic Power BI: Working with Data Sources

Abstract:

Power BI (either Desktop or the service) supports a wide (and growing) range of data sources. From the sources with which most IT pros and data analysts are regularly involved (relational and OLAP databases, text and similar files, etc.) to sources that are a little more out of the ordinary for some of us (OData, MS Exchange, Active Directory, and a growing list of others), these reservoirs and suppliers of data grow increasingly more valuable in self-service BI.

In this session, BI Architect, SQL Server MVP and Analysis Services Maestro Bill Pearson focuses upon the first step in working with data sources in Power BI: connecting to, and extracting data from, a diverse range of data sources. Throughout the session, we explore various sources and witness how to employ Power BI with each.

SessionID: 49707

Zero to Hero with PowerShell and SQL Server

Back to calendar

Event Date: 27-08-2016 - Session time: 11:30:00 - Track: Enterprise Database Administration Deployment

Speaker: Robert Cain

Title: Zero to Hero with PowerShell and SQL Server

Abstract:

PowerShell is everywhere, and that includes SQL Server. In this session we'll look at using PowerShell with both the SQL Server provider and the SMO (SQL Management Objects) library. Learn how to handle common DBA tasks, such as backups, reviewing error logs, and checking the status of SQL Jobs.

You'll also see how to perform developer tasks such as creating tables, inserting records, and querying data. Perhaps most importantly, you will learn how to read and understand the SMO object model, and translate it into PowerShell commands. Come see how to make your SQL Server Pop with PowerShell.

SessionID: 48945

Performance Tuning for Mere Mortals Part I

Back to calendar

Event Date: 27-08-2016 - Session time: 13:30:00 - Track: Enterprise Database Administration Deployment

Speaker: Ed Watson

Title: Performance Tuning for Mere Mortals Part I

Abstract:

In this first part of a two part series, we look at performance tuning from the very beginning. You're a new DBA, you want to be a DBA, or you've been declared an "Accidental DBA" and the phone rings. Someone tells you that they believe SQL Server is having a performance issue, what now? The application is running slowly. Can you help them? Do you even know where to begin to help them? In this session we'll cover how to handle performance tuning from the very beginning, when the user says "The database is slow."

SessionID: 48980

A Quick Peek into the 4th Dimension with T-SQL

Back to calendar

Event Date: 27-08-2016 - Session time: 13:30:00 - Track: Application Database Development

Speaker: Rodney Landrum

Title: A Quick Peek into the 4th Dimension with T-SQL

Abstract:

Time. We are all cursed and blessed with it. We run out of it, often need more of it, sometimes forget it but are always keeping track of it. In this session, we will delve into the functions provided in T-SQL and Excel to demonstrate how to solve both simple and complex problems with time and dates for your reports and dashboards. Ever wondered what is so special about 01/01/1900 and what will happen on January 1, 10,000? Do you want to know how to find gaps in time between systems or forecast the future? Are you interested to know how to accurately tally hours from minutes (it may not be as easy as you thought), then this session will not be a waste of your time.

SessionID: 48990

Enhancing Data and Predictive Analytics with Azure HDInsight

Back to calendar

Event Date: 27-08-2016 - Session time: 13:30:00 - Track: Analytics and Visualization

Speaker: Cornell Emile

Title: Enhancing Data and Predictive Analytics with Azure HDInsight

Abstract:

The pervasiveness of Big Data has created significant challenges for companies that have historically utilized relational database management systems to perform data analysis and predictive analytics. This presentation outlines the challenges that stem from Big Data as it relates to deriving value from data and how Azure HDInsight can serve as a data platform that significantly enhances the data analysis and predictive analytics capabilities of companies.

SessionID: 49119

Using SQL to Avoid the SharePoint List Threshold

Back to calendar

Event Date: 27-08-2016 - Session time: 13:30:00 - Track: Application Database Development

Speaker: Theresa Eller

Title: Using SQL to Avoid the SharePoint List Threshold

Abstract:

What do you do when your SharePoint list exceeds the 5,000 item threshold? Do you turn off throttling for the list? Do you increase the limit in Central Admin? If either of these are your solution, you're risking a SQL database lockup, which could affect more than the one list. Based on a real world scenario, this session will share how a major healthcare institution recently used a SQL view containing 6,000+ items to avoid SharePoint's list threshold. Additionally, attendees will see how a Power View report built in SharePoint used the same SQL data to provide an interactive dashboard for data monitoring.

SessionID: 53987

I See What You Did There– Automating Auditing in SQL Server

Back to calendar

Event Date: 27-08-2016 - Session time: 13:30:00 - Track: Enterprise Database Administration Deployment

Speaker: Rodney Landrum

Title: I See What You Did There– Automating Auditing in SQL Server

Abstract:

You are a DBA, not a psychic. If you want to know who is making changes, trying to access confidential data, or unsuccessfully attempting to login as the Web service account on any or all of the SQL Server instances you manage; you don’t need a crystal ball to gain the power of insight. However, if you follow along in this presentation you will be able to use the magic of SQL Server Audit to peer into the past with Power View and tell the professional future of the unwary soul who crossed your path. None shall PASS!

SessionID: 48914

Self-Service ETL with Microsoft Power Query

Back to calendar

Event Date: 27-08-2016 - Session time: 14:45:00 - Track: BI Platform Architecture, Development, Delivery, Administration

Speaker: Damu Venkatesan

Title: Self-Service ETL with Microsoft Power Query

Abstract:

In this session, I will introduce you to Microsoft's new self-service ETL tool "Power Query" for Excel. I will show you, how to source data from various data sources, how you can massage the data and consume the data for your use in the data pipeline. I will introduce you to "M" language that is used in Power Query. I will show you how you can discover and mash data from public data sources within Power Query. If you would like to do ETL quickly without writing SSIS packages, Power Query is the way go. Come and attend this session to learn "Power Query".

SessionID: 48927

Execution Plans for Mere Mortals

Back to calendar

Event Date: 27-08-2016 - Session time: 14:45:00 - Track: Enterprise Database Administration Deployment

Speaker: Mike Lawell

Title: Execution Plans for Mere Mortals

Abstract:

For beginning database professionals, execution plans can be intimidating. This 1-hour session takes you through the basics of reading graphical execution plans and drills into key operators, warnings, and properties. Learn how, why, and when an execution plan is created and saved to plan cache.

Reading execution plans becomes much less intimidating as we walk through the flow and process of a graphical execution plan. After looking at the key operators, you will be able to analyze the operators of your execution plans, view the operator properties, and identify common performance-tuning opportunities. Finally, you will be able to capture the execution plan and save it for analysis and comparison after modifications.

SessionID: 49046

APPLY Yourself

Back to calendar

Event Date: 27-08-2016 - Session time: 14:45:00 - Track: Application Database Development

Speaker: Kevin Feasel

Title: APPLY Yourself

Abstract:

Microsoft introduced the APPLY operator in SQL Server 2005. This under-used, non-standard operator can help us solve a number of common (and not-so-common) problems with elegant code which performs well. We will look several problem spaces in which the APPLY operator shines, such as joining to table-valued functions, getting the top N child records for each parent record, string splitting, and word matching. With the use of these examples, we will gain a deeper understanding of when to use the APPLY operator.

SessionID: 53915

Enterprise Machine Learning with R and SQL Server

Back to calendar

Event Date: 27-08-2016 - Session time: 14:45:00 - Track: Analytics and Visualization

Speaker: Paco Gonzalez

Title: Enterprise Machine Learning with R and SQL Server

Abstract:

R is a pure data science and statistics scripting language. It is considered the best fit for Machine Learning. With more than 5000 packages all machine learning algorithms are covered and improving. R packages help you prepare the data, e.g.: packages for cross validation with N folds, build machine learning models, validation, create plots and to generate predictions. SQL Server 2016 and R Server are a perfect match for building enterprise grade solutions that support deployments for real time predictions and continuous model updates. Join this session for an overview based on sample cases about how to build enterprise grade machine learning solutions with SQL Server and R.

This site is open source. Improve this page.