Nr: 474
SQLSaturday #474 - Salt Lake City 2015
SessionID: 40702
How I survived supporting a Java team
Event Date: 21-11-2015 - Session time: 09:00:00 - Track: Application Database Development
Speaker: Rick Lowe
Title: How I survived 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: 40923
Hadoop Cluster - Basic OS Setup Insights
Event Date: 21-11-2015 - Session time: 09:00:00 - Track: Other
Speaker: Sruthi Kumar Annamnidu
Title: Hadoop Cluster - Basic OS Setup Insights
Abstract:
In order to implement a successful big data project, Hadoop Cluster needs to be installed successfully. To successfully install a Hadoop Cluster on physical servers, the operating system must be prepared with many configuration changes. I will discuss a few tips tricks about the overall process, right from the operation system installation, potential processes to follow, some features to consider along with steps for public key authentication (PKE). These steps will provide you with great confidence, save lots of time and a good starting point to successfully install a Hadoop Cluster.
SessionID: 40932
Branding Yourself for a Dream Job
Event Date: 21-11-2015 - Session time: 09:00: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: 41210
Power BI Intro for DBAs Using Indexing Strategy Analysis as a Data Source
Event Date: 21-11-2015 - Session time: 09:00:00 - Track: Enterprise Database Administration Deployment
Speaker: Tim Ford
Title: Power BI Intro for DBAs Using Indexing Strategy Analysis as a Data Source
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.
Pointing out what is sub-par is only part of the process though. As a group we will discuss what the better options are based upon what we uncover. In a combination of instructor-led training and group discussion formats we will use Dynamic Management Objects, System Catalog Views and even Ola Hallengren's SQL Server Maintenance Solution to identify improvement points and next steps.
Tim then goes one step further and introduces you to how Power BI takes this collected metadata to the next level of performance analysis.
SessionID: 39863
Creating Access 2013 Web Apps based on SQL Azure using SharePoint
Event Date: 21-11-2015 - Session time: 10:10:00 - Track: Cloud Application Development Deployment
Speaker: Andy Tabisz
Title: Creating Access 2013 Web Apps based on SQL Azure using SharePoint
Abstract:
Access 2013 web apps feature a new, full integration with SQL Azure. When you create a web app on SharePoint, Access Services will create SQL Azure database that houses all of your Access objects. This opens up new opportunities for SQL developers to extend and work with the data in Access apps. In this session you will learn to easily create an Access Web Apps with automatic views, view the online development environment and see a real-world, production web app in action. We’ll discuss different the use of hybrid applications and integrating office web apps as well as learn about app distribution, deployment and upgrades. And lastly, see the pros/cons of Access Web Apps in a corporate environment.
SessionID: 40029
Splits, Merges and Purges: The How To of Table Partitioning
Event Date: 21-11-2015 - Session time: 10:10:00 - Track: Application Database Development
Speaker: Brandon Preece
Title: Splits, Merges and Purges: The How To of Table Partitioning
Abstract:
We have all heard of Table level partitioning in SQL Server. It has been around for a few years but isn't something that is highly used. In this session, we will walk through the definition, setup and maintenance of table partitioning on SQL Server. We will also highlight some advanced concepts like Sliding Windows and Partition Switching.
SessionID: 40725
PoshDBA: Practical PowerShell for the DBA
Event Date: 21-11-2015 - Session time: 10:10:00 - Track: Enterprise Database Administration Deployment
Speaker: Ben Miller
Title: PoshDBA: Practical PowerShell for the DBA
Abstract:
SessionID: 40820
Don't get your three-tiered environments in a twist!
Event Date: 21-11-2015 - Session time: 10:10:00 - Track: Enterprise Database Administration Deployment
Speaker: Steve Peterson
Title: Don't get your three-tiered environments in a twist!
Abstract:
How to keep the database parts of three tier server environments (Development, Staging [QA], Production) in alignment so you can minimize risk to your production release process. I'll show you how we have been able to keep application database releases from spiraling out of control and give us the ability to rollback and respond to rapidly changing environments and how to release what was truly testing in the staging tier. Rapid development requires rapid changes to the database schema and with the change of database schema come some difficulties that can be managed to reduce downtime and scale-ability.
SessionID: 40443
SQL Game Show
Event Date: 21-11-2015 - Session time: 11:20:00 - Track: Application Database Development
Speaker: Chad Crawford
Title: SQL Game Show
Abstract:
How well do you know your SQL components, methods and fundamentals? Come test your SQL foo against your peers and co-workers Jeopardy™ style! Questions will cover a broad scope of SQL development, administration and BI basics up to a 300 level. There will be time to discuss the correct answers and (as time allows) dig deeper into explanations. No one will be required to participate, but everyone who wishes to will have an opportunity to lead their team to glory as SQL Champions!
SessionID: 40701
Why should I care about the plan cache?
Event Date: 21-11-2015 - Session time: 11:20:00 - Track: Enterprise Database Administration Deployment
Speaker: Rick Lowe
Title: Why should I care about the plan cache?
Abstract:
SessionID: 40968
Powershell Jumpstart for SQL Server DBAs
Event Date: 21-11-2015 - Session time: 11:20:00 - Track: Enterprise Database Administration Deployment
Speaker: Michael Fal
Title: Powershell Jumpstart for SQL Server DBAs
Abstract:
SessionID: 42048
SQL Server Management Studio Tips and Tricks
Event Date: 21-11-2015 - Session time: 11:20:00 - Track: Application Database Development
Speaker: Andrea Allred
Title: SQL Server Management Studio Tips and Tricks
Abstract:
Have you ever watched a Microsoft SQL Presentation and wondered how in the world they did that cool trick? What was that keyboard shortcut? Come find out Microsoft SQL tips and tricks that will help you be more productive in your day to day work and give you a few cool ideas to make other SQL people jealous.
SessionID: 39982
Event Date: 21-11-2015 - Session time: 13:20:00 - Track: Application Database Development
Speaker: Jay Robinson
Abstract:
SessionID: 40942
Use Visual Studio to create a solid database from conception to production
Event Date: 21-11-2015 - Session time: 13:20:00 - Track: Application Database Development
Speaker: Steve Seeley
Title: Use Visual Studio to create a solid database from conception to production
Abstract:
SessionID: 40967
Powershell and the Art of SQL Server Deployment
Event Date: 21-11-2015 - Session time: 13:20:00 - Track: Enterprise Database Administration Deployment
Speaker: Michael Fal
Title: Powershell and the Art of SQL Server Deployment
Abstract:
SessionID: 42033
Intro to Monitoring I/O: The Counters That Count
Event Date: 21-11-2015 - Session time: 13:20: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: 40139
Configuring and using PolyBase to interact with Hadoop
Event Date: 21-11-2015 - Session time: 14:30:00 - Track: BI Information Delivery
Speaker: Montrial Harrell
Title: Configuring and using PolyBase to interact with Hadoop
Abstract:
In this session, we are going to connect to a fully deployed Hadoop Cluster using PolyBase and Power BI. We will go over the Pros vs Cons of using this solution and what use cases this architecture fits. We will also visualize this data using PowerBI.
SessionID: 40808
Event Date: 21-11-2015 - Session time: 14:30:00 - Track: Advanced Analysis Techniques
Speaker: Chad Crawford
Abstract:
SessionID: 40908
Hadoop, Hive, JSON, and Data! Oh, my!
Event Date: 21-11-2015 - Session time: 14: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: 40989
15 Things to ensure survivability of your database
Event Date: 21-11-2015 - Session time: 14:30: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: 39883
An Introduction to Master Data Services
Event Date: 21-11-2015 - Session time: 15:40:00 - Track: Strategy and Architecture
Speaker: Michael Sexton
Title: An Introduction to Master Data Services
Abstract:
The “Gold” record. The “master maintainable list”.
There is so much data in so many systems that businesses may have no way of telling which record is accurate and up to date. Even if a given record is accurate, how do we correct the inaccurate records in other systems? The dissonance between these systems costs businesses time and money and can lead to poor customer relations.
Master Data Services (MDS) provides tools to get all of your databases singing from the same sheet of music. This hour will include an overview of key master data management concepts, an introduction to MDS and how that fits in a data quality strategy and demonstrations integrating MDS systems using SSIS.
SessionID: 40726
Event Date: 21-11-2015 - Session time: 15:40:00 - Track: Enterprise Database Administration Deployment
Speaker: Ben Miller
Abstract:
Ever wonder how Management Studio gets information for the Properties dialogs it shows? SQL Server SMO consists of objects that can be used to manipulate SQL Server and the objects it contains. Ever wanted to get information about a database without opening Management Studio, or writing a query against DMVs? Ever wanted to change a property of a database without writing an ALTER DATABASE statement? This session will cover a few main objects in SMO and how to manipulate them using SMO as well as learning a Turbo button for your automation using SMO. Join us for a great time while we take a look behind the curtain and seeing how SMO really works. The session will have a majority of demos to give us time to really see how things work and how you can control things to get just what you want as fast as you can.
SessionID: 40748
Flash and SQL Server—Re-Visiting Best Practices
Event Date: 21-11-2015 - Session time: 15:40:00 - Track: Enterprise Database Administration Deployment
Speaker: J May
Title: Flash and SQL Server—Re-Visiting Best Practices
Abstract:
SessionID: 42288
EXEC and sp_executesql: An ad hoc rally
Event Date: 21-11-2015 - Session time: 15:40:00 - Track: Application Database Development
Speaker: Jay Robinson
Title: EXEC and sp_executesql: An ad hoc rally
Abstract: