Nr: 211
SQLSaturday #211 - Chicago 2013
SessionID: 11472
What’s New for BI in Excel 2013?
Event Date: 13-04-2013 - Session time: 00:00:00 - Track: Track 1
Speaker: Chris Webb
Title: What’s New for BI in Excel 2013?
Abstract:
SessionID: 12565
Event Date: 13-04-2013 - Session time: 00:00:00 - Track: Track 5
Speaker: David Klee
Abstract:
SessionID: 13382
Hailing Frequencies: SSAS Terms and Concepts
Event Date: 13-04-2013 - Session time: 00:00:00 - Track: Track 1
Speaker: Doug Lane
Title: Hailing Frequencies: SSAS Terms and Concepts
Abstract:
In this Star Trek-themed presentation, we will explain the terms and concepts important to understand when participating in projects involving SQL Server Analysis Services (SSAS).
You’ll learn the key differences between SSAS Multidimensional Model (Cubes) and SSAS Tabular Model. You’ll also learn the definitions and examples of key terms for each model, including but not limited to: measure groups, measures, dimensions, attributes, and hierarchies in the SSAS Multidimensional Model and tables, columns, and calculated measures in the SSAS Tabular Model. We will also demonstrate the basics of browsing of both Multidimensional and Tabular models using Excel 2013.
SessionID: 13660
Service Broker: The Queue Continuum
Event Date: 13-04-2013 - Session time: 00:00:00 - Track: Track 6
Speaker: Ed Leighton-Dick
Title: Service Broker: The Queue Continuum
Abstract:
Pop quiz: How can SQL Server help developers build scalable, distributed, and asynchronous applications? Service Broker is the answer! In this presentation, I'll show you what it is; talk about when and why you might want to use it in your applications; walk through an example of how to set it up; and share a few lessons learned from our successful implementations.
SessionID: 13940
Making the Leap from Profiler to Extended Events
Event Date: 13-04-2013 - Session time: 00:00:00 - Track: Track 2
Speaker: Erin Stellato
Title: Making the Leap from Profiler to Extended Events
Abstract:
If you’re like me, you’ve been using SQL Trace and Profiler since you started using SQL Server. They’re like old friends, tried and true. You know how they work, you know what you can capture, you know how to find the data you need. But now you’ve been told that your good friends have been deprecated in SQL Server 2012, and you need to become best friends with Extended Events. What is THAT all about? It’s ok. Really. In this session we’ll look at Profiler and Extended Events side by side to see how easy it is to transition to Extended Events. We’ll step through real world examples using Extended Events to do what you’re used to doing with Trace, and even more. You can find the time learn Extended Events…today.
SessionID: 13941
Demystifying Database Statistics
Event Date: 13-04-2013 - Session time: 00:00:00 - Track: Track 4
Speaker: Erin Stellato
Title: Demystifying Database Statistics
Abstract:
Database statistics are not made up numbers, like the statistics you may hear on TV or read in a news article. They are critical metadata used by SQL Server’s query optimizer. In this session, we will look at statistics from the ground up and remove the mystery that surrounds them. Demos and real-world examples will be used to explain what statistics are, why you should care about them, and what you can control.
By the end of the session, you will understand:
• How to view statistics and interpret the histogram
• How and when to update statistics
• How statistics affect the query optimizer
• When you can let SQL Server manage statistics, and when you need to step in
SessionID: 14099
Partitioning for Perf and Mgmt of Large Tables
Event Date: 13-04-2013 - Session time: 00:00:00 - Track: Track 5
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 seamlessly 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: 14924
Monitoring and collecting storage info for DBAs
Event Date: 13-04-2013 - Session time: 00:00:00 - Track: Track 6
Speaker: Haidong Ji
Title: Monitoring and collecting storage info for DBAs
Abstract:
As an admin, we need to keep an eye on storage: What is the total size and available size on disk devices? What about mount points? How much space does each database take? What about breaking that down into schemas, tables, data size, and index size? Granted, some of that can be seen through Management Studio reports, but what if we want to keep a historical record of all that for planning and trending purposes? What if we are on a tight budget and cannot afford monitoring software.
In this session, I will explain and demo a PowerShell/SQL Server combo solution that is simple, elegant, and works! You will come away with code and instructions on how to implement it.
SessionID: 15005
Consulting The Good, The Bad, The Ugly
Event Date: 13-04-2013 - Session time: 00:00:00 - Track: Track 8
Speaker: Hope Foley
Title: Consulting The Good, The Bad, The Ugly
Abstract:
Ted Krueger will join Hope in presenting this session. Consulting is a mystical career path that is often questioned: should I do it, can I do it and why should I do it? Come join us on a discussion of the pros and cons to consulting with an emphasis on SQL Server and Microsoft Technologies. We'll field questions with real world experiences. Once you leave this open floor session, you'll be able to make better choices in your own professional development and how consulting may or may not effect it.
SessionID: 15565
Building an Effective Data Warehouse Architecture
Event Date: 13-04-2013 - Session time: 00:00:00 - Track: Track 1
Speaker: James Serra
Title: Building an Effective Data Warehouse Architecture
Abstract:
SessionID: 15568
What exactly is Business Intelligence?
Event Date: 13-04-2013 - Session time: 00:00:00 - Track: Track 4
Speaker: James Serra
Title: What exactly is Business Intelligence?
Abstract:
BI is the “Gathering of data from multiple sources to present it in a way that allows executives to make better business decisions”. I will describe in more detail exactly what BI is, what encompasses the Microsoft BI stack, why it is so popular, and why a BI career pays so much. I will review specific examples from previous projects of mine that show the benefits of BI and its huge return-on-investment. I'll go into detail on the components of a BI solution, and I will discuss key concepts for successfully implementing BI in your organization.
SessionID: 15889
Advanced Charting Techniques in SSRS
Event Date: 13-04-2013 - Session time: 00:00:00 - Track: Track 1
Speaker: Jason Thomas
Title: Advanced Charting Techniques in SSRS
Abstract:
SSRS 2008 R2 has been a game changer for SQL Server in terms of visualization techniques. With a wide range of available options for charting, BI professionals struggle to get familiar with even the basic functionalities of most charts.
This session will talk about the basic functionalities of all the charts as well as some tips and tricks around them. Come to this session and take your charting skills to the next level.
SessionID: 15951
What Are You Waiting For?
Event Date: 13-04-2013 - Session time: 00:00:00 - Track: Track 2
Speaker: Jason Strate
Title: What Are You Waiting For?
Abstract:
SessionID: 15953
Discovering the Plan Cache
Event Date: 13-04-2013 - Session time: 00:00:00 - Track: Track 2
Speaker: Jason Strate
Title: Discovering the Plan Cache
Abstract:
SessionID: 16217
Event Date: 13-04-2013 - Session time: 00:00:00 - Track: Track 6
Speaker: Joseph D'Antoni
Abstract:
Back in the old days, compression and databases was a really bad idea. Now, with powerful CPUs we can use to both improve performance and save disk space. We will cover the basics of how all compression and deduplication works, and then we will learn how SQL Server page and row compression work, and the special compression that is used in SQL 2012 Columnstore Indexes. We will demo performance and space savings in using compression.
SessionID: 16914
Analytic Cartography: Master geospatial reporting
Event Date: 13-04-2013 - Session time: 00:00:00 - Track: Track 3
Speaker: Julie Koesmarno
Title: Analytic Cartography: Master geospatial reporting
Abstract:
In this session, Julie will show you three options for creating and delivering these analytics. First SQL Server Reporting Services 2012 will be presented to show how we can create custom shape objects to conform with business defined regions. Secondly, using the power of Excel 2013, Bing Maps and GeoFlow, learn how to build captivating visualizations directly in Excel. Finally, we'll show how easy it is to build interactive maps using Power View.
SessionID: 17410
What is a BI DBA?
Event Date: 13-04-2013 - Session time: 00:00:00 - Track: Track 3
Speaker: Jorge Segarra
Title: What is a BI DBA?
Abstract:
Have you ever read a job description (or needed to hire one yourself) asking specifically for a “BI DBA” and wondered what exactly that means? In this session we will discuss the expectations of the role, what the various pieces of the Microsoft BI stack are and what administrative components and gotchas are involved for each one. If you need to unveil the mysteries and intricacies of administrating an SSIS, SSAS and/or SSRS environment from a DBA perspective then check this session out!
SessionID: 17488
Data Quality Services Approach to Cleansing
Event Date: 13-04-2013 - Session time: 00:00:00 - Track: Track 3
Speaker: Joseph Verftido
Title: Data Quality Services Approach to Cleansing
Abstract:
Learn about Microsoft’s Data Quality Services (DQS), what it is and how it works. You will discover how DQS sets itself apart from conventional data cleansing routines and go through examples on how to begin your own Data Quality Project. What really makes DQS unique and powerful is its ability to access shared knowledge, so we will show you how to access and use this shared knowledge to your benefit.
SessionID: 17518
Demystifying BISM and Tabular Mode SSAS
Event Date: 13-04-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: 18215
SQL Server Internals Architecture
Event Date: 13-04-2013 - Session time: 00:00:00 - Track: Track 2
Speaker: Kevin Kline
Title: SQL Server Internals Architecture
Abstract:
Want to take your skills to the next level? Then it’s critical to know SQL Server’s internal processes and architecture. This session will answer questions like:- What are the various areas of memory inside of SQL Server?- How are queries handled behind the scenes?- What does SQL Server do with procedural code, like functions, procedures, and triggers?- What happens during checkpoints? Lazywrites?- How are IOs handled with regards to transaction logs and database?This fast paced session will take you through many aspects of the internal operations of SQL Server. So strap on your silly, as we cover all these topics and more at speed with tongue planted firmly in cheek!
SessionID: 18424
SQL Server 2012 T-SQL
Event Date: 13-04-2013 - Session time: 00:00:00 - Track: Track 2
Speaker: Kathi Kellenberger
Title: SQL Server 2012 T-SQL
Abstract:
Have you heard about all the great new T-SQL features? Attend this session to learn about new functions, OVER clause enhancements, the Sequence Object and more!
SessionID: 18911
Locks, Blocks, and Deadlocks
Event Date: 13-04-2013 - Session time: 00:00:00 - Track: Track 4
Speaker: Kyle Neier
Title: Locks, Blocks, and Deadlocks
Abstract:
These terms seem to be thrown around all the time – but what do they all mean? In this session we’ll explore the different isolation levels in SQL Server and how they affect the way that blocking and locking behave within the database engine. We’ll dive into the most common locks and how they can be leveraged and avoided to improve your application experience. Once locks are explored, we’ll discuss the dreaded deadlock and discuss techniques to detect and mitigate this troublemaker in your environment.
SessionID: 19131
Getting the most out of Power View
Event Date: 13-04-2013 - Session time: 00:00:00 - Track: Track 3
Speaker: Leonard Murphy
Title: Getting the most out of Power View
Abstract:
SessionID: 20058
PowerShell 101
Event Date: 13-04-2013 - Session time: 00:00:00 - Track: Track 7
Speaker: Merrill Aldrich
Title: PowerShell 101
Abstract:
If you haven't dug in to PowerShell at this point, you're missing out on some amazing, powerful, practical stuff that could save you time every day. PowerShell does have a learning curve at the outset, especially for those not already familiar with OO concepts or programming in a language like C#, so this introductory session will go through the very basics of PowerShell syntax. If that collection of pipes and hyphens and curly braces seems to be written in some incomprehensible foreign language, this session is for you. At the end of the session you should have a grasp of how and why a PowerShell script does what it does, and the confidence to dig in deeper and begin using POSH scripts in your own work.
SessionID: 21355
SQL Server 2012 Memory Management
Event Date: 13-04-2013 - Session time: 00:00:00 - Track: Track 4
Speaker: Neil Hambly
Title: SQL Server 2012 Memory Management
Abstract:
SQL Server 2012 brings a wide range of changes from its previous versions - one key change is the way SQL Server memory is managed. With releases prior to SQL Server 2012, there were 2 memory managers, these have been merged into 1 with the latest version, and that’s just the start of the changes for SQL Server memory.
This session will dive into questions related to memory primarily for SQL Server 2012.
SessionID: 21829
Visualization Choices: What, When, and How?
Event Date: 13-04-2013 - Session time: 00:00:00 - Track: Track 8
Speaker: Paul Turley
Title: Visualization Choices: What, When, and How?
Abstract:
SessionID: 22388
An Optimistic Approach: Snapshot Isolation in SQL
Event Date: 13-04-2013 - Session time: 00:00:00 - Track: Track 5
Speaker: Paul Timmerman
Title: An Optimistic Approach: Snapshot Isolation in SQL
Abstract:
Until 2005, SQL Server was a very pessimistic RDBMS. However with the introduction of the Read Committed Snapshot database option and the new Snapshot Isolation level, that is no longer the case.
After a high level look at all SQL Server isolation levels, we’ll spend the majority of this session discussing the implementation of optimistic concurrency control in SQL Server. We’ll look at the benefits and drawbacks of using an optimistic isolation level and discuss use cases where it may or may not be appropriate.
Come learn how to put one of the more powerful, but least understood, aspects of SQL Server to work for you!
SessionID: 22994
Rules of Engagement: NoSQL is SQL Server's Ally
Event Date: 13-04-2013 - Session time: 00:00:00 - Track: Track 6
Speaker: Rick Krueger
Title: Rules of Engagement: NoSQL is SQL Server's Ally
Abstract:
When should you favor a NoSQL store over SQL Server, or consider polyglot persistence? In military and police operations, the rules of engagement determine when, where, and how force shall be used. As the “data police”, we are responsible for determining when, where, and how data is stored. As SQL Server professionals, it tends to be our first choice, even when there are other data storage options that are a ‘more natural’ fit. In this session, Rick and Dave will start with the NoSQL basics, and then dive into the different categories of NoSQL stores while explaining what each type is well suited for. (Pair Presented with Dave Valentine @IngeniousSQL)
SessionID: 23272
Tame Your Unruly Data...With Constraints!
Event Date: 13-04-2013 - Session time: 00:00:00 - Track: Track 7
Speaker: Rob Volk
Title: Tame Your Unruly Data...With Constraints!
Abstract:
Never given time or care, never forming good relationships, becoming bloated, corrupt and rife with indistinguishable copies, and all so horrifyingly pervasive in society. But enough about the Kardashians, what about YOUR DATA? If you want to straighten it out and prevent it from going too far in the first place, this session is for you. We will cover constraint basics (not null, check, primary key/unique, foreign keys), provide standard use cases, and address misconceptions about constraint use and performance. We will also look at triggers and application logic and why these are NOT substitutes for (but can effectively complement) good constraint usage. Attendees will enjoy learning how to keep THEIR data off the tabloid page!
SessionID: 23451
Deep dive on SQL Server 2012 Availability Groups
Event Date: 13-04-2013 - Session time: 00:00:00 - Track: Track 5
Speaker: Ross LoForte
Title: Deep dive on SQL Server 2012 Availability Groups
Abstract:
SessionID: 23942
Database Unit Testing made Easy
Event Date: 13-04-2013 - Session time: 00:00:00 - Track: Track 7
Speaker: Sanil Mhatre
Title: Database Unit Testing made Easy
Abstract:
Though most developers agree that unit testing plays an important role in software development, to ensure quality meet milestones, most developers write unit tests only as an afterthought. VSTS helps to mainstream Test Driven Development methodology (TDD) into world of database development. In this session, we will not only cover the basis of unit testing concepts and terminology, but also discuss how unit testing helps ensure and document the quality and accuracy of database deliverables. We will run through a demo of creating and running database unit tests using VSTS 2012, as well as upgrading from VSTS2010 database and unit test projects.
SessionID: 24308
Anatomy of a Join
Event Date: 13-04-2013 - Session time: 00:00:00 - Track: Track 7
Speaker: Luke Jian
Title: Anatomy of a Join
Abstract:
SessionID: 24583
Event Date: 13-04-2013 - Session time: 00:00:00 - Track: Track 6
Speaker: Frank Gill
Abstract:
Are you a DBA? Do you have more than one instance? An instance with more than one database? A database with more than one object? If you answered yes to any of these questions, join me to learn to administer multiple instances, databases and objects from a single query or script. Topics covered will include Central Management Server, loops with dynamic SQL and sqlcmd.
SessionID: 24675
Dashboard Do's and Don'ts
Event Date: 13-04-2013 - Session time: 00:00:00 - Track: Track 8
Speaker: Stacia Varga
Title: Dashboard Do's and Don'ts
Abstract:
SessionID: 24838
The Future of the DBA
Event Date: 13-04-2013 - Session time: 00:00:00 - Track: Track 4
Speaker: Scott Shaw
Title: The Future of the DBA
Abstract:
What will the DBA role look like in 10 years? 20 years? Will a DBA still be necessary? We'll explore a number of scenarios in an open forum as
we try to determine how, as DBA's, we can position ourselve for a bright and productive future. I'll talk about the trends I'm seeing
from companies of all shapes and sizes. This presentation isn't about consensus but about tackling the tough issues facing the
future of our profession.
SessionID: 24979
Flipping Through the SSIS Catalag
Event Date: 13-04-2013 - Session time: 00:00:00 - Track: Track 8
Speaker: MIKE DONNELLY
Title: Flipping Through the SSIS Catalag
Abstract:
SessionID: 26027
Event Date: 13-04-2013 - Session time: 00:00:00 - Track: Track 8
Speaker: Terry Bunio
Abstract:
SessionID: 26087
Upgrading to SQL Server 2012 with limited downtime
Event Date: 13-04-2013 - Session time: 00:00:00 - Track: Track 1
Speaker: Ted Krueger
Title: Upgrading to SQL Server 2012 with limited downtime
Abstract:
I don’t and that is why we’re going to look at methods to upgrade or migrate SQL Server 2005, SQL Server 2008 and SQL Server 2008 R2 up to SQL Server 2012 with as little downtime as possible - minutes. In this session, we’ll see how mirroring, log shipping and even replication, can make us look like DBA Rock stars at upgrade time.
SessionID: 8891
Writing Professional Database Code
Event Date: 13-04-2013 - Session time: 00:00:00 - Track: Track 7
Speaker: Aaron Lowe
Title: Writing Professional Database Code
Abstract:
SessionID: 9254
Demystifying Clustering for the DBA
Event Date: 13-04-2013 - Session time: 00:00:00 - Track: Track 5
Speaker: Allan Hirt
Title: Demystifying Clustering for the DBA
Abstract: