sqlsathistory

Nr: 611

Back to Main list

SQLSaturday #611 - Orange County 2017

Start Time (24h)	Speaker	Track	Title
08:30:00	Vazi Okhandiar	BI Analytics, Visualization Presentation	Building a PowerPivot BI Dashboard in an Hour
08:30:00	Alex Grinberg	Database Development	Efficient table design
08:30:00	Kevin Feasel	Database Development	Kafka For .NET Developers
08:30:00	Leonard Lobel	Database Development	Geospatial Data Types in SQL Server
08:30:00	Warren Sifre	Azure Cloud Services	Introduction to Azure Streaming Analytics
08:30:00	Peter Kral	Database Development	JSON and the Astronauts
08:30:00	Rick Lowe	Database Administration	Why should I care about ... the plan cache?
09:45:00	Alex Grinberg	Database Administration	CONVERT_IMPLICIT is a hidden danger
09:45:00	Kevin Feasel	Database Development	APPLY Yourself
09:45:00	Leonard Lobel	Azure Cloud Services	No Schema, No Problem! – Introduction to Azure DocumentDB
09:45:00	Simon Cho	BI Architecture, Development Management	Build ETL efficiently (10x) with Minimal Logging
09:45:00	Chris Hyde	BI Analytics, Visualization Presentation	SQL Server R Services in SQL 2016
09:45:00	Ted Stathakis	BI Architecture, Development Management	Reporting Services 2016: New Features Smart Migration Strategy
09:45:00	Rick Lowe	Database Development	Weird Stuff I Saw While ... Working With Heaps
11:00:00	Simon Cho	Database Development	Myths and Truths about SQL Server Transaction
11:00:00	Jonathan Stewart	BI Analytics, Visualization Presentation	Data Visualization: How to truly tell a great story!
11:00:00	Armando Lacerda	Database Administration	Unleashing Stretched Databases
11:00:00	Lori Edwards	Database Administration	DBA 101 – Let’s Get Started
11:00:00	Vern Rabe	Database Development	Ouch! Our Data Type Usage did THAT?!
11:00:00	Kate Grass	BI Architecture, Development Management	Let’s Get Meta: an Overview of ETL Frameworks using Biml
11:00:00	Ike Ellis	Azure Cloud Services	Take a Dive into Azure Data Lake
12:30:00	Mickey Stuewe	Database Development	Redgate Source Control
12:30:00	Ted Stathakis	Professional Development	Pyramid Technology Solutions - Resume Writing Interview Skills
12:30:00	Ted Stathakis	Professional Development	Ledgent Technology - Resume Interview Tips
12:30:00	Harriet Farmer	Professional Development	Pyramid Technology Solutions - Resume Writing Interview Skills
12:30:00	Ted Stathakis	Database Administration	Dell/EMC
13:30:00	Prakash Heda	Database Administration	Consolidated Essential Performance Health Check using PowerShell
13:30:00	Armando Lacerda	Database Administration	Why are you still taking backups?
13:30:00	Amy Herold	Professional Development	Making the Leap from Developer to DBA
13:30:00	Paul Turley	BI Architecture, Development Management	Power BI for the Enterprise
13:30:00	Phil Robinson	BI Analytics, Visualization Presentation	Data Wrangling for Reporting Analytics
13:30:00	Deji Akomolafe	Database Administration	Successfully Virtualizing SQL Server on vSphere
13:30:00	Chris Hyde	BI Analytics, Visualization Presentation	Row Based Security in SSRS and SSAS
14:45:00	Jeff Prom	BI Architecture, Development Management	Mastering Master Data Services
14:45:00	David McCarter	Professional Development	Rock Your Technical Interview (Part 1)
14:45:00	Lori Edwards	Database Administration	SQL Server Statistics – What Are The Chances?
14:45:00	Jonathan Stewart	BI Analytics, Visualization Presentation	From problem to Power BI: A journey in data visualization
14:45:00	Susan Wong	Database Administration	Zero Impact Data Migration – Oracle to SQL Server
14:45:00	Mickey Stuewe	Database Development	Changing Your Habits to Improve the Performance of Your T-SQL
14:45:00	Prakash Heda	Database Administration	Re-Indexing - The quest of ultimate automation
16:00:00	Jeff Prom	Database Development	SQL Injections and How to Stop Them
16:00:00	David McCarter	Professional Development	Rock Your Technical Interview (Part 2)
16:00:00	Warren Sifre	Database Administration	DBA Monitoring and Maintenance Fundamentals
16:00:00	Amy Herold	Database Administration	Deadlock, Block Two Smoking Barrels: Breaking Down Blocking and Deadlocks
16:00:00	Peter Kral	BI Architecture, Development Management	SSIS Project Deployment: The T-SQL Way
16:00:00	Thomas Hull	Database Administration	Backup and Recovery

SessionID: 57542

Building a PowerPivot BI Dashboard in an Hour

Back to calendar

Event Date: 01-04-2017 - Session time: 08:30:00 - Track: BI Analytics, Visualization Presentation

Speaker: Vazi Okhandiar

Title: Building a PowerPivot BI Dashboard in an Hour

Abstract:

Demonstrate the steps to import raw data from text file, Access database and Excel file into Excel 2013/2016, and then build a BI dashboard using PowerPivot, Power Map and Power BI.

SessionID: 57546

Efficient table design

Back to calendar

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

Speaker: Alex Grinberg

Title: Efficient table design

Abstract:

The importance of proper table design cannot be underestimated. Misconceptions could lead into serious problems not only in terms of database performance, but also it can effect disk space management and interactivity of user interface as well. In this session the audience will have a sensible walk-through of database and table design in detail, encompassing a number of key areas of focus ranging from Data Types to FILESTREAM implementation. Discuss most common a table design mistakes. Find out efficiency of one type over another, IDENTITY vs. SEQUENCE vs. GUID to support PK uniqueness, pros and cons of using composite Primary Key and SPARSE column, and more.

SessionID: 57556

Kafka For .NET Developers

Back to calendar

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

Speaker: Kevin Feasel

Title: Kafka For .NET Developers

Abstract:

Apache Kafka is a distributed publish-subscribe messaging system which can scale out to handle millions of messages per second. In this talk, we will cover the basics of this powerful system, including general architectural and design principles. We will also build a .NET project which uses Kafka to produce and consume messages quickly and efficiently.

SessionID: 57598

Geospatial Data Types in SQL Server

Back to calendar

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

Speaker: Leonard Lobel

Title: Geospatial Data Types in SQL Server

Abstract:

The geospatial capabilities in SQL Server are not only powerful, but easy and fun to use! In this session, Lenni shows you how to integrate location-awareness into your own applications with the geometry and geography data types. We’ll explore the planar and geodetic spatial models, spatial markup languages such as WKT and GML, and then put these concepts to use as we build several useful demos, (e.g., Bing Maps integration). Demos show how to use the geospatial methods to easily calculate area, length, and distance, and project new shapes based on intersection and overlap. Attend this session and embrace spatial programming today!

SessionID: 57748

Introduction to Azure Streaming Analytics

Back to calendar

Event Date: 01-04-2017 - Session time: 08:30:00 - Track: Azure Cloud Services

Speaker: Warren Sifre

Title: Introduction to Azure Streaming Analytics

Abstract:

This session will cover what is Streaming Analytics and the various use cases. We will demonstrate the creation of a Streaming Analytics process which will output the data to a dashboard for review. The intention is to provide insights in how this technology can potentially be leveraged by the SQL community.

SessionID: 61363

JSON and the Astronauts

Back to calendar

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

Speaker: Peter Kral

Title: JSON and the Astronauts

Abstract:

In one small step, SQL Server 2016 has taken a giant leap...to JSON! In this session, we'll launch a probe into a JSON data file containing profiles of NASA astronauts using new JSON T-SQL functions in SQL Server. With each astronaut we meet, we'll learn to validate, read, and manipulate "unstructured" JSON data. We'll get The Right Stuff to start developing, no previous JSON experience required. Let's go where NoSQL has gone before!

Prerequisites: You should have experience writing queries in T-SQL. No previous knowledge of JSON is needed.

Goals: Learn about JSON, and its basic data types Discover how SQL Server 2016 can handle JSON data Be amazed at the cool people NASA sends into space!

SessionID: 61580

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

Back to calendar

Event Date: 01-04-2017 - Session time: 08:30:00 - Track: Database Administration

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

CONVERT_IMPLICIT is a hidden danger

Back to calendar

Event Date: 01-04-2017 - Session time: 09:45:00 - Track: Database Administration

Speaker: Alex Grinberg

Title: CONVERT_IMPLICIT is a hidden danger

Abstract:

Abstract: The CONVERT_IMPLICIT operator is part of an execution plan. When an execution plan has a CONVERT_IMPLICIT operator, this is a signal that “your statement has a problem”. This presentation will show you how to detect the Execution Plans with CONVERT_IMPLICIT operator; how to find the statement that causes conversion, and what DMVs can help to solve the problem. It will also show you the solution to collect the Execution Plans with CONVERT_IMPLICIT operator across the servers.

SessionID: 57554

APPLY Yourself

Back to calendar

Event Date: 01-04-2017 - Session time: 09:45:00 - Track: 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: 57596

No Schema, No Problem! – Introduction to Azure DocumentDB

Back to calendar

Event Date: 01-04-2017 - Session time: 09:45:00 - Track: Azure Cloud Services

Speaker: Leonard Lobel

Title: No Schema, No Problem! – Introduction to Azure DocumentDB

Abstract:

This session presents an overview of Azure DocumentDB, Microsoft's massively-scalable, fully managed NoSQL database platform designed specifically for modern web and mobile applications. Like other NoSQL platforms, DocumentDB supports a schema-free data model and scales easily. But it also offers several unique features that make it a compelling candidate for NoSQL scenarios.

We begin by explaining NoSQL and document databases, and how they compare with traditional relational database platforms. Then we tour the many features of DocumentDB, including rich querying with SQL (that’s right, you query this NoSQL database using SQL!), and client development using the REST API and the DocumentDB SDKs. Next, learn about the server-side programming model and write fully transactional stored procedures, triggers, and user-defined functions. Also explore tunable consistency, scale-out partitioning, custom indexing, attachments, and more. Attend this session, and get up to speed on DocumentDB to

SessionID: 57664

Build ETL efficiently (10x) with Minimal Logging

Back to calendar

Event Date: 01-04-2017 - Session time: 09:45:00 - Track: BI Architecture, Development Management

Speaker: Simon Cho

Title: Build ETL efficiently (10x) with Minimal Logging

Abstract:

This session is designed to teach DBAs and developers the best strategy to transfer large data.

We will first analyze how data gets accessed from the source and how data gets updated or inserted to the target server: index access patterns in read operation and minimal logging in wring operation. I will introduce TF610 and cover its benefit for minimal logging even in full recovery mode.

SessionID: 59376

SQL Server R Services in SQL 2016

Back to calendar

Event Date: 01-04-2017 - Session time: 09:45:00 - Track: BI Analytics, Visualization Presentation

Speaker: Chris Hyde

Title: SQL Server R Services in SQL 2016

Abstract:

One of the most exciting new features of SQL Server 2016 is the integration of the R statistical programming language into the platform with the brand-new SQL Server R Services. In this introductory session we'll briefly introduce the R language and then look at how to install and administer SQL Server R Services. We'll start to demonstrate the power of R by showing you how to create and run simple R 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 R to integrate data analytical methods in real-world situations, and wow your customers with the power of statistics!

SessionID: 59909

Reporting Services 2016: New Features Smart Migration Strategy

Back to calendar

Event Date: 01-04-2017 - Session time: 09:45:00 - Track: BI Architecture, Development Management

Speaker: Ted Stathakis

Title: Reporting Services 2016: New Features Smart Migration Strategy

Abstract:

With the release of SQL Server 2016, Reporting Services is finally getting some love! In this session you will get a brief peek at some of the new features and functionality including a look at the new Report Manager interface and the new control we have over the parameter placement on screen.

We will then dive into how to use a custom report, based on the ReportServer database transaction log table, to see which reports are actually being used and use that report to determine a smart strategy for which reports to migrate to a new 2016 installation. You will see how to combine this understanding of active reports with the power of linked reports to simplify your Reporting Services implementation as you convert to SQL Server 2016.

The session will conclude with a look at my “Ultimate Footer”, which you can use on any version of Reporting Services, that shows report utilization, performance details, stored procedures and data sets used and discover any inline TSQL being abused.

SessionID: 61582

Weird Stuff I Saw While ... Working With Heaps

Back to calendar

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

Speaker: Rick Lowe

Title: Weird Stuff I Saw While ... Working With Heaps

Abstract:

We've all been told at some point that heaps are usually bad for select, update, and delete performance. But how bad are they really? Can they also be problematic for inserts? Are they ever a good idea? For this installment of Rick's "Weird Stuff" series we will take a closer look at why heaps can cause issues and maybe see a deadlock or two.

SessionID: 57665

Myths and Truths about SQL Server Transaction

Back to calendar

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

Speaker: Simon Cho

Title: Myths and Truths about SQL Server Transaction

Abstract:

This session is well suited for DBAs and Developers who are constantly exposed to production environment because the session covers the common issues many neglect without recognizing.

We demonstrate examples of incorrect development methodologies and analyze internal transaction logs in multi-transaction cases. After identifying the common mistakes, we will cover the best practice to avoid nested transactions in a stored procedure for smart error handling. We will also learn the basics of minimally logged operations.

SessionID: 57673

Data Visualization: How to truly tell a great story!

Back to calendar

Event Date: 01-04-2017 - Session time: 11:00:00 - Track: BI Analytics, Visualization Presentation

Speaker: Jonathan Stewart

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

Abstract:

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

SessionID: 59411

Unleashing Stretched Databases

Back to calendar

Event Date: 01-04-2017 - Session time: 11:00:00 - Track: Database Administration

Speaker: Armando Lacerda

Title: Unleashing Stretched Databases

Abstract:

This is a deep dive session full of demos about SQL 2016 stretched databases feature. It will go from pre-reqs and blocking factor through deployment and disaster recovery. Everything you need to know and when to use this new cloud-based exciting capability.

SessionID: 59739

DBA 101 – Let’s Get Started

Back to calendar

Event Date: 01-04-2017 - Session time: 11:00:00 - Track: Database Administration

Speaker: Lori Edwards

Title: DBA 101 – Let’s Get Started

Abstract:

Administering SQL Server environments can seem like a daunting task for any DBA. In this session, we’ll provide some guidelines and tips to help new DBAs get started on the right foot. Backups/restores, integrity checks, index maintenance, documentation, security and alerting will be some of the topics covered in this session. We’ll also be covering some of the online resources that are available. Bring your questions!

SessionID: 59790

Ouch! Our Data Type Usage did THAT?!

Back to calendar

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

Speaker: Vern Rabe

Title: Ouch! Our Data Type Usage did THAT?!

Abstract:

It’s an all too common occurrence to have table columns or variables that have been assigned less than ideal data types. Join this session and learn the importance of choosing the proper data type, the guidelines in determining what an appropriate data type would be, and, once chosen, some tools for its usage and management. There will be several demonstrations on performance and accuracy issues, along with their possible solutions, caused by either the assignment of inappropriate data types or improper usage of them.

In addition, we will cover several data type related functions, and the caveats in their usage.

SessionID: 61166

Let’s Get Meta: an Overview of ETL Frameworks using Biml

Back to calendar

Event Date: 01-04-2017 - Session time: 11:00:00 - Track: BI Architecture, Development Management

Speaker: Kate Grass

Title: Let’s Get Meta: an Overview of ETL Frameworks using Biml

Abstract:

Do you have SSIS projects that have grown unwieldy, become difficult to troubleshoot or suffer from performance issues? Or maybe you’re getting ready to start a new ETL project and want to learn more about how you can gain efficiency while adding value to your solution?

In this session we’ll discuss the concept of an ETL framework and the potential elements that can be incorporated within one. We will look at the advantages of implementing a framework based on metadata and look at some database design options for storing that metadata.

To start you off on your framework building journey, we’ll introduce Biml and BimlScript and provide some simple code demos to showcase how Biml can be used to help automate your SSIS package generation. This session will be geared for those with a beginner to intermediate knowledge of SSIS and SQL. While we won’t be teaching Biml in great detail, you’ll get an overview of the technology and pointers on where to learn more.

SessionID: 62466

Take a Dive into Azure Data Lake

Back to calendar

Event Date: 01-04-2017 - Session time: 11:00:00 - Track: Azure Cloud Services

Speaker: Ike Ellis

Title: Take a Dive into Azure Data Lake

Abstract:

In this session, we'll show the power of this Azure MPP solution. T-SQL is a great data language that makes parallelism easy. C# is a fantastic statically typed language that taps into the power of the .NET framework, but parallelism has a big barrier to entry. Learn how U-SQL combines the best of both worlds to clean and analyze data at incredible levels. Azure Data Lake Analytics makes Hadoop affordable and easy by leveraging your existing knowledge of T-SQL and C#.

SessionID: 62474

Redgate Source Control

Back to calendar

Event Date: 01-04-2017 - Session time: 12:30:00 - Track: Database Development

Speaker: Mickey Stuewe

Title: Redgate Source Control

Abstract:

It has been a long established practice to keep maintain application code in version control. Versioning your application code allows you to view changes made by several developers working on the same project. It allows the team to get the latest changes in a consistent and reliable manner. It allows you to return your code to a prior state. It even acts as a safety net for when that day comes when your developer’s computer won’t turn on.

So, what about your SQL Objects?

Join me in this demo heavy session where we will explore the benefits of versioning your SQL Objects and learn how it can enable streamlined database development without sacrificing control and visibility. We’ll be using Red Gate’s SQL Source Control tool for demos, and we’ll see how it integrates with your existing version control software to manage your SQL Objects just like application code.

SessionID: 63565

Pyramid Technology Solutions - Resume Writing Interview Skills

Back to calendar

Event Date: 01-04-2017 - Session time: 12:30:00 - Track: Professional Development

Speaker: Ted Stathakis

Title: Pyramid Technology Solutions - Resume Writing Interview Skills

Abstract:

Your career is like a game of chess. It requires using multiple skills, simultaneously, while continually improving in all areas. All with one goal—to ‘win’ the current challenge and move on to the next milestone.

This Session will look at where you are in your Career Path and focus on three key areas that keep you moving toward the next milestone. Bring your resume with you (thumb drive or hard copy) for review and edit.

SessionID: 63566

Ledgent Technology - Resume Interview Tips

Back to calendar

Event Date: 01-04-2017 - Session time: 12:30:00 - Track: Professional Development

Speaker: Ted Stathakis

Title: Ledgent Technology - Resume Interview Tips

Abstract:

You need to nail the interview to get the job but you can't get the interview if you don't nail the resume. This session starts with key points to get your resume into the "Yes" stack, covers interview tips and concludes with appropriate follow-up actions items. Bring you own resume for some professional feedback on how it stacks up and get your resume into the "Yes" stack!

SessionID: 63661

Pyramid Technology Solutions - Resume Writing Interview Skills

Back to calendar

Event Date: 01-04-2017 - Session time: 12:30:00 - Track: Professional Development

Speaker: Harriet Farmer

Title: Pyramid Technology Solutions - Resume Writing Interview Skills

Abstract:

Your career is like a game of chess. It requires using multiple skills, simultaneously, while continually improving in all areas. All with one goal—to ‘win’ the current challenge and move on to the next milestone.

This Session will look at where you are in your Career Path and focus on three key areas that keep you moving toward the next milestone. Bring your resume with you (thumb drive or hard copy) for review and edit.

SessionID: 63799

Dell/EMC

Back to calendar

Event Date: 01-04-2017 - Session time: 12:30:00 - Track: Database Administration

Speaker: Ted Stathakis

Title: Dell/EMC

Abstract:

Grab your box lunch and come hear all about Dell and EMC's solutions.

SessionID: 57552

Consolidated Essential Performance Health Check using PowerShell

Back to calendar

Event Date: 01-04-2017 - Session time: 13:30:00 - Track: Database Administration

Speaker: Prakash Heda

Title: Consolidated Essential Performance Health Check using PowerShell

Abstract:

Standardizing essential performance health check is the key in responding quickly to production issues and can cut down initial evaluation phase to 1/3rd of the time, whether you have been requested to do health check or you may want to run these due to an alert. These sets of essential checks can be the first major checkpoint for a DBA, they can look quickly on consolidated email stats first to decide if any further action is required to fix an issue or is it feasible to jump into in-depth troubleshooting. This will cut down on time and effort while responding to Production issues.

First part of the email shares some key observations about SQL Server performance which can be the key to quick resolution of the issue. Rest of the email shows different set of stats regarding CPU/Disk IO/Disk Space/Memory/Network/Blocking and database performance which could lead to the slowness observed in the application. This consolidated email can be shared with technical stakeholders to give a snaps

SessionID: 59410

Why are you still taking backups?

Back to calendar

Event Date: 01-04-2017 - Session time: 13:30:00 - Track: Database Administration

Speaker: Armando Lacerda

Title: Why are you still taking backups?

