sqlsathistory

Nr: 492

Back to Main list

SQLSaturday #492 - Phoenix 2016

Start Time (24h)	Speaker	Track	Title
10:00:00	Paul Turley	BI Information Delivery	Reporting Services 2016 Solutions: The New Awesome
10:00:00	Rob Mandeville	Enterprise Database Administration Deployment	Know your bottlenecks: Wait time analysis
10:00:00	Chris Hyde	Advanced Analysis Techniques	SQL Server R Services in SQL 2016
10:00:00	Vern Rabe	Enterprise Database Administration Deployment	It’s Time for a Change : Temporal Table Support in SQL Server 2016
10:00:00	Ryan McCauley	Strategy and Architecture	How to troubleshoot beyond what you understand
10:00:00	Delora Bradish	BI Platform Architecture, Development Administration	Build Your BI House with a Blueprint: Modeling for MS BI
10:00:00	William E Pearson III	Analytics and Visualization	Introducing Forensic Analytics with Power BI
10:00:00	Andy Tabisz	Application Database Development	Creating Access Web Apps with SQL Azure and SharePoint
10:00:00	Thomas Grohser	Enterprise Database Administration Deployment	SQL Server Storage Engine under the hood
10:00:00	Rushabh Mehta	BI Information Delivery	Mastering and Enhancing Company Data
10:00:00	Mindy Curnutt	Enterprise Database Administration Deployment	SQL Server Bingo – Install, Migration Config
10:00:00	Joseph D'Antoni	Strategy and Architecture	The Tricky Part of Doing Tricky Things in your Data Model
10:00:00	Carlos Bossy	Advanced Analysis Techniques	Predictive Analytics Fundamentals
10:00:00	Orion Gebremedhin	Advanced Analysis Techniques	Microsoft Azure : Elastic Cloud Compute and Storage for Big Data Processing
11:15:00	Eric Peterson	Application Database Development	JSON and SQL 2016
11:15:00	Delora Bradish	BI Platform Architecture, Development Administration	Performance Matters: Optimizing SSAS Multidimensional Cubes
11:15:00	William E Pearson III	Strategy and Architecture	Possible Musics: Choosing between SSAS Multidimensional and Tabular
11:15:00	Sean Werick	Application Database Development	Tired of looking for query performance optimizations? Try the Query Store!
11:15:00	Kevin Wilkie	Application Database Development	Even VIEWs can be sexy
11:15:00	Stan Geiger	BI Platform Architecture, Development Administration	Performance Monitoring for Analysis Services
11:15:00	Ned Otter	Enterprise Database Administration Deployment	SQL SERVER 2016, HEKATON REVEALED
11:15:00	Chris Shaw	Enterprise Database Administration Deployment	Tips for SQL Server Performance and Resiliency
11:15:00	Geoff Valera	Analytics and Visualization	DataZen and More
11:15:00	Joseph D'Antoni	BI Platform Architecture, Development Administration	Essential Architecture for Bi in a Virtual Environment
11:15:00	Reeves Smith	BI Platform Architecture, Development Administration	SQL Server Integration Services for Data Science
11:15:00	Carlos Bossy	BI Platform Architecture, Development Administration	Real-time Data Warehousing for rapid BI Analysis
11:15:00	Steve Jones	Application Database Development	End to End Protection with Always Encrypted in SQL Server 2016
12:30:00	Orion Gebremedhin	Advanced Analysis Techniques	Microsoft Cortana Analytics: The Unified Platform for Advanced Analytics
12:30:00	Josh Sivey	Strategy and Architecture	Don’t forget the licensing!
12:30:00	Matt White	Professional Development	Learn about Pyramid Analytics’ BI Office Version 6 Platform Release
12:30:00	Matthew Smith	Strategy and Architecture	Microsoft Presents: Don’t forget the licensing!
12:30:00	Ed Cho	Strategy and Architecture	Cisco and Nimble Storage: Partnering to Create the Next Generation SQL Serv
12:30:00	Kathi Kellenberger	Professional Development	WIT Session: The Year of Yes
13:45:00	Michael Perillo	Analytics and Visualization	Introduction to Tableau
13:45:00	Mike Byrd	Application Database Development	SS2014 In-Memory Tables: Formula 1 Performance Unleashed?
13:45:00	Mark Broadbent	Enterprise Database Administration Deployment	Ye Olde Cluster Curiosity Shoppe - A miscellany of SQL Clustering top tips
13:45:00	Mark Broadbent	Enterprise Database Administration Deployment	The NOLOCK Chronicles
13:45:00	Drew Furgiuele	Enterprise Database Administration Deployment	SQL Server and PowerShell: Let's Get Serious
13:45:00	TJay Belt	Cloud Application Development Deployment	Hadoop, Hive, JSON, and Data! Oh, my!
13:45:00	Phil Ekins	Enterprise Database Administration Deployment	Availability Groups: Monitoring and Alerting
13:45:00	Sean Brown	Application Database Development	Managing Databases in Visual Studio and TFS
13:45:00	Steve Hughes	Application Database Development	A Window into Your Data: Using SQL Window Functions
13:45:00	Stan Geiger	BI Platform Architecture, Development Administration	"Polybase and Time Travel (Temporal Tables)"
13:45:00	Josh Sivey	Cloud Application Development Deployment	Azure SQL Data Warehouse – Elastic Data Analytics in the cloud
13:45:00	Mindy Curnutt	Application Database Development	The Ins and Outs of SQL Indexes
13:45:00	Martin Schoombee	BI Information Delivery	MDX: Troubleshooting Tips Tricks
13:45:00	Rowland Gosling	BI Platform Architecture, Development Administration	Accelerating Batch Processing with Apache Spark
15:00:00	Mike Byrd	Application Database Development	SQL Server Foreign Keys – De-mystifying the Rest of the Story
15:00:00	Jeff Schmidt	Enterprise Database Administration Deployment	SQL 2014 , been there done that!
15:00:00	Dean Richards	Enterprise Database Administration Deployment	Introduction to Wait Types and Response Time Analysis
15:00:00	Kathi Kellenberger	Enterprise Database Administration Deployment	Kerberos Delegation for SSRS Made Simple
15:00:00	Naomi Williams	Professional Development	SQL Server Internals
15:00:00	Konstantin Melamud	BI Platform Architecture, Development Administration	Optimizing your data warehouse for OLAP Processing
15:00:00	Paul Graham	BI Platform Architecture, Development Administration	How do you validate your ETL?
15:00:00	Ginger Grant	Advanced Analysis Techniques	Data Driven Decision Making with Azure ML
15:00:00	Alan Faulkner	Cloud Application Development Deployment	Introduction to Azure Data Factory Service
15:00:00	Jeff Prom	BI Platform Architecture, Development Administration	Mastering Master Data Services
15:00:00	Amy Herold	Enterprise Database Administration Deployment	Deadlock, Block Two Smoking Barrels: Breaking Down Blocking and Deadlocks
15:00:00	Steve Jones	Application Database Development	Get Testing with tSQLt
15:00:00	Jason Brimhall	Enterprise Database Administration Deployment	Bare Naked Skinny on SQL Server
16:00:00	Thomas Grohser	Enterprise Database Administration Deployment	Optimizing the SQL Server and Databases for large Fact Tables
16:15:00	Rachael Martino	BI Platform Architecture, Development Administration	Power BI Performance Tips
16:15:00	Reeves Smith	BI Platform Architecture, Development Administration	Increase your SSIS productivity with Biml
16:15:00	Kathi Kellenberger	Enterprise Database Administration Deployment	Top 5 SQL Server Mistakes
16:15:00	Arnie Rowland	Strategy and Architecture	Table Partitioning -Beyond the Basics
16:15:00	Konstantin Melamud	Enterprise Database Administration Deployment	Turbo Boost Performance: In Memory Tables index optimizations
16:15:00	Rick Lowe	Application Database Development	Weird stuff I saw while supporting a Java team
16:15:00	Ben Thul	Application Database Development	Phone Book Phun - Learning database concepts with the White Pages
16:15:00	Robert Miller	Analytics and Visualization	Welcome to Azure Stream Analytics
16:15:00	Amy Herold	Enterprise Database Administration Deployment	Hi, my name is Powershell, let's be friends! An Intro to PoSH
16:15:00	Sayed Saeed	BI Information Delivery	The Business Intelligence Side of SQL Server
16:15:00	Jason Brimhall	Enterprise Database Administration Deployment	Working with Object Compression in SQL Server
16:15:00	Phil Robinson	BI Information Delivery	Power BI Desktop – A BI developer’s view

