Nr: 122
SQLSaturday #122 - Louisville 2012
SessionID: 10002
PowerShell 101 for the SQL Server DBA
Event Date: 21-07-2012 - Session time: 00:00:00 - Track: DBA
Speaker: Allen White
Title: PowerShell 101 for the SQL Server DBA
Abstract:
The more you have to manage, the more likely you'll want to automate your processes. PowerShell is the scripting language that will make you truly effective at managing lots of servers. This session will introduce you to PowerShell and show you how to use it to manage SQL Server across many instances.
SessionID: 11770
So I started this blog... now what?
Event Date: 21-07-2012 - Session time: 00:00:00 - Track: Prof. Growth
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: 11841
Transitioning from SQL Trace to Extended Events
Event Date: 21-07-2012 - Session time: 00:00:00 - Track: DBA
Speaker: Jack Corbett
Title: Transitioning from SQL Trace to Extended Events
Abstract:
Extended Events were introduced with SQL Server 2008, but without a UI, which meant using T-SQL to create and manage them and using XPath and XQuery to parse the output. Microsoft has added an Extended Events UI in SQL Server 2012 and also added additional events. With the announcement that SQL Trace/Profiler is being deprecated now is the time to begin learning Extended Events. This session will show you how to take existing Traces and convert them to Extended Event Sessions.
SessionID: 11843
Getting Start with SQL Server Profiler
Event Date: 21-07-2012 - Session time: 00:00:00 - Track: Developer
Speaker: Jack Corbett
Title: Getting Start with SQL Server Profiler
Abstract:
SessionID: 12030
Professional Networking for IT Pros
Event Date: 21-07-2012 - Session time: 00:00:00 - Track: Prof. Growth
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: 12105
Why Data Warehousing Projects Fail
Event Date: 21-07-2012 - Session time: 00:00:00 - Track: BI
Speaker: Craig Utley
Title: Why Data Warehousing Projects Fail
Abstract:
Is your organization planning to build a data warehouse or BI solution? Data warehousing projects, like many large IT projects, have high failure rates. While the exact rate of failure for data warehousing projects is difficult to pin down, the causes of these failures fall into a small number of categories. It is obviously possible to successfully complete a data warehousing project and deliver value to the business. Craig Utley has seen Microsoft BI solutions in various states of completeness at over 30 companies worldwide and has seen some awesome successes and some spectacular failures. This session addresses the reasons data warehousing projects fail and how you can succeed in overcoming these obstacles.
SessionID: 12343
My Favorite SSIS Tips and Tricks
Event Date: 21-07-2012 - Session time: 00:00:00 - Track: BI
Speaker: Dave Fackler
Title: My Favorite SSIS Tips and Tricks
Abstract:
SSIS is a very powerful platform for creating different types of data integration solutions. But unless you've been using SSIS every day, read through countless blogs each week, and attend every available SSIS session at every conference available, you've probably missed out on several SSIS tips and tricks that have surfaced over the years. So come and listen as I describe and demonstrate some of my favorite SSIS tips and tricks!
SessionID: 13187
Change Data Capture the foundation of BI
Event Date: 21-07-2012 - Session time: 00:00:00 - Track: BI
Speaker: Jim Deppen
Title: Change Data Capture the foundation of BI
Abstract:
This session will explore the fundamental importance of Change Data Capture to an organization building a Business Intelligence infrastructure. Many organizations will spend large amounts of time and money researching Business Intelligence software and databases without understanding how key business metrics are consistently captured. The techniques and methodologies used to capture business events are the key success factors for a winning Business Intelligence strategy.
SessionID: 13449
What Counts For a DBA
Event Date: 21-07-2012 - Session time: 00:00:00 - Track: Prof. Growth
Speaker: Louis Davidson
Title: What Counts For a DBA
Abstract:
The world of a DBA can be daunting for a person, either as a new or old, because not only do they need to keep up with new and emerging technologies, but also with the code and designs of their coworkers. In this highly participation driven session, we will employ a random topic chooser to pick several of these traits for discussion as a group. Possible topics include past blog topics such as Logic, Curiosity, Failure, Humility, Skill and Passion, as well as any other topics that might be added for that day. So come prepared to participate and voice your opinion about what counts for a DBA.
SessionID: 13450
What Sequence objects are (and are not)
Event Date: 21-07-2012 - Session time: 00:00:00 - Track: Design/Architecture
Speaker: Louis Davidson
Title: What Sequence objects are (and are not)
Abstract:
SessionID: 14040
Partitioning for Perf Management of Large Tables
Event Date: 21-07-2012 - Session time: 00:00:00 - Track: Advanced DBA
Speaker: Eddie Wuerch
Title: Partitioning for Perf Management 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: 15687
Don't Panic, DBAs! Databases on VMware made easy.
Event Date: 21-07-2012 - Session time: 00:00:00 - Track: DBA
Speaker: Janis Griffin
Title: Don't Panic, DBAs! Databases on VMware made easy.
Abstract:
More and more companies are virtualizing with VMWare, and databases are the next logical step. This presentation will explore the fundamentals of monitoring databases running in a VMWare environment because it can be much different than when running on a physical machine. You will learn business and technical benefits of virtualization, master new terms and concepts, pick up useful planning tips and tricks, and cover best practices for maintaining optimum performance in a VMWare environment.
SessionID: 15896
Advanced Charting Techniques in SSRS
Event Date: 21-07-2012 - Session time: 00:00:00 - Track: BI
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: 18168
SQL Server Internals Architecture
Event Date: 21-07-2012 - Session time: 00:00:00 - Track: DBA
Speaker: Kevin Kline
Title: SQL Server Internals Architecture
Abstract:
SessionID: 18172
Communicating Upward
Event Date: 21-07-2012 - Session time: 00:00:00 - Track: Prof. Growth
Speaker: Kevin Kline
Title: Communicating Upward
Abstract:
• Building credibility and influence with your boss
• What is the most effective process to win explicit support for a new project?
• How to get executives to spend money for something you think is important
SessionID: 18394
SQL Server 2012 T-SQL
Event Date: 21-07-2012 - Session time: 00:00:00 - Track: Developer
Speaker: Kathi Kellenberger
Title: SQL Server 2012 T-SQL
Abstract:
You have heard all about AlwaysOn, BI Semantic Model, and Power View. Did you know that SQL Server 2012 has a host of new T-SQL features? Attend this session to learn more about the Sequence object, new functions and enhancements to the OVER clause.
SessionID: 18395
2012 Blitz
Event Date: 21-07-2012 - Session time: 00:00:00 - Track: DBA
Speaker: Kathi Kellenberger
Title: 2012 Blitz
Abstract:
How many SQL Server 2012 features can Aunt Kathi show you in an hour? Attend this session to find out. Demos, demos, demos...
SessionID: 18890
Throwing T-SQL 2012 Enhancements Against the Wall
Event Date: 21-07-2012 - Session time: 00:00:00 - Track: Developer
Speaker: Kyle Neier
Title: Throwing T-SQL 2012 Enhancements Against the Wall
Abstract:
Just like your grandma tested spaghetti to tell if it was done, we'll be throwing several of the new T-SQL enhancements against the wall to see what's good and what falls off. We'll silence the lion's RaiseRror by throwing some meaty exceptions. We'll bring together the old lovers "Coalesce" and "+" for one last jaunt before they are banished by the Concat function. We'll even open the window on some of the new aggregate and analytical functions as well as some other t-sql enhancements introduced in SQL 2012.
SessionID: 19568
Optimizing Stored Procedures
Event Date: 21-07-2012 - Session time: 00:00:00 - Track: Developer
Speaker: Mark Rosenberg
Title: Optimizing Stored Procedures
Abstract:
SessionID: 22748
Designing data frameworks for SQL Server
Event Date: 21-07-2012 - Session time: 00:00:00 - Track: Azure/Big Data
Speaker: Rameshdurai Palnisami
Title: Designing data frameworks for SQL Server
Abstract:
Having trouble in managing large scan data process for SQL Server? Efficient way to MODEL, PROCESS ANALYSE large scale data for SQL Server platform. Identifying common and client specific process steps to process client data. Parsing Efficient way to process data comes in multiple formats (Excel, Flat Files, Access etc. ) for SQL Server. Automate and schedule large scale data in parallel. Centralized management of client data model across multiple domains.
SessionID: 23955
Understanding Parameter sniffing and making it wor
Event Date: 21-07-2012 - Session time: 00:00:00 - Track: Developer
Speaker: Sanil Mhatre
Title: Understanding Parameter sniffing and making it wor
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: 23976
Private Clouds with SQL Server 2012
Event Date: 21-07-2012 - Session time: 00:00:00 - Track: Azure/Big Data
Speaker: Sarah Barela
Title: Private Clouds with SQL Server 2012
Abstract:
SessionID: 23977
Bulletproof: Hardening your SQL Server from Attack
Event Date: 21-07-2012 - Session time: 00:00:00 - Track: Design/Architecture
Speaker: Sarah Barela
Title: Bulletproof: Hardening your SQL Server from Attack
Abstract:
Recent major security breaches have not only exposed customer data, but also the system vulnerabilities DBAs must overcome daily. As data protection is a DBA’s primary responsibility, establishing an impenetrable environment to host the data is the first step towards risk-free security. How can DBAs ensure SQL Servers are fortified against the latest threats and vulnerabilities? In this session, we will go through the process of hardening your SQL Server from attack from Windows Server to the database level step-by-step. I will share will share with you how establish security baselines and monitor for changes to your security foundation. This session will provide specific actions for you to take back and apply to your servers.
SessionID: 23978
Women in Technology Session
Event Date: 21-07-2012 - Session time: 00:00:00 - Track: Prof. Growth
Speaker: Sarah Barela
Title: Women in Technology Session
Abstract:
SessionID: 26313
Death by UDF
Event Date: 21-07-2012 - Session time: 00:00:00 - Track: Advanced DBA
Speaker: Kevin Boles
Title: Death by UDF
Abstract:
SessionID: 26317
Parallel Query Execution Deep Dive
Event Date: 21-07-2012 - Session time: 00:00:00 - Track: Advanced DBA
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: 26752
Transaction Log Internals
Event Date: 21-07-2012 - Session time: 00:00:00 - Track: Advanced DBA
Speaker: Tim Chapman
Title: Transaction Log Internals
Abstract:
The transaction log is the most important aspect of a SQL Server database. Separating the data and log files is usually good advice, but there is so much more about the transaction log that is misunderstood. Join Microsoft Premier Field Engineer Tim Chapman as he discusses data modification internals, write-ahead logging and the inner workings of the SQL Server transaction log.
SessionID: 27327
SQL Azure Data Sync and What's New
Event Date: 21-07-2012 - Session time: 00:00:00 - Track: Azure/Big Data
Speaker: Andy Thiru
Title: SQL Azure Data Sync and What's New
Abstract:
In this session, you will get introduced to SQL Azure Data Sync and learn how to get started. We will explore how to migrate data from an existing on-premise SQL Server database to SQL Azure and bi-directional data synchronization and data management capabilities allowing data to be easily shared across SQL Azure databases across multiple data centers.
What you will learn:
• Overview of SQL Azure
• How to Get Started with SQL Azure Data Sync
• Cloud to cloud synchronization
• Enterprise (on-premises) to cloud
• Cloud to on-premises.
• Bi-directional or sync-to-hub or sync-from-hub synchronization
SessionID: 27329
SQL Azure Intro and What's New
Event Date: 21-07-2012 - Session time: 00:00:00 - Track: Azure/Big Data
Speaker: Andy Thiru
Title: SQL Azure Intro and What's New
Abstract:
In this session, you will get introduced to SQL Azure and learn how to get started. We will explore how to migrate an existing on-premise SQL Server database to SQL Azure. We will then walkthrough how to manage and administer your SQL Azure servers and databases. We will take a look at how to connect and build applications using SQL Azure. Next, we will look at more advanced scenarios using new capabilities like reporting with SQL Azure Reporting, synchronizing data with SQL Azure Data Sync for hybrid scenarios and global reach. Finally, we will explore some of the things you should consider when using SQL Azure
SessionID: 27710
Windowing Functions in SQL Server 2012
Event Date: 21-07-2012 - Session time: 00:00:00 - Track: Advanced DBA
Speaker: Wayne Sheffield
Title: Windowing Functions in SQL Server 2012
Abstract:
SessionID: 32583
Revenge: The SQL!
Event Date: 21-07-2012 - Session time: 00:00:00 - Track: Design/Architecture
Speaker: Rob Volk
Title: Revenge: The SQL!
Abstract:
Have you been wronged, cheated, lied to, lied about, or deceived by a coworker? Feel like your DBA position offers no opportunity for revenge? WRONG! This session is a light-hearted exploration of some delightfully mischievous SQL design patterns that will annoy, aggravate, and antagonize anyone who has to work with them. (But they deserved it!) Learn how to: create tables with no names; columns with duplicate names; and write perfectly valid yet utterly nonsensical SQL. You may never get to use these techniques…but you'll ache for the chance!
SessionID: 32586
Revenge: The SQL Part 2: The Sequel!
Event Date: 21-07-2012 - Session time: 00:00:00 - Track: Design/Architecture
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, hiding and obfuscating data and code, 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: 34438
Bridging the Chasm: BI Theory vs. Practice
Event Date: 21-07-2012 - Session time: 00:00:00 - Track: BI
Speaker: William E Pearson III
Title: Bridging the Chasm: BI Theory vs. Practice
Abstract:
A Dynamic Dialog session: According to research compiled by Gartner from discussions with many BI clients, a substantial disparity exists, in the implementation of BI, between theory (standard approaches, promises, claims and expectations) and practice (shortfalls, compromises and other realities). In this session, Business Intelligence Architect and Microsoft MVP Bill Pearson leads a dialog within which we will gain an understanding of the general types of discrepancies between the “ideal” approach to BI and the compromised reality that a large number of organizations experience. We’ll then share and class experiences as a group, and discuss ways to avoid these discrepancies in future projects.
SessionID: 9804
Strategies for Sharding with SQL Azure Federations
Event Date: 21-07-2012 - Session time: 00:00:00 - Track: Azure/Big Data
Speaker: Arie Jones
Title: Strategies for Sharding with SQL Azure Federations
Abstract:
Putting big data in the cloud is not without its difficulties and the Microsoft Azure teams have been consistently upping the resource limits that you are able to utilize within a given instance. Those of us with larger capacity instances still have to hedge our bets when looking at moving to the cloud. That is until the recent release of SQL Azure Federations, which offers a native SQL Azure based option to possible unlimited scalability. In this session, we will break down the basics of sharding within SQL Azure Federations, explain what needs to be taken into consideration in terms of database design, and put you on the right path to a successful Federation based deployment.
SessionID: 9805
PWNED! Security, SQL Server, and You!
Event Date: 21-07-2012 - Session time: 00:00:00 - Track: Design/Architecture
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!