Nr: 421
SQLSaturday #421 - Columbus 2015
SessionID: 12802
SRS Report Builder for Business Intelligence
Event Date: 11-07-2015 - Session time: 08:30:00 - Track: Track 3
Speaker: David Eichner
Title: SRS Report Builder for Business Intelligence
Abstract:
Learn how easy it is to utilize the free download from Microsoft that allows users to create maps, charts, dashboard objects and reports against any kind of data easily without having to use Visual Studio. See how SQL Report Builder makes creating executive dashboards easy!
SessionID: 17230
How to get Microsoft Certified
Event Date: 11-07-2015 - Session time: 08:30:00 - Track: Track 3
Speaker: John Deardurff
Title: How to get Microsoft Certified
Abstract:
This session focuses on what you need to know to get Microsoft Certified on SQL Server. The session is led by an expert Microsoft Certified Trainer (MCT) who regularly teaches the SQL Server certification courses. The presenter walks you through the certifications, exams, and resources available to get you ready for certification..
SessionID: 36038
Get Near Realtime ETL with Service Broker
Event Date: 11-07-2015 - Session time: 08:30:00 - Track: Track 1
Speaker: Allen White
Title: Get Near Realtime ETL with Service Broker
Abstract:
SessionID: 36890
What changed? Auditing options in SQL Server 2014
Event Date: 11-07-2015 - Session time: 08:30:00 - Track: Track 1
Speaker: Colleen Morrow
Title: What changed? Auditing options in SQL Server 2014
Abstract:
When and how was this view changed? Where did that index go? Who's accessing my sensitive data? As a DBA, you'll face these and similar questions throughout your career. And if you don't have an audit in place, providing answers can be difficult.
In this demo-rich session we'll examine auditing options in SQL Server 2014, including SQL Trace, event notifications, DDL and logon triggers, and SQL Server Audit. We'll begin by defining real-world requirements for an auditing solution, such as events to capture, data to collect, output destinations, and performance considerations. As we implement each tool, we'll discuss its unique benefits and limitations, and see how it stacks up against our specifications.
By the end of this session, you'll have the knowledge you need to select and implement the auditing tool that's right for you.
SessionID: 37239
Event Date: 11-07-2015 - Session time: 08:30:00 - Track: Track 3
Speaker: Erin Stellato
Abstract:
SessionID: 12264
Database: The Motion Picture
Event Date: 11-07-2015 - Session time: 09:40:00 - Track: Track 3
Speaker: Dave Mattingly
Title: Database: The Motion Picture
Abstract:
Power up your data presentations with Power View and Power Map. Charts and maps can be made interactive, generated on the fly, or recorded as video with a soundtrack and special effects. Instead of trying to make your point with a boring list of names, numbers, and dates, put on your movie director's hat and give your data the Hollywood treatment as you yell, "Lights! Cameras! Action!"
SessionID: 36404
Event Date: 11-07-2015 - Session time: 09:40:00 - Track: Track 3
Speaker: Ravi Kumar
Abstract:
SessionID: 36943
Full-Text Search with Custom Proximity
Event Date: 11-07-2015 - Session time: 09:40:00 - Track: Track 3
Speaker: Sam Nasr
Title: Full-Text Search with Custom Proximity
Abstract:
Custom proximity search is a new feature introduced in SQL Server 2012 Full-Text Search. It's facilitated using the NEAR operator, allowing it to be used in the CONTAINS predicate or CONTAINSTABLE function. The NEAR operator allows for searching words near each other. It also allows the user to specify the maximum number of non-search terms separating the first and last search terms in a match. In addition, an optional parameter can be used to specify an exact order match.
SessionID: 37279
Primer on Power BI
Event Date: 11-07-2015 - Session time: 09:40:00 - Track: Track 2
Speaker: Mark Tabladillo
Title: Primer on Power BI
Abstract:
Power BI (Business Intelligence) is a new and emerging self-service business intelligence and business analytics framework that brings together and enhances a few key Microsoft technologies. We will answer the following questions:
◾What makes Power BI different from the Microsoft Office I have known for years?
◾What are the major Power BI features in Excel 2013 and 2010?
◾What are the major features for Power BI for Office 365?
◾How can our team license Power BI?
SessionID: 37306
DQ What? DQ Who? DQ How?
Event Date: 11-07-2015 - Session time: 09:40:00 - Track: Track 3
Speaker: Brian Davis
Title: DQ What? DQ Who? DQ How?
Abstract:
Whether a company has 1 database containing 1GB of data or hundreds of databases containing terabytes or even petabytes of data, at some point they all have the same question..."What is the quality of our data?". A business runs off of it's data and if that data isn't complete, consistent, and accurate bad decision can be made. Come to this session and learn how to tell if your data is quality data worthy of making decision from. We'll learn what it means to have quality data and how you can measure the quality of your data using the Data Quality Services (DQS) component of SQL Server. Together we'll explore this lesser known part of SQL Server and learn how it works and how you can start using it to measure and improve the quality of your data and thus the decisions being made from it.
SessionID: 36048
A Day in the Life of a Row: Internals Deep Dive
Event Date: 11-07-2015 - Session time: 10:50:00 - Track: Track 1
Speaker: Eddie Wuerch
Title: A Day in the Life of a Row: Internals Deep Dive
Abstract:
Attend this advanced session and you will be able to: * View and interpret raw data and metadata with DMVs, XEvents, and DBCC commands, including some undocumented ones (all demo scripts included in session download) * View and describe, with precise details, exactly what data and metadata actions any given query took, and, * Attack and destroy query performance problems with some neat new weapons.
SessionID: 36532
Right-Sizing Your SQL Server Virtual Machine
Event Date: 11-07-2015 - Session time: 10:50:00 - Track: Track 1
Speaker: David Klee
Title: Right-Sizing Your SQL Server Virtual Machine
Abstract:
The methods for understanding the performance of your mission-critical SQL Servers gathered over the past ten years of SQL Server virtualization will be addressed, and valuable processes for performance statistic collection and analysis will be displayed. Come learn how to properly ‘right-size’ the resources allocated to a VM, improve the performance of your SQL Servers, and keep it maximized well into the future.
SessionID: 36578
The Spy Who Loathed Me - An Overview of SQL's Security Features
Event Date: 11-07-2015 - Session time: 10:50:00 - Track: Track 1
Speaker: Chris Bell
Title: The Spy Who Loathed Me - An Overview of SQL's Security Features
Abstract:
You have lots of data painstakingly collected over the years.
How do you ensure that all your hard work is protected from hackers, spies and other ne’er-do-wells?
Having knowledge of the vast array of security features available in SQL Server is the first step in helping determine what actions you need to take to protect your data.
This session will quickly go through a majority of the security features in SQL Server, to help you learn what each does, and let you determine which features work best for your situation.
*Note – This session is demo-free.
SessionID: 37214
Event Date: 11-07-2015 - Session time: 10:50:00 - Track: Track 3
Speaker: Konstantin Melamud
Abstract:
SessionID: 37312
SSIS Grab Bag of Best Practices
Event Date: 11-07-2015 - Session time: 10:50:00 - Track: Track 1
Speaker: Adam Belebczuk
Title: SSIS Grab Bag of Best Practices
Abstract:
SessionID: 14232
Much Ado About Hadoop
Event Date: 11-07-2015 - Session time: 13:00:00 - Track: Track 3
Speaker: Kevin Feasel
Title: Much Ado About Hadoop
Abstract:
Hadoop is a hot topic right now, and Microsoft is betting that Hadoop and SQL Server will go together like peanut butter and chocolate. This presentation will spend a little bit of time on the theory behind Hadoop, but the rest will be a demo-driven look at how to get a handle on Hadoop before somebody introduces it into your enterprise.
SessionID: 22128
Getting Started with Analysis Services Tabular mode
Event Date: 11-07-2015 - Session time: 13:00:00 - Track: Track 3
Speaker: Phillip Labry
Title: Getting Started with Analysis Services Tabular mode
Abstract:
SessionID: 35976
Execution Plans 101
Event Date: 11-07-2015 - Session time: 13:00:00 - Track: Track 3
Speaker: Eugene Meidinger
Title: Execution Plans 101
Abstract:
Do you have a query that you want to tune, but don't know where to start? Execution plans can be a great starting point for understanding what your query is doing under the hood. This course covers the bare bones basics: what an execution plan is, how to run them, how to read them, 5 common troublemakers, and where to learn more. If an execution plan looks like hieroglyphics, this course is for you!
SessionID: 36678
Backup and Restore Tips and Tricks
Event Date: 11-07-2015 - Session time: 13:00:00 - Track: Track 1
Speaker: Ryan Adams
Title: Backup and Restore Tips and Tricks
Abstract:
SessionID: 37305
Goodbye Next Next Next, Hello Automated Installs
Event Date: 11-07-2015 - Session time: 13:00:00 - Track: Track 3
Speaker: Brian Davis
Title: Goodbye Next Next Next, Hello Automated Installs
Abstract:
SessionID: 14638
Partition Switching - Moving a Lot of Data Very Quickly
Event Date: 11-07-2015 - Session time: 14:10:00 - Track: Track 3
Speaker: Gill Rowley
Title: Partition Switching - Moving a Lot of Data Very Quickly
Abstract:
You have a million rows you need to move into a table. Because of constraints, this import process is very slow. In this session I will show you how you can speed up this process greatly by partitioning the table and moving partitions from one table to another.
SessionID: 36322
Scripting out SQL Server for Documentation and Disaster Recovery
Event Date: 11-07-2015 - Session time: 14:10:00 - Track: Track 1
Speaker: George Walkey
Title: Scripting out SQL Server for Documentation and Disaster Recovery
Abstract:
Even using Visual Studio and Database Projects, not all objects are exportable and live at the server level, above the database.
Using Powershell, we will script out an organized set of files that can be checked into any Source Control system and or used for moving or recovering a SQL server instance for Disaster Recovery purposes.
Objects exported include: SQL Agent Jobs/Alerts/Schedules, NT Service Credentials, SSIS-MSDB, SSIS-Catalog, SSAS Cubes, SSRS Reports, Logins, Server Configs, Linked Servers, DB Mail Operators/Accounts, and Server Triggers
SessionID: 36579
Hacking Expos#233; - Using SSL to Secure SQL Server Connections
Event Date: 11-07-2015 - Session time: 14:10:00 - Track: Track 1
Speaker: Chris Bell
Title: Hacking Expos#233; - Using SSL to Secure SQL Server Connections
Abstract:
You know all the ways to protect your database when it is at rest, but what about when someone connects and starts running some queries? What if they connect and don't do anything? Just how exposed is that data?
We will assume the role of a hacker and, by using a simple technique, we will sniff packets on a network to reveal what data is being sent. You may be shocked!
We will then secure our database connections with a simple self-signed SSL certificate.
Once secured, we will resume the role of the hacker and look inside the packets to see what has changed.
*Warning - Do not try these demos at work without proper permissions as actual hacking techniques are used.
SessionID: 36905
Introduction to Azure Machine Learning
Event Date: 11-07-2015 - Session time: 14:10:00 - Track: Track 3
Speaker: Warren Sifre
Title: Introduction to Azure Machine Learning
Abstract:
We will discuss what is Azure Machine Learning, how it works, what it can do, and why would you use it. This session includes demonstration and use case scenarios. The goal of this session it to provide an understand of what Azure ML can do and how it may apply to business use cases.
SessionID: 37313
Join Us! Getting Started as a Technical Speaker
Event Date: 11-07-2015 - Session time: 14:10:00 - Track: Track 3
Speaker: Eddie Wuerch
Title: Join Us! Getting Started as a Technical Speaker
Abstract:
SessionID: 21880
Clusters! From the ground up, don't double your storage, let's build one together.
Event Date: 11-07-2015 - Session time: 15:20:00 - Track: Track 3
Speaker: Paul Popovich Jr
Title: Clusters! From the ground up, don't double your storage, let's build one together.
Abstract:
You're looking to protect your SQL instance from a machine failure. Or maybe your storage budget and tight and you don't want to have your databases in two places with one of the other highly available options that SQL provides. Let's learn what a cluster is and why it might be the right thing for you. We'll explore the system, network, storage and database administration sides of the equation. And, when it's all said and done we'll even have built a SQL clustered instance!
SessionID: 27608
Introduction to APS
Event Date: 11-07-2015 - Session time: 15:20:00 - Track: Track 3
Speaker: Warren Sifre
Title: Introduction to APS
Abstract:
We will have a conversation of what is APS and specifically how it differs from the normal SQL Server instances we work with daily. By the end of this talk, you will have a very good understanding of the differences between the APS' MPP architecture compared to SMP SQL Server. We will cover the topic of Polybase and what Hadoop Components are supported by Polybase.
SessionID: 36534
My Brain Has Blue Screened - Let's Laugh
Event Date: 11-07-2015 - Session time: 15:20:00 - Track: Track 1
Speaker: David Klee
Title: My Brain Has Blue Screened - Let's Laugh
Abstract:
Is it the end of the day, your brain is mush, but you want to stay for the raffle? Come share your IT war stories with the group and laugh for an hour. This open panel session is guaranteed to at least get a chuckle as we all relax and share our experiences.
SessionID: 36653
Playing in Traffic: Lessons from High-Speed, High-Volume Applications
Event Date: 11-07-2015 - Session time: 15:20:00 - Track: Track 1
Speaker: Jay Robinson
Title: Playing in Traffic: Lessons from High-Speed, High-Volume Applications
Abstract:
How do you as a developer take database activity into account when designing and writing your code? What works well on a small scale can often fall down as traffic picks up. In this session, attendees will learn methods for making their SQL scripts run faster, avoid blocking, and remain stable in a busy environment.
SessionID: 8992
XML Without Xanax: How to Handle XML in SQL Server
Event Date: 11-07-2015 - Session time: 15:20:00 - Track: Track 3
Speaker: Adam Belebczuk
Title: XML Without Xanax: How to Handle XML in SQL Server
Abstract:
Do you cringe whenever you have to look at an XML document? Does the very thought of XML data living in your database make you scream? Do you have a panic attack any time you have to parse XML? If you answered yes to any of these questions, then this session is for you!
We'll start with reasons why having XML in SQL Server might be a good thing, then we'll face our fears and turn tabular data into XML, and finally we'll confront the true source of our anxiety by parsing XML back into tabular data using xQuery.
If you survive this session, you'll have faced your fears about XML in SQL Server, you'll have a solid understanding of creating XML from tabular data, and you'll know how to use xQuery to parse XML.