Nr: 232
SQLSaturday #232 - Orlando 2013
SessionID: 10019
Automate Your ETL Infrastructure with SSIS and PowerShell
Event Date: 14-09-2013 - Session time: 00:00:00 - Track: Powershell
Speaker: Allen White
Title: Automate Your ETL Infrastructure with SSIS and PowerShell
Abstract:
Much of your ETL process flow consists of packages that are very similar in structure, capturing data from a single source and transferring that to a single destination. Creating the individual packages can be tedious and it's easy to miss something in the process of generating the same basic package over and again. BI Markup Language makes it easy to build new packages, and PowerShell makes creating the BIML scripts easy. In this session we'll show you how to use PowerShell to generate dozens of SSIS packages doing similar tasks from a defined set of ETL sources.
SessionID: 10146
SQL Server 2014: A First Look at What’s New!
Event Date: 14-09-2013 - Session time: 00:00:00 - Track: SSIS
Speaker: Bradley Ball
Title: SQL Server 2014: A First Look at What’s New!
Abstract:
Microsoft has announced that our next version of SQL Server will be SQL Server 2014. SQL Server 2012 had some major upgrades in AlwaysOn Availability Groups, ColumnStore Indexes, and Resource Governor. SQL 2014 takes those features to the next level and introduces a whole lot more! Rebuild Indexes and Statistics by Partition? Yes! A new Optimizer/Cardinality Estimator that you can choose for your Queries? Yes! Hekaton in memory data tables that exist separate to the buffer pool and use HASH indexes instead of B-TREE? YES! Plus SSD Buffer Pool Extensions, Read-Write ColumnStore Indexes and much more!
SessionID: 11069
Troubleshooting Tips 101
Event Date: 14-09-2013 - Session time: 00:00:00 - Track: DBA Admin 3
Speaker: Brandie Tarvin
Title: Troubleshooting Tips 101
Abstract:
Are you new to SQL Server? Did your first tasks involve problem solving someone else's work? Diagnosing SQL Server problems does not have to be a time sink, or a struggle. Learn about the most common errors in SQL Server and Brandie's top 20 tips for finding the problem fast.
SessionID: 11121
Matching with Data Quality Services
Event Date: 14-09-2013 - Session time: 00:00:00 - Track: SSIS
Speaker: Julie Smith
Title: Matching with Data Quality Services
Abstract:
Matching is the identification of rows which are likely duplicates and is the less well known feature of Data Quality Services. In this session we'll go over the creation of matching rules, how to use the rules with matching activity projects and the brand new Codeplex DQS SSIS Matching component!
SessionID: 11178
Your SQL Server Environment--Fair or foul?
Event Date: 14-09-2013 - Session time: 00:00:00 - Track: DBA Admin 2
Speaker: Carlos L Chacon
Title: Your SQL Server Environment--Fair or foul?
Abstract:
Determine what's in play and what's not.
This presentation will focus on steps you can take to determine the performance of your SQL Server and where you may need to spend some time optimizing. We will review tools and scripts that are available from Windows Server and the SQL community so you won't have to go and ask your boss to buy something.
SessionID: 11251
“Indexing” Encrypted Data
Event Date: 14-09-2013 - Session time: 00:00:00 - Track: DBA Admin
Speaker: Chris Bell
Title: “Indexing” Encrypted Data
Abstract:
As a SQL Server DBA I see my role having 2 main focuses. First is to protect the data and second is to ensure performance is maximized. More often than not companies forget about data security when they focus on performance tuning. In this presentation I will mention a few cases where encryption could have saved a lot of hassle. I will then demo a method that can be used to "index" commonly searched on encrypted values (ex: SSNs, Credit Card, etc) helping reduce the impact on the performance of a query.
SessionID: 11673
DQS: Business logic meets integration
Event Date: 14-09-2013 - Session time: 00:00:00 - Track: BI Big Data
Speaker: Chris Schmidt
Title: DQS: Business logic meets integration
Abstract:
Data Quality Services brings a new way to clean bad data as it's entering your data warehouse environment. In this session, we'll discuss what benefits using data quality services provides and how it can make development simpler in the long run. We'll show how to create a knowledge base, data quality projects, and administration of your data quality server. Finally, we'll use SSIS to consume this project and load into a data mart for cleaner data.
SessionID: 11858
An Introduction to Extended Events
Event Date: 14-09-2013 - Session time: 00:00:00 - Track: DBA Admin 2
Speaker: Jack Corbett
Title: An Introduction to Extended Events
Abstract:
XEvents were introduced with SQL Server 2008 and enhanced in SQL Server 2012 and with the announcement that SQL Trace/Profiler is being deprecated now is the time to begin learningXEvents. We will look at why you should start working with Extended Events, when you should start, and how to start. What you will learn:
- How to investigate XEvents objects using the DMV's
- How to create an XEvents Session
- How to transition an existing Trace to an XEvents Session.
What you should know coming in:
- Basic use of SSMS
- Familiarity with Trace/Profiler
SessionID: 11901
Into the Wild,Taming Unstructured Data
Event Date: 14-09-2013 - Session time: 00:00:00 - Track: BI Big Data
Speaker: Christopher Price
Title: Into the Wild,Taming Unstructured Data
Abstract:
There is runaway growth in the data volumes many organizations are facing today. The bad news is that much of this data is unstructured which means your traditional RDBMS just isn't capability of helping you deal with it. As a result significant emphasis has been put on technologies like Hadoop, No SQL and other distributed databases which are better suited to handling unstructured data. With the latest release SQL Server 2012 however, Microsoft has provided new features which will help tame some of this unstructured data. This session will dive into the new FileTable and Statistical Semantic Search features. We will show you how they work and highlight real world examples for integrating these exciting new features into your organization.
SessionID: 12152
Will SQL Server Standard edition meet your needs?
Event Date: 14-09-2013 - Session time: 00:00:00 - Track: DBA Admin 2
Speaker: Daniel Taylor
Title: Will SQL Server Standard edition meet your needs?
Abstract:
Working in large Enterprise environments as an employee is a challenge on the best of days. Getting the company to purchase the proper software is I believe a difficult task for even the most seasoned DBAs. Having started at my 3rd large Enterprise I have come to learn that each one manages the purse strings in their own manner. I have always been graced with corporate licenses that allowed me to install Enterprise Editions of SQL Server across the board. I am happy to say that the pendulum has swung and I am now tasked with justifying my SQL Server licenses. This has been a positive event for me that I would like to share with you. This session will share with you some of my current experiences with Standard and Enterprise Editions of SQL Server. You will be armed with some facts that can help you decide Standard or Enterprise edition so that you can meet the projects objectives, your SLAs and most importantly justify the cost of your SQL Server license.
SessionID: 12949
Whats New in T-SQL With SQL Server 2012
Event Date: 14-09-2013 - Session time: 00:00:00 - Track: DBA Admin 3
Speaker: David Dye
Title: Whats New in T-SQL With SQL Server 2012
Abstract:
This session covers the new features and functions introduced to T-SQL in SQL Server 2012. Our time will be spent reviewing enhancements to T-SQL specifically for SQL Server 2012 with attention to demonstrations and code samples. This is a basic session, but ttendees should have a general knowledge of T-SQL.
SessionID: 13284
From S to 3XL: Implementing Data Partitioning and Tiered Storage
Event Date: 14-09-2013 - Session time: 00:00:00 - Track: DBA Admin 3
Speaker: Dmitri Korotkevitch
Title: From S to 3XL: Implementing Data Partitioning and Tiered Storage
Abstract:
SessionID: 13361
DBA 101
Event Date: 14-09-2013 - Session time: 00:00:00 - Track: DBA Admin 3
Speaker: Don Stevic
Title: DBA 101
Abstract:
When I was a freshly minted DBA and trying to learn the ropes, my manager used to tell me “You should know that, that’s DBA 101”. As much as it frustrated me, he was right. There is a core set of knowledge that DBA. Correct SQL installation and configuration, how’s and whys of backups, how to make your role proactive, and many other things fall under that heading. This session is for the “freshly minted” DBA to help them find and define their own set of best practices.
SessionID: 13701
Backup Strategies are for Losers!
Event Date: 14-09-2013 - Session time: 00:00:00 - Track: DBA Admin
Speaker: Ed Watson
Title: Backup Strategies are for Losers!
Abstract:
Every company has a backup strategy. That backup strategy is worthless and will cause your business to fail miserably while losing valuable customer data and more importantly you will lose my order of chicken wings! In this session you will learn why backup strategies are for losers, what can I do to keep from being a loser, and how can I build a winning strategy!
SessionID: 14022
An Introductory Look at Execution Plans
Event Date: 14-09-2013 - Session time: 00:00:00 - Track: DBA Admin 3
Speaker: Eric Wisdahl
Title: An Introductory Look at Execution Plans
Abstract:
SessionID: 14086
Join Us! Getting Started as a Technical Speaker
Event Date: 14-09-2013 - Session time: 00:00:00 - Track: Prof Dev/Cloud/Misc
Speaker: Eddie Wuerch
Title: Join Us! Getting Started as a Technical Speaker
Abstract:
SessionID: 14851
Power View Reporting Enhancements in SQL Server
Event Date: 14-09-2013 - Session time: 00:00:00 - Track: BI 2
Speaker: Guillermo Caicedo Santiago
Title: Power View Reporting Enhancements in SQL Server
Abstract:
SessionID: 15009
Spatial Data: Cooler Than You'd Think!
Event Date: 14-09-2013 - Session time: 00:00:00 - Track: DBA Admin
Speaker: Hope Foley
Title: Spatial Data: Cooler Than You'd Think!
Abstract:
Spatial data has been around since 2008 but it should fire it's PR person. It's too bad that spatial data gets no love, it's actually something that pretty much all SQL Server shops could use. This session will focus on utilizing these native types to store, analyze, and retrieve spatial data. I will use some real world examples to help get the wheels turning on how you can use it within your organization and show how powerful it can be to see your data visually on a map.
SessionID: 15787
5 TSQL Commands I've been missing
Event Date: 14-09-2013 - Session time: 00:00:00 - Track: DBA Admin 2
Speaker: Jason Carter
Title: 5 TSQL Commands I've been missing
Abstract:
Being a full-stack .NET developer, I have written my fair share of T-SQL, but not until I became an accidental DBA did I find a new world of T-SQL options available to me. In this session, I will go over a five T-SQL commands available since SQL Server 2005 and up that I have been completely missing. We will evaluate the usefulness of CTE, OUTPUT, MERGE, APPLY, and RANKING FUNCTIONS and how each of these can replace common cases you see everyday.
SessionID: 16321
Indexing for Join Optimization
Event Date: 14-09-2013 - Session time: 00:00:00 - Track: DBA Admin 3
Speaker: Jeffrey Garbus
Title: Indexing for Join Optimization
Abstract:
Everything you wanted to know about join optimization but were afraid to ask... Join types, indexing, and how the optimizer makes its selections.
SessionID: 16384
Strategies in Data Deployment
Event Date: 14-09-2013 - Session time: 00:00:00 - Track: Prof Dev/Cloud/Misc
Speaker: Jonathon Moorman
Title: Strategies in Data Deployment
Abstract:
A bane to almost every DBA, data deployments are one of the least enjoyed part of database development. In this session we'll look at the causes of this pain and the best ways to avoid the pain.
SessionID: 16512
Best Practice Data Visualization
Event Date: 14-09-2013 - Session time: 00:00:00 - Track: SSIS
Speaker: Jen Underwood
Title: Best Practice Data Visualization
Abstract:
SessionID: 16965
Predictive Analytics at your fingertips
Event Date: 14-09-2013 - Session time: 00:00:00 - Track: BI 2
Speaker: Jose L. Rivera
Title: Predictive Analytics at your fingertips
Abstract:
The Business Intelligence adoption over the last few years has grown dramatically to the point where organizations require business insights, not only from what has already happened (typical data warehousing), but from real-time performance and how will the future be, based on the business and market trends. In this session we will explore and demonstrate the main decision-making capabilities in SQL Server 2012 using Analysis Services, Data Mining and the power behind PowerPivot and PowerView hosted within Excel.
SessionID: 16973
Changing Data Is Easy, Managing Data Change is Hard!
Event Date: 14-09-2013 - Session time: 00:00:00 - Track: DBA Admin 3
Speaker: James McAuliffe
Title: Changing Data Is Easy, Managing Data Change is Hard!
Abstract:
SessionID: 17060
Solving Complex Problems with Extended Events
Event Date: 14-09-2013 - Session time: 00:00:00 - Track: DBA Admin
Speaker: Jonathan Kehayias
Title: Solving Complex Problems with Extended Events
Abstract:
New to SQL Server 2008, Extended Events provide a refreshingly new method of looking at what occurs inside of SQL Server. This session will show you how to leverage Extended Events to solve complex problems by identifying the root cause faster than other methods of data collection provide.
SessionID: 17200
Moving Big Data - SSIS, Pig, and Sqoop
Event Date: 14-09-2013 - Session time: 00:00:00 - Track: BI Big Data
Speaker: John Welch
Title: Moving Big Data - SSIS, Pig, and Sqoop
Abstract:
SessionID: 17366
SSIS Development Using .net
Event Date: 14-09-2013 - Session time: 00:00:00 - Track: SSIS
Speaker: Jorge Novo
Title: SSIS Development Using .net
Abstract:
SessionID: 17434
Entity Framework: Or How I Learned to Stop Worrying and Learned to Love Developers
Event Date: 14-09-2013 - Session time: 00:00:00 - Track: DBA Admin
Speaker: Richie Rump
Title: Entity Framework: Or How I Learned to Stop Worrying and Learned to Love Developers
Abstract:
Do you have applications in your environment that don't use SQL written by a person but by the application itself? No, the system isn't self-aware. Chances are the system is utilizing Microsoft's Entity Framework.
Entity Framework (EF) and other object relational mapping technologies have been a boon for developers. But is Entity Framework a technology that developers should even be using? In this session, we'll review what Entity Framework is and how it's changed over time. We'll also dive into how Entity Framework works and what to look for when inspecting a database generated by Entity Framework. Finally, we'll review T-SQL generated by Entity Framework and give some tips on how to improve performance. If you're a data professional that manages databases that are accessed through Entity Framework or would like a basic knowledge of how Entity Framework works this session is for you.
SessionID: 17526
SSRS: On Premises or Azure? What's the difference?
Event Date: 14-09-2013 - Session time: 00:00:00 - Track: BI 2
Speaker: Josh Luedeman
Title: SSRS: On Premises or Azure? What's the difference?
Abstract:
With a lot of companies looking to the cloud for cost savings, it helps to know what the differences are between on premises and cloud installations of your IT services. In this session, we'll take a look at SQL Server Reporting Services and the feature differences between deploying in the cloud, and deploying on premises. We'll look at different options for where you can deploy your reports as well. Also, Shannon Lowder will help with the associated costs of each solution, as well as preparing you for some of the gotchas you'll face as you move to the cloud today.
SessionID: 17551
Creating an SSIS Framework
Event Date: 14-09-2013 - Session time: 00:00:00 - Track: SSIS
Speaker: James Phillips
Title: Creating an SSIS Framework
Abstract:
In this session we will cover what is a SSIS Framework, why you need a SSIS Framework, and how to implement it.
SessionID: 18058
Discover, Document, Diagnose Your Servers on Your Coffee Break
Event Date: 14-09-2013 - Session time: 00:00:00 - Track: BI 2
Speaker: Kendal Van Dyke
Title: Discover, Document, Diagnose Your Servers on Your Coffee Break
Abstract:
Documentation is the bane of every DBA's existence. We all know we should do it but it's time consuming; by the time you're finally done it's probably out of date. Throw in the new servers you just found out about last week and keeping documentation up to date can turn into a full time job. And with everything we have to do in our day, who has time for that?
You need a way to work smarter, not harder, and automate your documentation. It can be done, and in this session you'll learn how to discover all the SQL Servers on your network, document their configuration from top to bottom (including OS details), and diagnose common problems before they turn into big headaches - all while you're on a coffee break. You'll look like a rock star without writing a line of code on your own or having to ask management to sign a check.
Attend this session and walk away with everything you need to generate documentation for your entire SQL Server environment on your first day back at the office
SessionID: 18256
Integrating PowerPivot and SharePoint
Event Date: 14-09-2013 - Session time: 00:00:00 - Track: BI 2
Speaker: Kevin Grohoske
Title: Integrating PowerPivot and SharePoint
Abstract:
If you've only seen the 'canned' MS demo's of PowerPivot and are looking a little to sink you teeth into, this is your session. We will walk through real-life demonstrations utilizing SharePoint and PowerPivot technologies. Describe approaches to common problems and pitfalls that have been learned overtime from real implementations.
SessionID: 18991
Getting started with Master Data Services 2012
Event Date: 14-09-2013 - Session time: 00:00:00 - Track: BI Big Data
Speaker: Luis Figueroa
Title: Getting started with Master Data Services 2012
Abstract:
Are you currently using Master Data Services? if the answer is no, you can't afford to miss this presentation. In this session Luis will provide an overview of MDS 2012. Whether you are looking for a better solution for your business users than the common spread-marts or you are implementing a Master Data Management strategy to go along with your EDW, this session is for you.
SessionID: 19894
SSIS - Integrating PowerShell in a ScriptTask component
Event Date: 14-09-2013 - Session time: 00:00:00 - Track: Powershell
Speaker: Maximo Trinidad
Title: SSIS - Integrating PowerShell in a ScriptTask component
Abstract:
This session will demostrate how you can reuse a PowerShell script in SSIS "Script Task" component as part on a ETL flow. I'll be showing some basic .NET Script code in both C# and VB. I'll be adding some useful tips when re-using existing Powershell code. Integrating different .NET technologies in a SSIS package: C#, VB.NET, XML, and PowerShell. Everyone is welcome to attend.
SessionID: 19969
Complex DAX Functions
Event Date: 14-09-2013 - Session time: 00:00:00 - Track: BI Big Data
Speaker: Mike Davis
Title: Complex DAX Functions
Abstract:
SessionID: 20374
DBA Task Automation: Unleash the PowerShell Hero in You!
Event Date: 14-09-2013 - Session time: 00:00:00 - Track: Powershell
Speaker: Michael Wells
Title: DBA Task Automation: Unleash the PowerShell Hero in You!
Abstract:
As DBAs, we constantly have to stretch our time and budget resources, and the best way to keep up with demands is through process automation. Workflow and PassThru parameters are just two of the features that will allow you to turn complex tasks into simple, repeatable, automated processes easier than you would have ever dreamed possible. And if you’ve had trouble with PowerShell in the past, the auto-completion and eager loading of modules will make your transition to PowerShell hero even simpler. Come see how mid-tone blue can help take your skills to the next level.
SessionID: 20485
Putting Quality Back Into Your Data Analysis
Event Date: 14-09-2013 - Session time: 00:00:00 - Track: Prof Dev/Cloud/Misc
Speaker: Michael Antonovich
Title: Putting Quality Back Into Your Data Analysis
Abstract:
This session introduces Data Quality Services, a feature introduced in SQL Server 2012. One of the challenges in developing Business Intelligence solutions is ensuring that the data does not have inconsistencies, incomplete records, invalid or inaccurate values, and data duplication. Sometimes when consolidating data from more than one source you have to transform data to create one standard set of domain values in a standard format. SQL 2012 answers this need with Data Quality Services (DQS). In this session, you will learn the basics of what DQS is and how it can be used to clean your data. You will see how to build a domain both manually and from an existing data table. You will then see how to use these domains to validate tables in SQL Server and Excel preparing them for use in SSAS and PowerPivot. After this session, you will understand how by putting quality back into your data, you can be your organization's BI hero.
SessionID: 20513
What the VLF?
Event Date: 14-09-2013 - Session time: 00:00:00 - Track: DBA Admin 2
Speaker: Mike Hillwig
Title: What the VLF?
Abstract:
Experienced DBAs know that SQL Server stores data in data files and transaction log files. What is less commonly known is that the transaction log file is broken up into smaller segments known as Virtual Log Files, or VLFs.
Having too many VLFs will cause performance to suffer. And having too few will cause backup performance to suffer. How do you strike the right balance?
In this more advanced session, veteran DBA Mike Hillwig will show you what VLFs are, how they're created, how to identify them, and how to strike the right balance between too few and too many.
SessionID: 21707
15 aspects of SQL Server indexes that you might not know
Event Date: 14-09-2013 - Session time: 00:00:00 - Track: Powershell
Speaker: Sebastian Meine
Title: 15 aspects of SQL Server indexes that you might not know
Abstract:
You probably know that indexes make you queries faster. But do you know why? Knowing how the different index types work under the covers will help you make the right decisions when (re-)designing you indexing strategy.
After attending this demo rich session you will be able to
- Explain the differences between SQL Servers 9 "index" types
- Identify the layout of SQL Server data on disk
- Decide which index types are the right ones to use for a given query
- Assess the impact of the Key on access speed
SessionID: 22328
When Reporting is More than Reporting
Event Date: 14-09-2013 - Session time: 00:00:00 - Track: BI 2
Speaker: Pam Shaw
Title: When Reporting is More than Reporting
Abstract:
Is your day full of repetitive tasks that you would like to hand off? Maybe you can push them back to the source. SSRS can empower you to empower your users. By pass the UI team and do it yourself. We will discuss options and considerations you should know about to create a report process to populate data your users are asking you to populate with validation and defaults.
SessionID: 23142
Maintaining Indexes in SQL Server
Event Date: 14-09-2013 - Session time: 00:00:00 - Track: DBA Admin 2
Speaker: Robert Biddle
Title: Maintaining Indexes in SQL Server
Abstract:
So... you've created a bunch of indexes to improve the performance of your application, but then you start to notice performance degradation overtime. Digging further, you find that your indexes are not being maintained. In this session we'll look at some different systems that can be used for index maintenance. Additionally we'll explore some of the basic DMV's that provide us information about indexes.
SessionID: 23287
Revenge: The SQL Part 2: The Sequel!
Event Date: 14-09-2013 - Session time: 00:00:00 - Track: Powershell
Speaker: Rob Volk
Title: Revenge: The SQL Part 2: The Sequel!
Abstract:
In a world...where DBAs are blamed, mistreated, and overworked...one man...WILL. GET. EVEN. In this entertaining and impractical follow-up to the entertaining and impractical Revenge: The SQL, Rob Volk will show you even more impractical but oh-so-tempting ways to get back at those who abuse SQL Server and make you clean it up. Techniques will cover: preventing sa use, preventing ad-hoc SQL, cursors and missing WHERE clauses, and the ever-popular trigger mayhem. And if you stay for the after-credits sequence you may encounter the evil twins, duplicate primary keys!
SessionID: 23439
Cure your sysadmin addiction
Event Date: 14-09-2013 - Session time: 00:00:00 - Track: DBA Admin
Speaker: Ronald Dameron
Title: Cure your sysadmin addiction
Abstract:
Learn how to use the Separation of Duties Framework and a Privileged Identity Management suite to minimize the permissions needed by DBAs to do routine work. I'll review the Separation of Duties Framework and an easy to implement, low hassle solution that provides DBAs the minimum necessary access required to maintain the server but not be able to view user data. I will prove that sysadmin is not always required more often than most DBAs think. Also, attendees will learn how to define a permission set with a single script that allows your company’s DBAs to do routine work and how to elevate DBA permissions quickly to respond to production emergencies.
SessionID: 23611
Building a Windows 8 app from scratch
Event Date: 14-09-2013 - Session time: 00:00:00 - Track: Prof Dev/Cloud/Misc
Speaker: Russell Fustino
Title: Building a Windows 8 app from scratch
Abstract:
-
A modern UI user experience that leverages the signature Windows 8 controls such as GridView, ListView, FlipView, AppBar, Semantic Zoom and other Windows 8 controls.
-
A user experience that scale
-
Getting data locally or thru Azure
SessionID: 24619
OnPremise to Azure
Event Date: 14-09-2013 - Session time: 00:00:00 - Track: Prof Dev/Cloud/Misc
Speaker: Shannon Lowder
Title: OnPremise to Azure
Abstract:
During this talk I'll walk you through the process actually used to migrate a client's systems from hosted in a company closet to multiple Microsoft Azure data centers. Along the way we'll discuss the planning that went into the migration, the testing we went through, the pain points we hit, all the way to up and running in the cloud. This session covers the roadmap, we won't go through the actual migration itself...that took almost a year to complete.
SessionID: 26595
Event Date: 14-09-2013 - Session time: 00:00:00 - Track: SSIS
Speaker: Tim Mitchell
Abstract:
In this demo-packed session, we'll work through some of the most common causes of performance bottlenecks in SSIS packages, along with recommended practices for maximizing performance. Among the topics we'll cover: troubleshooting methods to detect performance hotspots; optimizing sources and destinations for maximum throughput; choosing the most efficient data flow transformations; and using parallelism to improve performance.
SessionID: 26827
A Walk Around the SQL Server 2012 Audit Feature
Event Date: 14-09-2013 - Session time: 00:00:00 - Track: DBA Admin
Speaker: Timothy McAliley
Title: A Walk Around the SQL Server 2012 Audit Feature
Abstract:
In this session, we will start by covering an overview of server and database auditing capabilities of SQL Server 2012. The session will largely focus on the specifics of using the SQL Server Audit feature, and we will step through a demonstration on configuring, maintaining and troubleshooting SQL Server Audit for server and database events.
SessionID: 26866
He Said - She Said: A Telemcommuting Love Story
Event Date: 14-09-2013 - Session time: 00:00:00 - Track: Prof Dev/Cloud/Misc
Speaker: Tim Ford
Title: He Said - She Said: A Telemcommuting Love Story
Abstract:
He's been telecommuting in some capacity or another since before he was a DBA. For 13 years he's been able to be a productive, responsive, integral and valuable asset to my company without maintaining a physical presence within the confines of a corporate office. She's been telecommuting for less than a year and is directing a fleet of SQL BI Professionals for a Major Microsoft partner.
Together, let's have a conversation and discuss what has (and has not) worked for us over the years. Let's discuss the traits of a good telecommuter as well as those attributes that may not make this the right arrangement for everyone. We will even discuss what our companies have done over the years to not only accommodate telecommuting, but to embrace and succeed from having staff that work remotely!
Taken from the approach of a husband and wife team with different experiences in telecommuting, this session is aimed at staff, spouses and management alike.
SessionID: 34844
10 Things That Every DBA Should Know!
Event Date: 14-09-2013 - Session time: 00:00:00 - Track: DBA Admin 2
Speaker: John Morehouse
Title: 10 Things That Every DBA Should Know!
Abstract:
Are you just starting out in the DB world? Are you a developer wanting to gain further insight on how to improve your SQL Skills? If you answered 'Yes' to either of those questions, then this is the session for you! John will be talk about things from both an administration side a well as developmental that he's seen in the wild that every DBA should know and understand. We'll look at things like Auto Shrink, SELECT *, Index Basics and 7 others!
SessionID: 8756
Event Date: 14-09-2013 - Session time: 00:00:00 - Track: DBA Admin
Speaker: Tony Tomarchio and Sandy Sandifer
Abstract:
SessionID: 8845
PowerShell for Data Professionals
Event Date: 14-09-2013 - Session time: 00:00:00 - Track: Powershell
Speaker: Aaron Nelson
Title: PowerShell for Data Professionals
Abstract:
SessionID: 9579
Building Your Professional Development Plan
Event Date: 14-09-2013 - Session time: 00:00:00 - Track: Prof Dev/Cloud/Misc
Speaker: Andy Warren
Title: Building Your Professional Development Plan
Abstract:
SessionID: 9902
DAX for T-SQL folks
Event Date: 14-09-2013 - Session time: 00:00:00 - Track: BI Big Data
Speaker: Anthony Sammartino
Title: DAX for T-SQL folks
Abstract:
A lot of report development today is done through T-SQL using a lot of temp tables and aggregate functions. The reason for this is because a lot of database developers were scared of Analysis Services MDX and its complexity. Until SQL Server 2012 there was no other option in the Microsoft stack for a corporate BI solution until SQL Server 2012 and the BISM Tabular Model. BISM Tabular's query language is an Excel like language called Data Analysis Expressions (DAX). This session will cover some basic concepts of the DAX language and how powerful it is and why the T-SQL developer should consider it.