Abstract:

Keep doing things the same way because they have always worked in the past is a very comfortable mistake we all make in many areas. That includes backup strategies and service account administration. In this one hour presentation full of demos I will explore many options available in SQL Server 2016 and Azure that can potentially reduce the amount of data and time required for backups and even eliminate the need all together. It sounds scary but it will be really fun.

SessionID: 59517

Making the Leap from Developer to DBA

Back to calendar

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

Speaker: Amy Herold

Title: Making the Leap from Developer to DBA

Abstract:

You are a Developer (.NET, SQL or otherwise) but you have been doing some DBA work and have now decided that is all you want to do - how do you make the transition? What do you need to know? This session will cover this topic from first-hand experience.

SessionID: 59778

Power BI for the Enterprise

Back to calendar

Event Date: 01-04-2017 - Session time: 13:30:00 - Track: BI Architecture, Development Management

Speaker: Paul Turley

Title: Power BI for the Enterprise

Abstract:

Sure, Power BI is a terrific self-service data analysis tool but it's also an enterprise-class reporting and dashboard tool for serious business data. Learn how to build serious business solutions with on-premises data sources; SQL Server, Analysis Services and other business systems. You'll also see how you can architect solutions with security and user access control utilizing groups and content packs.

SessionID: 61109

Data Wrangling for Reporting Analytics

Back to calendar

Event Date: 01-04-2017 - Session time: 13:30:00 - Track: BI Analytics, Visualization Presentation

Speaker: Phil Robinson

Title: Data Wrangling for Reporting Analytics

Abstract:

This session will review common challenges encountered when preparing new data sets for use in analytics and reporting. We will look at tools for exploring and modifying large CSV/TXT files and discuss design patterns for cleaning and repair.

SessionID: 63580

Successfully Virtualizing SQL Server on vSphere

Back to calendar

Event Date: 01-04-2017 - Session time: 13:30:00 - Track: Database Administration

Speaker: Deji Akomolafe

Title: Successfully Virtualizing SQL Server on vSphere

Abstract:

Over the years, virtualization has matured from the exotic black magic realm to become a mainstream standard IT practice. "Virtualize First"; is now a well-accepted default practice in most enterprises and any deviation is now considered an anomaly. In spite of this trend, many IT administrators and architects still have some reservations about virtualizing SQL Server workloads. They consider SQL too "critical" to be virtualized; they wonder and worry about scale about performance; they are looking for guidance and reassurance. If this is where you (or your clients) are today, be sure to attend this session. You will gain valuable insights from what others have done to successfully undertake similar tasks in their environments. We will talk about configuration pitfalls to avoid and also review the configuration and current performance data for some of the most demanding applications in customers environments. Got an SQL virtualization or performance question? Bring it!

SessionID: 63907

Row Based Security in SSRS and SSAS

Back to calendar

Event Date: 01-04-2017 - Session time: 13:30:00 - Track: BI Analytics, Visualization Presentation

Speaker: Chris Hyde

Title: Row Based Security in SSRS and SSAS

Abstract:

It is relatively straight-forward to grant a user access to a particular SSRS report, multi-dimensional cube, or tabular model table, but what happens when the user needs access to the object but should be denied access to view certain rows of data? In this session we'll investigate a real-world solution to this common BI problem.

SessionID: 57682

Mastering Master Data Services

Back to calendar

Event Date: 01-04-2017 - Session time: 14:45:00 - Track: BI Architecture, Development Management

Speaker: Jeff Prom

Title: Mastering Master Data Services

Abstract:

As your organization grows, one challenge will be the management of data between systems and organizational units. With MDS, Microsoft provides the ability to have one accurate source of non-transactional data. This data can then be used within applications, other databases, and ETL processes. By leveraging data stewards to help manage the data repository, you can ensure that your MDS data is always up-to-date and accurate.

In this presentation we will cover MDS from start to finish including installation, creating models/entities, working with data, using the Excel add-in, security, hierarchies, views, versions, and business rules. After this presentation, you will have a good understanding of what master data management is, what MDS does, how to use it, and how to get started with your own MDS project.

SessionID: 57685

Rock Your Technical Interview (Part 1)

Back to calendar

Event Date: 01-04-2017 - Session time: 14:45:00 - Track: Professional Development

Speaker: David McCarter

Title: Rock Your Technical Interview (Part 1)

Abstract:

Have you ever not gotten a job because you weren’t prepared for the interview? Would you like a big raise? Do you need motivation to rock your career? I’ve interviewed 100’s of software developers and will share my knowledge on how to survive, what we look for and even divulge some of the secrets we use during the process. Whether you are looking for a new position within your company or at a new company you need to attend this session. Included are crazy and strange interview stories from engineers just like you! Learn tips to get you started, working with recruiters, getting prepared, the technical interview and more. You will also learn what is the #1 question you need to ask during an interview… it’s a game changer! Make sure you attend part 2!

SessionID: 59740

SQL Server Statistics – What Are The Chances?

Back to calendar

Event Date: 01-04-2017 - Session time: 14:45:00 - Track: Database Administration

Speaker: Lori Edwards

Title: SQL Server Statistics – What Are The Chances?

Abstract:

For far too long, I thought that statistics only contained information on table row counts. While they do contain that information, there is more to it than that. In this beginner session, we’ll go over statistics – how they are created, the different types of statistics that exist, how they’re maintained and how the Query Optimizer uses them. We will also touch on system tables and DMVs that will provide additional information on your statistics. We'll also go over the cardinality estimator changes in 2014 2016. At the end of this session, you should have a better idea of how the query optimizer within SQL Server makes decisions on how to gather data.

SessionID: 61006

From problem to Power BI: A journey in data visualization

Back to calendar

Event Date: 01-04-2017 - Session time: 14:45:00 - Track: BI Analytics, Visualization Presentation

Speaker: Jonathan Stewart

Title: From problem to Power BI: A journey in data visualization

Abstract:

Power BI is all the rage right now in visualizing data on the Microsoft BI stack. We've seen multiple how tos and presentations on the features, but in this hour, we will actually go through the journey of a specific problem, research it, storyboard it, work through how we solve it (before we ever open Power BI) and then build the Power BI visualization. Make your visualization count. Come join us on the journey.

SessionID: 61076

Zero Impact Data Migration – Oracle to SQL Server

Back to calendar

Event Date: 01-04-2017 - Session time: 14:45:00 - Track: Database Administration

Speaker: Susan Wong

Title: Zero Impact Data Migration – Oracle to SQL Server

Abstract:

Do you have a mission to move from Oracle to SQL Server but downtime is not acceptable?

If the requirements for a migration project are - • Continued user access to Oracle during the migration • No performance impact to the production Oracle database • Fault tolerance – no loss of transactions should the network or servers or databases go down

Learn how SharePlex can accomplish all of this with a quick and easy install, at half the cost of Oracle replication, and visibility into the replication stream. Also, learn about other business use cases where SharePlex replicating from Oracle to SQL Server can meet your ROI, and service level agreements, including real time reporting, data consolidation and distribution, and more.

SessionID: 61436

Changing Your Habits to Improve the Performance of Your T-SQL

Back to calendar

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

Speaker: Mickey Stuewe

Title: Changing Your Habits to Improve the Performance of Your T-SQL

Abstract:

Do you dread handing your T-SQL over for code review? Do your queries run slower than you expect? Does the DBA always want to tweak your T-SQL? In this demo-heavy session, we’ll take a look at various ways to improve your T-SQL. You’ll learn why top down design is not always the best pattern as well as why implicit conversions can slow down your queries. You’ll learn how to rewrite most cursors as well as finding out how user defined functions affect performance. You’ll learn some simple ways to troubleshoot these types of issues using execution plans and extended events. Finally, we’ll take a look at how standards can help quicken turnaround time when refactoring T-SQL. By changing some of your T-SQL writing habits you can improve performance of queries from the very beginning.

SessionID: 63923

Re-Indexing - The quest of ultimate automation

Back to calendar

Event Date: 01-04-2017 - Session time: 14:45:00 - Track: Database Administration

Speaker: Prakash Heda

Title: Re-Indexing - The quest of ultimate automation

Abstract:

How many times you have been called on weekends to handle a nightmare caused by Re-Indexing job? One of the most common aspect of performance tuning is a well-design dynamic index optimization process. If you ever wonder what it takes to design an efficient re-indexing process, which do selective re-indexing, handles blocking efficiently, avoid system downtime due to log disk full, automatically stop itself beyond a threshold, can be implemented across all sql servers regardless of application type or data size, in other words, fewer headaches. This session is for you!!

In this session, Prakash will walk you through design considerations, accompanied with a script demo using PowerShell to generate a dynamic re-indexing script , created based on his real-life experience from managing high performing database systems.

SessionID: 57683

SQL Injections and How to Stop Them

Back to calendar

Event Date: 01-04-2017 - Session time: 16:00:00 - Track: Database Development

Speaker: Jeff Prom

Title: SQL Injections and How to Stop Them

Abstract:

Right now, there are hackers all around the world trying to get into your web applications. How safe are you? By using a technique called SQL injections, hackers can wreak havoc on web applications by compromising security, manipulating data, choking system resources, retrieving sensitive information, and modifying database objects. Without proper precautions, attackers can even drop databases!

During the demo, we will take on a couple of different roles. As a hacker, we will walk through steps a hacker might take to compromise a web application in order to retrieve sensitive data such as credit card information, usernames, passwords, and social security numbers. Assuming the role of a developer, we will then show various prevention techniques and their effectiveness in preventing SQL injections.

Attend this session to learn how SQL injections work, identify if you are being attacked, and how to stop them!

SessionID: 57686

Rock Your Technical Interview (Part 2)

Back to calendar

Event Date: 01-04-2017 - Session time: 16:00:00 - Track: Professional Development

Speaker: David McCarter

Title: Rock Your Technical Interview (Part 2)

Abstract:

Have you ever not gotten a job because you weren’t prepared for the interview? Would you like a big raise? Do you need motivation to rock your career? I’ve interviewed 100’s of software developers and will share my knowledge on how to survive, what we look for and even divulge some of the secrets we use during the process. Whether you are looking for a new position within your company or at a new company you need to attend this session. Included are crazy and strange interview stories from engineers just like you! Learn tips to get you started, working with recruiters, getting prepared, the technical interview and more. You will also learn what is the #1 question you need to ask during an interview… it’s a game changer! Make sure you attend part 1!

SessionID: 57747

DBA Monitoring and Maintenance Fundamentals

Back to calendar

Event Date: 01-04-2017 - Session time: 16:00:00 - Track: Database Administration

Speaker: Warren Sifre

Title: DBA Monitoring and Maintenance Fundamentals

Abstract:

The key to becoming a great DBA is time. The best way to regain some time is by spending less time doing the daily mundane work. Let this mundane effort work autonomously. We will introduce the basics in monitoring and maintenance. The how and why certain things should be done at a minimum and what things can be done to help improve the quality of life in larger dynamic environments.

SessionID: 59514

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

Back to calendar

Event Date: 01-04-2017 - Session time: 16:00:00 - Track: Database Administration

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

SSIS Project Deployment: The T-SQL Way

Back to calendar

Event Date: 01-04-2017 - Session time: 16:00:00 - Track: BI Architecture, Development Management

Speaker: Peter Kral

Title: SSIS Project Deployment: The T-SQL Way

Abstract:

Do you deploy SQL Server Integration Services (SSIS) Projects using the Integration Services Deployment Wizard? If you're looking for a repeatable deployment method that can be source controlled, there's another way...the T-SQL way! In this session, you will see a demonstration of T-SQL script deployment of SSIS projects, using stored procedures in the SSISDB database. You'll learn how to query the SSIS catalog to find your project configurations so they can be captured and source controlled. Take control of your SSIS deployments...the T-SQL way!

Prerequisites: You should have previous experience with SQL Server Integration Services (SSIS) package deployment and/or development.

Goals: Learn about the SSISDB database and catalog objects See how to use T-SQL to deploy SSIS projects and packages Discover the new features of SSIS delivered with SQL Server 2016

SessionID: 61584

Backup and Recovery

Back to calendar

Event Date: 01-04-2017 - Session time: 16:00:00 - Track: Database Administration

Speaker: Thomas Hull

Title: Backup and Recovery

Abstract:

"Backup and Recovery" is the most basic fundamental responsibility of any DBA, and your mastery (or lack thereof) of this topic can make you a hero or get you fired. Beginner level folks will benefit from this talk because we'll cover the basics, but I think even more experienced DBA's might learn a few tricks.

Outline:

• Review the fundamentals (recovery models, backup types, etc) with use cases
• Give practical examples w/ syntax
• Do performance tuning on backups
• Recommend best practices and strategies

This site is open source. Improve this page.