sqlpasshistory

ID: 462

Back to Main list

24 Hours of PASS: Growing Our Community

Session Date/Time (dd-MM-YYYY 24h)	Speaker	Category	Track	Title
24-06-2015 12:00	Edward Pollack	24 Hours of PASS (60 minutes)	Application & Database Development	Database Design: Solving Problems Before they Start!
24-06-2015 13:00	Michael Bourgon	24 Hours of PASS (60 minutes)	Enterprise Database Administration & Deployment	Overlord - tracking changes, real-time, in your environment
24-06-2015 14:00	Amy Herold	24 Hours of PASS (60 minutes)	Professional Development	Making the Leap from Developer to DBA
24-06-2015 15:00	Ed Leighton-Dick	24 Hours of PASS (60 minutes)	Application & Database Development	Protecting Your Data with Encryption
24-06-2015 16:00	Konstantin Melamud	24 Hours of PASS (60 minutes)	BI Platform Architecture, Development & Administration	Optimizing your data warehouse for OLAP Processing
24-06-2015 17:00	David Maxwell	24 Hours of PASS (60 minutes)	Enterprise Database Administration & Deployment	Turbo-Charged Transaction Logs
24-06-2015 18:00	Steve Wake	24 Hours of PASS (60 minutes)	BI Information Delivery	Introduction to the Power BI Designer
24-06-2015 19:00	Paul Ou Yang	24 Hours of PASS (60 minutes)	Enterprise Database Administration & Deployment	Trend Analysis of SQL Error Logs: Seeing Beyond the Error
24-06-2015 20:00	Jeff Renz	24 Hours of PASS (60 minutes)	Application & Database Development	Introduction to Microsoft Azure DocumentDB
24-06-2015 21:00	Ginger Grant	24 Hours of PASS (60 minutes)	BI Platform Architecture, Development & Administration	Improving Data Analytics with Azure Machine Learning
24-06-2015 22:00	Andy Yun	24 Hours of PASS (60 minutes)	Application & Database Development	Every Byte Counts: Why Your Data Type Choices Matter
24-06-2015 23:00	Chris Schmidt	24 Hours of PASS (60 minutes)	BI Platform Architecture, Development & Administration	Rethink your ETL with BIML
25-06-2015 00:00	Tim Radney	24 Hours of PASS (60 minutes)	Enterprise Database Administration & Deployment	Common SQL Server Mistakes and How to Avoid Them
25-06-2015 01:00	Steve Stedman	24 Hours of PASS (60 minutes)	Application & Database Development	Common Table Expressions - Advanced
25-06-2015 02:00	Scott McCormick	24 Hours of PASS (60 minutes)	Cloud Application Development & Deployment	Azure IOT: A Practical Introduction to Stream Analytics
25-06-2015 03:00	Maxwell Myrick	24 Hours of PASS (60 minutes)	Enterprise Database Administration & Deployment	The Art and the Science of Designing a Mission Critical SQL Server Solution
25-06-2015 04:00	Alan Faulkner	24 Hours of PASS (60 minutes)	BI Platform Architecture, Development & Administration	SSAS Design and Performance Best Practices
25-06-2015 05:00	Brandon Leach	24 Hours of PASS (60 minutes)	Enterprise Database Administration & Deployment	Data Pages, Allocation Units, IAM chains... Oh My!
25-06-2015 06:00	Andrey Zavadskiy	24 Hours of PASS (60 minutes)	Application & Database Development	Offline Database Development and Unit Testing with SSDT
25-06-2015 07:00	Lance Tidwell	24 Hours of PASS (60 minutes)	Enterprise Database Administration & Deployment	SQL Server Agent: The life preserver for the drowning DBA
25-06-2015 08:00	Tomaž Kaštrun	24 Hours of PASS (60 minutes)	BI Information Delivery	Understanding and Visualizing Data Using R in SQL Server
25-06-2015 09:00	Murilo Miranda	24 Hours of PASS (60 minutes)	Enterprise Database Administration & Deployment	Curious Cases of Availability Groups
25-06-2015 10:00	Cathrine Wilhelmsen	24 Hours of PASS (60 minutes)	BI Platform Architecture, Development & Administration	Don't Repeat Yourself - An Introduction to Agile SSIS Development
25-06-2015 11:00	Matan Yungman	24 Hours of PASS (60 minutes)	Enterprise Database Administration & Deployment	The Data Loading Performance Presentation

SessionID: 28349

Database Design: Solving Problems Before they Start!

Back to calendar

Event Date: 24-06-2015 12:00 - Category: 24 Hours of PASS (60 minutes) - Track: Application & Database Development

Speaker(s): Edward Pollack

Title: Database Design: Solving Problems Before they Start!

Description:

Explore the most important topics in database design and discuss examples of where design mistakes can lead to bad data, poor performance, and other headaches that your future self would love to avoid!

Choosing the right data types, normalization, and choosing the right column names can allow for easier database development, make planning for future changes simpler, and avoid the roadblocks often associated with poor design.

Using live demos, we will explore the potential disasters that can occur when poor design decisions are made. We'll then correct the mistakes and bask in the glory of beautiful design.

Database design is about anticipating the future needs of your organization and using that information to make smart decisions. Good decision-making here can reflect positively on everyone you work with, so show off your design skills and feel good about the TSQL you write!

SessionID: 8726

Overlord - tracking changes, real-time, in your environment

Back to calendar

Event Date: 24-06-2015 13:00 - Category: 24 Hours of PASS (60 minutes) - Track: Enterprise Database Administration & Deployment

Speaker(s): Michael Bourgon

Title: Overlord - tracking changes, real-time, in your environment

Description:

Don’t you LOVE it when changes are made to your databases without notice!? Those AWESOME “Object doesn't exist” messages, sudden performance problems, failed audits and other unexpected errors can be soooo much fun! Time to put an end to these unreported changes and get real-time notice as they occur, via emails, reports, or even Source Control. Learn to use Event Notifications, a native SQL Server feature, along with some production-ready code, to become the Overlord your users need.

SessionID: 28350

Making the Leap from Developer to DBA

Back to calendar

Event Date: 24-06-2015 14:00 - Category: 24 Hours of PASS (60 minutes) - Track: Professional Development

Speaker(s): Amy Herold

Title: Making the Leap from Developer to DBA

Description:

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

Protecting Your Data with Encryption

Back to calendar

Event Date: 24-06-2015 15:00 - Category: 24 Hours of PASS (60 minutes) - Track: Application & Database Development

Speaker(s): Ed Leighton-Dick

Title: Protecting Your Data with Encryption

Description:

We’ve all seen the recent news stories about companies whose data has been stolen by hackers. What was once a rare event has become all too common, and companies large and small are at risk. While it isn’t always possible to prevent intrusions, you can reduce the risk by encrypting your data. In this presentation, I’ll show you the four ways that SQL Server provides to encrypt data: hashes, cell-level encryption, database-level encryption (also known as transparent data encryption), and backup encryption. We’ll also discuss the keys required for each type of encryption and discuss how to protect the keys themselves.

SessionID: 35559

Optimizing your data warehouse for OLAP Processing

Back to calendar

Event Date: 24-06-2015 16:00 - Category: 24 Hours of PASS (60 minutes) - Track: BI Platform Architecture, Development & Administration

Speaker(s): Konstantin Melamud

Title: Optimizing your data warehouse for OLAP Processing

Description:

Analysis Services have become a major part of upper management daily decision making activities. However, with our DW sizes reaching multiple terabytes minimizing time required to process our data has become our top priority. In this session, we will cover the options we have as DBA’s to improve the performance of our DW processing time. We will look at features and general best practices available to us within SSAS as well as enterprise level features within the database engine itself and how aligning them to work side by side would yield us at least 200% improvement in our processing time.

SessionID: 8743

Turbo-Charged Transaction Logs

Back to calendar

Event Date: 24-06-2015 17:00 - Category: 24 Hours of PASS (60 minutes) - Track: Enterprise Database Administration & Deployment

Speaker(s): David Maxwell

Title: Turbo-Charged Transaction Logs

Description:

The transaction log is one of the most critical, yet often misunderstood components of SQL Server. From out of control log growth to very long start-up times, problems with the transaction log can cause a lot of pain. In this session, we'll look at how the transaction log works and how to optimize its performance. You'll learn how to determine the right settings for maximum throughput, and what to do when things get out of control.

SessionID: 35549

Introduction to the Power BI Designer

Back to calendar

Event Date: 24-06-2015 18:00 - Category: 24 Hours of PASS (60 minutes) - Track: BI Information Delivery

Speaker(s): Steve Wake

Title: Introduction to the Power BI Designer

Description:

Power BI Designer is a new standalone Business Intelligence tool that allows you to design and build Power BI reports outside of the web and Excel. While Power BI Designer is currently only in preview it shows where Microsoft is going with Power BI to try and make a more complete and well-rounded Business Intelligence solution. In this session we will go through what is currently offered in the latest version of Power BI Designer with live demos and what might be coming in the future. If you have been thinking about using Power BI in your environment, this session will give you a good overview of the tool that will allow you to make the dashboards/reports you have wanted in a fraction of the time.

SessionID: 35568

Trend Analysis of SQL Error Logs: Seeing Beyond the Error

Back to calendar

Event Date: 24-06-2015 19:00 - Category: 24 Hours of PASS (60 minutes) - Track: Enterprise Database Administration & Deployment

Speaker(s): Paul Ou Yang

Title: Trend Analysis of SQL Error Logs: Seeing Beyond the Error

Description:

You carefully search for errors in the logs daily and fix them as they come. Recently, you noticed some errors are reoccurring and wonder when they started and what you could do differently. However the logs have already recycled and the information is gone, so you are left with the inquiry and go on with the next task. In this session, you will learn how to automatically parse the errors from multiple SQL error logs using PowerShell, store the data in a central database, and create reports to visualize the information using SQL Server Reporting Services. Analyzing error trends will allow you to see solutions that will lead to greater process efficiency.

SessionID: 35580

Introduction to Microsoft Azure DocumentDB

Back to calendar

Event Date: 24-06-2015 20:00 - Category: 24 Hours of PASS (60 minutes) - Track: Application & Database Development

Speaker(s): Jeff Renz

Title: Introduction to Microsoft Azure DocumentDB

Description:

In this session I will demonstrate how to create a DocumentDB instance in Azure, how to work with JSON documents, create Ad hoc queries with familiar SQL syntax, create application logic as stored procedures, triggers and user defined functions (UDFs) using standard JavaScript.

Goals: #1 Show how to create validate JSON strings using Notepad++, validate the JSON against a schema using C# Newtonsoft dll. Demonstrate how to work with JSON in SQL Server as a reference on how hard it is to work with JSON when it is not natively stored. #2 Demo the basics of DocumentDB - Create the database, collections and documents using the web interface. Demo how to perform basic selects, joins and filtering. Review java script basics as java script is fundamental in creating stored procedures #3 Demo of how to work with DocumentDB in a C# by creating collections, documents and querying the database using lync and SQL syntax.

SessionID: 28356

Improving Data Analytics with Azure Machine Learning

Back to calendar

Event Date: 24-06-2015 21:00 - Category: 24 Hours of PASS (60 minutes) - Track: BI Platform Architecture, Development & Administration

Speaker(s): Ginger Grant

Title: Improving Data Analytics with Azure Machine Learning

Description:

Companies are looking for the existing data to provide answers for many questions and Azure Machine Learning [ML] can help provide them. Starting with data stored in a SQL Server database deployed in Azure, attendees will learn rules to classify the data for ML analysis. Building upon this information, I’ll show the best methods for determining which ML models to use as well as how to integrate custom analysis methods. The presentation will cover the ability to expand ML by including analysis components from other sources by incorporating existing modules from both custom R code and SQL scripts within the ML solution. Upon completion, the ML experiment will be deployed as part of a Data Factory pipeline, as it is the tool for distributing ML, and lastly added back to the Azure SQL server database. Join this session to learn more about the opportunities for data analysis using Azure ML, and see how the insights gained can be included in your current data distribution and visualizations.

SessionID: 8728

Every Byte Counts: Why Your Data Type Choices Matter

Back to calendar

Event Date: 24-06-2015 22:00 - Category: 24 Hours of PASS (60 minutes) - Track: Application & Database Development

Speaker(s): Andy Yun

Title: Every Byte Counts: Why Your Data Type Choices Matter

Description:

Ever encounter a table consisting only of BIGINT, CHAR(255), and NVARCHAR(MAX) columns? Did your gut tell you that this is bad, but you had difficulty explaining why? Did you know that these data type choices can be a real performance killer? Attend this session to learn how database records are stored within SQL Server, and why all data types are not created equal. Armed with that knowledge, we will then explore several performance scenarios that may be impacting your systems right now! When you leave, you will be able to explain to your colleagues why data type choices matter, assess your own systems, and implement some best practices to mitigate these performance killers.

SessionID: 35543

Rethink your ETL with BIML

Back to calendar

Event Date: 24-06-2015 23:00 - Category: 24 Hours of PASS (60 minutes) - Track: BI Platform Architecture, Development & Administration

Speaker(s): Chris Schmidt

Title: Rethink your ETL with BIML

Description:

It's estimated that 70% of data warehousing development is in the extract, transformation, and load processes between the different source systems and the analytical layer. Recently a new language has entered the market that promises to revolutionize the way we think about how data is moved around the enterprise. Gone are the days where we need to manually code every component and painstakingly ensure that every package adheres to corporate standards. In this session, I'll introduce you to the world of BIML and show you how to quickly create a template that will adhere all your packages to corporate standards. I'll then use metadata to quickly generate dozens of packages to populate your dimensional tables. Stop spending weeks developing SSIS packages that can be built in hours!

SessionID: 35577

Common SQL Server Mistakes and How to Avoid Them

Back to calendar

Event Date: 25-06-2015 00:00 - Category: 24 Hours of PASS (60 minutes) - Track: Enterprise Database Administration & Deployment

Speaker(s): Tim Radney

Title: Common SQL Server Mistakes and How to Avoid Them

Description:

Making mistakes is natural, but learning from them and avoiding them in future takes effort. There's no substitute for experience or the shared wisdom of others to help you learn what mistakes to avoid. In this session, Tim will share with you a ton of what he's learned over the years from working and consulting at multiple Fortune-level companies. You'll hear about real-world environments he has worked on where there was a high impact from administrators making mistakes in how SQL Server was configured and administered. You'll learn many proven and accepted best practices for installing, configuring and supporting SQL Server to help your environment run as smoothly as possible and you'll leave with a checklist of items to take home to make sure your SQL Server environment is configured properly.

SessionID: 35537

Common Table Expressions - Advanced

Back to calendar

Event Date: 25-06-2015 01:00 - Category: 24 Hours of PASS (60 minutes) - Track: Application & Database Development

Speaker(s): Steve Stedman

Title: Common Table Expressions - Advanced

Description:

You have been introduced to Common Table Expression, you understand the WITH syntax, but you want to know more. Learn how to recursive queries work with CTEs and how to display hierarchical data. Did you know that you can INSERT, UPDATE and DELETE data from CTEs. Some of the common use cases for CTEs will be covered including finding holes in patterns, finding and removing duplicate data, string parsing, and more. See how CTEs compare to SQL Server 2012 offset and fetch paging techniques. Get an in depth understanding of the performance behind a common table expression. Understand when the CTE is the right solution, and the wrong solution to use. Finally we will take a look at some classic recursive algorithms and how they can be implemented with CTEs. Take away several CTE samples that you can use to extend your TSQL query abilities.

SessionID: 8729

Azure IOT: A Practical Introduction to Stream Analytics

Back to calendar

Event Date: 25-06-2015 02:00 - Category: 24 Hours of PASS (60 minutes) - Track: Cloud Application Development & Deployment

Speaker(s): Scott McCormick

Title: Azure IOT: A Practical Introduction to Stream Analytics

Description:

Azure Stream Analytics is a integral piece of the new Internet of Things Suite offering from Microsoft. More and more devices are being connected to the cloud, and an intelligently written, real-time processing engine is required to capture this data and then analyze and present it as usable information to the business.

In this session, we will cover what Stream Analytics is, we will demonstrate multiple data streams being sent to an Azure system, how to process and analyze those data streams into a format that makes sense to a business, and how to send those streams on to another destination for further analysis.

Finally, we will cover how Stream Analytics ties into the overall IOT suite from Microsoft and how you can potentially plug it in as part of your company's data strategy

SessionID: 35579

The Art and the Science of Designing a Mission Critical SQL Server Solution

Back to calendar

Event Date: 25-06-2015 03:00 - Category: 24 Hours of PASS (60 minutes) - Track: Enterprise Database Administration & Deployment

Speaker(s): Maxwell Myrick

Title: The Art and the Science of Designing a Mission Critical SQL Server Solution

Description:

When asked to design a critical database system, too many people pick an HA feature and then design the solution around it. This usually results in a costly and disappointing design. This session will explain the five basic archetypes for mission critical database systems and how to select the right features from SQL Server to implement your design. Along the way you’ll hear best practices, tips, and real world advice for features like availability groups, clustered instances of SQL Server, as well as the history of some of the more interesting and less often used availability features. While you may not be able to revisit your current designs right away, what you learn will make you the hero of your next mission critical deployment.

SessionID: 35534

SSAS Design and Performance Best Practices

Back to calendar

Event Date: 25-06-2015 04:00 - Category: 24 Hours of PASS (60 minutes) - Track: BI Platform Architecture, Development & Administration

Speaker(s): Alan Faulkner

Title: SSAS Design and Performance Best Practices

Description:

A journey through best practices in relation to scalable SQL Server Analysis Services cube design. From dimension design to SSAS engine internals we will explore SSAS multidimensional design patterns that will take you through steps to assist in getting your SSAS cubes better optimized to better match the needs of your organization. After this session you will be able to take these performance design patterns and apply them to new and existing cubes to tune your SSAS cube environment.

SessionID: 35566

Data Pages, Allocation Units, IAM chains... Oh My!

Back to calendar

Event Date: 25-06-2015 05:00 - Category: 24 Hours of PASS (60 minutes) - Track: Enterprise Database Administration & Deployment

Speaker(s): Brandon Leach

Title: Data Pages, Allocation Units, IAM chains... Oh My!

Description:

Understanding how SQL Server organizes your data under the hood can seem like a daunting task. In this session we’ll take a look at how objects such as tables and indexes are stored in the data file. We’ll also look at how these concepts tie in to your work as a DBA or developer. We’ll see these concepts in action using demos and see how we can use this knowledge to better design solutions. We’ll start off by looking at the structure of a row and then move on the concept of a data page. From there we’ll cover a few special page types like the index allocation map. Then we’ll look at index structures and talk about the differences between heaps and clustered indexes.

SessionID: 8740

Offline Database Development and Unit Testing with SSDT

Back to calendar

Event Date: 25-06-2015 06:00 - Category: 24 Hours of PASS (60 minutes) - Track: Application & Database Development

Speaker(s): Andrey Zavadskiy

Title: Offline Database Development and Unit Testing with SSDT

Description:

Unit testing is a process commonly used by application developers. Nowadays it can be used for Microsoft SQL Server database development. In this session, you will learn how to create a test project and write unit tests for your T-SQL code using SQL Server Data Tools. We take a look at unit test structure, create some tests for SQL Server stored procedures and functions, and define various test conditions for them. Also we discover how to extend the functionality of built-in test conditions and create a customized extension in C#.

SessionID: 8725

SQL Server Agent: The life preserver for the drowning DBA

Back to calendar

Event Date: 25-06-2015 07:00 - Category: 24 Hours of PASS (60 minutes) - Track: Enterprise Database Administration & Deployment

Speaker(s): Lance Tidwell

Title: SQL Server Agent: The life preserver for the drowning DBA

Description:

Automation is a key part to becoming a great DBA. Without automation a DBA can start to drown in a sea of repeating tasks. The SQL Server Agent can serve as the much-needed life preserver to pull your head above the water. In this session you will learn at how to setup the SQL Agent as well as creating jobs and alerts within the agent to help you automate daily, monthly, yearly tasks. In addition we will look into how to monitor the jobs and alerts created. Lastly we will talk about some common pitfalls to watch out for when dealing with the SQL Server Agent.

