sqlsathistory

Nr: 757

Back to Main list

SQLSaturday #757 - Sacramento 2018

Start Time (24h) Speaker Track Title
08:30:00 Grant Fritchey Enterprise Database Administration Deployment Data Protection Privacy in the World of Database DevOps
08:30:00 Anthony Nocentino Enterprise Database Administration Deployment Monitoring Linux Performance for the SQL Server Admin
08:30:00 Robert Muir Application Database Development SQL Query 101
08:30:00 John Morehouse Cloud Application Development Deployment Azure Basics for the DBA
08:30:00 Jason Horner Cloud Application Development Deployment Real-World Data Movement and Orchestration Patterns with Azure Data Factory
09:45:00 Marsha Pierce Enterprise Database Administration Deployment Mom Rules for Managing Enterprise Database Environments
09:45:00 Monica Rathbun Application Database Development Always Encrypted for Beginners
09:45:00 John Morehouse Enterprise Database Administration Deployment SQL Server Databaseology: A Deep Dive Into Database Internals
09:45:00 Mitchell Bottel Enterprise Database Administration Deployment Get TurnedOn with AlwaysOn
09:45:00 Hasan Savran Professional Development What's new in SQL Server 2017
11:00:00 Marsha Pierce Enterprise Database Administration Deployment How To Talk To Your Storage Admin
11:00:00 Adam Anderson BI Platform Architecture, Development Administration Delivering Business Value Faster
11:00:00 Suresh Datla BI Platform Architecture, Development Administration Power BI Dashboard - Creating End to End Solutions
11:00:00 Ami Levin Strategy and Architecture Big Data - The Biggest Fad of the Decade
11:00:00 Steve Rezhener Information Delivery Introduction to SQL Server Integration Services, what's new in SSIS
12:15:00 Diane Schuster BI Platform Architecture, Development Administration CozyRoc: Dynamic Data Flows in SSIS Without Programming
12:15:00 Amie Mason Cloud Application Development Deployment Attunix: Azure Intelligent Services
13:30:00 Armando Lacerda BI Platform Architecture, Development Administration Insights with massive data ingestion and Power BI
13:30:00 Grant Fritchey Cloud Application Development Deployment Disaster Recovery and High Availability in Azure SQL Database
13:30:00 Steven Tidwell Application Database Development Dynamic SQL: Tables, Pivots, Parameters More
13:30:00 Monica Rathbun Enterprise Database Administration Deployment I'm It - Survival Techniques for the Lone DBA
13:30:00 Kalen Delaney Advanced Analysis Techniques A Look Inside SQL Server Distribution Statistics
14:45:00 Phil Robinson BI Platform Architecture, Development Administration Data Wrangling for Reporting Analytics using Power BI
14:45:00 Randy Knight Professional Development Soft skills for Geeks: Don't be a flat boxer
14:45:00 Rick Lowe Strategy and Architecture Why Should I Care About ... Partitioned Views?
14:45:00 Ted Stathakis BI Platform Architecture, Development Administration Reporting Services 2016: New Features Smart Migration Strategy
14:45:00 Neil Hambly BI Information Delivery PowerBI your way to understand your SQL Server Estate
16:00:00 Armando Lacerda Enterprise Database Administration Deployment Microsoft Azure for SQL Server Professionals - Get your head in the cloud
16:00:00 Sayed Saeed BI Platform Architecture, Development Administration The Business Intelligence Side of SQL Server
16:00:00 Anthony Nocentino Enterprise Database Administration Deployment Containers - You Better Get on Board
16:00:00 Eric Freeman Application Database Development CSV files and ETL- The Good, Bad, and Ugly
16:00:00 Glenn Burnett Enterprise Database Administration Deployment Lightning Talks!

SessionID: 77954

Data Protection Privacy in the World of Database DevOps

Back to calendar

Event Date: 28-07-2018 - Session time: 08:30:00 - Track: Enterprise Database Administration Deployment

Speaker: Grant Fritchey

Title: Data Protection Privacy in the World of Database DevOps

Abstract:

Ensuring the ongoing protection of personally identifiable information is mandatory in today's business, helping you to guard against data breaches, and comply with the GDPR. In a climate where cyber attacks are all too frequent, and data is spread across a growing number of different environments, the challenge of protecting your data can seem daunting. This session will address the implications of the GDPR on database management, and demonstrate a privacy-first approach to controlling and protecting data as it changes and moves through your SQL Server estate. As well as offering guidance for assessing your data estate for GDPR readiness, this session will include some great tools and tips for building data protection and privacy into your development processes, and dispel the myth that database DevOps and compliance can't go hand in hand. With the right preparation, you can build compliance into your processes, keep sensitive data safe, and deliver value quickly to your end users.

SessionID: 78312

Monitoring Linux Performance for the SQL Server Admin

Back to calendar

Event Date: 28-07-2018 - Session time: 08:30:00 - Track: Enterprise Database Administration Deployment

Speaker: Anthony Nocentino

Title: Monitoring Linux Performance for the SQL Server Admin

Abstract:

So you’re a SQL Server administrator and you just installed SQL Server on Linux. It’s a whole new world. Don’t fear, it’s just an operating system. It has all the same components Windows has and in this session we’ll show you that. We will look at the Linux operating system architecture and show you where to look for the performance data you’re used to! Further we'll dive into SQLPAL and how it architecture and internals enables high performance for your SQL Server. By the end of this session you’ll be ready to go back to the office and have a solid understanding of performance monitoring Linux systems and SQL on Linux. We’ll look at the core system components of CPU, Disk, Memory and Networking monitoring techniques for each and look some of the new tools available including new DMVs and DBFS.

SessionID: 80368

SQL Query 101

Back to calendar

Event Date: 28-07-2018 - Session time: 08:30:00 - Track: Application Database Development

Speaker: Robert Muir

Title: SQL Query 101

Abstract:

A beginner level session to cover table creation and various usage of data types. Query techniques to cover single and multiple tables covering inner, left, right, and outer joins. Usage of functions like Max, Min, Sum, and Having in queries. We will wrap up the session with some items to beware of.

SessionID: 82860

Azure Basics for the DBA

Back to calendar

Event Date: 28-07-2018 - Session time: 08:30:00 - Track: Cloud Application Development Deployment

Speaker: John Morehouse

Title: Azure Basics for the DBA

Abstract:

It's not a question on whether or not the landscape for the common DBA is changing. Without a doubt, it is.  Azure offers up a new world of possibilities for DBA's and we should all strive to learn it.  In this session we'll cover some basic knowledge and terminology of Azure as well as how easy it is to incorporate Azure into your environment. We will stand up a new Azure virtual machine as well as a setup SQL DB. You will see how easy it is to accomplish this.  This new found knowledge will help propel your career into the new landscape.

SessionID: 84304

Real-World Data Movement and Orchestration Patterns with Azure Data Factory

Back to calendar

Event Date: 28-07-2018 - Session time: 08:30:00 - Track: Cloud Application Development Deployment

Speaker: Jason Horner

Title: Real-World Data Movement and Orchestration Patterns with Azure Data Factory

Abstract:

In this session, we will start with an overview of Azure Data Factory V2 concepts, then show you how you can use metadata to quickly build scalable serverless pipelines to move data from disparate data sources including On-Premises and Platform As A Service. Next, we will look at how to integrate the solution using continuous integration and deployment techniques. Finally, we will look at how to schedule, monitor and log our solution.

Whether you are just getting started with Azure Data Factory or looking to make your current data factory robust and enterprise-ready this session will take you to the next level.

SessionID: 74400

Mom Rules for Managing Enterprise Database Environments

Back to calendar

Event Date: 28-07-2018 - Session time: 09:45:00 - Track: Enterprise Database Administration Deployment

Speaker: Marsha Pierce

Title: Mom Rules for Managing Enterprise Database Environments

Abstract:

Have you ever looked at an environment and wondered how the heck they ever got anything done because it is so disorganized? The first thing I do for newly inherited environments is implement some organization and do some database clean up. Not only does organization make the environment easier to maintain, it can help speed up trouble shooting. Good organization can even help with some performance issues.

SessionID: 82742

Always Encrypted for Beginners

Back to calendar

Event Date: 28-07-2018 - Session time: 09:45:00 - Track: Application Database Development

Speaker: Monica Rathbun

Title: Always Encrypted for Beginners

Abstract:

One of the biggest challenges to successful implementation of data encryption has been the back and forth between the application and the database.  You have to overcome the obstacle of the application decrypting the data it needs.  Microsoft tried to simplify this process when it introduced Always Encrypted (AE) into SQL Server 2016 and Azure SQL Database. In this demo intense session, you will learn about what Always Encrypted is, how it works, and the implications for your environment. By the end you will know how to now easily encrypt columns of data and just as importantly how to unencrypt. You will also learn about the current limitations of the feature and what your options are to work around them.

SessionID: 82863

SQL Server Databaseology: A Deep Dive Into Database Internals

Back to calendar

Event Date: 28-07-2018 - Session time: 09:45:00 - Track: Enterprise Database Administration Deployment

Speaker: John Morehouse

Title: SQL Server Databaseology: A Deep Dive Into Database Internals

Abstract:

Have you ever taken apart a toaster or an alarm clock just to see how it worked? Ever wondered how that database actually functions at the record level, behind the scenes? SQL Server Databaseology is the study of SQL Server databases and their structures down to the very core of the records themselves. In this session, we will explore some of the deep inner workings of a SQL Server database at the record and page level. You will walk away with a better understanding of how SQL Server stores data and that knowledge will allow you to build better, faster databases.

SessionID: 83204

Get TurnedOn with AlwaysOn

Back to calendar

Event Date: 28-07-2018 - Session time: 09:45:00 - Track: Enterprise Database Administration Deployment

Speaker: Mitchell Bottel

Title: Get TurnedOn with AlwaysOn

Abstract:

Once upon a time, there were 2 SQL Solutions named High Availability and Disaster Recovery. They had a love hate relationship and could never find a common ground. That is, until SQL Server 2012 brought them together in a love story built for the ages. When the dust settled, a beautiful new feature was born. It was called AlwaysON and brought with it new technologies like availability groups, read-only mirrors and listeners. It was a perfect blend of both HA and DR all wrapped up in one bundle of joy.

SQL Server AlwaysOn provides a high-availability and Disaster-recovery solution for SQL Server 2012. Come see and learn some of the new features associated with it, how they work and why this new feature of SQL Server 2012 is so wonderful.

SessionID: 83563

What's new in SQL Server 2017

Back to calendar

Event Date: 28-07-2018 - Session time: 09:45:00 - Track: Professional Development

Speaker: Hasan Savran

Title: What's new in SQL Server 2017

Abstract:

SQL Server 2017 was the surprise software hit of the year. Here is a list of the features I am going to focus on in this session:

Linux Version: I will cover the things you need to know before you decide to move SQL Server into Linux. Graph Tables: I will cover why you may need to add Graph Tables into your database. You will learn the differences between Relational Database Tables and Graph Database Tables. Query Optimization: We will look at the new Intelligent Query Processing options in Query Plans with demos. Resumable Online Index Rebuild: I will show you how to pause/resume ongoing index rebuild with demos. Machine Learning Services: I will demo how to run R Script in SQL Server 2017. We will look at the ways to monitor Machine Learning Services. In-Memory Tables: SQL Server 2017 became a great resource for caching with the new In-Memory features. We will create a NoSql Environment in SQL Server 2017 by using In-Memory tables and JSON functions

SessionID: 74399

How To Talk To Your Storage Admin

Back to calendar

Event Date: 28-07-2018 - Session time: 11:00:00 - Track: Enterprise Database Administration Deployment

Speaker: Marsha Pierce

Title: How To Talk To Your Storage Admin

Abstract:

A general discussion about storage and how it affects DBA's. We will discuss how to monitor for performance as well. We will also discuss what DBA's need to consider when talking to their storage administrators.

SessionID: 82554

Delivering Business Value Faster

Back to calendar

Event Date: 28-07-2018 - Session time: 11:00:00 - Track: BI Platform Architecture, Development Administration

Speaker: Adam Anderson

Title: Delivering Business Value Faster

Abstract:

Every team’s goal is to deliver business value faster, the question is how do you do that? If you’re a small shop with 1 or 2 developers then writing script in test and then running them production may be okay, but for a larger team that leads to problems. Using continuous integration (CI) and deployment techniques you can make small incremental changes which then set off a chain of automation steps that validates the new code. After automated validation, the code changes are ready for any additional User Acceptance Testing (UAT) and staging environments. During this session, you will learn how to manage database schema changes in a dynamic environment and deliver code to production by utilizing continuous integration and certain development techniques in minutes with minimal risk.

SessionID: 83328

Power BI Dashboard - Creating End to End Solutions

Back to calendar

Event Date: 28-07-2018 - Session time: 11:00:00 - Track: BI Platform Architecture, Development Administration

Speaker: Suresh Datla

Title: Power BI Dashboard - Creating End to End Solutions

Abstract:

We will be discussing the lifecycle of a Power BI Dashboard beginning from

Accessing data, Data preparation, and cleansing, consuming the data for reports and deploying the reports to Power BI services, configuring security and making the Dashboards available to end users.

SessionID: 83354

Big Data - The Biggest Fad of the Decade

Back to calendar

Event Date: 28-07-2018 - Session time: 11:00:00 - Track: Strategy and Architecture

Speaker: Ami Levin

Title: Big Data - The Biggest Fad of the Decade

Abstract:

In this session we will investigate what Big Data really means, and more importantly - what it doesn't mean. What makes Big Data different than any other data? What makes Big Data challenges different than the same old challenges we had 30 years ago? Together, we will perform an honest, inquisitive, and enlightening investigation of what Big Data really is, it's origins, and how it evolved over the last decade. We will use history, analytics and logic to dissect the beast, and expose it for what it really is. Why should you care? The Big Data hype is holding you back from doing what is really important with data - getting value out of it. Making sense of it. Vendors, organizations, and architects have become so obsessed with the 'Big Data' fad, and too many either lost sight, or no longer have the resources to pursue their real goals. In this session I will plea to your reasoning, critical thinking, and plain common sense, to wake up and shout with me "The Emperor has no cloths!!!"

SessionID: 84286

Introduction to SQL Server Integration Services, what's new in SSIS

Back to calendar

Event Date: 28-07-2018 - Session time: 11:00:00 - Track: Information Delivery

Speaker: Steve Rezhener

Title: Introduction to SQL Server Integration Services, what's new in SSIS

Abstract:

We will have an introduction to ETL, ETL software landscape and Microsoft SQL Server Integration Services a.k.a. SSIS in greater details. We will also discuss what's new in SSIS 2016. For the hands-on section, we will create a simple SSIS package and test-drive some selected features, like Balance Data Distributor, Control parts, and Expression Task.

SessionID: 82747

CozyRoc: Dynamic Data Flows in SSIS Without Programming

Back to calendar

Event Date: 28-07-2018 - Session time: 12:15:00 - Track: BI Platform Architecture, Development Administration

Speaker: Diane Schuster

Title: CozyRoc: Dynamic Data Flows in SSIS Without Programming

Abstract:

This session is an introduction to the unique functionality offered by COZYROC to create integration packages that dynamically map columns at runtime. The standard SSIS Data Flow Task can only use static metadata which is defined when the package is initially designed. The mapping of columns is configured and remains unchanged until the package is re-opened and design changes are made, thus costing maintenance time and effort. Data Flow Task Plus extends the capabilities of the standard Microsoft Data Flow task in that it allows you to set up dynamic data flows, thus eliminating maintenance time and effort. Changes to tables and columns are automatically incorporated at run time without the need to change and redeploy the package. Columns and fields are mapped automatically at run time. Furthermore, the initial design time and effort may be greatly reduced when dealing with huge amounts of data in a large number of files and/or databases.

