Nr: 126
SQLSaturday #126 - Indianapolis 2012
SessionID: 10005
Manage SQL Server 2012 on Server Core w/PowerShell
Event Date: 28-07-2012 - Session time: 00:00:00 - Track: Track 1
Speaker: Allen White
Title: Manage SQL Server 2012 on Server Core w/PowerShell
Abstract:
SessionID: 10190
Database Crime Scene Investigation
Event Date: 28-07-2012 - Session time: 00:00:00 - Track: Track 4
Speaker: Brent Dragoo
Title: Database Crime Scene Investigation
Abstract:
SessionID: 11112
Data Quality Services--Finally!
Event Date: 28-07-2012 - Session time: 00:00:00 - Track: Track 4
Speaker: Julie Smith
Title: Data Quality Services--Finally!
Abstract:
SessionID: 12027
Professional Networking for IT Pros
Event Date: 28-07-2012 - Session time: 00:00:00 - Track: Track 3
Speaker: Craig Purnell
Title: Professional Networking for IT Pros
Abstract:
Want to invest in your long term career success? You need to network. C’mon give it a try! It’s not that bad! This presentation will explain some in-person networking tips and some do’s and don’ts for networking on LinkedIn. Takeaways include: -How to find events -Tips on getting to most out of attending events -How to develop and maintain your network of contacts -A Review of Linkedin networking best practices and profile optimization strategies.
SessionID: 12346
Event Date: 28-07-2012 - Session time: 00:00:00 - Track: Track 5
Speaker: Dave Fackler
Abstract:
SessionID: 14037
Event Date: 28-07-2012 - Session time: 00:00:00 - Track: Track 1
Speaker: Eddie Wuerch
Abstract:
SessionID: 15019
Consulting The Good, The Bad, The Ugly
Event Date: 28-07-2012 - Session time: 00:00:00 - Track: Track 4
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: 15482
(SQL,SSIS,MDS) Adv Fuzzy Matching Roll Your Own
Event Date: 28-07-2012 - Session time: 00:00:00 - Track: Track 5
Speaker: Ira Warren
Title: (SQL,SSIS,MDS) Adv Fuzzy Matching Roll Your Own
Abstract:
Fuzzy Matching, Similarity Matching or Record Linkage is the most critical and least understood process in any Data Warehouse, BI, Integration, Big Data , Data Quality, MDM , Social Network or integrating crap effort. Over at LinkedIn there is Group run by Henrik Liliendahl Sorensen for Data Matching, Bill Winkler, principal researcher at the US Census" has written a series of white papers on record linkage and particular a technique called "Blocking Indexs". In addition we wil cover William Cohen Research Professor, Machine Learning Department, Carnegie Mellon University white papers an implementations. Presented will be our collection of "real world" examples(Code) and you will leave a master of record linkage and the concepts behind it
SessionID: 16715
Looking to the future - Tabular Mode SSAS
Event Date: 28-07-2012 - Session time: 00:00:00 - Track: Track 2
Speaker: Josh Fennessy
Title: Looking to the future - Tabular Mode SSAS
Abstract:
In this session, attendees will be treated to an introduction to tabular mode. Installation, configuraiton, development tips, maintance, and end user reporting options will all be introduced. A description of BISM and what it means for our beloved Multi-Dimension cubes will be discussed. Attendees wanting to know when to use tabular, and when to stick with multi-dimensional will want to attend this introductory session.
SessionID: 17130
SQL Server and Sharepoint: Best Frienemies
Event Date: 28-07-2012 - Session time: 00:00:00 - Track: Track 1
Speaker: Joe McTaggart
Title: SQL Server and Sharepoint: Best Frienemies
Abstract:
SharePoint is a rapidly growing application that relies heavily on SQL Server. In this session, we will discuss what a DBA needs to know to successfully manage instances hosting SharePoint databases. What configurations options are best for a SharePoint workload? What kind of maintenance shoule be performed? How should databases be provisioned? What the heck are all these databases for anyway? We will also discuss some nomenclature and key components of SharePoint to help better communicate with SharePoint application teams.
SessionID: 17131
Event Date: 28-07-2012 - Session time: 00:00:00 - Track: Track 2
Speaker: Joe McTaggart
Abstract:
SessionID: 18885
Powershell? Yea, but I'm a DBA!
Event Date: 28-07-2012 - Session time: 00:00:00 - Track: Track 4
Speaker: Kyle Neier
Title: Powershell? Yea, but I'm a DBA!
Abstract:
Powershell has become a very popular scripting language for Windows, Exchange, Sharepoint and other admins. In this session, we'll get our heads down and our inner geek on as we explore how Powershell can add value to our lives a DBAs. We'll explore how Powershell can handle common tasks as well as several tasks that are difficult or even impossible with TSQL. We'll wrap up by discussing how Powershell could be used to fully automate your install and post-install processes, standardizing your environment. Get your typing skills honed as you will leave here desiring to never click again.
SessionID: 19318
Introduction to the new Data Alert feature in SSRS
Event Date: 28-07-2012 - Session time: 00:00:00 - Track: Track 5
Speaker: Ludwig Armbruster
Title: Introduction to the new Data Alert feature in SSRS
Abstract:
SSRS 2012 provides a brand new feature called data alerts. It allows users to monitor changes in report data and send data alert messages by email when report data follow rules that define data of interest to you. This session introduces this great new feature and will show real world scenarios for its application.
SessionID: 20552
Seven SQL Agent Jobs You Should be Running
Event Date: 28-07-2012 - Session time: 00:00:00 - Track: Track 2
Speaker: Mike Hillwig
Title: Seven SQL Agent Jobs You Should be Running
Abstract:
See those things around your ankles? You hope they're your socks because no DBA wants to be caught with their pants down.
Whether you're an accidental DBA, a DBA who has just inherited a bunch of servers, or someone who works in a shop that won't buy monitoring tools, this session will help you get basic monitoring in place to make sure you know what's going on in your environment.
You'll learn how to implement seven simple scripts that perk their ears up and start barking like a dog after a stranger walks in the house. They are the canary in your coal mine. You'll know when backups fail, when they run longer than usual, when data files are getting full, when transaction logs have excessive VLFs, and more.
SessionID: 21505
The Script Task, powerhouse of SSIS
Event Date: 28-07-2012 - Session time: 00:00:00 - Track: Track 3
Speaker: Norman Kelm
Title: The Script Task, powerhouse of SSIS
Abstract:
SessionID: 23319
Tame Your Unruly Data...With Constraints!
Event Date: 28-07-2012 - Session time: 00:00:00 - Track: Track 2
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: 23957
Parameter sniffing - make it work for you !
Event Date: 28-07-2012 - Session time: 00:00:00 - Track: Track 5
Speaker: Sanil Mhatre
Title: Parameter sniffing - make it work for you !
Abstract:
In this session we will discuss the workings of Parameter Sniffing and demonstrate how it helps improve the performance of your database applications. We will also explore how Parameter Sniffing can go wrong and its impact. Several ways to fix bad Parameter Sniffing will be demonstrated to help make an appropriate choice for your scenario.
SessionID: 24119
SQL Azure Scalability with Federations
Event Date: 28-07-2012 - Session time: 00:00:00 - Track: Track 3
Speaker: Scott Klein
Title: SQL Azure Scalability with Federations
Abstract:
SessionID: 24311
Optimizing SQL Server I/O with Solid State Drives
Event Date: 28-07-2012 - Session time: 00:00:00 - Track: Track 3
Speaker: Luke Jian
Title: Optimizing SQL Server I/O with Solid State Drives
Abstract:
Optimal configuration and maintenance of the I/O subsystem is critical and can ultimately be responsible for higher response times of your applications. The HDDs are by design about 1 million times slower than the memory or CPU. In this session we analyze the different options that exist for durable storage, what are their pros and cons . Solid state drives are a viable option and we are going under the covers to see how you can best use them as an alternative to a large and expensive SAN in your infrastructure
SessionID: 24408
Powershell and Perfmon...Come on!
Event Date: 28-07-2012 - Session time: 00:00:00 - Track: Track 4
Speaker: Shaun Watts
Title: Powershell and Perfmon...Come on!
Abstract:
SessionID: 26081
SSIS: The DBA Multiplier
Event Date: 28-07-2012 - Session time: 00:00:00 - Track: Track 1
Speaker: Ted Krueger
Title: SSIS: The DBA Multiplier
Abstract:
SessionID: 26292
Parallel Query Execution Deep Dive
Event Date: 28-07-2012 - Session time: 00:00:00 - Track: Track 2
Speaker: Kevin Boles
Title: Parallel Query Execution Deep Dive
Abstract:
What exactly does it mean to parallelize a query? Why would the optimizer do this and what are the benefits and what are the drawbacks?? Is it always faster? Can it cause problems? Are there reasons we might NOT want parallelization? What can prevent it's use by the engine? These are some of the topics we will cover as we dig into this facet of the SQL Server relational engine.
SessionID: 27794
Read Dirty to Me - Isolation Levels/User Impact
Event Date: 28-07-2012 - Session time: 00:00:00 - Track: Track 1
Speaker: Wendy Pastrick
Title: Read Dirty to Me - Isolation Levels/User Impact
Abstract:
Issue a "SELECT {data} FROM {myTable}" statement and users need to trust the data returned is accurate. What happens when multiple processes access the same data? What happens further if one of those process is an UPDATE or even a DELETE statement? How about if both processes will be updating that data? Understanding Isolation in SQL Server is paramount in ensuring data integrity in your system. We will cover the different levels of isolation and how they impact what a user views when accessing the data at a given point-in-time.
SessionID: 27795
Transactional Replication 101
Event Date: 28-07-2012 - Session time: 00:00:00 - Track: Track 3
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: 28566
A Complete BI Solution in About an Hour!
Event Date: 28-07-2012 - Session time: 00:00:00 - Track: Track 5
Speaker: Aaron King
Title: A Complete BI Solution in About an Hour!
Abstract:
In this presentation Aaron will cover how to collect data from multiple SQL Servers using SQL Server 2008 Integration Services (SSIS). Then he will use SQL Server Reporting Services (SSRS) to report detail on that data. After that he will use SQL Server Analysis Services (SSAS) to create a KPI. Finally he’ll present that KPI on a dashboard via a web page. The goal of this presentation is to show how seamless the Microsoft Business Intelligence products are. If you’ve only used a few of these products, you’ll appreciate seeing them together all at once. Code will be provided.
SessionID: 33857
Contained DB? Did it do something wrong?
Event Date: 28-07-2012 - Session time: 00:00:00 - Track: Track 2
Speaker: Warren Sifre
Title: Contained DB? Did it do something wrong?
Abstract:
Imagine an environment where moving a database from a SQL Instance to another is as simple as just restoring the database. (Yes, no other steps!) SQL Server 2012 RC0 now supports Partial Contained databases. We will cover the different levels of containment, configuring SQL Server to support it, and much more (i.e. Demos).
SessionID: 34465
Overcoming Barriers and Avoiding Mistakes with BI
Event Date: 28-07-2012 - Session time: 00:00:00 - Track: Track 3
Speaker: William E Pearson III
Title: Overcoming Barriers and Avoiding Mistakes with BI
Abstract:
A Dynamic Dialog session: Whether you’re considering implementing business intelligence for the first time, have completed projects in the past (and are perhaps looking at later phases), or are somewhere in between, an investment in this session will likely pay dividends. Business Intelligence Architect and Microsoft MVP Bill Pearson leads a dialog about common pitfalls or traps that we can encounter in designing and implementing BI. We’ll discuss, as a group, environmental and other challenges we have experienced, and share ways to avoid or minimize them, in our ongoing efforts with BI.
SessionID: 8898
Writing Professional Database Code
Event Date: 28-07-2012 - Session time: 00:00:00 - Track: Track 5
Speaker: Aaron Lowe
Title: Writing Professional Database Code
Abstract:
SessionID: 8987
SQL Server 2012 AlwaysOn Readable Secondaries
Event Date: 28-07-2012 - Session time: 00:00:00 - Track: Track 4
Speaker: Adam Belebczuk
Title: SQL Server 2012 AlwaysOn Readable Secondaries
Abstract:
SessionID: 9801
PWNED! Security, SQL Server, and You!
Event Date: 28-07-2012 - Session time: 00:00:00 - Track: Track 1
Speaker: Arie Jones
Title: PWNED! Security, SQL Server, and You!
Abstract:
With an ever increasing workload, security is often hoisted upon the DBA. So where do you start? Sometimes it's better to start off by understanding what an attacker could do to you in order to get a clearer picture of what you need to do to prevent it. In this session, we will delve into the key features of the SQL Server and explain what the various attack vectors are, what an attack can do with them, and what you can do about them. We'll also look at important features such as SQL Audit that, while not helping to prevent, can definitely help you in definitely help in figuring out what is going on. It'll be AWESOME!