SessionID: 41898

Reporting Services 2016 Solutions: The New Awesome

Back to calendar

Event Date: 16-04-2016 - Session time: 10:00:00 - Track: BI Information Delivery

Speaker: Paul Turley

Title: Reporting Services 2016 Solutions: The New Awesome

Abstract:

Your old favorite reporting tool just got a lot better. In the new world of SSRS, traditional RDL reports integrate with mobile dashboards, Power BI and Excel. You'll receive guidance and learn best practices to design and orchestrate integrated reporting and BI solutions with improved Reporting Services features and the new report portal.

SessionID: 42222

Know your bottlenecks: Wait time analysis

Back to calendar

Event Date: 16-04-2016 - Session time: 10:00:00 - Track: Enterprise Database Administration Deployment

Speaker: Rob Mandeville

Title: Know your bottlenecks: Wait time analysis

Abstract:

Find the bottlenecks in your environment using best practice wait based analysis. If you listen to your database engine, it will tell you where it's spending the time which helps the database professional identify where to focus for performance issues. We tend to jump straight to resources when we hear performance issues - what if I told you there's a better way?

SessionID: 42277

SQL Server R Services in SQL 2016

Back to calendar

Event Date: 16-04-2016 - Session time: 10:00:00 - Track: Advanced Analysis Techniques

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

It’s Time for a Change : Temporal Table Support in SQL Server 2016

Back to calendar

Event Date: 16-04-2016 - Session time: 10:00:00 - Track: Enterprise Database Administration Deployment

Speaker: Vern Rabe

Title: It’s Time for a Change : Temporal Table Support in SQL Server 2016

Abstract:

Without temporal tables (AKA history tables), we can only see the current version of data. We can’t see rows that have been deleted or rows as they existed before the latest update. The temporal table support in SQL Server 2016 gives us the ability to create system maintained “history” tables to track all changes to the table data.

In this session we’ll discuss how you can benefit from temporal support in your tables, how to implement temporal tables in SQL Server 2016, and how to write “time travel queries” using the new FOR SYSTEM_TIME clause in a SELECT statement to easily query historical information.

SessionID: 42562

How to troubleshoot beyond what you understand

Back to calendar

Event Date: 16-04-2016 - Session time: 10:00:00 - Track: Strategy and Architecture

Speaker: Ryan McCauley

Title: How to troubleshoot beyond what you understand

Abstract:

Troubleshooting can be easy when the cause of an issue is obvious - except sometimes it isn't because it's not. In those cases, how do you find the cause - especially when it's something you don't directly control? You're having issues with your storage, but is it a result of RAID being setting up improperly or a constraint on the fiber channel switch? Can you tell the difference between a blockage of firewall ports and a network switch that's nearing capacity? You're not a SAN admin or a firewall engineer, but you don't need to be to understand enough to identify whether these systems are involved.

In this session, we'll talk about troubleshooting as a process - how you can identify issues beyond what you can see and may not understand. While we may discuss some specific situations or hard-to-identify causes in the examples, the session will be focused on understanding the impact of different issues, and how you can better identify the cause of an issue when it's outside your system.

SessionID: 42938

Build Your BI House with a Blueprint: Modeling for MS BI

Back to calendar

Event Date: 16-04-2016 - Session time: 10:00:00 - Track: BI Platform Architecture, Development Administration

Speaker: Delora Bradish

Title: Build Your BI House with a Blueprint: Modeling for MS BI

Abstract:

The topic for this hour will be modeling for MS BI with a focus on multidimensional modeling. We’ll talk about a recommended blueprint for MS BI projects, the best option for effectively handing deleted rows, denormalization, degenerate dimensions, slowly changing dimensions, many-to-many relationships, considerations for predictive analytics, and tips for migrating from other platforms. Given time considerations, we’ll also be covering how agile methodologies and ABC (audit, balance and control) impact our modeling decisions. Come join us for an information packed hour!

SessionID: 43035

Introducing Forensic Analytics with Power BI

Back to calendar

Event Date: 16-04-2016 - Session time: 10:00:00 - Track: Analytics and Visualization

Speaker: William E Pearson III

Title: Introducing Forensic Analytics with Power BI

Abstract:

Despite the wealth of analytical technologies available today, 65% of fraud at public companies is detected through tips, management review, or simple accidents. Forensic Analytics combine human intuition and leading-edge technologies, and can provide superior detection methods to significantly improve the detection and investigation of illegal or unethical activities.

In this session, we explore Forensic Analytics: a set of techniques we can use to uncover irregularities in financial data. We also gain an understanding of goals of Forensic Analytics: to enable us to find out how — and why — these irregularities exist, and to find out their source(s) — especially when fraudulent activity is suspected. We discuss guiding principles that are key to isolating data anomalies, and outline a standard, repeatable process to Forensic Analytics. Throughout the session, we view examples of how we can employ Power BI to drive Forensic Analytics via various tests and reviews.

SessionID: 44879

Creating Access Web Apps with SQL Azure and SharePoint

Back to calendar

Event Date: 16-04-2016 - Session time: 10:00:00 - Track: Application Database Development

Speaker: Andy Tabisz

Title: Creating Access Web Apps with SQL Azure and SharePoint

Abstract:

In this session, you'll learn how to quickly build an Access Web App, tour the online development environment and see a real, live working app in action. We'll discuss app distribution and deploying updates and demonstrate add-in features like Power BI Tiles and Bing Maps. And lastly, you'll learn the pros/cons of Access Web Apps and hybrid solutions in a corporate environment as well as how to extend the data to mobile phones tablets. Presented by Andy Tabisz, Microsoft MVP, WorkSmart Database Masters.

SessionID: 45602

SQL Server Storage Engine under the hood

Back to calendar

Event Date: 16-04-2016 - Session time: 10:00:00 - Track: Enterprise Database Administration Deployment

Speaker: Thomas Grohser

Title: SQL Server Storage Engine under the hood

Abstract:

How SQL Server performs I/O

