Nr: 439
SQLSaturday #439 - Columbus 2015
SessionID: 36649
SQL Server 2014 In-Memory Programming
Event Date: 03-10-2015 - Session time: 09:00:00 - Track: Application Database Development
Speaker: miguel Cebollero
Title: SQL Server 2014 In-Memory Programming
Abstract:
SQL Server 2014 introduces a game changer technology; in-memory objects. This session is a hands-on demo based presentation that will introduce you to what the technology is and how to use it. You will come out of this session with the knowledge and scripts that you can take back to your shop and instantly be productive. You will gain an understanding of the architecture, how to get started, indexes, natively compiled stored procedures and the limitations.
SessionID: 36661
Revenge: The SQL! - Director's Cut
Event Date: 03-10-2015 - Session time: 09:00:00 - Track: Enterprise Database Administration Deployment
Speaker: Rob Volk
Title: Revenge: The SQL! - Director's Cut
Abstract:
Pop quiz DBA: Your developers are running rampant in production. Logic, reason, and threats have all failed. You're on the edge. What do you do? WHAT DO YOU DO?
Hint: You attend Revenge: The SQL!
This session will show you how to "correct" all those bad practices. Everyone logging in as sa? Running huge cursors? Using SELECT * and ad-hoc SQL? Stop them dead, without actually killing them. Ever dropped a table, or database, or WHERE clause? You can prevent that! And if you’re tired of folks ignoring your naming conventions, make them behave with Unicode…and take your revenge!
Revenge: The SQL! is fun and educational and may even have some practical use, but you’ll want to attend simply to indulge your Dark Side. Revenge: The SQL! assumes no liability and is not available in all 50 states. Do not taunt Revenge: The SQL! or Happy Fun Ball.
SessionID: 36942
Event Date: 03-10-2015 - Session time: 09:00:00 - Track: Enterprise Database Administration Deployment
Speaker: Ed Watson
Abstract:
SessionID: 37558
Tone Analysis with HDInsight and Azure Machine Learning
Event Date: 03-10-2015 - Session time: 09:00:00 - Track: BI Information Delivery
Speaker: Paco Gonzalez
Title: Tone Analysis with HDInsight and Azure Machine Learning
Abstract:
People’s sentiments and opinions are written in social networks. There are tweets, Facebook posts, book reviews, forum discussions, and more. These attitudes and feelings are communicated using text, with format depending on the social network. Twitter messages are limited to 140 characters and use hash-tags,; Facebook messages can be longer. This session reviews the different Natural Language Processing, text mining, and data mining techniques you can use for sentiment and tone analysis. Organizations can use the extracted knowledge for brand reputation, market predictions, and automatic learning. We’ll look at, Hadoop, data mining, Microsoft Big Data Hadoop distribution HDInsight and Azure Machine Learning
SessionID: 38494
Introducing the SSAS Tabular Data Model
Event Date: 03-10-2015 - Session time: 09:00:00 - Track: BI Information Delivery
Speaker: Robert Cain
Title: Introducing the SSAS Tabular Data Model
Abstract:
New to SQL Server Analysis Services 2012 is the Tabular model. In this session you'll learn about the newest way to do analytics in SQL Server. We'll compare and contrast it with the traditional Multidimensional Model, then see how to create your first "cube" using the Tabular mode. Finally we'll look at some of the reporting options for using your new Tabular database, including SSRS, Excel, and PowerView.
SessionID: 38539
Self-Service ETL with Microsoft Power Query
Event Date: 03-10-2015 - Session time: 09:00:00 - Track: BI Information Delivery
Speaker: Damu Venkatesan
Title: Self-Service ETL with Microsoft Power Query
Abstract:
SessionID: 39828
Smart Rats Leave First
Event Date: 03-10-2015 - Session time: 09:00:00 - Track: Professional Development
Speaker: Geoff Hiten
Title: Smart Rats Leave First
Abstract:
IT jobs are notoriously short-lived, with most only lasting a few years. Very few people keep a single employer for their entire career. Knowing when, why, and how to leave your job is as important a career step as finding new work. Learn about how to use job transitions as opportunities to develop your career.
SessionID: 36663
Table Partitioning Intro and make that a sliding window too!
Event Date: 03-10-2015 - Session time: 10:15:00 - Track: Enterprise Database Administration Deployment
Speaker: Jeff Reinhard
Title: Table Partitioning Intro and make that a sliding window too!
Abstract:
A walk-through of creating a sliding window table partition on an AdventureWorks table.
SessionID: 36748
SQL Server Optimization for SharePoint
Event Date: 03-10-2015 - Session time: 10:15:00 - Track: Enterprise Database Administration Deployment
Speaker: Sven Aelterman
Title: SQL Server Optimization for SharePoint
Abstract:
DBAs know that SharePoint just doesn't play nice with SQL Server. SharePoint administrators know that DBAs just don't understand SharePoint. This session will show hands-on how to get a SQL Server instance set up effectively for SharePoint 2013. It's not black magic and it doesn't involve undocumented trace flags. Maybe DBAs and SharePoint admins can't get along in social circles, but at least you'll be able to cooperate after this session.
SessionID: 38491
Zero to Hero with PowerShell
Event Date: 03-10-2015 - Session time: 10:15:00 - Track: Other
Speaker: Robert Cain
Title: Zero to Hero with PowerShell
Abstract:
There are two kinds of people in the SQL Server world. Those who are using PowerShell, and those that will be. In this session you'll learn how to become one of the "cool kids" using PowerShell.
In this session we'll start with the basics, like cmdlets, variables, and the IDE. But we'll quickly transition to more advanced topics like flow control, functions, and creating your own objects. By the time you are done you'll have a good grasp on how to implement your own solutions in PowerShell.
SessionID: 38506
Self-Service Analysis with Power BI
Event Date: 03-10-2015 - Session time: 10:15:00 - Track: BI Information Delivery
Speaker: Dan Evans
Title: Self-Service Analysis with Power BI
Abstract:
SessionID: 38514
Event Date: 03-10-2015 - Session time: 10:15:00 - Track: Enterprise Database Administration Deployment
Speaker: Mike Lawell
Abstract:
This is a very demo intensive session some basic issues and performance analysis that will be used as a starting point for performance tuning.
There will be homework!
SessionID: 40887
Azure Data Factory: My Data Wandered Lonely as a CLOUD.
Event Date: 03-10-2015 - Session time: 10:15:00 - Track: Application Database Development
Speaker: Julie Smith
Title: Azure Data Factory: My Data Wandered Lonely as a CLOUD.
Abstract:
This is an absolute beginner session on Azure Data Factory. I will cover basic terms and operations and show how to move your data the Azure way.
SessionID: 41014
Sparkhound Top Dog Challenge
Event Date: 03-10-2015 - Session time: 11:30:00 - Track: Analytics and Visualization
Speaker: William Assaf
Title: Sparkhound Top Dog Challenge
Abstract:
Do you have what it takes to be Top Dog? If so, come play the “Sparkhound Top Dog” challenge during our SQLSaturday lunch session. Test your Sparkhound knowledge and technical prowess in a fun, interactive game of “Jeopardy!” presented by Sparkies William Assaf, Cody Gros and John Walker. Besides bragging rights, the winner will walk away with a nice treat.
SessionID: 36656
Introducing Forensic Analytics with PowerPivot for Excel
Event Date: 03-10-2015 - Session time: 12:30:00 - Track: Analytics and Visualization
Speaker: William E Pearson III
Title: Introducing Forensic Analytics with PowerPivot for Excel
Abstract:
Despite the wealth of analytical technologies available today, 65% of fraud at public companies is detected through tips, management review, or simple accidents. Forensic Analytics combine human intuition and leading-edge technologies, and can provide superior detection methods to significantly improve the detection and investigation of illegal or unethical activities.
In this session, we explore Forensic Analytics: a set of techniques we can use to uncover irregularities in financial data. We also gain an understanding of goals of Forensic Analytics: to enable us to find out how — and why — these irregularities exist, and to find out their source(s) — especially when fraudulent activity is suspected. We discuss guiding principles that are key to isolating data anomalies, and outline a standard, repeatable process to Forensic Analytics. Throughout the session, we view examples of how we can employ PowerPivot for Excel to drive Forensic Analytics via various tests and reviews.
SessionID: 36662
AlwaysOn Availability Groups Kickoff
Event Date: 03-10-2015 - Session time: 12:30:00 - Track: Enterprise Database Administration Deployment
Speaker: Jeff Reinhard
Title: AlwaysOn Availability Groups Kickoff
Abstract:
A run through from start to end of my experience implementing AlwaysOn Availability Groups for High Availability and read only secondary database copies
SessionID: 37499
How do I Get-Started with PowerShell?
Event Date: 03-10-2015 - Session time: 12:30:00 - Track: Enterprise Database Administration Deployment
Speaker: Mike Robbins
Title: How do I Get-Started with PowerShell?
Abstract:
SessionID: 38065
Awesome PowerShell for SQL 2014
Event Date: 03-10-2015 - Session time: 12:30:00 - Track: Enterprise Database Administration Deployment
Speaker: Aaron Nelson
Title: Awesome PowerShell for SQL 2014
Abstract:
Need to import millions of rows from a CSV in under a minute? No problem. Need to copy all the Users, Databases, and Agent Jobs from one server to another? Done. Need to update all of your development databases to have the same schema, but want to skip the update and only spit out a report if data loss might occur? Piece of CAKE!! These are some of the scenarios that we will cover in this session on how to leverage PowerShell with SQL Server 2014.
SessionID: 38490
So you think MDX is hard?
Event Date: 03-10-2015 - Session time: 12:30:00 - Track: Application Database Development
Speaker: Robert Cain
Title: So you think MDX is hard?
Abstract:
A lot of people have this perception that MDX is difficult. It really isn't, when you understand what it is trying to accomplish under the hood. In this session we'll begin with a fundamental understanding of what MDX will do for you. Then we'll roll up our sleeves and dive into MDX code, starting from the simplest select statement and winding up building calculations you can put into your own SSAS Cubes.
SessionID: 38754
Event Date: 03-10-2015 - Session time: 12:30:00 - Track: Application Database Development
Speaker: Jon Boulineau
Abstract:
SessionID: 39397
Balancing Work and Home to Create a Better You
Event Date: 03-10-2015 - Session time: 12:30:00 - Track: Professional Development
Speaker: Karlyn LeBlanc
Title: Balancing Work and Home to Create a Better You
Abstract:
If you are a working professional there is a chance that your career has interrupted your life and you've forgotten about you and/or your family. How do you create a healthy balance between the two so that you are happy and everyone else is to? In the session, you will learn how to properly manage time, erase stress, advance at work, address common marriage and family Issues, and ultimately create a better you.
SessionID: 40086
SQL + SharePoint: Friends Forever
Event Date: 03-10-2015 - Session time: 12:30:00 - Track: Enterprise Database Administration Deployment
Speaker: William Assaf
Title: SQL + SharePoint: Friends Forever
Abstract:
Learn from two subject matter experts about best practices to make your SQL Server and SharePoint servers play nice together forever. It will be a 50/50 split of best practices for administering SharePoint farms and their underlying SQL Servers. With a special section on AlwaysOn Availability Groups! William Assaf is a SQL Server MCSE and Cody Gros is a SharePoint SME, both are Principal Consultants in their fields at Sparkhound.
SessionID: 36657
Getting Started with Analysis Services 2012 Tabular
Event Date: 03-10-2015 - Session time: 13:45:00 - Track: BI Information Delivery
Speaker: William E Pearson III
Title: Getting Started with Analysis Services 2012 Tabular
Abstract:
The Analysis Services 2012 Business Intelligence Semantic Model (BISM) unifies Multidimensional (OLAP) and Tabular (relational) options for organizational BI. In this session, BI Architect, SQL Server MVP and Analysis Services Maestro Bill Pearson introduces Microsoft Business Intelligence 2012 and the Business Intelligence Semantic Model ("BISM"). He then overviews the Tabular model, beginning with the creation of a project with SQL Server Data Tools (“SSDT”), and continuing from the data import steps to the creation and management of calculations, measures and Key Performance Indicators (“KPIs”). Finally, he provides insight to the creation and maintenance of perspectives and hierarchies, as well as other considerations involved in working with Tabular.
SessionID: 36750
Windows Server 2012 R2 High Availability for SQL Server
Event Date: 03-10-2015 - Session time: 13:45:00 - Track: Enterprise Database Administration Deployment
Speaker: Sven Aelterman
Title: Windows Server 2012 R2 High Availability for SQL Server
Abstract:
With the increasing adoption rate of virtualization, creating SQL Server clusters is now within reach of many more DBAs. What do you need to know about Windows Server 2012 (R2) virtualization and high availability to set up your first cluster? Come learn from a Windows Server admin and (accidental) DBA who's been building SQL Server clusters since 2000 (the year and the version!). We'll discuss initial planning, the process and the maintenance best practices. There will be demos too, so if you want to see a multi-node SQL cluster run on a Lenovo X230 tablet, come see (it's pretty cool!).
SessionID: 36940
Introduction to SQL Server Integration Services
Event Date: 03-10-2015 - Session time: 13:45:00 - Track: BI Information Delivery
Speaker: Ed Watson
Title: Introduction to SQL Server Integration Services
Abstract:
Take an introductory journey into the world of SSIS through the eyes of a SQL Server DBA as he navigates the Business Intelligence waters. This is an introductory course for beginners or users without any SSIS experience. Come learn how to SSIS with me!
SessionID: 37500
PS C:\gt; Get-Started -With 'PowerShell Desired State Configuration
Event Date: 03-10-2015 - Session time: 13:45:00 - Track: Enterprise Database Administration Deployment
Speaker: Mike Robbins
Title: PS C:\gt; Get-Started -With 'PowerShell Desired State Configuration
Abstract:
SessionID: 38745
Primer on Power BI
Event Date: 03-10-2015 - Session time: 13:45:00 - Track: BI Information Delivery
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: 41209
Event Date: 03-10-2015 - Session time: 13:45:00 - Track: Analytics and Visualization
Speaker: Rodney Landrum
Abstract:
SessionID: 38512
Execution Plans for Mere Mortals
Event Date: 03-10-2015 - Session time: 15:00:00 - Track: Application Database Development
Speaker: Mike Lawell
Title: Execution Plans for Mere Mortals
Abstract:
This is a beginner session that will look at the graphical execution plan, and the important operators, properties and what to look for in an execution plan. It will discuss the ways to determine a poor cardinality estimate, parameter sniffing and spill to tempdb.
SessionID: 38755
How Queries Work
Event Date: 03-10-2015 - Session time: 15:00:00 - Track: Application Database Development
Speaker: Jon Boulineau
Title: How Queries Work
Abstract:
SessionID: 39047
Introduction to the Power BI Desktop
Event Date: 03-10-2015 - Session time: 15:00:00 - Track: Analytics and Visualization
Speaker: Patrick LeBlanc
Title: Introduction to the Power BI Desktop
Abstract:
Most of us are overwhelmed with data from all the different applications that we use on a daily basis. Bringing all the data together is often a very time-consuming and sometimes a challenging process. Even further, attempting to analyze and visualize the data poses new challenges that is sometime difficult or impossible to overcome. Now with Power BI this can all be made very simple. Individuals, ranging from novice information workers to advanced IT professionals can quickly and easily transform, analyze and visualize data using a single tool, Power BI Desktop. In this course we will work through four main topics: Shaping Data, Building a Data Model, Visualizing Data and Using the Power BI Server.
SessionID: 39826
Room for a SQL VIEW
Event Date: 03-10-2015 - Session time: 15:00:00 - Track: Application Database Development
Speaker: Kevin Wilkie
Title: Room for a SQL VIEW
Abstract:
What constitutes a view? Do we really need them in database development? Do they serve their purpose? Can we make them faster? At what point have we gone overboard with views? Just some of the questions that will be asked and answered...
SessionID: 40041
Self-Service Business Intelligence in Excel
Event Date: 03-10-2015 - Session time: 15:00:00 - Track: BI Information Delivery
Speaker: Theresa Eller
Title: Self-Service Business Intelligence in Excel
Abstract:
SessionID: 40049
SQL Admin Best Practices with DMVs
Event Date: 03-10-2015 - Session time: 15:00:00 - Track: Enterprise Database Administration Deployment
Speaker: William Assaf
Title: SQL Admin Best Practices with DMVs
Abstract:
In this practical and script-focused session, we'll discuss many best practices regarding SQL Server administration, maintenance, optimizations and monitoring using Dynamic Management Views. DMV's are essential tools for the SQL administrator, but have a wide range of applications by developers, network engineers and DBAs. We will delve into best practices for server maintenance, index fragmentation, XEvents, wait type analysis and future features. This session will be informative and eye-opening to anyone from a junior DBA on up.
SessionID: 41092
Windowing Functions with SQL Server 2016 (Preview)
Event Date: 03-10-2015 - Session time: 15:00:00 - Track: Application Database Development
Speaker: Mark Tabladillo
Title: Windowing Functions with SQL Server 2016 (Preview)
Abstract:
Windowing functions are powerful analytic functions built into SQL Server. SQL Server 2005 introduced the core window ranking functions, and SQL Server 2012 added time and statistical percentage windowing functions. These functions allow for advanced variable creation, and are of direct benefit to people creating features for data science. This talk will also recommend further reading on this topic.