SessionID: 84514

Attunix: Azure Intelligent Services

Back to calendar

Event Date: 28-07-2018 - Session time: 12:15:00 - Track: Cloud Application Development Deployment

Speaker: Amie Mason

Title: Attunix: Azure Intelligent Services

Abstract:

Discover the ways Azure transforms AI and Predictive Analytics making it easier and more accessible through services like Azure Machine Learning and pre-built Cognitive Services, while also supporting custom development and deep-learning.

SessionID: 74132

Insights with massive data ingestion and Power BI

Back to calendar

Event Date: 28-07-2018 - Session time: 13:30:00 - Track: BI Platform Architecture, Development Administration

Speaker: Armando Lacerda

Title: Insights with massive data ingestion and Power BI

Abstract:

We all love Power BI and its abilities to show data insights through its interface. But Power BI has its limits when it comes to massive data ingestion and near real time dashboards. In this presentation we will evaluate some out of the box solutions to render metrics and KPIs from massive loads that extrapolates Power BI limits.

You will learn:

• Power BI limits for accommodate data refresh and streaming datasets • Develop strategies for continuous and discrete data capturing for Power BI • Azure services options for near real time dashboards Power BI • SQL Server features to source discrete dataset for Power BI

SessionID: 77956

Disaster Recovery and High Availability in Azure SQL Database

Back to calendar

Event Date: 28-07-2018 - Session time: 13:30:00 - Track: Cloud Application Development Deployment

Speaker: Grant Fritchey

Title: Disaster Recovery and High Availability in Azure SQL Database

Abstract:

While Azure SQL Database does have built-in safety mechanisms, these are not always well understood. Further, a good architect will ensure redundancy even with an already protected system. This session will show how Azure SQL Database is built and maintained by Microsoft to provide protection for your production information. We’ll also go over methods you can employ to add additional protection to your systems. Moving to the cloud and taking advantage of all that it offers doesn’t mean your data is automatically, fully protected. The knowledge from this session will help to ensure a higher degree of safety, faster recovery, and more up-time for your Azure SQL Databases.

SessionID: 78700

Dynamic SQL: Tables, Pivots, Parameters More

Back to calendar

Event Date: 28-07-2018 - Session time: 13:30:00 - Track: Application Database Development

Speaker: Steven Tidwell

Title: Dynamic SQL: Tables, Pivots, Parameters More

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. We will also see how to use Dynamic SQL to build multiple databases across servers, alter a single table in multiple servers and add columns to a table, all through the magic of Dynamic SQL.

SessionID: 82743

I'm It - Survival Techniques for the Lone DBA

Back to calendar

Event Date: 28-07-2018 - Session time: 13:30:00 - Track: Enterprise Database Administration Deployment

Speaker: Monica Rathbun

Title: I'm It - Survival Techniques for the Lone DBA

Abstract:

Are you the only database person at your company? Are you both the DBA and the Developer? Being the only data professional in an environment can seem overwhelming, daunting, and darn near impossible sometimes. However, it can also be extremely rewarding and empowering. This session will cover how you can keep your sanity, get stuff done, and still love your job. We'll cover how I have survived and thrived being a Lone DBA for 15 years and how you can too. When you finish this session, you'll know what you can do to make your job easier, where to find help, and how to still be able to advance and enrich your career.

SessionID: 84044

A Look Inside SQL Server Distribution Statistics

Back to calendar

Event Date: 28-07-2018 - Session time: 13:30:00 - Track: Advanced Analysis Techniques

Speaker: Kalen Delaney

Title: A Look Inside SQL Server Distribution Statistics

Abstract:

Where do the estimated rowcount values come from? We’ll look inside SQL Server’s distribution statistics to see how they are used to come up with the estimates. We’ll explore some of the new metadata that let you see more details about the statistics and the data changes. We’ll see how and when SQL Server’s distribution statistics are updated and what control you have over the updating of statistics.

SessionID: 74183

Data Wrangling for Reporting Analytics using Power BI

Back to calendar

Event Date: 28-07-2018 - Session time: 14:45:00 - Track: BI Platform Architecture, Development Administration

Speaker: Phil Robinson

Title: Data Wrangling for Reporting Analytics using Power BI

Abstract:

In today’s world reporting and analytics are no longer focused exclusively on internal data from transactional systems and the data warehouse.

Mashups using data from partners, commercial and public sources are fast becoming the new normal. Do you have a csv file too big to open, is a non-windows format or generates errors on import or opening? Need to determine the quality of a file downloaded from the internet or supplied by another party? In this presentation we will review tools to examine/repair schema issues and explore Power BI Desktop features that provide insights into your datasets along with the M language for building mashups and data models.

SessionID: 82506

Soft skills for Geeks: Don't be a flat boxer

Back to calendar

Event Date: 28-07-2018 - Session time: 14:45:00 - Track: Professional Development

Speaker: Randy Knight

Title: Soft skills for Geeks: Don't be a flat boxer

Abstract:

If you like being the surly IT geek who lives in a dark office and gets fed pizza under the door (i.e. a flat boxer) this session is NOT for you. However, if promotion, appreciation for what you do, and the adoration of your peers and management are appealing to you, you might want to participate in this one.

SessionID: 83366

Why Should I Care About ... Partitioned Views?

Back to calendar

Event Date: 28-07-2018 - Session time: 14:45:00 - Track: Strategy and Architecture

Speaker: Rick Lowe

Title: Why Should I Care About ... Partitioned Views?

Abstract:

Partitioned tables are awesome and partitioned views are dead, right? Well, sure partitioned views are not sexy but there are still plenty of applications where they are critical. And not necessarily just for standard edition users who aren't on the new service pack yet. If your data is time stamped, do you see different queries run against older data than new data? Do you with you could segment your data across multiple columns? Do you have data you need to partition horizontally? It's possible partitioned views may still be for you. Come hear why this is still an important topic long after cargo pants and trucker hats went away ... and even after 2016 SP1.

SessionID: 83946

Reporting Services 2016: New Features Smart Migration Strategy

Back to calendar

Event Date: 28-07-2018 - Session time: 14:45:00 - Track: BI Platform Architecture, Development Administration

Speaker: Ted Stathakis

Title: Reporting Services 2016: New Features Smart Migration Strategy

Abstract:

With the release of SQL Server 2016, Reporting Services finally got some love! In this session, you will get an overview of some of the new features and functionality: A look at the new Report Manager interface, Mobile reports, KPIs and the new control we have over the placement of parameters. We will also look at the new Mobile Report Publisher app and see how easy it is to create mobile reports. The session will cover tips for a smart migration to 2016.

The session will then dive into how to use the data in the ReportServer database tables to see which reports in your environment are being used and how well they are performing. With this understanding you can determine which reports, data sets and data sources to migrate to a new 2016 installation. Come see how to leverage PowerShell to extract the reports from the database, instead of having to download them from Report Manager, to facilitate an easy migration to a new SQL Server 2016 Reporting Services implementation.

SessionID: 84236

PowerBI your way to understand your SQL Server Estate

Back to calendar

Event Date: 28-07-2018 - Session time: 14:45:00 - Track: BI Information Delivery

Speaker: Neil Hambly

Title: PowerBI your way to understand your SQL Server Estate

Abstract:

Would having a good understanding of all the different versions, editions, OS Builds, CPU Memory and database details in a single reporting place be useful?

Many of my previous clients have found that just to be the case…. Well now you can too and it’s totally FREE

Come Discover what really exists in your environments Visualise valuable details about your SQL Servers [Do you even know about all of them] Claim your FREE PowerBI SQL Server Estate Report Every Attendee can sign-up for their free report Useful for Capacity Planning, Migrations, Consolidations and Licensing and more. Extend the report to add additional reports and information In this session, we showcase a sample PowerBI report, giving you a flavour of what we can report on using PowerBI. This is just the beginning of the journey, if you want to know more then ask Neil about his SQL Server Health-Checks that expand on these reports.

SessionID: 74133

