Nr: 132
SQLSaturday #132 - Pensacola 2012
SessionID: 11023
SQL Azure For Developers
Event Date: 09-06-2012 - Session time: 00:00:00 - Track: DEV
Speaker: Bryan Soltis
Title: SQL Azure For Developers
Abstract:
SQL Azure is Microsoft’s cloud-based relational database platform for managing information in the Windows Azure. In this session, Bryan will cover several areas of managing data using Microsoft SQL Azure platform. Topics include migrating existing databases to SQL Azure, importing/exporting content, the SQL Azure management portal, management of SQL Azure databases using SQL Server Management Studio, and real-world scenarios using SQL Azure and Windows Azure. Also covered are deployment scenarios, including full Azure-based systems and hybrid solutions utilizing on-premise and off-premise platforms.
SessionID: 11445
Replication Magic: Initializing From Backups
Event Date: 09-06-2012 - Session time: 00:00:00 - Track: DBA
Speaker: Robert Davis
Title: Replication Magic: Initializing From Backups
Abstract:
If you work with very large databases (VLDBs) that must be replicated, you should be using initialization from backup. There are a some misconceptions the have caused DBAs to assume that they could not use initialization from backup. In this session I will explore those misconceptions and prove that they are incorrect.
Demos will include initializing a subscriber from a transaction log backup and performing a partial restore of a database and initializing the subscriber from the partial backup.
SessionID: 11466
The Legend of Lambda
Event Date: 09-06-2012 - Session time: 00:00:00 - Track: MISC
Speaker: Chris Eargle
Title: The Legend of Lambda
Abstract:
Lambda expressions are a powerful feature of C#, one that can be wielded for good or evil. Attend this session for an adventure through the evolution of the C# language, from the depths of the delegate keyword to the expressiveness of the lambda expression. I will show you how anyone can easily learn to wield and empower code with lambda expressions. It's dangerous to go alone!
SessionID: 11967
A Lap Around Data Quality Services 2012
Event Date: 09-06-2012 - Session time: 00:00:00 - Track: Performance/Security
Speaker: Christopher Price
Title: A Lap Around Data Quality Services 2012
Abstract:
We will explore data quality issues that face today’s business and how Data Quality Services 2012 can help IT Pros and Data Stewards meet those challenges. We will start from zero, build a knowledge base, profile data to train our knowledge base and then use that knowledge to highlight both the cleansing and matching capabilities of DQS. This session will also cover the DQS SSIS component that’s available in SQL Server 2012.
SessionID: 13730
Windows PowerShell best practices for the busy DBA
Event Date: 09-06-2012 - Session time: 00:00:00 - Track: DBA
Speaker: Ed Wilson
Title: Windows PowerShell best practices for the busy DBA
Abstract:
Learn Windows PowerShell best practices for DBA’s as they apply to each stage of the script development lifecycle. See the differences between working interactively from the Windows PowerShell prompt, writing an inline script, adding basic function, advanced functions and finally the implementation of Windows PowerShell Modules. What is a local best practice for Windows PowerShell development is not the same as a global best practice, and this talk covers those differences
SessionID: 14031
Data Quality Made Simple
Event Date: 09-06-2012 - Session time: 00:00:00 - Track: DBA
Speaker: Eric Wisdahl
Title: Data Quality Made Simple
Abstract:
SessionID: 16984
It’s In There Somewhere!
Event Date: 09-06-2012 - Session time: 00:00:00 - Track: New in 2012
Speaker: James McAuliffe
Title: It’s In There Somewhere!
Abstract:
FileTable and Statistical Semantic Search In SQL 2012
It’s like having the biggest junk drawer EVER. That’s often what our “Document Repositories” become. You know you have that golden nugget of information that you’re searching for, and it’s in there somewhere, but you can’t find it. This session explores a new feature of SQL 2012 called Statistical Semantic Search. It's like having a closet organizer on staff at all times. While full-text search lets you query the words in a document, semantic search lets you query the meaning of the document. New scenarios we will look into will include automatic tag extraction, related content discovery, and hierarchical navigation across similar content.
SessionID: 17386
Do More With Less: Consolidate and Virtualize
Event Date: 09-06-2012 - Session time: 00:00:00 - Track: DBA
Speaker: Jorge Segarra
Title: Do More With Less: Consolidate and Virtualize
Abstract:
SessionID: 17387
Policy-Based Management in a Nutshell
Event Date: 09-06-2012 - Session time: 00:00:00 - Track: MISC
Speaker: Jorge Segarra
Title: Policy-Based Management in a Nutshell
Abstract:
We will be learning an overview of this powerful new feature in SQL Server 2008 and how you can leverage it to help manage your existing SQL environment. This will include plenty of demos, best practices and QA so by the end you should be able to walk away ready to take control of your SQL Server environment using this awesome new feature!
SessionID: 17961
5 Minute Speed Rounds by Various Speakers
Event Date: 09-06-2012 - Session time: 00:00:00 - Track: MISC
Speaker: Karla Landrum
Title: 5 Minute Speed Rounds by Various Speakers
Abstract:
A chance for both new and seasoned speakers to present for 5 minutes on their favourite topic. Prizes awarded for the best and most entertaining lightning talk.
SessionID: 17962
Prepare for When Disaster Strikes by Steve Jones
Event Date: 09-06-2012 - Session time: 00:00:00 - Track: DBA
Speaker: Karla Landrum
Title: Prepare for When Disaster Strikes by Steve Jones
Abstract:
SessionID: 18005
Building an Infrastructure for Secure SQL Servers
Event Date: 09-06-2012 - Session time: 00:00:00 - Track: Performance/Security
Speaker: Brian Kelley
Title: Building an Infrastructure for Secure SQL Servers
Abstract:
In warfare, understanding your enemy is a supreme advantage. The same is true when it comes to protecting SQL Server. We’ll get into the mindset of an attacker, looking at the methods and techniques attackers use to go after SQL Server. Once we understanding the threats, we’ll then examine defensive techniques to secure and protect our SQL Servers, using both new and creative methods, as well as the tried and true.
SessionID: 18007
The Dirty Business of Auditing
Event Date: 09-06-2012 - Session time: 00:00:00 - Track: MISC
Speaker: Brian Kelley
Title: The Dirty Business of Auditing
Abstract:
SessionID: 18181
Event Date: 09-06-2012 - Session time: 00:00:00 - Track: DEV
Speaker: Kevin Grohoske
Abstract:
Microsoft’s SQL Server team has provided a unique set of capabilities for Business Intelligence. With Power Pivot, Power View, and SQL Server Reporting Services (SSRS) provides a full breadth of capabilities that can be utilized to mash up data across the enterprise. In this session we will walk through the product stack and determine how they can be utilized within your organization to provide greater insight into your business data.
SessionID: 18627
Event Date: 09-06-2012 - Session time: 00:00:00 - Track: BI
Speaker: Devin Knight
Abstract:
SessionID: 18629
Adapting your ETL Solutions to use SSIS 2012
Event Date: 09-06-2012 - Session time: 00:00:00 - Track: BI
Speaker: Devin Knight
Title: Adapting your ETL Solutions to use SSIS 2012
Abstract:
With all the great new features added to SSIS in SQL Server 2012 it is important to understand how they can make your development life easier. This session will not only highlight what is new in SSIS but also show how your existing solutions can be adapted to utilize the latest features. Topics will include changes to usability, deployment, configuration and management.
SessionID: 20025
SQL 2012 DMV's Extended Events
Event Date: 09-06-2012 - Session time: 00:00:00 - Track: New in 2012
Speaker: Gareth Swanepoel
Title: SQL 2012 DMV's Extended Events
Abstract:
As a lone DBA in the scary world of the SQL Server 2012 Fire Swamp, you may be wary of the multiple threats of Lightning sand, Flame spurts Rodents of unusual size. In this session, come and learn how to map your way through these threats using new and improved DMV's and Extended Events.
SessionID: 20719
Service your Applications with WCF
Event Date: 09-06-2012 - Session time: 00:00:00 - Track: DEV
Speaker: Mike Huguet
Title: Service your Applications with WCF
Abstract:
SessionID: 20724
SharePoint Primer for .NET Developers
Event Date: 09-06-2012 - Session time: 00:00:00 - Track: DEV
Speaker: Mike Huguet
Title: SharePoint Primer for .NET Developers
Abstract:
This session will cover an introduction of the SharePoint architecture, details on the more common customization and extensibility areas for developers including application pages, JavaScript, event receivers, workflows, web parts, and field types. We will also cover different options for developing composite solutions leveraging SharePoint data and hosting of your applications in SharePoint. Due to the amount of content, this session is mostly at the architectural level. There will be some demos, but there will not be a lot of depth in one particular area. To gain the most value out of this session it is suggested that you be at least an intermediate level web developer and some experience using SharePoint basic functions as an end user.
SessionID: 22740
SQL Azure Reporting
Event Date: 09-06-2012 - Session time: 00:00:00 - Track: MISC
Speaker: Ryan Duclos
Title: SQL Azure Reporting
Abstract:
***It is assumed that you have familiarity with designing/managing SSRS reports.
SessionID: 22948
SSIS 2012: Project Deployment Model End To End
Event Date: 09-06-2012 - Session time: 00:00:00 - Track: New in 2012
Speaker: Rafael Salas
Title: SSIS 2012: Project Deployment Model End To End
Abstract:
SessionID: 23321
Lego Sets: Relational Building Blocks
Event Date: 09-06-2012 - Session time: 00:00:00 - Track: DEV
Speaker: Rob Volk
Title: Lego Sets: Relational Building Blocks
Abstract:
Do your eyes glaze over at the mention of tuples, domains, or even basic SQL terms? Have you moved to SQL Server from MS Access, or Excel, or other non-relational database products? This session will help explain the basics of set theory and relational theory using actual Lego blocks. We will illustrate terms and concepts such as joins, unions, and set-based operations, and how you can translate them into actual SQL. If you're an absolute beginner to SQL, or feel overwhelmed by the baggage of computer data models, or would just like to play with Legos, you'll both enjoy and learn something during this session.
SessionID: 23323
Tame Your Unruly Data...With Constraints!
Event Date: 09-06-2012 - Session time: 00:00:00 - Track: MISC
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: 23610
Bring Data to Life! by Russ Fustino
Event Date: 09-06-2012 - Session time: 00:00:00 - Track: Performance/Security
Speaker: Russell Fustino
Title: Bring Data to Life! by Russ Fustino
Abstract:
SessionID: 24454
Encryption in SQL Server
Event Date: 09-06-2012 - Session time: 00:00:00 - Track: Performance/Security
Speaker: Steve Jones
Title: Encryption in SQL Server
Abstract:
There are a number of encryption options in SQL Server and this session will talk about many of them, looking briefly at TDE, hashing, encryption keys, and SSL encrpytion.
SessionID: 24455
Unstructured Data in SQL Server
Event Date: 09-06-2012 - Session time: 00:00:00 - Track: DBA
Speaker: Steve Jones
Title: Unstructured Data in SQL Server
Abstract:
A look at the Filestream and Filetable features in SQL Server that can allow you to handle unstructured data inside your SQL Server database.
SessionID: 24909
SQL Server 2012 AlwaysOn for HA and DR
Event Date: 09-06-2012 - Session time: 00:00:00 - Track: New in 2012
Speaker: Chad Churchwell
Title: SQL Server 2012 AlwaysOn for HA and DR
Abstract:
This presentation will focus on the concepts behind AlwaysOn, benefits it provides, and a demo of setting up AlwaysOn Availability groups
SessionID: 25910
Upgrading SSIS Packages to SQL Server 2012
Event Date: 09-06-2012 - Session time: 00:00:00 - Track: New in 2012
Speaker: Sven Aelterman
Title: Upgrading SSIS Packages to SQL Server 2012
Abstract:
SQL Server Integration Services has received significant upgrades in SQL Server 2012. How to effectively upgrade SSIS packages to take advantage of the new SSIS features is the main driver behind this session. Primarily focused on upgrading packages from SSIS 2008, some notes will also be made about upgrading from SSIS 2005.
SessionID: 25911
What's New for Developers in SQL Server 2012
Event Date: 09-06-2012 - Session time: 00:00:00 - Track: DEV
Speaker: Sven Aelterman
Title: What's New for Developers in SQL Server 2012
Abstract:
SessionID: 26337
Windowing Functions: THE Reason to Upgrade to 2012
Event Date: 09-06-2012 - Session time: 00:00:00 - Track: DBA
Speaker: Kevin Boles
Title: Windowing Functions: THE Reason to Upgrade to 2012
Abstract:
SessionID: 26339
SQL Server 2012 TSQL Enhancements and Additions
Event Date: 09-06-2012 - Session time: 00:00:00 - Track: New in 2012
Speaker: Kevin Boles
Title: SQL Server 2012 TSQL Enhancements and Additions
Abstract:
The breadth and depth of improvements in TSQL coming out with SQL Server 2012 represent the most significant changes in, well, probably ever! This fast and furious overview will touch on a large range of these goodies, with plenty of sample code for you to take home and review at your leisure!
SessionID: 26511
Using SSIS 2012 for ETL in a Data Warehouse
Event Date: 09-06-2012 - Session time: 00:00:00 - Track: BI
Speaker: Thomas LeBlanc
Title: Using SSIS 2012 for ETL in a Data Warehouse
Abstract:
This session will go through some old and new features of Integration Service 2012 to help with loading data into a Data Warehouse/Mart. The GUI has been improved visually during design and execution. The storage of packages has been update with Integration Service Catalogs. The Change Data Capture task helps with incremental updates. Logging has been improved for debugging. A demostration of creating your own Slowly Changing Dimension with current Tasks will be shown with some design hints.
SessionID: 26512
Execution Plan Beyond Basics
Event Date: 09-06-2012 - Session time: 00:00:00 - Track: Performance/Security
Speaker: Thomas LeBlanc
Title: Execution Plan Beyond Basics
Abstract:
So you been using Execution Plans for a little while and want to know more. This session will look deeper into Nested, Merge and Hash Joins. What to look for in the memory grants will be discussed. Using MAXDOP and Cost Threshold will be demostrated to understand parallel plans. Demostrations will show Aggregate Iterators and how to find out if the optimizer is smarter than us. 2012 enhancements to execution plans will be shown throughout the demos
SessionID: 26675
Know Backups and Know Recovery
Event Date: 09-06-2012 - Session time: 00:00:00 - Track: MISC
Speaker: Tim Radney
Title: Know Backups and Know Recovery
Abstract:
It is easy to schedule full backups to run each night, but is that the right decision for your organization? You say you have a backup strategy, but what is your recovery strategy? Do you have a well-executed recovery plan?
In this session Tim Radney will cover several methods for performing much needed backups and how to recover those backups. Full, Differential, File Group, Transaction logs and recovery the tail end of a the log. He will discuss industry best practices and hopefully cause you to validate and test your current strategy.
SessionID: 26765
Event Date: 09-06-2012 - Session time: 00:00:00 - Track: Performance/Security
Speaker: Tim Costello
Abstract:
SessionID: 27870
Beyond Plateaux: Optimize SSAS with Best Practices
Event Date: 09-06-2012 - Session time: 00:00:00 - Track: BI
Speaker: William E Pearson III
Title: Beyond Plateaux: Optimize SSAS with Best Practices
Abstract:
SessionID: 27875
Getting Started with MDX: The (Very) Basics
Event Date: 09-06-2012 - Session time: 00:00:00 - Track: BI
Speaker: William E Pearson III
Title: Getting Started with MDX: The (Very) Basics
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.
SessionID: 28185
SQL Server Permissions and Security Principals
Event Date: 09-06-2012 - Session time: 00:00:00 - Track: Performance/Security
Speaker: William Assaf
Title: SQL Server Permissions and Security Principals
Abstract:
A review of SQL Server permissions starting with the basics and moving into the security implications behinds stored procedures, views, database ownership, application connections, consolidated databases, application roles and more.
SessionID: 9779
Event Date: 09-06-2012 - Session time: 00:00:00 - Track: DBA
Speaker: Argenis Fernandez
Abstract: