Nr: 108
SQLSaturday #108 - Redmond 2012
SessionID: 28417
PowerShell for Data Professionals
Event Date: 25-02-2012 - Session time: 00:00:00 - Track: Pioneer Square
Speaker: Aaron Nelson
Title: PowerShell for Data Professionals
Abstract:
SessionID: 28491
Fundamentals of SAN, NAS and IP Storage
Event Date: 25-02-2012 - Session time: 00:00:00 - Track: Queen Anne
Speaker: Wesley Brown
Title: Fundamentals of SAN, NAS and IP Storage
Abstract:
SessionID: 28788
Event Date: 25-02-2012 - Session time: 00:00:00 - Track: Queen Anne
Speaker: Argenis Fernandez
Abstract:
SessionID: 29474
Replication Magic: Initializing From Backups
Event Date: 25-02-2012 - Session time: 00:00:00 - Track: Pioneer Square
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: 29800
SRS Report Builder for Business Intelligence
Event Date: 25-02-2012 - Session time: 00:00:00 - Track: Montlake
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.
SessionID: 29901
Database Development: Keep It Agile, Not Fragile
Event Date: 25-02-2012 - Session time: 00:00:00 - Track: Capitol Hill
Speaker: Dev Nambi
Title: Database Development: Keep It Agile, Not Fragile
Abstract:
Does your company use agile development? It can deliver more value to customers with lower project risk. However, it can also make the system design change rapidly, and require frequent software rollouts. This session will focus on best practices for DBAs and developers to make design, testing and deployments easier. Keep your systems agile, not fragile!
SessionID: 29960
SQL Server Reporting Services - Beyond the Basics
Event Date: 25-02-2012 - Session time: 00:00:00 - Track: Montlake
Speaker: Donabel Santos
Title: SQL Server Reporting Services - Beyond the Basics
Abstract:
You’re already familiar with your data sources and datasets, and already comfortable with your basic tables and matrices. Now you want to add a bit more “zing” to your reports. In this presentation we will look different ways of using and extending Reporting Services.
In this session we will work with expressions to add dynamic components to SSRS, create drilldowns and drillthroughs, use custom code to modularize our logic, connect to non-SQL Server data sources, and utilize your geospatial data by plotting them onto SSRS maps. We’ll include a few more cool stuff you might not have known about SSRS!
This presentation will be demo-filled. You'll be sure to go home with ready-to-use tricks up your sleeve.
SessionID: 29976
Data Warehousing Update
Event Date: 25-02-2012 - Session time: 00:00:00 - Track: Montlake
Speaker: Douglas Barrett
Title: Data Warehousing Update
Abstract:
Data warehousing is changing. New products, new features - how do you make sense of it all. This session takes a look data warehousing on SQL Server, looking at Classic Data warehousing, Fast Track, PDW and the new features Denali introduces, specifically Columnar storage and Data Quality Services. How do you use them in your situation, why and what is the impact.
SessionID: 29984
Merge Replication for High Availability
Event Date: 25-02-2012 - Session time: 00:00:00 - Track: Queen Anne
Speaker: Diane Robey
Title: Merge Replication for High Availability
Abstract:
Load balancing web servers between database servers enables high availability when using merge replication. When one data center has a power failure, the HVAC is down or other disaster, the web hosting and databases at the other data center can take over new connections along with the existing connections and continue with the entire load. Upgrades and equipment maintenance are more convenient when another data center can easily take over. There are limitations and specific procedures for setup and maintenance. Discover the benefits and caveats of merge replication.
SessionID: 30348
Advanced indexing
Event Date: 25-02-2012 - Session time: 00:00:00 - Track: Queen Anne
Speaker: Hugo Kornelis
Title: Advanced indexing
Abstract:
SessionID: 31323
Top 10 Admin Mistakes on SQL Server
Event Date: 25-02-2012 - Session time: 00:00:00 - Track: Pioneer Square
Speaker: Kevin Kline
Title: Top 10 Admin Mistakes on SQL Server
Abstract:
Microsoft SQL Server is easier to administrate than any other relational database on
the market. But “easier than everyone else” doesn’t mean it’s easy. And it doesn’t mean that
database administration on SQL Server is problem free. And since SQL Server is constantly
growing from small, home-grown applications, many IT professionals end up encountering issues
that others had tackled and solved years ago. Why not learn from those who first blazed the trails
of database administration, so that we don’t make the same mistakes over and over again. In
fact, wouldn’t you like to learn about those mistakes before they ever happen?
SessionID: 31600
The Elephant in the Room (Hadoop for DBAs)
Event Date: 25-02-2012 - Session time: 00:00:00 - Track: Capitol Hill
Speaker: Mark Simms
Title: The Elephant in the Room (Hadoop for DBAs)
Abstract:
This session will explore the key technology gaps and drivers behind this shift, and examine the pros and cons of various tools and approaches.
This will encompass hands-on demonstrations, real world applications and how best to leverage these new platforms in conjunction with SQL Server.
SessionID: 31702
PowerShell 101
Event Date: 25-02-2012 - Session time: 00:00:00 - Track: Pioneer Square
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: 32184
Dashboard Design: Making Reports Pop
Event Date: 25-02-2012 - Session time: 00:00:00 - Track: Montlake
Speaker: Paul Turley
Title: Dashboard Design: Making Reports Pop
Abstract:
SessionID: 32318
Database lifecycle with Visual Studio 2010 and TFS
Event Date: 25-02-2012 - Session time: 00:00:00 - Track: Capitol Hill
Speaker: Piotr Palka
Title: Database lifecycle with Visual Studio 2010 and TFS
Abstract:
Are you tired of manually integrating scripts before every release, inadequate history of changes to database objects or lack of consistent and automated unit testing for SQL Server objects?
We will learn how we can use Visual Studio 2010 Database Project and Team Foundation Server for managing lifecycle of our database projects. Session will cover basic rules for managing tables, views and stored procedures in Visual Studio project, using Team Foundation Server source control and creating unit tests.
We will also use TFS build agent to automate creation of the differential SQL scripts, deploying it to test/development environment and execution of defined unit tests.
Finally we will create deliverables for release.
SessionID: 32514
Event Date: 25-02-2012 - Session time: 00:00:00 - Track: Capitol Hill
Speaker: Rick Morelan
Abstract:
SessionID: 33082
Enterprise Data Mining with SQL Server
Event Date: 25-02-2012 - Session time: 00:00:00 - Track: Pioneer Square
Speaker: Mark Tabladillo
Title: Enterprise Data Mining with SQL Server
Abstract:
This presentation describes SQL Server Data Mining (SSDM) for SQL Server Professionals. Starting with SQL Server Management Studio (SSMS), the demo includes the interfaces important for professional development, including Business Intelligence Development Studio (BIDS), highlighting Integration Services, and PowerShell. The interactive demos are based on Microsoft's Contoso Retail sample data. Finally we will evaluate where Microsoft data mining can help you in a practical business environment, which may include Oracle and SAS.
SessionID: 33215
Unleashing Common Table Expressions in SQL Server
Event Date: 25-02-2012 - Session time: 00:00:00 - Track: Capitol Hill
Speaker: Steve Stedman
Title: Unleashing Common Table Expressions in SQL Server
Abstract:
Have you ever wanted to create a recursive query, but didn't see how to do it. With the Common Table Expressions class you will learn everything needed to start using CTE's for recursive queries, as a temporary views, and to use the result set multiple times in the same query. Learn how simplify query syntax using CTE's. One of the most overlooked features of SQL Server is the CTE which no only simplifies the query, but gives you the ability to do things that would otherwise be impossible (or at least very challenging) with SQL Server. This presentation is targeted for database programmers and administrators who are familiar with TRANSACT SQL, Subqueries, and advanced join techniques.
SessionID: 34489
5 SSIS Tricks to Take You from Beginner to Awesome
Event Date: 25-02-2012 - Session time: 00:00:00 - Track: Montlake
Speaker: Wil Sisney
Title: 5 SSIS Tricks to Take You from Beginner to Awesome
Abstract:
You know how to create a connection manager, and you can extract data to a flat file. So how do you get past basic package creation? This presentation will cover 5 high-level techniques you can use to become the "go-to" person for SSIS in your organization. This session will be packed with demos of packages you can use to achieve SSIS Awesomeness!
SessionID: 34694
Parallel Task Scheduling with T-SQL
Event Date: 25-02-2012 - Session time: 00:00:00 - Track: Queen Anne
Speaker: John Huang
Title: Parallel Task Scheduling with T-SQL
Abstract:
It's not so difficult to write a stored procedure to execute number of tasks (SQL statements) sequentially and/or conditionally. However, things will become complex when you decide to run the code blocks within the procedure from different sessions concurrently with desired ordering and definable degrees of parallelism. In this session, we will discuss different ways to implement thread schedulers, semaphores, synchronizations, and process ordering as well as process monitoring and manipulation by using pure T-SQL.