How is SQL Server really accessing the data and log files on the disk? What's done asynchronous and what's synchronous and what impact does that have on our queries and DML statements. Which impact have features like database mirroring and replication, what's different when SQL Server is starting up. #160; Which I/O Subsystems (including SSD) are best for which type of data and what's the impact if you choose a different one. Which files can be placed on the same volume and which should not.

SessionID: 46091

Mastering and Enhancing Company Data

Back to calendar

Event Date: 16-04-2016 - Session time: 10:00:00 - Track: BI Information Delivery

Speaker: Rushabh Mehta

Title: Mastering and Enhancing Company Data

Abstract:

Getting a good 360 degree view of organizations (customers or vendors) or doing customer centric analysis is often complicated as a result of bad data/ duplicate data / inconsistent data coming from multiple systems. In addition, there are external factors like mergers and acquisitions, inter-company relationships and other nuances that may not be captured in source systems. Getting a clear picture of customer and vendor data can not only provide a clear picture for analysis of information, but also aid in critical risk management functions. In this session, you will learn about some techniques and data services from DB that you can use to clean and enhance your data.

SessionID: 46418

SQL Server Bingo – Install, Migration Config

Back to calendar

Event Date: 16-04-2016 - Session time: 10:00:00 - Track: Enterprise Database Administration Deployment

Speaker: Mindy Curnutt

Title: SQL Server Bingo – Install, Migration Config

Abstract:

Get ready to play SQL Buzzword Bingo with the subject matter being SQL Install, Migration Configuration. Are you preparing to move a database from one SQL Server to another? Whether it's your first SQL install, a SQL Server Upgrade or changing from physical to virtual, there is a lot to consider. In some areas of the setup, you get only one chance to "get it right." Come to this session and find out all about the process - and have some fun while you're at it. First one to hit BINGO! Are you preparing to move a database from one SQL Server to another?

Whether it's your first SQL install, a SQL Server Upgrade or changing from physical to virtual, there is a lot to consider. In some areas of the setup, you get only one chance to "get it right." Come to this session and find out all about the process - and have some fun while you're at it. First one to hit BINGO! will win a fun and unique prize.

SessionID: 46529

The Tricky Part of Doing Tricky Things in your Data Model

Back to calendar

Event Date: 16-04-2016 - Session time: 10:00:00 - Track: Strategy and Architecture

Speaker: Joseph D'Antoni

Title: The Tricky Part of Doing Tricky Things in your Data Model

Abstract:

We've mastered the basics of data modeling and data modeling patterns, but what happens when you or a teammate wants to use this one weird trick to improve on the data model and the resulting database design? Have you just discovered a brilliant new trick that no one else has ever thought of? Or will your new design cost you more, take on more risk and cause all kinds of pain for both IT and your business users?

We'll look at a few tricks that we've seen in our database design review and show you how they work and talk about the trade offs for using them. You'll learn about:

Building a database engine inside your database Designing before understanding your business model Dealing with data structures that don't do well in RDBMSs Optimizing the developer versus the data or the app Using design patterns that don't reflect modern architectures and tools …and a lot more

SessionID: 46777

Predictive Analytics Fundamentals

Back to calendar

Event Date: 16-04-2016 - Session time: 10:00:00 - Track: Advanced Analysis Techniques

Speaker: Carlos Bossy

Title: Predictive Analytics Fundamentals

Abstract:

The practice of Data Science has arrived and as data professionals we're on the forefront of this change. The data we collect can now be used in new and exciting ways, providing more value than ever before. To get started in this field, a number of tools and methodologies must be employed to help you achieve predictive analytics success with your data. In this session the predictive analytics process will be covered from start to finish, providing a practical understanding of what it takes to develop your own predictive models. The session includes an overview of definitions, concepts and terminology, successful applications of predictive analytics, and how predictive analytics fits into a BI environment.

SessionID: 46927

Microsoft Azure : Elastic Cloud Compute and Storage for Big Data Processing

Back to calendar

Event Date: 16-04-2016 - Session time: 10:00:00 - Track: Advanced Analysis Techniques

Speaker: Orion Gebremedhin

Title: Microsoft Azure : Elastic Cloud Compute and Storage for Big Data Processing

Abstract:

Massively Parallel Processing (MPP) appliances have gained increasing popularity for processing both structured, unstructured and semi structured big data. Cloud platforms for big data as a service are gaining momentum in recent years because of the convenience they provide mainly due to fast and independent scaling of storage and compute resources as well as a pay-as-you-go pricing model. In this session Orion will explain the fundamentals behind MPP big data processing tools, with a focus on Azure SQL Data Warehouse and provide a practical demonstration of the capabilities of the tool.

SessionID: 42930

JSON and SQL 2016

Back to calendar

Event Date: 16-04-2016 - Session time: 11:15:00 - Track: Application Database Development

Speaker: Eric Peterson

Title: JSON and SQL 2016

Abstract:

JSON: What it is, what it isn't and how to use it.

We'll look at JSON vs HTML, JSON implementation as a built-in vs. native data type in SQL, shaping the JSON output and code examples of using SQL JSON from .Net and PHP.

SessionID: 42939

Performance Matters: Optimizing SSAS Multidimensional Cubes

Back to calendar

Event Date: 16-04-2016 - Session time: 11:15:00 - Track: BI Platform Architecture, Development Administration

Speaker: Delora Bradish

Title: Performance Matters: Optimizing SSAS Multidimensional Cubes

Abstract:

Come and learn tips and tricks for optimizing multidimensional cubes! We'll be covering cube file system storage and the top design considerations for cubes. Dimension design best practices, optimizing for degenerate dimensions, as well as partitions and aggregations will also be covered. Come join me as we spin through a checklist for MultiD cube design! A foundational knowledge of OLAP design and MultiD cubes will be helpful, but is not required.

SessionID: 43033

Possible Musics: Choosing between SSAS Multidimensional and Tabular

Back to calendar

Event Date: 16-04-2016 - Session time: 11:15:00 - Track: Strategy and Architecture

Speaker: William E Pearson III

Title: Possible Musics: Choosing between SSAS Multidimensional and Tabular

Abstract:

The Analysis Services 2012 (and above) Business Intelligence Semantic Model (BISM) unifies Multidimensional (OLAP) and Tabular (relational) options for organizational BI. BI professionals can implement Multidimensional cubes, or they can deploy Tabular models, developed by business users, to a dedicated server. Those new to Tabular, or those embarking upon BI for the first time with Analysis Services 2012, may find it difficult to choose between the two paths. In this session, BI Architect, SSAS Maestro and SQL Server MVP Bill Pearson overviews the nature and design goals of each option, comparing Multidimensional and Tabular features. He then offers guidance on selecting the appropriate model, providing real world examples to illustrate approaches for given scenarios.

SessionID: 45518

Tired of looking for query performance optimizations? Try the Query Store!

Back to calendar

Event Date: 16-04-2016 - Session time: 11:15:00 - Track: Application Database Development

Speaker: Sean Werick

Title: Tired of looking for query performance optimizations? Try the Query Store!

Abstract:

This session will discuss the fantastic new capabilities of Query Store with SQL Server 2016. It will illustrate what it is, why we want it, how we would use it, and how it is BETTER than any other available performance tuning tools. This session will walk through enabling this feature, leveraging its capabilities, and modifying some of the available options. If attendees walk away with nothing else from this session, remember the LIVE Query Statistics (or Execution Plan). This is a game changer and will greatly impact any on-demand query optimization.

SessionID: 45683

Even VIEWs can be sexy

Back to calendar

Event Date: 16-04-2016 - Session time: 11:15:00 - Track: Application Database Development

Speaker: Kevin Wilkie

Title: Even VIEWs can be sexy

Abstract:

What constitutes a view? Do we really need them in database development? Do they serve their purpose? Can we make them faster? At what point have we gone overboard with views? Just some of the questions that will be asked and answered...

SessionID: 46038

Performance Monitoring for Analysis Services

Back to calendar

Event Date: 16-04-2016 - Session time: 11:15:00 - Track: BI Platform Architecture, Development Administration

Speaker: Stan Geiger

Title: Performance Monitoring for Analysis Services

Abstract:

So you are responsible for monitoring the availability and performance of an SSAS instance as well as making recommendations for performance improvements. So you’re like no problem it’s just SQL Server right? All of the “tricks of the trade” for SQL Server you have learned over the years will work right? Then you do some research and find out that Analysis Services is not your mother’s SQL Server. In this presentation we will open the “black box” that is Analysis services and highlight key areas of performance that you should be looking at when monitoring. We will also discuss architecture of Analysis Services for both multidimensional and tabular model.

SessionID: 46350

SQL SERVER 2016, HEKATON REVEALED

Back to calendar

Event Date: 16-04-2016 - Session time: 11:15:00 - Track: Enterprise Database Administration Deployment

Speaker: Ned Otter

Title: SQL SERVER 2016, HEKATON REVEALED

Abstract:

First released in SQL 2014, Hekaton - also known as In-Memory OLTP - is a vast technology that is designed to solve scalability problems specific to write-intensive, highly concurrent workloads. In SQL 2016, Microsoft has further enhanced In-Memory OLTP, removing many of the former barriers to adoption.

Attendees will learn about the benefits and pitfalls of In-Memory OLTP in SQL 2016, allowing them to determine if their production workloads might benefit from this exciting new technology.

Session topics include architecture, capacity planning, and database maintenance.

SessionID: 46422

Tips for SQL Server Performance and Resiliency

Back to calendar

Event Date: 16-04-2016 - Session time: 11:15:00 - Track: Enterprise Database Administration Deployment

Speaker: Chris Shaw

Title: Tips for SQL Server Performance and Resiliency

Abstract:

After working 20 years in the industry on hundreds of SQL Servers clear patterns emerge. These observations of patterns and best practices directly relate to the health of the server.#160; During this session we will review the patterns of healthy SQL Servers and identify unhealthy behavior that clearly shows servers that are at risk.#160;

We will review shared patterns, configuration and practices.#160;#160; Which of these repeating patterns represent healthy Servers and which of these patterns are#160; shared with servers that are having issues daily.#160; These patterns are so clear in fact that I many SQL Servers will benefit from the application of at least one if not more of the tips we will cover.#160; At the end of this session attendees will have the tools to identify and correct common issues that impact SQL Servers Performance and Resiliency.

SessionID: 46457

DataZen and More

Back to calendar

Event Date: 16-04-2016 - Session time: 11:15:00 - Track: Analytics and Visualization

Speaker: Geoff Valera

Title: DataZen and More

Abstract:

Cristian Vasconez and I will be presenting an in depth look at DataZen and what it has to offer, previewing Dashboard capabilities, KPI's, and administration. We will also explore the different cloud solution that was used to create this project and how we use different BI Tools, such as Powershell and SSIS to not only create this project, but to show how cost effective the cloud can be .

SessionID: 46530

Essential Architecture for Bi in a Virtual Environment

Back to calendar

Event Date: 16-04-2016 - Session time: 11:15:00 - Track: BI Platform Architecture, Development Administration

Speaker: Joseph D'Antoni

Title: Essential Architecture for Bi in a Virtual Environment

Abstract:

While more and more workloads have moved to virtual environments, the data warehouse is often one of the last physical server in the data center. However, that doesn’t need to be the case, in this webinar you will learn about the challenges of implementing your BI environments in a virtual environment. This includes your data warehouse, and its ancillary systems like Analysis Services, Integration Services and Reporting Services. Finally, we’ll talk a little bit about how Azure VMs can change this guidance.

SessionID: 46673

SQL Server Integration Services for Data Science

Back to calendar

Event Date: 16-04-2016 - Session time: 11:15:00 - Track: BI Platform Architecture, Development Administration

Speaker: Reeves Smith

Title: SQL Server Integration Services for Data Science

Abstract:

With all of the excitement around data science and the increased demand for advanced analytics, the business needs your help. Data integration involves combining the available data, and providing the business with a unified view of all of the enterprise data assets. What if your data integration target is a mining model?

ETL developers are required for the majority of the work on a data science project. What are the additional skills that are needed to enable ETL Developers to work on the next data science project? In this presentation, we’ll discuss the data preparation and integration considerations that are needed for data science project.

Some of the topics that will be covered in this session include: • Data Cleansing • Data Normalization • Missing Values • Noisy Data • Data Reduction • Model Integration

This presentation is ideally suited for Business Intelligence professionals that are interested in applying their skills to a data science project.

SessionID: 46794

Real-time Data Warehousing for rapid BI Analysis

Back to calendar

Event Date: 16-04-2016 - Session time: 11:15:00 - Track: BI Platform Architecture, Development Administration

Speaker: Carlos Bossy

Title: Real-time Data Warehousing for rapid BI Analysis

Abstract:

Having BI measures available in real-time is a challenging endeavor that requires putting together a dependable architecture with many moving parts. In this demo-rich session we will explore database and ETL architectures that let you reliably move data from your application databases across the enterprise in real-time to your data warehouse. You will see how to use the many features provided by SQL Server such as Replication, Change Data Capture, SSIS, and other techniques to extract, transform, and load data fast and dependably. The development of an actual real-time system during the session from beginning-to-end will be shown, that by its conclusion will populate a star schema with actual data. We will also discuss and walk through alternative real-time architectures such as data virtualization. Finally, we will see how to create cubes and reports to present data with a minimum amount of latency.

SessionID: 46856

End to End Protection with Always Encrypted in SQL Server 2016

Back to calendar

Event Date: 16-04-2016 - Session time: 11:15:00 - Track: Application Database Development

Speaker: Steve Jones

Title: End to End Protection with Always Encrypted in SQL Server 2016

Abstract:

Protecting our data from unauthorized access becomes more and more important all the time, however it has been difficult to ensure sensitive data is encrypted in SQL Server. The new Always Encrypted feature in SQL Server 2016 makes this much simpler for developers and DBAs with a framework for protecting data from the client, across networks, and inside of the database. This new feature allows for limiting access to the data, even from the DBAs and sysadmins that may control the database instance itself. Learn how to implement and use Always Encrypted in your applications.

SessionID: 46928

Microsoft Cortana Analytics: The Unified Platform for Advanced Analytics

Back to calendar

Event Date: 16-04-2016 - Session time: 12:30:00 - Track: Advanced Analysis Techniques

Speaker: Orion Gebremedhin

Title: Microsoft Cortana Analytics: The Unified Platform for Advanced Analytics

Abstract:

With the fast moving release cycles as well as frequent emergence of various new big data and advanced analytics tools cloud platforms can be the home of disconnected services. This can impact business continuity, cost ease of use and application integrations.

With Cortana Analytics Microsoft provides a well-integrated and managed platform for advanced analytics and big data solutions. In this session, Orion will explore the different components of Cortana Analytics as well as provide various reference architectures and uses cases built on top of Cortana Analytics to solve real world problems.

SessionID: 48665

Don’t forget the licensing!

Back to calendar

Event Date: 16-04-2016 - Session time: 12:30:00 - Track: Strategy and Architecture

Speaker: Josh Sivey

Title: Don’t forget the licensing!

Abstract:

It may not be the most exciting topic, but it can quickly become the most important topic for a project! Many developers and architects make technical decisions based on features and capabilities, but do not consider licensing as part of the decision making process. Other times decisions are made by perceived licensing costs, that may not truly impact a customer’s environment. In this session Matt Smith will provide an overview of licensing options and details to consider for SQL Server including editions, versions, agreements, and software assurance. After an initial level set, Matt will then focus on guidance and best practices for licensing a SQL Server environment across a number of scenarios such as: Virtualized environments, public and private cloud scenarios, support, upgrades, high availability and disaster recovery scenarios.

SessionID: 49313

Learn about Pyramid Analytics’ BI Office Version 6 Platform Release

Back to calendar

Event Date: 16-04-2016 - Session time: 12:30:00 - Track: Professional Development

Speaker: Matt White

Title: Learn about Pyramid Analytics’ BI Office Version 6 Platform Release

Abstract:

Do you like Power BI – but your company is not ready to move to cloud? Does your organization need a platform that will provide agility, speed, and scalability without sacrificing governance and security? Do you want to allow your business users to build Tabular models on the fly, or connect to your multi-dimensional cubes – and visualize them immediately? Come and learn from Matt White about Version 6 BI Office from Pyramid Analytics, an end-to-end platform that enables people across your organization to have governed access to trusted data – to form insights, collaborate freely, and make better data-driven decisions.

SessionID: 49366

Microsoft Presents: Don’t forget the licensing!

Back to calendar

Event Date: 16-04-2016 - Session time: 12:30:00 - Track: Strategy and Architecture

Speaker: Matthew Smith

Title: Microsoft Presents: Don’t forget the licensing!

Abstract:

It may not be the most exciting topic, but it can quickly become the most important topic for a project! Many developers and architects make technical decisions based on features and capabilities, but do not consider licensing as part of the decision making process. Other times decisions are made by perceived licensing costs, that may not truly impact a customer’s environment. In this session Matt Smith will provide an overview of licensing options and details to consider for SQL Server including editions, versions, agreements, and software assurance. After an initial level set, Matt will then focus on guidance and best practices for licensing a SQL Server environment across a number of scenarios such as: Virtualized environments, public and private cloud scenarios, support, upgrades, high availability and disaster recovery scenarios.

SessionID: 49367

Cisco and Nimble Storage: Partnering to Create the Next Generation SQL Serv

Back to calendar

Event Date: 16-04-2016 - Session time: 12:30:00 - Track: Strategy and Architecture

Speaker: Ed Cho

Title: Cisco and Nimble Storage: Partnering to Create the Next Generation SQL Serv

Abstract:

SmartStack solutions bring together the innovative Cisco Unified Computing System (Cisco UCS) and the Nimble Storage Adaptive Flash platform, creating the first integrated infrastructure solution based on a modern, flash-optimized storage architecture. Learn how SmartStack provides an efficient platform that delivers enterprise capabilities in a small form factor for Microsoft’s SQL Server workloads.

SessionID: 49540

WIT Session: The Year of Yes

Back to calendar

Event Date: 16-04-2016 - Session time: 12:30:00 - Track: Professional Development

Speaker: Kathi Kellenberger

Title: WIT Session: The Year of Yes

Abstract:

Imagine being successful beyond your wildest dreams but not being truly happy. This session will discuss how saying yes to those things that scare you can change your life!

SessionID: 41770

Introduction to Tableau

Back to calendar

Event Date: 16-04-2016 - Session time: 13:45:00 - Track: Analytics and Visualization

Speaker: Michael Perillo

Title: Introduction to Tableau

Abstract:

In this introductory Step-by-step you'll learn how to visually analyze data with Tableau by connecting to data, creating views and more.

• Introducing the Tableau Desktop application
• Connecting to data sources (e.g. SQL Azure)
• Creating worksheets and dashboards
• Demonstrating query and design best practices

SessionID: 41798

SS2014 In-Memory Tables: Formula 1 Performance Unleashed?

Back to calendar

Event Date: 16-04-2016 - Session time: 13:45:00 - Track: Application Database Development

Speaker: Mike Byrd

Title: SS2014 In-Memory Tables: Formula 1 Performance Unleashed?

Abstract:

Query performance is what it is all about. SQL Server 2014 now has the new in-memory functionality that takes a completely different approach to data access and manipulation. Google “In-Memory Tables” and you’ll get a myriad of results from white papers, blogs, webinars, etc. This session will consolidate the relevant information from all these sources so the production DBA/Developer will be able to understand, create, use, maintain, and trouble-shoot in-memory table functionality. This session will also examine several demo scripts showing performance gains using the in-memory tables over equivalent disk based tables.

This session is all about when and how to apply in-memory tables in a production environment. After this session you will

1. Understand what in-memory tables are and how to create and maintain them including their limitations
2. Be able to identify performance gains over equivalent disk back tables
3. Comprehend the new data monitoring needed for in-memory table

SessionID: 42086

Ye Olde Cluster Curiosity Shoppe - A miscellany of SQL Clustering top tips

Back to calendar

Event Date: 16-04-2016 - Session time: 13:45:00 - Track: Enterprise Database Administration Deployment

Speaker: Mark Broadbent

Title: Ye Olde Cluster Curiosity Shoppe - A miscellany of SQL Clustering top tips

Abstract:

Welcome to the strange and mysterious world of SQL Server Failover-Clustering and enter Ye Olde Cluster Curiosity Shoppe where we will reveal a miscellany of top tips, tricks and advice gained from nearly two decades of installing and troubleshooting SQL Clusters.

Roll-up roll-up! Come and see: The Shrunken Head; The Bearded Lady; Many Headed Cluster; The Marie Celeste; The Zombie; Installation of Death; The Bodysnatcher; Montezuma’s Revenge ...and many more exhibits and top tips from the field.

SessionID: 42087

The NOLOCK Chronicles

Back to calendar

Event Date: 16-04-2016 - Session time: 13:45:00 - Track: Enterprise Database Administration Deployment

Speaker: Mark Broadbent

Title: The NOLOCK Chronicles

Abstract:

The use of READ UNCOMMITTED isolation and its evil lock hint offspring NOLOCK is the root cause behind 9 of 10 stress-related heart attacks suffered by SQL Server pros on the job. In this Lightning Talk, through the use of real-world examples, we will do our best to convince the SQL Developer and Business Intelligence (BI) communities to avoid this nasty practice. We'll reveal unexpected behaviors and provide alternative solutions.

SessionID: 42240

SQL Server and PowerShell: Let's Get Serious

Back to calendar

Event Date: 16-04-2016 - Session time: 13:45:00 - Track: Enterprise Database Administration Deployment

Speaker: Drew Furgiuele

Title: SQL Server and PowerShell: Let's Get Serious

Abstract:

Whether you've dabbled in PowerShell or wondered what all the fuss is about, make no mistake: PowerShell is something worth learning to make your life as a SQL Server professional easier. Whether you're a DBA, a SSIS developer, or security professional, In this session you'll see practical, real world examples of how you can blend SQL Server and PowerShell together, and not just a bunch of regular T-SQL tasks that have been made more complicated.

SessionID: 42484

Hadoop, Hive, JSON, and Data! Oh, my!

Back to calendar

Event Date: 16-04-2016 - Session time: 13:45:00 - Track: Cloud Application Development Deployment

Speaker: TJay Belt

Title: Hadoop, Hive, JSON, and Data! Oh, my!

Abstract:

Tips and Tricks and Painful lessons learned as I have ventured into the world of Hadoop, JSon and Hive. Our data has made the move from a relational database to a JSon structure, and reporting across the entire enterprise of data has changed. We have introduced Hadoop batch processing to our ETL processes to collect and process data from various locations, depositing them in various other locations. Along the way, various brick walls were surmounted. We will discuss some of these brick walls. Some of the oddities encountered in this journey. and hopefully prepare you for a similar trip, without all the pain we suffered.

SessionID: 43013

Availability Groups: Monitoring and Alerting

Back to calendar

Event Date: 16-04-2016 - Session time: 13:45:00 - Track: Enterprise Database Administration Deployment

Speaker: Phil Ekins

Title: Availability Groups: Monitoring and Alerting

Abstract:

So you have your availability groups configured and everything reports green. How do you measure SLA compliance? Do you know when replication is delayed? Did you know it failed over last night?

This session will answer all these questions and more, and will show you what should you be looking at to ensure no surprises... We will look at the DMVs, extended event sessions, perfmon counters, SQL agent jobs and policies to show what to monitor in your AG and how to setup alerts so you know when to take action.

SessionID: 45206

Managing Databases in Visual Studio and TFS

Back to calendar

Event Date: 16-04-2016 - Session time: 13:45:00 - Track: Application Database Development

Speaker: Sean Brown

Title: Managing Databases in Visual Studio and TFS

Abstract:

Introduction to managing Database objects in Visual Studio using TFS as the version control system.

Topics covered: 1 - Why manage a database in Visual Studio, is that for application code? 2 - Creating and changing objects in Visual Studio 3 - Deploying objects to the live database

SessionID: 45465

A Window into Your Data: Using SQL Window Functions

Back to calendar

Event Date: 16-04-2016 - Session time: 13:45:00 - Track: Application Database Development

Speaker: Steve Hughes

Title: A Window into Your Data: Using SQL Window Functions

Abstract:

Window functions and the OVER() clause are an underused feature in T-SQL. These functions can help you solve complex business problems such as running totals and ranking. If you have never used these functions or are looking to solve ranking and aggregate types of calculations without using GROUP BY, join us for a demo filled session on SQL window functions. We will also look at some of the performance implications of using these functions.

SessionID: 46041

"Polybase and Time Travel (Temporal Tables)"

Back to calendar

Event Date: 16-04-2016 - Session time: 13:45:00 - Track: BI Platform Architecture, Development Administration

Speaker: Stan Geiger

Title: "Polybase and Time Travel (Temporal Tables)"

Abstract:

"With the release of SQL Server 2016, Microsoft has included two features that could fundamentally change the way we look at Data Warehousing. The addition of Polybase for connecting to external data sources such as Hadoop and Azure Blob for native TSQL queries extends the reach of the DW. The Temporal Table feature creates all kinds of possibilities for implementing Type 1 and 2 dimensions as well as time based reporting and logical data recovery. In this session we will take an in depth lock at the features and scenarios for use. We will also look at some actual demos of the technologies so you can get a feel for the technologies in action."

SessionID: 46413

Azure SQL Data Warehouse – Elastic Data Analytics in the cloud

Back to calendar

Event Date: 16-04-2016 - Session time: 13:45:00 - Track: Cloud Application Development Deployment

Speaker: Josh Sivey

Title: Azure SQL Data Warehouse – Elastic Data Analytics in the cloud

Abstract:

Join Microsoft TSP Josh Sivey as we explore Microsoft’s new Azure SQL Data Warehouse cloud service. SQL Data Warehouse is a data warehouse as a service offering that offers petabyte scale massively parallel processing power, created and managed with the tools developers are familiar with. In this session we will provision a SQL Data Warehouse in minutes and show how we can independently scale the storage and compute to meet the needs of the workload on demand. We will showcase SQL Data Warehouse’s Polybase feature to allow us to write T-SQL queries across relational and non-relational data. We will manage and maintain our SQL Data Warehouse using the tools we are familiar with (SSMS and Visual Studio). Finally, we will show how SQL Data Warehouse seamlessly integrates with Power BI, Machine Learning and other Cortana Analytic services.

SessionID: 46417

The Ins and Outs of SQL Indexes

Back to calendar

Event Date: 16-04-2016 - Session time: 13:45:00 - Track: Application Database Development

Speaker: Mindy Curnutt

Title: The Ins and Outs of SQL Indexes

Abstract:

This course will focus on the fundamentals of strategic SQL Server index design and creation. Terms that will be covered and clarified: clustered index, non-clustered index, uniqueness, covering index, fill-factor, scan, seek, key lookup, and fragmentation. This is a beginning level course for those who have always found indexes confusing and somewhat elusive. Lots of valuable information will be provided in a short amount of time.

SessionID: 46742

MDX: Troubleshooting Tips Tricks

Back to calendar

Event Date: 16-04-2016 - Session time: 13:45:00 - Track: BI Information Delivery

Speaker: Martin Schoombee

Title: MDX: Troubleshooting Tips Tricks

Abstract:

We all know that MDX is not an easy language, and cryptic (or no) error messages make it even more difficult to figure out where you have gone wrong.

In this session I will share (and demonstrate) very useful ways to find out the reason(s) behind your MDX query not returning the correct results...or any results for that matter.

SessionID: 48112

Accelerating Batch Processing with Apache Spark

Back to calendar

Event Date: 16-04-2016 - Session time: 13:45:00 - Track: BI Platform Architecture, Development Administration

Speaker: Rowland Gosling

Title: Accelerating Batch Processing with Apache Spark

Abstract:

The Apache Spark framework can accelerate processing 100x or more on Hadoop from diverse data sources such as Cassandra, Hive, or HBase. We’re going to look at the architecture and go step by step through examples using R and Python against public data sources.

SessionID: 41797

SQL Server Foreign Keys – De-mystifying the Rest of the Story

Back to calendar

Event Date: 16-04-2016 - Session time: 15:00:00 - Track: Application Database Development

Speaker: Mike Byrd

Title: SQL Server Foreign Keys – De-mystifying the Rest of the Story

Abstract:

Foreign Keys are the ultimate Catch-22; you need them for data integrity, but they just kill insert, update, and delete performance. In this session we will describe the concept of Foreign Keys and how they maintain data integrity. You will learn their syntax for creating, deleting, disabling, and re-enabling. You will also learn the possible effects of disabling and re-enabling Foreign Keys for data modification. We will also examine the two most important Foreign Key attributes: is_not_trusted and is_disabled and their effect on query performance. All of these characteristics will be demo'ed with many script examples.

After attending this session you will

1. Comprehend the pro and cons of Foreign Keys in a real world production environment
2. Understand the consequences of disabling and re-enabling Foreign Keys for data modification
3. Be able to better assess best approach for Foreign Key maintenance

SessionID: 42204

SQL 2014 , been there done that!

Back to calendar

Event Date: 16-04-2016 - Session time: 15:00:00 - Track: Enterprise Database Administration Deployment

Speaker: Jeff Schmidt

Title: SQL 2014 , been there done that!

Abstract:

Being on the Bleeding Edge of technology doesn't hurt until you hit a roadblock, Jeff has compiled a road map of treasure and pitfalls from the upgrade of all my servers* to the newest SQL version. With what he has found with in memory, high availability and replication.

(*Well of course we can't get rid of the SQL 2000 box )

SessionID: 45448

Introduction to Wait Types and Response Time Analysis

Back to calendar

Event Date: 16-04-2016 - Session time: 15:00:00 - Track: Enterprise Database Administration Deployment

Speaker: Dean Richards

Title: Introduction to Wait Types and Response Time Analysis

Abstract:

Using Wait Types and Response Time Analysis is a proven methodology for tuning SQL Server instances and applications. However, there is often confusion on exactly what the data represents. The issue typically centers around the fact the response time data is analyzed at the wrong level and is not detailed enough. This presentation will focus on these problems and review several real-life case studies of using SQL Server wait types coupled with response time analytics to solve the most difficult performance issues. If you are a DBA or Developer you will definitely benefit from having this methodology in your toolbox.

SessionID: 45625

Kerberos Delegation for SSRS Made Simple

Back to calendar

Event Date: 16-04-2016 - Session time: 15:00:00 - Track: Enterprise Database Administration Deployment

Speaker: Kathi Kellenberger

Title: Kerberos Delegation for SSRS Made Simple

Abstract:

Is Kerberos delegation something you avoid like a vicious three-headed guard dog? Once you hear a clear explanation, it will all make sense and no longer be scary! Attend this session to learn what needs to be done to get SSRS working with Kerberos delegation.

SessionID: 46428

SQL Server Internals

Back to calendar

Event Date: 16-04-2016 - Session time: 15:00:00 - Track: Professional Development

Speaker: Naomi Williams

Title: SQL Server Internals

Abstract:

How does SQL do what it does? Take a look under the hood at how the SQL database engine works with the storage engine. What causes those waits and where do we look to resolve them!

SessionID: 46452

Optimizing your data warehouse for OLAP Processing

Back to calendar

Event Date: 16-04-2016 - Session time: 15:00:00 - Track: BI Platform Architecture, Development Administration

Speaker: Konstantin Melamud

Title: Optimizing your data warehouse for OLAP Processing

Abstract:

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

How do you validate your ETL?

Back to calendar

Event Date: 16-04-2016 - Session time: 15:00:00 - Track: BI Platform Architecture, Development Administration

Speaker: Paul Graham

Title: How do you validate your ETL?

Abstract:

After creating your perfect ETL process, how do you know if it is performing properly over time? It should be monitored and validated regularly. I will discuss several different types of validation as well as different methods to validate these attributes. I hope others will be willing to share their experiences with this session as well.

SessionID: 46750

Data Driven Decision Making with Azure ML

Back to calendar

Event Date: 16-04-2016 - Session time: 15:00:00 - Track: Advanced Analysis Techniques

Speaker: Ginger Grant

Title: Data Driven Decision Making with Azure ML

Abstract:

What kinds of things can you determine with Azure ML? Attendees will find out what kind of questions are good candidates for Azure ML and what aren't. This session will show how to use Azure ML, by ncorporating items created in and SQL to develop an Azure ML solution and incorporate the results into a data environment.

SessionID: 46756

Introduction to Azure Data Factory Service

Back to calendar

Event Date: 16-04-2016 - Session time: 15:00:00 - Track: Cloud Application Development Deployment

Speaker: Alan Faulkner

Title: Introduction to Azure Data Factory Service

Abstract:

Data Factory is a cloud-based data integration service that orchestrates and automates the movement and transformation of data. Just like a manufacturing factory that runs equipment to take raw materials and transform them into finished goods, Data Factory orchestrates existing services that collect raw data and transform it into ready-to-use information.

In this session, we will review key concepts associated with Azure Data Factory to understand how key entities work together to define input and output data, processing events, and the schedule and resources required to execute the desired data flow.

SessionID: 46765

Mastering Master Data Services

Back to calendar

Event Date: 16-04-2016 - Session time: 15:00:00 - Track: BI Platform Architecture, Development Administration

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

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

Back to calendar

Event Date: 16-04-2016 - Session time: 15:00:00 - Track: Enterprise Database Administration Deployment

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

Get Testing with tSQLt

Back to calendar

Event Date: 16-04-2016 - Session time: 15:00:00 - Track: Application Database Development

Speaker: Steve Jones

Title: Get Testing with tSQLt

Abstract:

tSQLt is a testing framework that is designed to help you write repeatable, isolated tests against your database code. In this session we will briefly examine the goals of testing, where it can be used in an automated deployment pipeline, and introduce you to the tSQLt framework. We’ll show you how to design and write tests to enforce standards, check calculations and other DML operations as well as check exception handling. You will see how a real world refactoring task can be tested in a repeatable manner. Learn how you can incrementally write tests that help you build higher quality code and minimize the introduction of errors against your existing objects.

SessionID: 48623

Bare Naked Skinny on SQL Server

Back to calendar

Event Date: 16-04-2016 - Session time: 15:00:00 - Track: Enterprise Database Administration Deployment

Speaker: Jason Brimhall

Title: Bare Naked Skinny on SQL Server

Abstract:

Ever feel like there are just too many layers with SQL Server? You peel off a layer and behold there is yet another layer. SQL Server is rather complex. The complexities can be rather frustrating from time to time.

Join this NSFW (not safe for whining) session as we strip SQL down to the bare bones. I will help you undress the complexities of a few of the basic SQL Server concepts. These concepts will include locks, principals, query directives and deadlocks.

In this session I will disrobe misunderstandings related to the aforementioned topics. I will show the different types of principals in SQL Server. I will also show various scenarios involving locks and deadlocks along with some of their effects with and without query directives. The goal is to better understand these topics and to hopefully stop using and perpetuating common mis-uses of terminology and common misconceptions about the technology.

SessionID: 45601

Optimizing the SQL Server and Databases for large Fact Tables

Back to calendar

Event Date: 16-04-2016 - Session time: 16:00:00 - Track: Enterprise Database Administration Deployment

Speaker: Thomas Grohser

Title: Optimizing the SQL Server and Databases for large Fact Tables

Abstract:

A session full of demos demonstrating how SQL Server startup parameters, trace flags and the create database and alter database command when used correctly for the underlying hardware can make scanning your fact tables much faster.

We will also as a side effect explore the Mary Go Round query feature and find ways to bulk load data faster and how to load from an OLTP system with zero impact to it.

SessionID: 44820

Power BI Performance Tips

Back to calendar

Event Date: 16-04-2016 - Session time: 16:15:00 - Track: BI Platform Architecture, Development Administration

Speaker: Rachael Martino

Title: Power BI Performance Tips

Abstract:

It is quick and easy to build large, complex data models in Power BI (based on Power Pivot). However, Building a model that performs well might seem hit or miss unless you are aware of how Power BI manages your data. A Power BI data model can increase your model's size exponentially even for relatively small data sets causing significant performance issues. This session provides design techniques and tips that will have you building your own models to deliver solutions without those nasty performance surprises!

SessionID: 45295

Increase your SSIS productivity with Biml

Back to calendar

Event Date: 16-04-2016 - Session time: 16:15:00 - Track: BI Platform Architecture, Development Administration

Speaker: Reeves Smith

Title: Increase your SSIS productivity with Biml

Abstract:

Business Intelligence Markup Language (Biml) is an XML language for Microsoft Business Intelligence that can take your Integration Services package development to the next level. Creating template packages added productivity to your Integration Services development effort. If the template design changes after development begins, a fair amount of rework to packages could be needed. See how Biml can help create template packages that can better adapt to changing business needs and allow for more comprehensive design or redesign.

This session will be a demo based session that will inspire you to make Biml your number one integration services development tool. Learn how to use Biml scripts to create staging tables and integration services packages. Add metadata to your Biml scripts and really watch the possibilities expand.

SessionID: 45626

Top 5 SQL Server Mistakes

Back to calendar

Event Date: 16-04-2016 - Session time: 16:15:00 - Track: Enterprise Database Administration Deployment

Speaker: Kathi Kellenberger

Title: Top 5 SQL Server Mistakes

Abstract:

SQL Server is a popular and powerful relational database system. It's easy to install with just a few clicks. Create a database, and you are in business. It will run great without much attention...until it doesn't. It's true that your shop may not have enough SQL Server instances to require a full time DBA, but SQL Server still needs some love and attention to perform its best. Attend this session to learn about knobs that need turning and more to get the most out of SQL Server.

SessionID: 46052

Table Partitioning -Beyond the Basics

Back to calendar

Event Date: 16-04-2016 - Session time: 16:15:00 - Track: Strategy and Architecture

Speaker: Arnie Rowland

Title: Table Partitioning -Beyond the Basics

Abstract:

You've read about table partitioning; you know that partitioning ‘promises’ to solve some performance issues, make backups -and even restores, faster, and, wait, wait, there’s more! Perhaps you have worked through demo code and set up a POC scenario. It looks good, like maybe it would solve some of the problems your organization faces.

But …

You’re just not sure how to pull it off. Sure, the demo code made it seem easy -and it will always be realtively simple for new tables, new data. You have a handle on the ‘basics’. However, your production database has very large tables, hundreds of millions, or even billions, of rows. The SLA does not allow much, if any, downtime.

This session will look at how Table Partitioning can be introduced into existing production environments with little or no downtime And we will explore the ‘real’ performance and maintenance benefits that can be harvested. So, if you want to move beyond the ‘Basics’, don’t miss this session.

SessionID: 46455

Turbo Boost Performance: In Memory Tables index optimizations

Back to calendar

Event Date: 16-04-2016 - Session time: 16:15:00 - Track: Enterprise Database Administration Deployment

Speaker: Konstantin Melamud

Title: Turbo Boost Performance: In Memory Tables index optimizations

Abstract:

With the introduction of in-memory based tables in SQL Server 2014, it’s natural to expect significant increases in query performance. But what do we do when queries which utilize in-memory tables actually start to perform same or, in some cases, even worse than their equivalent disk based table predecessors? In this session, we are going to take a look at the changes to the indexing design for in-memory based objects and how it differs from existing disk based table indexing. Also, we are going to cover how to choose the appropriate indexes for your in-memory object to give you the performance boost that you have been expecting.

SessionID: 46596

Weird stuff I saw while supporting a Java team

Back to calendar

Event Date: 16-04-2016 - Session time: 16:15:00 - Track: Application Database Development

Speaker: Rick Lowe

Title: Weird stuff I saw while supporting a Java team

Abstract:

After spending the last decade or so completely devoted to the Microsoft stack, I spent the last year supporting the SQL Server instance for a team of Java developers. Yes, sure, Java is just another language so there aren't really and issues that are absolutely unique to the Java world. I did find, however, that there were cultural differences which made my biggest challenges different from what I was used to dealing with in the .Net world. Come hear about my misadventures with JBoss, server side cursors, and NOCOUNT settings.

SessionID: 46665

Phone Book Phun - Learning database concepts with the White Pages

Back to calendar

Event Date: 16-04-2016 - Session time: 16:15:00 - Track: Application Database Development

Speaker: Ben Thul

Title: Phone Book Phun - Learning database concepts with the White Pages

Abstract:

Come with me back to a simpler time - a time where children played outside by light from a streetlamp, people still listened to music on a cassette tape, and if you wanted to call someone, you looked up their phone number in the phone book (all the while learning some important database concepts).

Wait... what was that last part? In this session, you'll gain a deeper understanding of key indexing concepts such as clustering, included columns, sargability, and more through the lens of the good old White Pages.

SessionID: 46780

Welcome to Azure Stream Analytics

Back to calendar

Event Date: 16-04-2016 - Session time: 16:15:00 - Track: Analytics and Visualization

Speaker: Robert Miller

Title: Welcome to Azure Stream Analytics

Abstract:

Azure Stream Analytics is an Azure feature for the ingestion of Streaming Data. What is Streaming Data, how is it utilized in Azure Stream Analytics, how does Azure Stream Analytics compare to other open source products, and how does one use Stream Analytics. These questions will be addressed when you attend this session.

SessionID: 46787

Hi, my name is Powershell, let's be friends! An Intro to PoSH

Back to calendar

Event Date: 16-04-2016 - Session time: 16:15:00 - Track: Enterprise Database Administration Deployment

Speaker: Amy Herold

Title: Hi, my name is Powershell, let's be friends! An Intro to PoSH

Abstract:

Powershell wants to be your friend - your very powerful friend. In this session we will go over some Powershell basics that will help get you started as well as some known "gotchas" when working in Powershell. This is a beginner session - no Powershell experience necessary. WARNING: You may get warm-fuzzies about Powershell by attending this session.

SessionID: 48128

The Business Intelligence Side of SQL Server

Back to calendar

Event Date: 16-04-2016 - Session time: 16:15:00 - Track: BI Information Delivery

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, will explore the improvements to SQL Server self-service reporting and talk about creating blended 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.

SessionID: 48622

Working with Object Compression in SQL Server

Back to calendar

Event Date: 16-04-2016 - Session time: 16:15:00 - Track: Enterprise Database Administration Deployment

Speaker: Jason Brimhall

Title: Working with Object Compression in SQL Server

Abstract:

"SQL Server 2008 introduced object compression to the DBA toolkit. We all know there are different kinds of compression available in SQL Server. What you might not know boils down to some subtleties of compression. For example, not all page compressed objects are entirely page compressed. Many pages can be uncompressed or just row-compressed.

This session shows you how to reach into the database and discover compression states at the page level. At the lower level, this session also shows how to determine compression settings of objects in the database. You can use both some undocumented and more commonly known commands to derive some interesting information from the database engine. "

SessionID: 49686

Power BI Desktop – A BI developer’s view

Back to calendar

Event Date: 16-04-2016 - Session time: 16:15:00 - Track: BI Information Delivery

Speaker: Phil Robinson

Title: Power BI Desktop – A BI developer’s view

Abstract:

Power BI Desktop is the new self-service entry in the Microsoft BI development landscape but what does it offer the professional BI developer?

This session will explore Power BI Desktop features for data accusation and manipulation, sample some of the visualization provided and review the deployment options.

This site is open source. Improve this page.