SessionID: 35575

Understanding and Visualizing Data Using R in SQL Server

Back to calendar

Event Date: 25-06-2015 08:00 - Category: 24 Hours of PASS (60 minutes) - Track: BI Information Delivery

Speaker(s): Tomaž Kaštrun

Title: Understanding and Visualizing Data Using R in SQL Server

Description:

Language R for Statistical computing is powerful language for data analysis with all great features for data import from SQL environment. Using R with SQL server data will help data scientists, data analysts and data stewards prepare, explore and validate data much easier, as well as to use wide range of statistics; from uni-variate to multivariate. Session will focus on: 1) establishing the R connecting with SQL server using standard ODBC connectors and T-SQL procedures, 2) validate data with using classical statistical methods on any of your SQL transactional and master data 3) use R output in standard report (using SSRS) and bring extra information to reports. Demos in session will include exploring T-SQL procedure for establishing connection, using R to your common statistical needs and creating report (in SSRS) to visualize data. Demo will also show sentiment analysis of Twitter PASS MVP Summit 2014 event.

SessionID: 8733

Curious Cases of Availability Groups

Back to calendar

Event Date: 25-06-2015 09:00 - Category: 24 Hours of PASS (60 minutes) - Track: Enterprise Database Administration & Deployment

Speaker(s): Murilo Miranda

Title: Curious Cases of Availability Groups

Description:

It's been more than two years after the release of the AlwaysOn Availability Groups and every day we see more and more architects implementing this technology. Either on new projects or as a new solution on existing systems, at the design stage everything looks feasible and possible, but sometimes small details may cause a headache during the implementation phase. In this session, we will go through common cases, and others not so common, when implementing Availability Groups in a production environment. Dive with me into these AG cases so when one of these situations pops during your professional life you will already be armed with the knowledge to resolve it!

SessionID: 35582

Don't Repeat Yourself - An Introduction to Agile SSIS Development

Back to calendar

Event Date: 25-06-2015 10:00 - Category: 24 Hours of PASS (60 minutes) - Track: BI Platform Architecture, Development & Administration

Speaker(s): Cathrine Wilhelmsen

Title: Don't Repeat Yourself - An Introduction to Agile SSIS Development

Description:

SSIS (SQL Server Integration Services) is a powerful tool for extracting, transforming and loading data, but creating and maintaining a large number of SSIS packages can be both tedious and time-consuming. Even if you use templates and follow best practices you often have to repeat the same steps over and over again. Handling metadata and schema changes is a manual process, and there are no easy ways to implement new requirements in multiple packages at the same time.

It is time to bring the Don't Repeat Yourself (DRY) software engineering principle to SSIS projects. First learn how to use Biml (Business Intelligence Markup Language) and BimlScript to generate SSIS packages from database metadata and implement changes in all those packages with just a few clicks. Then take the DRY principle one step further and learn how to update all packages in multiple projects by separating and reusing common code. See how Biml allows you to complete in a day what once took more than a week!

SessionID: 35525

The Data Loading Performance Presentation

Back to calendar

Event Date: 25-06-2015 11:00 - Category: 24 Hours of PASS (60 minutes) - Track: Enterprise Database Administration & Deployment

Speaker(s): Matan Yungman

Title: The Data Loading Performance Presentation

Description:

Loading huge amounts of data into SQL Server can be a challenging task. When doing it, there are quite a few factors that can help or hurt you.

For that, Microsoft has published a famous whitepaper called "The Data Loading Performance Guide". The problem is that it's long and full of small details, and we're too lazy to read it.

On this session, we will turn the whitepaper into a presentation and talk about the ways you can optimize your massive data loading processes by applying the techniques mentioned in the whitepaper, as well as other advanced techniques that have emerged since the whitepaper was published.

Among other topics, we will talk about the #1 enemy of high performance data loading, Minimal Logging and Bulk Load, indexing techniques, properly leveraging parallelism and partitioning, SQL Server 2014 Delayed Durability, and more.