Nr: 242
SQLSaturday #242 - Indianapolis 2013
SessionID: 10034
Manage SQLServer Efficiently w/PowerShell Remoting
Event Date: 10-08-2013 - Session time: 00:00:00 - Track: Track 5
Speaker: Allen White
Title: Manage SQLServer Efficiently w/PowerShell Remoting
Abstract:
You have more and more servers to manage and less time to accomplish everything. You're writing scripts to automate those tasks but they still take time to run. PowerShell remoting allows you to manage servers without the overhead of Remote Desktop, and allows you to run processes on all your servers simultaneously. In this session we'll walk through how PowerShell remoting works, how to set it up, and how you can save time getting things done more quickly.
SessionID: 10189
Going Live! Upgrading to SQL 2012 with Log Shipping
Event Date: 10-08-2013 - Session time: 00:00:00 - Track: Track 2
Speaker: Brent Dragoo
Title: Going Live! Upgrading to SQL 2012 with Log Shipping
Abstract:
Want to see an in-the-trenches example of transitioning a SQL2005 server to a SQL2012 server? This session will review how we upgraded a SQL2005 server to a SQL2012 by utilizing Log Shipping, speedy restore operations, and quick thinking. This isn't a technical demonstration of how you COULD do something:this is a review of how we planned, organized, and executed a server upgrade. I'll include some of the problems we encountered and troubleshot before, during, and after the upgrade.
SessionID: 11119
BIML--Step by Step
Event Date: 10-08-2013 - Session time: 00:00:00 - Track: Track 3
Speaker: Julie Smith
Title: BIML--Step by Step
Abstract:
BIML--Business Intelligence Markup Language is your key to faster development of SSIS Projects. This session will guide you through initial familiarization and setup of BIML, ending with more complex demos which show the true power of BIML.
SessionID: 11255
“Indexing” Encrypted Data
Event Date: 10-08-2013 - Session time: 00:00:00 - Track: Track 2
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 encrypted values (ex: SSNs, Credit Card, etc) helping reduce the impact on the performance of a query.
SessionID: 12417
Event Date: 10-08-2013 - Session time: 00:00:00 - Track: Track 3
Speaker: Sios Technology and Allan Hirt
Abstract:
SessionID: 13321
DBA 911 - Database Corruption
Event Date: 10-08-2013 - Session time: 00:00:00 - Track: Track 1
Speaker: David Maxwell
Title: DBA 911 - Database Corruption
Abstract:
SessionID: 14112
Partitioning for Perf and Mgmt of Large Tables
Event Date: 10-08-2013 - Session time: 00:00:00 - Track: Track 2
Speaker: Eddie Wuerch
Title: Partitioning for Perf and Mgmt of Large Tables
Abstract:
Managing data in ever-growing transaction and history tables can be challenging. Activities with large chunks of data such as moving data to archive tables, batch-importing many rows, or defragging an entire table when only the active portion changes introduces heavy I/O and blocking. Table partitioning solves a host of headaches with minimal effort. Ever wanted to truncate or defrag part of a table, or insert an entire staging table of data into another table in milliseconds instead of hours? Come see what partitioning can provide for you.
SessionID: 16082
Event Date: 10-08-2013 - Session time: 00:00:00 - Track: Track 3
Speaker: Josh Burgin
Abstract:
There’s no arguing the proliferation of mobile devices in our society. Mobile devices offer BI teams a very exciting new product offering, Mobile BI. Early studies indicate Mobile BI can dramatically increase user adoption. It also allows BI teams to market to new customer segments. While the possibilities are great, Mobile BI also introduces a number of challenges that can push a BI team out of their comfort zone.
In this session we’ll discuss the pros and cons of Mobile BI. We’ll discuss common use cases and look at best practices for developing mobile visualizations in the Microsoft BI stack on both Windows 8 and iOS platforms.
SessionID: 16145
What SQL DBAs need to know about SharePoint
Event Date: 10-08-2013 - Session time: 00:00:00 - Track: Track 4
Speaker: JD Wade
Title: What SQL DBAs need to know about SharePoint
Abstract:
With the number of deployments of SharePoint exponentially growing every day, as a DBA, it is very likely you are going to have SharePoint databases on SQL Servers you support. This session reviews SharePoint strictly from the SQL Server perspective. You will learn how SharePoint is optimized for SQL, how to properly manage and maintain the SharePoint databases, how to optimize the SQL configuration for SharePoint, what settings in SharePoint need to be changed or not changed to maintain SQL Server performance, supported methods for providing high availability and disaster recovery, and the part SharePoint and SQL each play in the Microsoft Business Intelligence story.
SessionID: 17127
Troubleshooting SQL IO issues with Xperf
Event Date: 10-08-2013 - Session time: 00:00:00 - Track: Track 6
Speaker: Joe McTaggart
Title: Troubleshooting SQL IO issues with Xperf
Abstract:
SessionID: 17511
Demystifying BISM and Tabular Mode SSAS
Event Date: 10-08-2013 - Session time: 00:00:00 - Track: Track 3
Speaker: Josh Fennessy
Title: Demystifying BISM and Tabular Mode SSAS
Abstract:
In this session, attendees will gain understanding of what Multidimensional and Tabular modelling IS, as well as how the BISM layer helps to translate user requests to ensure no confusion is made. Attendees will also learn how to BUILD a Tabular model, and will help design a solution live during the presentation.
SessionID: 17619
Agile Data Warehouse Design – Just Enough Design for Success
Event Date: 10-08-2013 - Session time: 00:00:00 - Track: Track 3
Speaker: Joe Salvatore
Title: Agile Data Warehouse Design – Just Enough Design for Success
Abstract:
How comfortable are you with your current process for designing data warehouses? Have you encountered difficulties determining how to better gather, organize, and use requirements to ensure a successful data warehouse design? This session will help by providing an agile data warehouse design process that gets targeted and meaningful requirements. The session will start by reviewing common\current data warehouse design elements and architectures. Next, the session will detail primary agile techniques and terminology. Lastly, the session will detail the use of Modelstorming using BEAM* (Business Event Analysis Modeling) and the 7 Ws Framework.
SessionID: 17642
Event Date: 10-08-2013 - Session time: 00:00:00 - Track: Track 1
Speaker: Jim Miller
Abstract:
Have you ever fallen behind on your Microsoft BI solution documentation? Can you easily determine which tables
and queries are used in which SSRS Report / SSIS Package / or SSAS Cube? The answers to these questions are
probably buried in your BI solution metadata. In this session, we will examine techniques that can be used to extract,
organize, and query this very helpful metadata.
SessionID: 17892
Database Design Contentious Issues
Event Date: 10-08-2013 - Session time: 00:00:00 - Track: Track 4
Speaker: Karen Lopez
Title: Database Design Contentious Issues
Abstract:
A highly interactive and popular session where attendees evaluate the options and best practices of common and advanced design issues, such as: * Natural vs. Surrogate keys * Classwords and other Naming Standards * Varchar Minimums *the CLOUD * Who Calls the Shots and Who Does What? ...and others. Bring your votes, your debates, and your opinions.
SessionID: 18901
Into a Swan - Discovering the Beauty of RESTORE
Event Date: 10-08-2013 - Session time: 00:00:00 - Track: Track 4
Speaker: Kyle Neier
Title: Into a Swan - Discovering the Beauty of RESTORE
Abstract:
Many DBAs believe that a backup is the most important process to implement. For most, they soon realize that the most important process to the business is actually the restore. In this session, we’ll start by exploring some of the options in the SSMS restore wizard, but will quickly move to T-SQL to discover the power and beauty that writing the RESTORE statement can provide. In addition to the classic RESTORE DATABASE and LOG statements, we’ll work through some real world examples of how to leverage some of the lesser known syntax of the restore statement to help in both foreign and well known environments.
SessionID: 19164
Event Date: 10-08-2013 - Session time: 00:00:00 - Track: Track 6
Speaker: Lisa Gardner
Abstract:
SessionID: 21371
Why are we Waiting..
Event Date: 10-08-2013 - Session time: 00:00:00 - Track: Track 1
Speaker: Neil Hambly
Title: Why are we Waiting..
Abstract:
An in-depth session examining "Waits" happening in your SQL Servers, using the well-known "Waits Queues" methodology.
With particular focus in the session on understanding and interpreting the information found the (DMV) sys.dm_os_wait_stats,
Taking note of which “Waits “with the highest counts or excessive wait times, as well as those which “Waits” can be safely ignored,
We can discover those "performance hurdles" and ways to overcome or remove them, restoring your SQL Servers performance levels.
By using established methodologies like “Waits Queues”, we can systematically identify and remove performance
Previous Presented @ SQLBits 8 9 in UK @ SQLPASS Summit 2011 (310 Attendees) SQLDay
And @ several UK User Groups
SessionID: 21372
MDS and DQS - Beyond the TLAs to Data Quality
Event Date: 10-08-2013 - Session time: 00:00:00 - Track: Track 6
Speaker: Neil Hambly
Title: MDS and DQS - Beyond the TLAs to Data Quality
Abstract:
Many three-letter acronyms (TLAs) adorn our database world. This session focuses on two recent additions – MDS (Master Data Services) and DQS (Data Quality Services) – explaining what the new features are and exploring how to leverage them to improve your data quality.
High data quality is fundamental to any business analytics system. In this session, we’ll begin with an overview of data quality and the latest Microsoft tools available, and then demonstrate MDS and DQS and how to use them together for continuously improving data quality. We’ll also look at how to integrate them into your existing data-quality strategies. Data quality is everyone’s responsibility – but we can still lead the way forward. Join this session to see how.
SessionID: 22653
SSIS Templates Can Make Your Life Easier
Event Date: 10-08-2013 - Session time: 00:00:00 - Track: Track 4
Speaker: Brian Davis
Title: SSIS Templates Can Make Your Life Easier
Abstract:
How many times have you started a new SSIS project and added the same components that you’ve added to almost every other package you’ve created? Components to handle logging and errors or even a standard workflow for loading data files. In this session I’ll show you how you can create standard templates that already contain any and all of the common components you desire. We’ll also look at how to implement and use these templates so that the next time you create a SSIS package you can spend your time on the work you actually need to do instead of implementing common components over and over again.
SessionID: 23270
Denali Ho! Exploring SQL Server
Event Date: 10-08-2013 - Session time: 00:00:00 - Track: Track 2
Speaker: Rob Volk
Title: Denali Ho! Exploring SQL Server
Abstract:
SessionID: 24309
Anatomy of a Join
Event Date: 10-08-2013 - Session time: 00:00:00 - Track: Track 6
Speaker: Luke Jian
Title: Anatomy of a Join
Abstract:
SessionID: 24753
WIT Panel: You.. as a brand.
Event Date: 10-08-2013 - Session time: 00:00:00 - Track: Track 6
Speaker: WIT Panel
Title: WIT Panel: You.. as a brand.
Abstract:
You.. as a brand. How important is it to create a professional presence for your career success?
SessionID: 25998
Event Date: 10-08-2013 - Session time: 00:00:00 - Track: Track 4
Speaker: Tamera Clark
Abstract:
SessionID: 26198
Windowing Functions: THE Reason to Upgrade to 2012
Event Date: 10-08-2013 - Session time: 00:00:00 - Track: Track 1
Speaker: Kevin Boles
Title: Windowing Functions: THE Reason to Upgrade to 2012
Abstract:
SessionID: 26199
Common TSQL Mistakes
Event Date: 10-08-2013 - Session time: 00:00:00 - Track: Track 5
Speaker: Kevin Boles
Title: Common TSQL Mistakes
Abstract:
SessionID: 27560
Introduction to FileTables in SQL 2012
Event Date: 10-08-2013 - Session time: 00:00:00 - Track: Track 5
Speaker: Warren Sifre
Title: Introduction to FileTables in SQL 2012
Abstract:
SessionID: 27807
Visualizing Your Indexes - Science vs Art
Event Date: 10-08-2013 - Session time: 00:00:00 - Track: Track 1
Speaker: Wendy Pastrick
Title: Visualizing Your Indexes - Science vs Art
Abstract:
Indexes make queries run faster, right? Not always, no. And finding the right indexes for your needs is often more of an Art than a Science. Attend this session as we take a visual tour of how indexes are laid out and the way data is accessed when indexes are utilized. We will discuss clustered indexes as well as non-clustered indexes and also when to use indexed views along with some other variations.
SessionID: 28103
Getting Started with MDX
Event Date: 10-08-2013 - Session time: 00:00:00 - Track: Track 6
Speaker: William E Pearson III
Title: Getting Started with MDX
Abstract:
In this session, led by Microsoft BI Architect and SQL Server MVP Bill Pearson, we will concentrate largely upon crafting simple MDX expressions and queries whose purposes, for the most part, are to return a set of data. We will overview the structure of a cube, using as a basis the sample Adventure Works cube that is available to anyone installing SQL Server Analysis Services 2008 R2. We will then outline the components of simple MDX syntax, and get started writing basic expressions and queries. We will expose basic member functions, introduce filters (or “slicers”), and begin exploring core MDX functionality, including calculated members, and named sets. This session applies equally to Analysis Services 2008, 2008R2 and 2012.
SessionID: 8884
T-SQL Tips Tricks
Event Date: 10-08-2013 - Session time: 00:00:00 - Track: Track 1
Speaker: Aaron Cutshall
Title: T-SQL Tips Tricks
Abstract:
SessionID: 8971
Introduction to SQL Server 2012 AlwaysOn Availability Groups
Event Date: 10-08-2013 - Session time: 00:00:00 - Track: Track 2
Speaker: Adam Belebczuk
Title: Introduction to SQL Server 2012 AlwaysOn Availability Groups
Abstract:
SessionID: 9169
Agile Database Development
Event Date: 10-08-2013 - Session time: 00:00:00 - Track: Track 5
Speaker: Aaron King
Title: Agile Database Development
Abstract:
In this talk Aaron will introduce users to some techniques and tools for developing and maintaining SQL code inside an Agile SDLC. Aaron will use test driven development techniques and commit his code changes to Team Foundation Services and schedule a build. He'll also demonstrate some custom solutions and go over all of the different databases that a DBA might support in an on-premise TFS install.
SessionID: 9830
Cloud Ready: Preparing Yourself for Azure SQL Databases
Event Date: 10-08-2013 - Session time: 00:00:00 - Track: Track 5
Speaker: Arie Jones
Title: Cloud Ready: Preparing Yourself for Azure SQL Databases
Abstract:
SessionID: 9965
Pretty Output: T-SQL for Presentation
Event Date: 10-08-2013 - Session time: 00:00:00 - Track: Track 3
Speaker: Audrey Hammonds
Title: Pretty Output: T-SQL for Presentation
Abstract: