sqlsathistory

Nr: 478

Back to Main list

SQLSaturday #478 - Albuquerque 2016

Start Time (24h) Speaker Track Title
08:30:00 Alan Faulkner BI Information Delivery SSAS Multidimensional vs. SSAS Tabular – Which one do I use?
08:30:00 Christopher Wolff Enterprise Database Administration Deployment Fun with Availability Groups
08:30:00 TJay Belt Cloud Application Development Deployment Hadoop, Hive, JSON, and Data! Oh, my!
08:30:00 Julia Renz Cloud Application Development Deployment The Internet of Things (IoT)
08:30:00 Michael Fal Enterprise Database Administration Deployment Powershell Jumpstart for SQL Server DBAs
08:30:00 Jay Robinson DEV EXEC and sp_executesql: An ad hoc rally
09:50:00 Mindy Curnutt Application Database Development TSQL Coding Techniques - Are You Playing with Fire?
09:50:00 Monica Rathbun Professional Development I'm It - Survival Techniques for the Lone DBA
09:50:00 Rick Lowe Enterprise Database Administration Deployment Why should I care about the plan cache?
09:50:00 Rushabh Mehta BI Platform Architecture, Development Administration Mastering and Enhancing Company Data
09:50:00 Ginger Grant Advanced Analysis Techniques Incorporating Azure Machine Learning to SQL Server Environments
09:50:00 Martin Schoombee BI Information Delivery MDX: Troubleshooting Tips Tricks
09:50:00 Carlos Bossy BI Platform Architecture, Development Administration Getting started with Big Data and BI
11:10:00 Russ Thomas BI Platform Architecture, Development Administration In Memory Tables; Not Just For OLTP
11:10:00 Tim Mitchell BI Platform Architecture, Development Administration Testing SSIS Packages
11:10:00 Leslie Weed BI Platform Architecture, Development Administration Source Control practices for your BI World
11:10:00 Jamey Johnston Analytics and Visualization Introduction to R and Data Science Tools in the Microsoft Stack
11:10:00 Steve Jones Professional Development Branding Yourself for a Dream Job
11:10:00 Seth Washeck Enterprise Database Administration Deployment VLT Shootout
12:30:00 Dylan Newlander BI How to be agile building the data warehouse with WhereScape RED
13:30:00 J May Enterprise Database Administration Deployment Intro to Monitoring I/O: The Counters That Count
13:40:00 Jay Robinson Application Database Development Adding Lightness: Better Performance Through Compression
13:40:00 Steve Wake BI Information Delivery Power BI is Awesome!
13:40:00 John Morehouse Application Database Development Database Continuous Delivery Your Salvation!
13:40:00 Kevin Boles Application Database Development Windowing Functions: THE Reason to Upgrade to 2012+
13:40:00 Todd Kleinhans Enterprise Database Administration Deployment Always Encrypted in SQL Server 2016
13:40:00 Naomi Williams DBA SQL Server Internals
15:00:00 John Martin Enterprise Database Administration Deployment SQL Server 2016, New Features Enhancements
15:00:00 Mike Byrd Application Database Development SQL Server Foreign Keys – De-mystifying the Rest of the Story
15:00:00 Reeves Smith BI Platform Architecture, Development Administration Increase your SSIS Productivity with Biml
15:00:00 Amy Herold Enterprise Database Administration Deployment Beginning Automation with Powershell
15:00:00 Kevin Boles Enterprise Database Administration Deployment SQL Server Defaults SUCK!!
15:00:00 Andre DuBois Enterprise Database Administration Deployment 15 Things to ensure survivability of your database
16:20:00 William E Pearson III BI Platform Architecture, Development Administration Design and Implement BI Like Edison!
16:20:00 Thane Schaffer Application Database Development Critical Path SQL
16:20:00 Benjamin Reyes Enterprise Database Administration Deployment The Hangover - Ben has really broken his SQL Server
16:20:00 Meagan Longoria Analytics and Visualization Overcoming Chartaphobia And Moving Toward Enlightening Data Viz
16:20:00 Gabriel Villa Cloud Application Development Deployment Getting Started with Databases on Amazon Web Services

SessionID: 40980

SSAS Multidimensional vs. SSAS Tabular – Which one do I use?

Back to calendar

Event Date: 20-02-2016 - Session time: 08:30:00 - Track: BI Information Delivery

Speaker: Alan Faulkner

Title: SSAS Multidimensional vs. SSAS Tabular – Which one do I use?

Abstract:

With the release of SQL Server 2012, we were introduced to two possible options when it came to Analysis Services. This ultimately presented a question…”Which one do I use SSAS multidimensional or SSAS tabular”?

Determining whether multidimensional or tabular is the optimum solution for your organization is a key step when working with SQL Server Analysis Services 2012/2014. This session will introduce you to some of the common pitfalls with each solution and how you can avoid them. By the end of this session, you’ll have a clearer understanding of the strengths and weakness of each model and how your organization can optimally leverage the strengths of SSAS 2012/2014.

SessionID: 41279

Fun with Availability Groups

Back to calendar

Event Date: 20-02-2016 - Session time: 08:30:00 - Track: Enterprise Database Administration Deployment

Speaker: Christopher Wolff

Title: Fun with Availability Groups

Abstract:

Follow along as we adventure through the vastness that is Availability Groups in SQL Server. In this beginners guys we show you how to make an Availability Group from scratch, the new system tables that go along with Availability Groups, and how to troubleshoot your Availability Group using the system tables and SSMS.

SessionID: 42483

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

Back to calendar

Event Date: 20-02-2016 - Session time: 08:30: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: 44229

The Internet of Things (IoT)

Back to calendar

Event Date: 20-02-2016 - Session time: 08:30:00 - Track: Cloud Application Development Deployment

Speaker: Julia Renz

Title: The Internet of Things (IoT)

Abstract:

SessionID: 44273

Powershell Jumpstart for SQL Server DBAs

Back to calendar

Event Date: 20-02-2016 - Session time: 08:30:00 - Track: Enterprise Database Administration Deployment

Speaker: Michael Fal

Title: Powershell Jumpstart for SQL Server DBAs

Abstract:

Powershell can be hard. As a language, it is fairly complex and provides a large array of functionality. Fortunately, you can teach yourself how to use Powershell with tools that are built right into the language. This session will cover some Powershell fundamentals, how you can use Powershell itself to learn about concepts and syntax, and techniques for using Powershell with SQL Server. We will focus on core language patterns that you can use immediately, taking the mystery out of the code and helping you start writing your own Powershell scripts. The key to learning Powershell is using it and this session will give you a launchpad to start building your own tools.

SessionID: 46767

EXEC and sp_executesql: An ad hoc rally

Back to calendar

Event Date: 20-02-2016 - Session time: 08:30:00 - Track: DEV

Speaker: Jay Robinson

Title: EXEC and sp_executesql: An ad hoc rally

Abstract:

The EXEC statement provides plenty of flexibility, and sp_executesql offers even more benefits on top of that. But both have their drawbacks, their nuances, and their impact on performance. After this session, you will know what to expect from the query processor when using these features in your code and how to get the most performance out of them.

SessionID: 40554

TSQL Coding Techniques - Are You Playing with Fire?

Back to calendar

Event Date: 20-02-2016 - Session time: 09:50:00 - Track: Application Database Development

Speaker: Mindy Curnutt

Title: TSQL Coding Techniques - Are You Playing with Fire?

Abstract:

The good news? T-SQL is one of the easiest coding languages to learn. The bad news? Writing scalable T-SQL that performs optimally is an art that takes years to master. In this session, learn about some common T-SQL Troublemakers - Looping, Scalar Functions, Implicit Conversions, Non-Parameterized SQL, Parameter Sniffing and Value List Handling. Through examples and demos in this session you will witness the situational pitfalls of the techniques above. With each demo, you will be given an alternate T-SQL solution that solves the same problem in an efficient and scalable manner. Let's get things moving!

SessionID: 40569

I'm It - Survival Techniques for the Lone DBA

Back to calendar

Event Date: 20-02-2016 - Session time: 09:50:00 - Track: Professional Development

Speaker: Monica Rathbun

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

Abstract:

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

SessionID: 40703

Why should I care about the plan cache?

Back to calendar

Event Date: 20-02-2016 - Session time: 09:50:00 - Track: Enterprise Database Administration Deployment

Speaker: Rick Lowe

Title: Why should I care about the plan cache?

Abstract:

SQL Server is a huge product, with many different places a DBA can go to look for information on how the server is performing. So many in fact that they can often overlap, which sometimes makes it hard to understand why tackling a new tool is worth the effort. In this first (and hopefully not last) installment of Rick's "Why should I care" series a case for why working knowledge of how to query the plan cache is critical for performance tuning efforts in real world environments, followed by a review of relevant DMV's for the newly motivated audience. Perfect for those who are relatively new to performance tuning concerns, or advanced DBAs trying to figure out how to have a similar conversation with their less experienced peers, or developers who are curious as to why their DBA is sometimes so moody.

SessionID: 41538

Mastering and Enhancing Company Data

Back to calendar

Event Date: 20-02-2016 - Session time: 09:50:00 - Track: BI Platform Architecture, Development Administration

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

Incorporating Azure Machine Learning to SQL Server Environments

Back to calendar

Event Date: 20-02-2016 - Session time: 09:50:00 - Track: Advanced Analysis Techniques

Speaker: Ginger Grant

Title: Incorporating Azure Machine Learning to SQL Server Environments

Abstract:

Azure Machine Learning [ML] is a great tool for gathering more insight with your data, but how do you know if the models you are using are providing the best results? How do you apply modules customized to analyze your data? After this session you will have the answers to these questions, as well as the knowledge necessary to implement machine learning data analysis into your data environment.

Using Azure based SQL Server, attendees will learn rules which can be used to classify the data and the type of analysis desired by Azure ML. Building upon this information, the best methods for determining which ML models to use will be shown. This presentation will demo how to extend the flexibility of Azure ML by implementing custom analysis from other sources. Incorporating items created in R and SQL will show the expanded capabilities available outside of the existing ML components. Lastly we will deploy the Azure ML solution and incorporate the results into our SQL Server Database.

SessionID: 44175

MDX: Troubleshooting Tips Tricks

Back to calendar

Event Date: 20-02-2016 - Session time: 09:50: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: 44252

Getting started with Big Data and BI

Back to calendar

Event Date: 20-02-2016 - Session time: 09:50:00 - Track: BI Platform Architecture, Development Administration

Speaker: Carlos Bossy

Title: Getting started with Big Data and BI

Abstract:

HDInsight is the latest evolution of Hadoop on the Windows platform. It allows you to manage big and unstructured data while using the rich Business Intelligence tools provided by SQL Server. This session will cover big data architecture and demonstrate map/reduce, the nucleus of big data technology. You will also see how you to get maximum value out of big data by incorporating it into your BI architecture with tools such as Hive, Excel, PowerQuery, and Tabular models.

SessionID: 40745

In Memory Tables; Not Just For OLTP

Back to calendar

Event Date: 20-02-2016 - Session time: 11:10: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: 41998

Testing SSIS Packages

Back to calendar

Event Date: 20-02-2016 - Session time: 11:10:00 - Track: BI Platform Architecture, Development Administration

Speaker: Tim Mitchell

Title: Testing SSIS Packages

Abstract:

Senior developer: “How do you test your code?” Junior developer: “I compile it.” It’s an old joke, but too often this reflects the reality of testing. If the code compiles, it has passed its test. Sadly, this principle is sometimes applied to Extract-Transform-Load (ETL) processes as well: “When the SSIS package runs without error, testing is complete.”

As in software development, testing of SQL Server Integration Services (SSIS) packages should not end at when the package executes successfully. You must also confirm that the package does what it was intended to do without placing an undue performance burden on the system.

This session walks through design patterns for testing SSIS packages during and after the development process. The session covers topics such as these:

SessionID: 42313

Source Control practices for your BI World

Back to calendar

Event Date: 20-02-2016 - Session time: 11:10:00 - Track: BI Platform Architecture, Development Administration

Speaker: Leslie Weed

Title: Source Control practices for your BI World

Abstract:

Source Control is a critical part of any development effort. For small shop developers tools like TFS can be overwhelming especially for developers that come from organizations with little to no source control experience. Let's talk about practices and ways to implement source control for SSIS, SSRS and Database Projects in both multi-developer and multi-tiered environments. We will cover when and how to branch, merge and shelve and discuss ideas around process for deployment and continuous integration.

SessionID: 42455

Introduction to R and Data Science Tools in the Microsoft Stack

Back to calendar

Event Date: 20-02-2016 - Session time: 11:10:00 - Track: Analytics and Visualization

Speaker: Jamey Johnston

Title: Introduction to R and Data Science Tools in the Microsoft Stack

Abstract:

Come to this session to get an introduction to the R language including installing and configuring R and RStudio, how to access and manipulate data, install packages, create and use variables, use control flows and some basic graphing and statistical analysis. We will finish with a very brief introduction of how R integrates in Azure ML, Power BI and SQL Server.

The focus of the session will be primarily on the introduction to the R language and getting attendees comfortable with using R to start the journey to Data Science!

SessionID: 42658

Branding Yourself for a Dream Job

Back to calendar

Event Date: 20-02-2016 - Session time: 11:10:00 - Track: Professional Development

Speaker: Steve Jones

Title: Branding Yourself for a Dream Job

Abstract:

Everyone wants a dream job that they enjoy going to each week. However finding that job, and getting yourself hired can be hard for most people. Steve Jones will give you practical tips and suggestions in this session that show you how to better market yourself, how to get the attention of employers, and help improve the chances that the job you want will get offered to you. Learn about networking, blogging, and more.

SessionID: 43030

VLT Shootout

Back to calendar

Event Date: 20-02-2016 - Session time: 11:10:00 - Track: Enterprise Database Administration Deployment

Speaker: Seth Washeck

Title: VLT Shootout

Abstract:

You have large tables. I have large tables. What can we do with them? How can we architect them in a way that allows for best performance? In this session we'll discuss the thought/theory behind some common suggestions, address some common misconceptions (I'm looking at you, incremental statistics, and partitioning), and see if we can validate the theories that underpin the suggestions at the individual query level, and at a proposed workload level. Suggestions covered include: Partitioned Views, Partitioning, Incremental Statistics, Filtered Indexes, Filtered Statistics, and Columnstore indexes.

SessionID: 46768

How to be agile building the data warehouse with WhereScape RED

Back to calendar

Event Date: 20-02-2016 - Session time: 12:30:00 - Track: BI

Speaker: Dylan Newlander

Title: How to be agile building the data warehouse with WhereScape RED

Abstract:

An agile project to build the data warehouse is a natural way to handle model, process and rule changes caused by a better understanding of requirements, data, and data quality during a project. And yet designing, building, changing and documenting a data warehouse is still a laborious exercise that makes agile difficult. By using WhereScape's flagship RED data warehouse automation software to remove to automate the mechanics of building the data warehouse you can accelerate delivery cycles and get agile. That’s the way the business wants to work with IT – and the way that data warehouse developers want to work with the data. Come and see a demonstration of data warehouse design and build automation – developed in WhereScape RED and implemented in SQL Server.

SessionID: 42292

Intro to Monitoring I/O: The Counters That Count

Back to calendar

Event Date: 20-02-2016 - Session time: 13:30:00 - Track: Enterprise Database Administration Deployment

Speaker: J May

Title: Intro to Monitoring I/O: The Counters That Count

Abstract:

For many engineers, interpreting disk I/O is a black art. Yet analyzing perfmon virtual file stats is typically straightforward. This session provides authoritative, clear guidance on collecting interpreting disk I/O metrics.

SessionID: 41446

Adding Lightness: Better Performance Through Compression

Back to calendar

Event Date: 20-02-2016 - Session time: 13:40:00 - Track: Application Database Development

Speaker: Jay Robinson

Title: Adding Lightness: Better Performance Through Compression

Abstract:

This is a deep dive into data compression in SQL Server and how it affects the performance of your database. After attending this session, you will be able to recognize situations in which enabling compression will help, how to configure it, and how to deploy it in busy production systems.

SessionID: 43060

Power BI is Awesome!

Back to calendar

Event Date: 20-02-2016 - Session time: 13:40:00 - Track: BI Information Delivery

Speaker: Steve Wake

Title: Power BI is Awesome!

Abstract:

Microsoft has changed its Business Intelligence strategy in the last few years from an IT centric approach with SQL Server Reporting Services and SQL Server Analysis Services to an end-user ad-hoc approach with Power BI. Initially the Power BI tools were all separate add-ons to Excel 2010+ that you had to know where to get them and install/activate them individually. Now with new Power BI product announcements and Power BI Desktop, the full vision of these once separate tools is becoming more clear and cohesive as an end-user ad-hoc analysis and reporting tool. In this demo heavy session you will see how Power BI is now a much more complete solution and how it can change how you deliver analysis and reporting to anyone in your company. Demos will include using Power BI Desktop to pull in data from multiple sources and repeatable transformations to clean usable data and build interactive reports and dashboards.

SessionID: 43119

Database Continuous Delivery Your Salvation!

Back to calendar

Event Date: 20-02-2016 - Session time: 13:40:00 - Track: Application Database Development

Speaker: John Morehouse

Title: Database Continuous Delivery Your Salvation!

Abstract:

Continuous Integration Delivery isn’t a new concept. Application Developers have been doing it for quite a while and now it’s time for Database Professionals to catch up. Whether you are a database administrator, database developer, or even an application developer, database continuous delivery can help you find your salvation. I'll show you how to apply these concepts to areas of security, collaboration, testing, support and deployments. We will look at what continuous delivery means, demonstrate some tools that can help you easily get it into place, and dive into why it’s important.

SessionID: 44228

Windowing Functions: THE Reason to Upgrade to 2012+

Back to calendar

Event Date: 20-02-2016 - Session time: 13:40:00 - Track: Application Database Development

Speaker: Kevin Boles

Title: Windowing Functions: THE Reason to Upgrade to 2012+

Abstract:

For the first time since SQL 7 there is a compelling reason for EVERY SQL Server user to upgrade to the next version and this time around the reason is Windowing Functions. And these are NOT limited to Enterprise Edition, like so many other really useful and important features! The range of data processing needs that can be very efficiently and cleanly solved with these tools is stunning. In this demo-packed session we will cover as many features as we can pack into an hour's time, and you can take the demo code back home with you to review at your leisure!

SessionID: 44271

Always Encrypted in SQL Server 2016

Back to calendar

Event Date: 20-02-2016 - Session time: 13:40:00 - Track: Enterprise Database Administration Deployment

Speaker: Todd Kleinhans

Title: Always Encrypted in SQL Server 2016

Abstract:

SQL Server 2016 introduces a new feature called Always Encrypted. This feature allows data to stay encrypted 100% of the time in transit to and from the server, can keep it encrypted at rest, and offloads the encrypt/decrypt operations off the server to be handled exclusively by the client. Always Encrypted can also be used with whole database encryption (TDE). In this presentation we will talk about what Always Encrypted is, how it is different from the encryption options currently available, and how database administrators can even be prevented from seeing the data! Demos will be done in both SQL Management Studio and in Visual Studio 2015.

SessionID: 46916

SQL Server Internals

Back to calendar

Event Date: 20-02-2016 - Session time: 13:40:00 - Track: DBA

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

SQL Server 2016, New Features Enhancements

Back to calendar

Event Date: 20-02-2016 - Session time: 15:00:00 - Track: Enterprise Database Administration Deployment

Speaker: John Martin

Title: SQL Server 2016, New Features Enhancements

Abstract:

SQL Sever 2016 is just around the corner and with it come some great new features and enhancements to existing capabilities, in this session we will look at some of these and understand how they might make us change the way that we look at designing and implementing SQL Server solutions. We will focus on the SQL Server engine, covering topics including Operational Analytics, Temporal Stretch Tables and Always Encrypted. And we will be having a look at some of the old favorites, including enhancements to In-Memory OLTP (Hekaton) AlwaysOn Availability Groups.

By the end of this session you will have a jump-start on getting ready for the next version of SQL Server, whether you are an application developer, DBA or Business Intelligence developer.

SessionID: 41793

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

Back to calendar

Event Date: 20-02-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: 42067

Increase your SSIS Productivity with Biml

Back to calendar

Event Date: 20-02-2016 - Session time: 15:00: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 SSIS package development productivity to the next level. Creating template packages can add productivity to your SSIS development effort. See how Biml can help create template packages that can better adapt to changing business needs and allow for more comprehensive design or redesign.

In this session we will walk through various examples that will inspire you to make Biml your number one SQL Server Integration Services development tool. Learn how to use Biml scripts to create both staging tables and Integration Services packages. Add metadata to your Biml scripts and really watch the possibilities expand. In this session, you will learn:

SessionID: 42246

Beginning Automation with Powershell

Back to calendar

Event Date: 20-02-2016 - Session time: 15:00:00 - Track: Enterprise Database Administration Deployment

Speaker: Amy Herold

Title: Beginning Automation with Powershell

Abstract:

This session will cover concepts of automating SQL processes with Powershell - the one tool no DBA should shy away from. If you haven't gotten on the bandwagon yet now is the time. With some simple demos that you can take and expand upon, you will learn how you can leverage Powershell to not only efficiently meet the needs of your business, but also free up your time for other things.

SessionID: 44226

SQL Server Defaults SUCK!!

Back to calendar

Event Date: 20-02-2016 - Session time: 15:00:00 - Track: Enterprise Database Administration Deployment