Microsoft Azure for SQL Server Professionals - Get your head in the cloud

Back to calendar

Event Date: 28-07-2018 - Session time: 16:00:00 - Track: Enterprise Database Administration Deployment

Speaker: Armando Lacerda

Title: Microsoft Azure for SQL Server Professionals - Get your head in the cloud

Abstract:

Lift and shift is an utopia many IT professionals have about moving on-prem resources to the cloud. The truth is we must understand how the cloud works so we adjust, design accordingly and deliver to expectations. As SQL DBAs we have options. We can choose between IaaS or PaaS, between SQL in a VM or SQL DB, NoSQL options, Azure Data Warehouse some more. In this session we will dive into these options and understand some key points on the platform through some demos.

You will learn: • Basic elements of Azure cloud ecosystem • VM disks specifics for SQL 2016/2017 • Azure SQL Database and Elastic pools • Azure Data Warehouse and Cosmos DB

SessionID: 77315

The Business Intelligence Side of SQL Server

Back to calendar

Event Date: 28-07-2018 - Session time: 16:00:00 - Track: BI Platform Architecture, Development Administration

Speaker: Sayed Saeed

Title: The Business Intelligence Side of SQL Server

Abstract:

This session focuses on Microsoft’s BI capabilities within SQL Server and its abilities to make advanced easy to use, accessible, insightful, and actionable decisions, all while helping clients increase organizational performance. Through several releases, Microsoft dramatically enhanced the Microsoft BI platform. During this session Plus Consulting, one of Microsoft's top global BI partners, value from your BI platform. We’ll show you why the combination of Microsoft Office, PowerBI and SQL Server are an excellent solution for creating self-service dashboards, scorecards, KPIs, pivots, data exploration and discovery.will explore the improvements to SQL Server self-service reporting and talk about creating blended

SessionID: 78317

Containers - You Better Get on Board

Back to calendar

Event Date: 28-07-2018 - Session time: 16:00:00 - Track: Enterprise Database Administration Deployment

Speaker: Anthony Nocentino

Title: Containers - You Better Get on Board

Abstract:

Containers are taking over, changing the way systems are developed and deployed…and that’s NOT hyperbole. Just imagine if you could deploy SQL Server or even your whole application stack in just minutes. You can do that, leveraging containers! In this session, we’ll get your started on your container journey learning container fundamentals in Docker, then look at some common container scenarios and introduce deployment automation with Kubernetes.

In this session we’ll look at Container Fundamentals with Docker Common Container Scenarios Automation with Kubernetes

SessionID: 83957

CSV files and ETL- The Good, Bad, and Ugly

Back to calendar

Event Date: 28-07-2018 - Session time: 16:00:00 - Track: Application Database Development

Speaker: Eric Freeman

Title: CSV files and ETL- The Good, Bad, and Ugly

Abstract:

CSV files come in a variety of shapes and sizes. If you’ve been working with them for a while, you will know that not all CSV’s are the same. We will cover methods to perform ETL on CSV’s file utilizing T-SQL and PowerShell. The Good- The simple, easy to load structure. The Bad- It looks good in excel, but I’m having difficulty loading it. The Ugly- You want me to load what monthly? That file it too big and it’s structure changes too often.

SessionID: 84662

Lightning Talks!

Back to calendar

Event Date: 28-07-2018 - Session time: 16:00:00 - Track: Enterprise Database Administration Deployment

Speaker: Glenn Burnett

Title: Lightning Talks!

Abstract:

Join Glenn Burnett, Dan Hess, Saru Radhakrishnan and Alex Purice for four 15-minute presentations!

  1. Glenn Burnett: SQL Server Audit Quick-Start!

  2. Dan Hess: A good look at SQL Operations Studio: How to manage SQL Server across multiple platforms (Windows, macOS and Linux).

  3. Saru Radhakrishnan: A quick overview of migrating on-prem SQL Server environments to the Microsoft Azure cloud platform. An easy-to-understand presentation of various approaches to guide the migration!

  4. Alex Purice: Temporal Tables Overview!