Nr: 160
SQLSaturday #160 - Kalamazoo 2012
SessionID: 10013
Manage SQL Server 2012 on Server Core w/PowerShell
Event Date: 22-09-2012 - Session time: 00:00:00 - Track: Track 5
Speaker: Allen White
Title: Manage SQL Server 2012 on Server Core w/PowerShell
Abstract:
SessionID: 10340
Dive into the Query Optimizer-Undocumented Insight
Event Date: 22-09-2012 - Session time: 00:00:00 - Track: Track 1
Speaker: Benjamin Nevarez
Title: Dive into the Query Optimizer-Undocumented Insight
Abstract:
SessionID: 10731
Building Faster SQL Servers
Event Date: 22-09-2012 - Session time: 00:00:00 - Track: Track 4
Speaker: Brent Ozar
Title: Building Faster SQL Servers
Abstract:
SQL Server speed boils down to how fast we can get data in and out of storage. Sooner or later, we're going to run out of memory to cache. In this session, we take a lesson from Microsoft's blazing-fast Fast Track Reference Architectures, look at why they work so well for the wildest queries, and explain how to build our own SQL Servers for quick queries. Brent Ozar shows you how to test your own servers and compares them to servers he's worked with in the field.
SessionID: 11776
So I started this blog... now what?
Event Date: 22-09-2012 - Session time: 00:00:00 - Track: Track 1
Speaker: Colleen Morrow
Title: So I started this blog... now what?
Abstract:
Ever thought about trying your hand at blogging? Or maybe you've started a blog but struggle with what to write about. We'll take a beginner's look at blogging and examine common roadblocks, finding topics, building readership, and setting you on the road to blogging stardom.
SessionID: 12743
SRS Report Builder for Business Intelligence
Event Date: 22-09-2012 - Session time: 00:00: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: 12816
Effective Data Visualization: The Ideas of Edward
Event Date: 22-09-2012 - Session time: 00:00:00 - Track: Track 5
Speaker: David Giard
Title: Effective Data Visualization: The Ideas of Edward
Abstract:
We spend much of our time collecting and analyzing data. That data is only useful if it can be displayed in a meaningful, understandable way.
Yale professor Edward Tufte presented many ideas on how to effectively present data to an audience or end user.
In this session, I will explain some of Tufte's most important guidelines about data visualization and how you can apply those guidelines to your own data. You will learn what to include, what to remove, and what to avoid in your charts, graphs, maps and other images that represent data.
SessionID: 13324
DBA Basics: The Four Tasks Every DBA Should Know.
Event Date: 22-09-2012 - Session time: 00:00:00 - Track: Track 3
Speaker: David Maxwell
Title: DBA Basics: The Four Tasks Every DBA Should Know.
Abstract:
There are four basic tasks every DBA should know how to do. They are, in this order: Restore, Backup, Index and Stats maintenance, and Consistency Checking. After this session, beginning and "involuntary" DBAs will know the basic ins and outs of each of these four critical tasks, as well as how to set up recurring maintenance on their servers, and handle some of the common issues these tasks present
SessionID: 14075
DB1: Let's Talk Internals
Event Date: 22-09-2012 - Session time: 00:00:00 - Track: Track 4
Speaker: Eddie Wuerch
Title: DB1: Let's Talk Internals
Abstract:
There are many tools and techniques for finding performance problems, but solving them is usually left to the person using those techniques. This extended session focuses on what’s going on under SQL Server’s hood for a set of tasks normally hidden from users, such as: memory allocation, data manipulation, and on-disk and in-memory data structures. Armed with this knowledge, you will be better prepared to solve a variety of performance problems through deeper insight into the processes working behind the scenes.
SessionID: 14076
DB2: Let's Talk Internals
Event Date: 22-09-2012 - Session time: 00:00:00 - Track: Track 4
Speaker: Eddie Wuerch
Title: DB2: Let's Talk Internals
Abstract:
There are many tools and techniques for finding performance problems, but solving them is usually left to the person using those techniques. This extended session focuses on what’s going on under SQL Server’s hood for a set of tasks normally hidden from users, such as: memory allocation, data manipulation, and on-disk and in-memory data structures. Armed with this knowledge, you will be better prepared to solve a variety of performance problems through deeper insight into the processes working behind the scenes.
SessionID: 14409
Scaling SQL Server to HUNDREDS of Terabytes!
Event Date: 22-09-2012 - Session time: 00:00:00 - Track: Track 2
Speaker: Garrett Edmondson
Title: Scaling SQL Server to HUNDREDS of Terabytes!
Abstract:
SessionID: 15010
PowerPivot BISM in SQL Server 2012
Event Date: 22-09-2012 - Session time: 00:00:00 - Track: Track 5
Speaker: Hope Foley
Title: PowerPivot BISM in SQL Server 2012
Abstract:
Want to create snazzy reports to impress the boss but aren't a BI expert? Don't climb the clock tower just yet, go get yourself PowerPivot 2012 and come to my session. We'll go over some very real world issues and ways PowerPivot can help solve it. Demos will be jam packed with many of the new features in 2012 at same time giving you a good base to get you started. And this session wouldn't be complete without covering BISM. We will definitely will cover how the BI world is all coming together as one to have hold and cherish in the BI Semantic Model.
SessionID: 15880
Event Date: 22-09-2012 - Session time: 00:00:00 - Track: Track 3
Speaker: Jason Spangler
Abstract:
Many new DBA's are unaware of the power of SQL Profiler. Many don't know it exists. And better yet, it's FREE. This session will generalize the importance of using Profiler to troubleshoot and tune your SQL queries. By demonstrating Profiler on a running server, attendees will get a look at what SQL is currently executing. This session will show how to discover query duration, reads, writes, locks, deadlocks, stored procedure executions and more.
SessionID: 15926
Discovering the Plan Cache
Event Date: 22-09-2012 - Session time: 00:00:00 - Track: Track 5
Speaker: Jason Strate
Title: Discovering the Plan Cache
Abstract:
SessionID: 16053
Hierarchies... on Steroids the No RBAR Way
Event Date: 22-09-2012 - Session time: 00:00:00 - Track: Track 2
Speaker: Jeff Moden
Title: Hierarchies... on Steroids the No RBAR Way
Abstract:
Hierarchical data sets are everywhere. If you haven't worked with one yet, you will. If you're already working with them, you know they can be horribly complex, slow performing, difficult to maintain resource hogs that can really take the steam out of any GUI or batch process. This simple but code intensive "black arts" session shows you how to quickly and easily get around all of that using all 3 common hierarchical structures and a new structure that just might make Nested Sets obsolete. For stalwarts, it also includes a very high performance method (100,000 nodes in 6 seconds) for converting Adjacency Lists to Nested Sets that even a beginner can understand. You just have to know that a Tally Table is involved somewhere in this. ;-)
SessionID: 16180
SQL 2012 -- All About HA and DR
Event Date: 22-09-2012 - Session time: 00:00:00 - Track: Track 2
Speaker: Joseph D'Antoni
Title: SQL 2012 -- All About HA and DR
Abstract:
Have you heard about all of the new Availability Group features in SQL 2012? Thinking about implementing a DR solution, but don't know where to start. In this presentation you'll learn all about the new DR features in SQL Server 2012 and see them in practice.
SessionID: 17307
Introduction to SSIS with a Real-World Example
Event Date: 22-09-2012 - Session time: 00:00:00 - Track: Track 1
Speaker: Ron Johnson
Title: Introduction to SSIS with a Real-World Example
Abstract:
SessionID: 17658
Wish you could live the glamorous consulting life?
Event Date: 22-09-2012 - Session time: 00:00:00 - Track: Track 2
Speaker: Juan Soto
Title: Wish you could live the glamorous consulting life?
Abstract:
Consulting is a great career choice, from the increased pay, (sometimes less), to the flexible hours, (working nights and weekends), you will work with a wide range of customers, (if you can find them), that will lead you to wonder why you didn't start earlier? (and walk away from a cushy job).
I would not trade my consulting career for any other choice, I love the rewards and the freedom it provides me, but I've learned the hard way.
In this session you will lean sales, marketing and management strategies to get your practice off the ground, sand traps to avoid along the way and a honest, down to earth assessment of the consulting life. An essential session for those thinking about this choice and/or those who are just starting out
SessionID: 21466
SQL Azure Federations
Event Date: 22-09-2012 - Session time: 00:00:00 - Track: Track 2
Speaker: Nitin Salgar
Title: SQL Azure Federations
Abstract:
This session is to introduce to SQL Azure Federations.
Will walk you through the process of setting up federation, managing feredations etc and converting an existing database to Federations.
This topic requires rudimentary SQL Azure understanding
SessionID: 21514
PowerShell, the New SQL Hammer
Event Date: 22-09-2012 - Session time: 00:00:00 - Track: Track 3
Speaker: Norman Kelm
Title: PowerShell, the New SQL Hammer
Abstract:
You've seen all the amazing scripts that use PowerShell, but writing your own is raising more questions. This session will help fill in the gaps by explaining all the moving parts of PowerShell 2.0, the integration with SQL Server and answer the following questions as well as others. Why is Invoke-Sqlcmd necessary? What is and why is there a Minishell for SQL Server? What makes the SQLSERVER: PS Drive so powerful? How does a remote SQL Server get added to the SQLSERVER: PS Drive?
SessionID: 23063
BI1 Big Data Analytics - Hadoop and Microsoft BI
Event Date: 22-09-2012 - Session time: 00:00:00 - Track: Track 4
Speaker: Rob Kerr
Title: BI1 Big Data Analytics - Hadoop and Microsoft BI
Abstract:
SessionID: 23064
BI2 Big Data Analytics - Hadoop and Microsoft BI
Event Date: 22-09-2012 - Session time: 00:00:00 - Track: Track 4
Speaker: Rob Kerr
Title: BI2 Big Data Analytics - Hadoop and Microsoft BI
Abstract:
SessionID: 24319
Anatomy of a Join
Event Date: 22-09-2012 - Session time: 00:00:00 - Track: Track 2
Speaker: Luke Jian
Title: Anatomy of a Join
Abstract:
SessionID: 24411
Women in Technology Panel Discussion
Event Date: 22-09-2012 - Session time: 00:00:00 - Track: Track 4
Speaker: Shelly Noll
Title: Women in Technology Panel Discussion
Abstract:
Join some of the Women in Technology as we share our experiences and field questions from the audience. ALL ATTENDEES ARE WELCOME!
SessionID: 24412
NoSQL: Know Your Enemy
Event Date: 22-09-2012 - Session time: 00:00:00 - Track: Track 3
Speaker: Shelly Noll
Title: NoSQL: Know Your Enemy
Abstract:
A current trend among application developers to is move data storage away from a traditional relational database model. This presentation will provide an introduction into the technology known as NoSQL. We will discuss who’s who in the NoSQL world and explain the different ways that NoSQL databases store data. We will also cover which types of applications are best suited for the NoSQL approach and when a relational database would be a more appropriate choice.
SessionID: 25099
Event Date: 22-09-2012 - Session time: 00:00:00 - Track: Track 3
Speaker: Kevin Bullen
Abstract:
SessionID: 26002
45 min to build your first SSRS Report
Event Date: 22-09-2012 - Session time: 00:00:00 - Track: Track 5
Speaker: Tamera Clark
Title: 45 min to build your first SSRS Report
Abstract:
Does this sound like you? You were just given access to SSRS and you want to make a report. Or, you're a DBA and could use a daily report. Either way, I've got your back! You will learn everything you need to know to get that first report out the door quickly and how to tweak it once it’s deployed. We’ll even look at the differences between building a report in BIDS (Business Intelligence Development Studio) and Report Builder 3.0. We’ll use SSRS (SQL Server Reporting Services) 2008 R2 and go interstellar with some space data!
SessionID: 26849
Event Date: 22-09-2012 - Session time: 00:00:00 - Track: Track 4
Speaker: Tim Ford
Abstract:
SessionID: 27802
Transactional Replication 101
Event Date: 22-09-2012 - Session time: 00:00:00 - Track: Track 5
Speaker: Wendy Pastrick
Title: Transactional Replication 101
Abstract:
We will cover the players in the game: Pubishers, Subscribers and Distributors, then delve into the data delivery process with Publications, Subscriptions and Articles, finishing up with the Log Reader and how to make sure everything is working and running smoothly.
SessionID: 8979
SQL Server 2012 AlwaysOn Readable Secondaries
Event Date: 22-09-2012 - Session time: 00:00:00 - Track: Track 1
Speaker: Adam Belebczuk
Title: SQL Server 2012 AlwaysOn Readable Secondaries
Abstract:
SessionID: 9678
Load Balancing Analysis Services
Event Date: 22-09-2012 - Session time: 00:00:00 - Track: Track 1
Speaker: Anthony Mattas
Title: Load Balancing Analysis Services
Abstract:
Have you ever wondered how to scale Analysis Services across the globe?
This session will cover a unique approach to load balancing SQL Server Analysis services using a unique approach created by Carl Rabler and Josh Caplan to load balance SQL Server Analysis services using features already built in to SQL Server Analysis Services and some standard Microsoft technologies.
SessionID: 9820
Introduction to Microsoft StreamInsight
Event Date: 22-09-2012 - Session time: 00:00:00 - Track: Track 1
Speaker: Arie Jones
Title: Introduction to Microsoft StreamInsight
Abstract: