sqlsathistory

Nr: 493

Back to Main list

SQLSaturday #493 - Silicon Valley 2016

Start Time (24h) Speaker Track Title
10:30:00 Anthony van Gemert Application Database Development MICROSOFT: SQL Server Stretch Database
10:30:00 Eric Peterson Enterprise Database Administration Deployment SQL Server 2016 - New DBMS Features and examples
10:30:00 Prakash Heda Enterprise Database Administration Deployment Detect Worst Performing SQL Queries During Peak Hour
10:30:00 Mark Van de Wiel Enterprise Database Administration Deployment Transaction Log Fundamentals
10:30:00 Paul Bertucci BI Platform Architecture, Development Administration Plugging Data Quality as a Service into Big Data
10:30:00 Eric Bragas Analytics Visualization Intro to DAX Patterns
11:45:00 J May Enterprise Database Administration Deployment Hardware for Nothing, Get Your Flash for Free
11:45:00 Reesha Dedhia Enterprise Database Administration Deployment Reduce deployment + management costs and make your employees more
11:45:00 Jason Picker BI Information Delivery In BI, one size does not fit all
11:45:00 Mark Van de Wiel BI Information Delivery Real-time data delivery may be easier than you think
11:45:00 Trent Mera Enterprise Database Administration Deployment Manage SQL Server performance with Spotlight on SQL Server
11:45:00 Bryan Walsh Enterprise Database Administration Deployment Transform Database Agility with XtremIO
13:15:00 Christopher Wolff Application Database Development Continuous Deployments using SSDT
13:15:00 Thomas LaRock Enterprise Database Administration Deployment Cardinality Estimates in Microsoft SQL Server 2014
13:15:00 Reeves Smith Advanced Analysis Techniques The New Revolution in Data Science, R Integrated into SQL Server
13:15:00 Sahaj Saini Analytics Visualization PolyBase in SQL Server 2016: Query Hadoop with ease
13:15:00 Arnie Rowland Strategy and Architecture Table Partitioning -Beyond the Basics
13:15:00 Angel Abundez BI Information Delivery Tabular Modeling for Power BI
14:30:00 Scott McCormick Cloud Application Development Deployment DBaaS Overview Migration - A Practical Guide
14:30:00 Tim Ford Enterprise Database Administration Deployment How Good Is Your Indexing Strategy?
14:30:00 Reeves Smith BI Platform Architecture, Development Administration Increase your SSIS productivity with Biml
14:30:00 Karen Lopez Application Database Development The Key to Keys
14:30:00 Ben Thul Application Database Development Phone Book Phun - Learning database concepts with the White Pages
14:30:00 Mark Kidwell Big Data and Cloud Metadata-driven schema evolution - building robust ELT workflows
15:00:00 Joshua Vickery Analytics Visualization Microsoft Visual Analytics: painting the picture
15:45:00 Daniel Janik Advanced Analysis Techniques Analyze your query plan like a Microsoft Engineer!
15:45:00 Russ Thomas BI Platform Architecture, Development Administration In Memory Tables; Not Just For OLTP
15:45:00 J May Enterprise Database Administration Deployment SQL Server 2016 AlwaysOn AGs Break-through Perf Enhancements
15:45:00 Brandon Leach Enterprise Database Administration Deployment Data Pages, Allocation Units, IAM chains... Oh My!
15:45:00 Rajesh Agadi Strategy and Architecture IoT For Data Guys
15:45:00 Kevin Boles Application Database Development Query Plan Deep Drive
16:45:00 Jarek Kazmierczak Analytics Visualization Cortana Analytics Suite: acceleration of intelligent solutions
17:00:00 Simon Cho BI Information Delivery Best Practice for ETL - How to use minimal logging, and when?
17:00:00 Thomas Grohser Enterprise Database Administration Deployment Establishing a SLA
17:00:00 Mitchell Bottel Bonus Lightning Talks - Sacramento SQL Server User Group
17:00:00 Kevin Boles Application Database Development Common TSQL Mistakes
17:00:00 Kimate Richards Application Database Development Developing for Mobile with Azure Mobile App Service

SessionID: 41911

MICROSOFT: SQL Server Stretch Database

Back to calendar

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

Speaker: Anthony van Gemert

Title: MICROSOFT: SQL Server Stretch Database

Abstract:

Your SAN consumption is increasing faster than your budget, you have tables so big that you dread re-indexing, or your end-users demand their cold or archived data always be online. There’s a solution that lets you take advantage of the Cloud, on your terms, all without impacting your existing end-user applications or queries.

Come find out how you can move your data securely and transparently, free up disc space and reduce your SAN consumption, while retaining full control from the on-premises SQL Server. You’ll reduce maintenance operations time and resources, plus lower overall cost. Learn how SQL Stretch database will simplify your journey to the Cloud!

SessionID: 42563

SQL Server 2016 - New DBMS Features and examples

Back to calendar

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

Speaker: Eric Peterson

Title: SQL Server 2016 - New DBMS Features and examples

Abstract:

Microsoft has released an advanced version of SQL Server 2016.

My job as lead architect is to implement these new features, and see how they actually work. The session will cover the following subject areas and include examples of usage:

SessionID: 45083

Detect Worst Performing SQL Queries During Peak Hour

Back to calendar

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

Speaker: Prakash Heda

Title: Detect Worst Performing SQL Queries During Peak Hour

Abstract:

How many times you have been thrown in a situation when you have been asked to fix performance issues of a database system which you have never seen before? Where do you start tuning? When do you stop tuning? Each application is different. With the ever increasing number of systems one production DBA has to manage today, it's very important to use TOP to BOTTOM approach to troubleshoot performance issues, which will lead to the answers in the right way for the application under consideration.

While you can find top queries, wouldn't it be awesome if you can find out which ones are the exact queries taking most of the resources in last hour and current situation? Now you can focus on those specific queries!

In this session, Prakash walks you through with scenario demos to find which exact queries are taxing production systems resources based on CPU/DISK/Memory/Network. They are all based on his own real-life experience from managing demanding database systems.

SessionID: 46468

Transaction Log Fundamentals

Back to calendar

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

Speaker: Mark Van de Wiel

Title: Transaction Log Fundamentals

Abstract:

ACID anyone?

Over time SQL Server management has become more and more automated and wizard-driven. With this automation there is less understanding of the fundamentals of the database, starting with the transaction log.

This session will remind the audience about the function of the transaction log, as well as what does (or doesn't) get written to the transaction log. This session will touch on topics such as SQL Server Replication and the impact it has on the transaction log, as well as the truncation point.

And acronyms such as ACID will be clarified.

SessionID: 47858

Plugging Data Quality as a Service into Big Data

Back to calendar

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

Speaker: Paul Bertucci

Title: Plugging Data Quality as a Service into Big Data

Abstract:

Mr. Bertucci will present the architecture, implementation, and provide a live demo of how he plugged the SQL Server based MDS (Master Data Management) into a Hadoop based Big Data Platform at one of the largest Silicon Valley chip manufacturers in the world. This will include a step-by-step explanation of this complex architecture which includes the Hadoop/Cloudera big data platform, Data Quality as a Service (DQaaS) web service capabilities, Profisee's Maestro master data tools, and Microsoft SQL Server's MDS Master Data Management capabilities. Presentation will also include a live demo of how big data is cleansed (Mastered) and the lessons learned along the way. Mr. Bertucci is one of the world' leading database and master data management authorities, the author of the SQL Server Unleashed series of books and a frequent speaker at industry database and data quality conferences around the world.

SessionID: 48563

Intro to DAX Patterns

Back to calendar

Event Date: 09-04-2016 - Session time: 10:30:00 - Track: Analytics Visualization

Speaker: Eric Bragas

Title: Intro to DAX Patterns

Abstract:

Whether you are an Excel Pro, BI Developer, or Data Architect, sooner or later you're going to find it helpful to know a little DAX and a few DAX Patterns. DAX, the Data Analysis Expression Language is the future of insight development in tools such as: Excel, Analysis Services Tabular, and the new Power BI Desktop. Using DAX and these DAX Patterns, you'll be able to define both centralized and ad hoc metrics for blazing fast data analysis!

SessionID: 47157

Hardware for Nothing, Get Your Flash for Free

Back to calendar

Event Date: 09-04-2016 - Session time: 11:45:00 - Track: Enterprise Database Administration Deployment

Speaker: J May

Title: Hardware for Nothing, Get Your Flash for Free

Abstract:

By now, Tier 1 apps deployed on flash is ubiquitous. However, Tier 2 apps often remain relegated to spinning media. This presentation explains the economics of consolidating on flash. Owing to the SQL Server core licensing model, licensing a 2-socket commodity server can cost up to $500,000 or more! Consolidating instances on flash can—and does—save hundreds of thousands to millions of dollars. This presentation provides real-life case studies showing such real-life savings.

SessionID: 47571

Reduce deployment + management costs and make your employees more

Back to calendar

Event Date: 09-04-2016 - Session time: 11:45:00 - Track: Enterprise Database Administration Deployment

Speaker: Reesha Dedhia

Title: Reduce deployment + management costs and make your employees more

Abstract:

77% reduction in time of your employees for deployment; 68% reduction in time of your employees for management; 96% reduction of your employees time dealing with down time; 368% ROI;$5 million reduction in costs over 5 years for your Data Center. Come and listen to how all of this is possible and why choosing the right platform can make these differences.

SessionID: 47644

In BI, one size does not fit all

Back to calendar

Event Date: 09-04-2016 - Session time: 11:45:00 - Track: BI Information Delivery

Speaker: Jason Picker

Title: In BI, one size does not fit all

Abstract:

Don’t be fooled by a vendor’s claims that their BI tool is all you need to solve your organization’s business intelligence needs. In this session we will discuss the varied business intelligence needs of an organization and how to solve them. Understand the differences between reporting and analytics and between self-service needs and the needs of IT. We will see examples of using the best tools for the best job and bringing them together in a unified interface.

SessionID: 48685

Real-time data delivery may be easier than you think

Back to calendar

Event Date: 09-04-2016 - Session time: 11:45:00 - Track: BI Information Delivery

Speaker: Mark Van de Wiel

Title: Real-time data delivery may be easier than you think

Abstract:

Join this session to learn how quickly you can integrate - in real-time - data from SQL Server and other relational databases into a SQL Server database, on premises or in Azure. This session will show a live, end-to-end demonstration of a Business Intelligence scenario.

SessionID: 48833

Manage SQL Server performance with Spotlight on SQL Server

Back to calendar

Event Date: 09-04-2016 - Session time: 11:45:00 - Track: Enterprise Database Administration Deployment

Speaker: Trent Mera

Title: Manage SQL Server performance with Spotlight on SQL Server

Abstract:

Trent will show you to get real-time notification and rapid diagnoses of your SQL Server performance problems using Dell Software’s Spotlight on SQL Server. Spotlight on SQL Server gives real-time alerts and brings together all of your critical SQL Server metrics onto a single dashboard-type screen, color-coded for problem severity and clickable for drilling down to the details and root causes of problems.

SessionID: 49197

Transform Database Agility with XtremIO

Back to calendar

Event Date: 09-04-2016 - Session time: 11:45:00 - Track: Enterprise Database Administration Deployment

Speaker: Bryan Walsh

Title: Transform Database Agility with XtremIO

Abstract:

: All-Flash Arrays deliver IOPS in abundance. XtremIO goes further to provide predictable, consistent sub-millisecond latency and unleash agility for your SQL Server databases. Our unique XtremIO Virtual Copies (XVC) capabilities allow for fully writable copies for production, test/dev, reporting/analytics workloads on our market leading consolidation platform. This allows for consolidation of your SQL Server based environments onto a single array to maximize efficiency.

SessionID: 42481

Continuous Deployments using SSDT

Back to calendar

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

Speaker: Christopher Wolff

Title: Continuous Deployments using SSDT

Abstract:

DevOps is a word that gets thrown around a lot these days and is the way most shops will operate in the future. In my presentation I'll show you how to fast forward to the future by automating your deployments from SSDT using Powershell and SQLPackage.exe.

SessionID: 42884

Cardinality Estimates in Microsoft SQL Server 2014

Back to calendar

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

Speaker: Thomas LaRock

Title: Cardinality Estimates in Microsoft SQL Server 2014

Abstract:

SQL Server 2014 includes a new cardinality estimator. This feature allows for statistics to be updated more frequently than previous versions of SQL Server, resulting in better query performance. Attend this session and understand how, why, and when SQL Server uses statistics and how this new feature will help improve performance.

SessionID: 45293

The New Revolution in Data Science, R Integrated into SQL Server

Back to calendar

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

Speaker: Reeves Smith

Title: The New Revolution in Data Science, R Integrated into SQL Server

Abstract:

Data Science is an ever increasing topic in the Data Analytics space and the R language is at the center of most conversations. R is an open source statistical language that is rapidly gaining popularity due to a robust set of machine learning functionality and a never-ending set of R packages that are used to increase functionality of the core R language. The R language is run as a desktop application and was not built with performance and scale required to accommodate Big Data. Revolution Analytics, a wholly owned subsidiary of Microsoft, has solved the performance and scaling issues of a desktop application by creating a more robust enterprise architecture. SQL Server 2016 brings the power of R and Revolution Analytics into the industry leading relational database.

This session will demo the functionality and power of using R within SQL Server.

SessionID: 45749

PolyBase in SQL Server 2016: Query Hadoop with ease

Back to calendar

Event Date: 09-04-2016 - Session time: 13:15:00 - Track: Analytics Visualization

Speaker: Sahaj Saini

Title: PolyBase in SQL Server 2016: Query Hadoop with ease

Abstract:

With the increased volumes of unstructured and semi-structured data , organizations are adopting heterogeneous data stores like Hadoop and cloud, requiring new skill sets to operate and making it harder for DBAs to build applications over them. This session will describe PolyBase, a new feature in SQL Server 2016, that will open the doors to data stored outside of SQL Server. PolyBase allows customers to use T-SQL to access and query data residing in Hadoop or Azure blob storage. It can intelligently push-down computation to Hadoop by generating Map jobs on-the-fly as well as scale-out query processing in SQL Server to enable highly performant queries on massive Hadoop data sets.

This session will cover the PolyBase fundamentals of what the feature is, how customers are using it and how it works under-the-covers. In addition, the session will include a Live Demonstration of how PolyBase can be used to bring relational and semi-structured data together using SQL skill sets.

SessionID: 46051

Table Partitioning -Beyond the Basics

Back to calendar

Event Date: 09-04-2016 - Session time: 13: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: 48562

Tabular Modeling for Power BI

Back to calendar

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

Speaker: Angel Abundez

Title: Tabular Modeling for Power BI

Abstract:

In this session, we'll learn how to make Tabular models intuitive and useful for your end users of Power BI. We'll focus on the Power BI interface and the capabilities within Tabular model that can enable end users to build dynamic reports and dashboards. We'll also review the prerequisites for setting up a secure hybrid cloud environment for your enterprise.

SessionID: 42517

DBaaS Overview Migration - A Practical Guide

Back to calendar

Event Date: 09-04-2016 - Session time: 14:30:00 - Track: Cloud Application Development Deployment

Speaker: Scott McCormick

Title: DBaaS Overview Migration - A Practical Guide

Abstract:

Amazon, Microsoft, VMWare, and many other companies are opening up Database-as-a-Service to the general public. These new database offerings can be perceived as a threat as well as a source of confusion to a DBA, but they're coming and you need to be ready.

In this presentation, Scott McCormick will cover Amazon's and Microsoft's DBaaS products. These are the leading SQL Server DBaaS vendors, and they have the most complete offerings to date.

You'll learn about: * Current DBaaS flavors and their future * Use cases for DBaaS instances * Security Best Practices for a DBaaS environment * Pros Cons of Amazon Microsoft DBaaS *** Including a cost comparison of each performance tier * How to migrate your database *** A walk through of Amazon's AWS Migration tool *** A walk through of migrating to Microsoft's Azure SQL DB using replication

SessionID: 42605

How Good Is Your Indexing Strategy?

Back to calendar

Event Date: 09-04-2016 - Session time: 14:30:00 - Track: Enterprise Database Administration Deployment

Speaker: Tim Ford

Title: How Good Is Your Indexing Strategy?

Abstract:

Like Frankenstein's Monster (or our teenagers) things get released into the wild and behave differently than planned - database usage patterns are no different. Join Tim as he reviews what to look for when tweaking your index strategy: poor clustering key decisions, underutilized indexes, covering indexes gone wrong, overlooked heaps and fill factor failures are just a few of the blunders to be identified.

A working knowledge of Dynamic Management Objects, indexing internals, and eagerness to experiment with metadata is a prerequisite!

SessionID: 45292

Increase your SSIS productivity with Biml

Back to calendar

Event Date: 09-04-2016 - Session time: 14:30: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: 45714

The Key to Keys

Back to calendar

Event Date: 09-04-2016 - Session time: 14:30:00 - Track: Application Database Development

Speaker: Karen Lopez

Title: The Key to Keys

Abstract:

So many of us have learned database design approaches from working with one database or data technology. We may have used only one data modeling or development tool. That means our vocabularies around identifiers and keys tend to be product specific. Do you know the difference between a unique index and a unique key? What about the difference between RI, FK and AK?

These concepts span data activities and it's important that your team understand each other and where they, their tools and approaches need to support these features.

We'll look at the generic and proprietary terms for these concepts, as well as where they fit in the database design process. We'll also look at implementation options in SQL Server and other DBMSs.

SessionID: 46679

Phone Book Phun - Learning database concepts with the White Pages

Back to calendar

Event Date: 09-04-2016 - Session time: 14:30: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: 47854

Metadata-driven schema evolution - building robust ELT workflows

Back to calendar

Event Date: 09-04-2016 - Session time: 14:30:00 - Track: Big Data and Cloud

Speaker: Mark Kidwell

Title: Metadata-driven schema evolution - building robust ELT workflows

Abstract:

Hadoop excels at running many large ETL/ELT workflows that previously ran on more expensive proprietary platforms. But when legacy tools and techniques are simply ported to work with Hadoop, they often bring the same legacy issues - brittleness due to their inability to support rapidly changing data sources and structures. And when more resilient processes are built to support an agile data lake, they often forgo metadata management, which makes later consumption by applications and users more difficult.

This presentation will discuss combining a metadata-driven schema evolution platform with existing tools in the Hadoop ecosystem (especially Hive and Impala) to:

SessionID: 47864

Microsoft Visual Analytics: painting the picture

Back to calendar

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

Speaker: Joshua Vickery

Title: Microsoft Visual Analytics: painting the picture

Abstract:

Come learn about the evolving landscape of Microsoft Visual Analytics. We'll cover Power BI, reporting services and the new mobile dashboarding functionality. Watch the product in action as we build live, integrated dashboards together.

SessionID: 42673

Analyze your query plan like a Microsoft Engineer!

Back to calendar

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

Speaker: Daniel Janik

Title: Analyze your query plan like a Microsoft Engineer!

Abstract:

This session is a deep dive into query plans and is presented by a former Microsoft PFE (Field Engineer). Learn how a Microsoft Engineer looks at plans and go beyond the typical! There will be plenty of demos and a lot to learn. Join me as I cover the "noteworthy" query plan patterns that go beyond the normal areas that customer tend to investigate. This session covers SQL Server 2005 forward and includes the new SQL Server 2016 Query Store and Live Query Statistics.

SessionID: 44708

In Memory Tables; Not Just For OLTP

Back to calendar

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

Speaker: Russ Thomas

Title: In Memory Tables; Not Just For OLTP

Abstract:

In Memory OLTP is one of the most popular features of SQL Server 2014. Many BI professionals are finding memory optimized objects make excellent tools in the quiver of the ETL developer as well. Attend this session to see how "hekaton", memory optimized objects, native stored procedures, and schema only designs can be applied to staging and transformations to achieve incredible performance gains over traditional models.

SessionID: 45723

SQL Server 2016 AlwaysOn AGs Break-through Perf Enhancements

Back to calendar

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

Speaker: J May

Title: SQL Server 2016 AlwaysOn AGs Break-through Perf Enhancements

Abstract:

SQL Server 2012 AlwaysOn Availability Groups shipped with two built-in bottlenecks: the network transport and log redo mechanisms compromised performance and availability of high performance environments. SQL Server 2014 failed to remediate these challenges. However, SQL Server 2016 provides significant performance enhancements which permit us to more fully leverage hardware and licensing investments including processors, storage, network, and core licensing.

SessionID: 46434

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

Back to calendar

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

Speaker: Brandon Leach

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

Abstract:

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

IoT For Data Guys

Back to calendar

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

Speaker: Rajesh Agadi

Title: IoT For Data Guys

Abstract:

Introduction to IoT

Strategy for IoT IoT Use Cases IoT Analytics

SessionID: 47134

Query Plan Deep Drive

Back to calendar

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

Speaker: Kevin Boles

Title: Query Plan Deep Drive

Abstract:

Another in TheSQLGuru's Deep Dive series! Query plans - the roadmaps of how your query will be handled by the engine. TONs of information for the asute SQL Server user. Lets dig into them and see what we can learn from and about them and also talk about how they can be used to aid our query tuning efforts.

SessionID: 48895

Cortana Analytics Suite: acceleration of intelligent solutions

Back to calendar

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

Speaker: Jarek Kazmierczak

Title: Cortana Analytics Suite: acceleration of intelligent solutions

Abstract:

A new era of business analytics is emerging, driven by an explosion of new data sources, an accelerated adoption of cloud computing, and a rise of machine learning and advanced analytics methods. Cortana Analytics, a fully managed big data and advanced analytics suite, embodies this paradigm shift. During the session, we will outline Microsoft’s advanced analytics vision, take a deep dive into the core components of Cortana Analytics Suite and demonstrate how Cortana Analytics streamlines data science processes and accelerates development of the state-of-the-art, intelligent solutions.

SessionID: 41876

Best Practice for ETL - How to use minimal logging, and when?

Back to calendar

Event Date: 09-04-2016 - Session time: 17:00:00 - Track: BI Information Delivery

Speaker: Simon Cho

Title: Best Practice for ETL - How to use minimal logging, and when?

Abstract:

This session is designed for production DBAs and Developers who are working on high volume data transfer.

I prepare many common mistakes people make with their ETL jobs, and how to do it right. I will introduce Minimal Logging, and discuss how to determine when minimal logging is appropriate. Wewill compare logs that are fully logged and minimal logged.

SessionID: 42541

Establishing a SLA

Back to calendar

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

Speaker: Thomas Grohser

Title: Establishing a SLA

Abstract:

Most DBA's rarely establish Service Level Agreements (SLA) with the Management and if they do they sometimes just come up with some random numbers for availability. Then when at some point something goes really wrong everybody wonders why it takes so long to bring everything back online.

#160; This Session will teach you how to ask the right questions, analyze your databases and servers and generate from the gathered data a realistic SLA.

SessionID: 46436

Lightning Talks - Sacramento SQL Server User Group

Back to calendar

Event Date: 09-04-2016 - Session time: 17:00:00 - Track: Bonus

Speaker: Mitchell Bottel

Title: Lightning Talks - Sacramento SQL Server User Group

Abstract:

LT1:

Title: SSRS report development for SSMS Description: Have you ever used the standard Microsoft reports in SSMS, reports that help show server activity, performance counters or missing indexes? Ever thought you could make a better looking report, or just wanted to visualize something else in your environment? This session will outline how to develop SSRS reports for use in SSMS, showing some of the default parameters that SSMS uses. We'll also see some live reports visualizing jobs and databases as an example.

LT2: Title: Getting Started with SQL Server Data Compression Description: The Enterprise Edition of SQL Server has offered native data compression since the 2008 version, but are you using it?

LT3: Title: Hidden Gems of SSMS Description: We will show you some of the unknown features of SSMS that will make your life easier.

LT4: Title: Auditing using SQL Audit Description: This session will provide a quick overview of auditing user actions using SQL Server Audit

SessionID: 47133

Common TSQL Mistakes

Back to calendar

Event Date: 09-04-2016 - Session time: 17:00:00 - Track: Application Database Development

Speaker: Kevin Boles

Title: Common TSQL Mistakes

Abstract:

We are going to examine a variety of oopsies MANY developers fall prey too - some obvious, some pretty subtle and some down right sneaky! Lots of code examples with the bad AND good code presented. I GUARANTEE that you will find things here that will either prevent you from getting bad data, throwing unwanted errors or vastly improving your database application's performance. I have given this talk over SEVENTY times now and it is always very highly rated!

SessionID: 48558

Developing for Mobile with Azure Mobile App Service

Back to calendar

Event Date: 09-04-2016 - Session time: 17:00:00 - Track: Application Database Development

Speaker: Kimate Richards

Title: Developing for Mobile with Azure Mobile App Service

Abstract:

We will discuss the various methods of presentation of data in applications, connectivity and services available in the Azure Mobile Apps suite. We will create a database and webserver and discuss the options available to the novice mobile developer to get started quickly with a limited set of knowledge about mobile applications. We will specifically use C# and Swift 2 for development and XCode and Visual Studio to demonstrate the mentioned functions. We will also briefly discuss Xamarin, Android, Android for Work and Hybrid Technologies.

This site is open source. Improve this page.