Speaker: Kevin Boles

Title: SQL Server Defaults SUCK!!

Abstract:

If you just click next-next-next and think you have a good-to-go SQL Server THINK AGAIN!! :-) There are umpteen things you just GOTTA change right out of the box if you want your potentially very expensive and always precious SQL Server resource to perform and behave optimally. This session will cover a laundry list from High Power Setting to data file growth and many useful items in between.

SessionID: 44261

15 Things to ensure survivability of your database

Back to calendar

Event Date: 20-02-2016 - Session time: 15:00:00 - Track: Enterprise Database Administration Deployment

Speaker: Andre DuBois

Title: 15 Things to ensure survivability of your database

Abstract:

Survivability of data should be the #1 priority for any database administrator. Corruption can happen to any database at any time. How soon corruption is detected and a quick response is key to minimize lost data and recovery in a timely manner. Have a plan ready when it happens, as this is one time you don’t want to “learn on the job”. In addition to daily and monthly maintenance that should be performed, other topics discussed will include e-mail notification when data becomes corrupt and Service Level Agreements.

SessionID: 41643

Design and Implement BI Like Edison!

Back to calendar

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

Speaker: William E Pearson III

Title: Design and Implement BI Like Edison!

Abstract:

As the most prolific inventor in American history, Thomas Edison was a master of “Best Practices!” Edison’s creations were not just novel and commercially successful, but many launched entire new industries including electric light and power, sound recording, motion pictures and industrial cement and concrete manufacture. At the heart of Edison’s remarkable record of innovation was his categorization of the innovation process into “competencies,” or bundles of skills supporting the achievement of success in a particular area of endeavor. In this session, we will look at ways that we can use many of these broad success secrets to bring powerful tools and strategies to the recurring implementation of business intelligence.

SessionID: 41707

Critical Path SQL

Back to calendar

Event Date: 20-02-2016 - Session time: 16:20:00 - Track: Application Database Development

Speaker: Thane Schaffer

Title: Critical Path SQL

Abstract:

Critical path SQL will focus on recursive common table expressions (and other proprietary approaches, if time permits) on problem solving in finding minimum and maximums for common business problems like minimum/maximum manufacturing costs and leadtimes in BOM's and other hierarchical data structures where a tree traversal would be needed. AdventureWorks will be the primary database for demonstration purposes.

SessionID: 42521

The Hangover - Ben has really broken his SQL Server

Back to calendar

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

Speaker: Benjamin Reyes

Title: The Hangover - Ben has really broken his SQL Server

Abstract:

Ben doesn't remember much about what happened last night, but he has broken his SQL Server. Yell instructions at him, he will click the buttons. Hopefully you can save the day.

SessionID: 44254

Overcoming Chartaphobia And Moving Toward Enlightening Data Viz

Back to calendar

Event Date: 20-02-2016 - Session time: 16:20:00 - Track: Analytics and Visualization

Speaker: Meagan Longoria

Title: Overcoming Chartaphobia And Moving Toward Enlightening Data Viz

Abstract:

Do your organization's reports consist mostly of giant tables of data? Perhaps you have gotten as far as adding KPI indicators or conditional highlighting to the tables. Although tables of data presented as reports are commonly found in many organizations, they may be doing you and your users a disservice. You should optimize your data viz just as you optimize your databases. Reports are a user interface that must be purposefully designed to help users achieve their goal of making informed decisions. In this session, we'll review requirements gathering and data viz best practices and apply those concepts to the use of Microsoft reporting tools such as Excel, Power View, and Reporting Services. You'll leave with guidance on how to take boring, unreadable tables of data and turn them into useful and visually appealing reports.

SessionID: 44259

Getting Started with Databases on Amazon Web Services

Back to calendar

Event Date: 20-02-2016 - Session time: 16:20:00 - Track: Cloud Application Development Deployment

Speaker: Gabriel Villa

Title: Getting Started with Databases on Amazon Web Services

Abstract:

Are you looking to understand what IaaS or PaaS really mean? Perhaps you are not sure of virtual, high available relational or NoSQL databases. Get started with the basics of managed services and platforms for running databases on AWS. Hear how to use managed relational databases such as MS SQL Server with minimal administration. Also discover other cloud options such as managed NoSQL or scaling your own instances with resizable elastic compute cloud. Take home an introduction from in-memory cache to petabyte-scale data warehouse databases in the Amazon cloud.

This site is open source. Improve this page.