Nr: 214
SQLSaturday #214 - Louisville 2013
SessionID: 10024
PowerShell 101 for the SQL Server DBA
Event Date: 13-07-2013 - 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: 12244
Master Data Management
Event Date: 13-07-2013 - Session time: 00:00:00 - Track: Developer
Speaker: Dave Mattingly
Title: Master Data Management
Abstract:
Making sure that data is accurate and current across multiple systems is very tricky, but can yield powerful benefits if done right. Learn approaches to coordinating your records, and see a case study.
SessionID: 12333
Migrating to SSIS 2012
Event Date: 13-07-2013 - Session time: 00:00:00 - Track: BI
Speaker: Dave Fackler
Title: Migrating to SSIS 2012
Abstract:
Ready to take advantage of all the new shiny bells and whistles available with SSIS 2012? During this session, we'll talk about some of those new features, focusing on the new project deployment model. And we'll talk about how to migrate your existing SSIS packages and projects to SSIS 2012 in order to use all those new features and capabilities. Come and learn about migrating your projects to take advantage of shared connection managers, project and package parameters, and the new SSIS Catalog!
SessionID: 12335
TFS for SQL/BI Developers
Event Date: 13-07-2013 - Session time: 00:00:00 - Track: Developer
Speaker: Dave Fackler
Title: TFS for SQL/BI Developers
Abstract:
If you do any kind of SQL Server or BI development, you eventually have to grapple with the problem of keeping multiple copies of your work. You either need to maintain stored procedure and DDL scripts or you have copies of SSIS and SSRS reports to keep up with. In most cases, this problem starts off small as you need to have development versus production copies of your code. But eventually, it becomes harder and harder to maintain your "source code" as your environment becomes more complex and as you potentially have to start working with a team of other developers. During this session, we'll talk about Team Foundation Server (TFS) and show you the different ways it can be used to keep up with all the different types of source code you might be responsible for -- from full database designs to complete BI solutions.
SessionID: 13459
How to Write a DML Trigger
Event Date: 13-07-2013 - Session time: 00:00:00 - Track: DBA
Speaker: Louis Davidson
Title: How to Write a DML Trigger
Abstract:
Triggers are extremely powerful and useful (if somewhat rarely needed) objects that are coded very similar to a common stored procedure. Yet for their similarity, there are some very important differences that need to be understood. In this session, I will walk through what goes into writing a robust DML trigger, starting with a simple version of a trigger, and working through some very useful applications of DML Triggers..
SessionID: 14095
Partitioning for Perf and Mgmt of Large Tables
Event Date: 13-07-2013 - Session time: 00:00:00 - Track: Adv. DBA
Speaker: Eddie Wuerch
Title: Partitioning for Perf and Mgmt 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 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: 15521
Data Warehouse Architecture (Ralph who?)
Event Date: 13-07-2013 - Session time: 00:00:00 - Track: Architecture/Design
Speaker: Jennifer Alexander
Title: Data Warehouse Architecture (Ralph who?)
Abstract:
The basics of designing a data warehouse using Kimball methodology and practices
SessionID: 18209
SQL Server Internals Architecture
Event Date: 13-07-2013 - Session time: 00:00:00 - Track: Architecture/Design
Speaker: Kevin Kline
Title: SQL Server Internals Architecture
Abstract:
Want to take your skills to the next level? Then it’s critical to know SQL Server’s internal processes and architecture. This session will answer questions like:- What are the various areas of memory inside of SQL Server?- How are queries handled behind the scenes?- What does SQL Server do with procedural code, like functions, procedures, and triggers?- What happens during checkpoints? Lazywrites?- How are IOs handled with regards to transaction logs and database?This fast paced session will take you through many aspects of the internal operations of SQL Server. So strap on your silly, as we cover all these topics and more at speed with tongue planted firmly in cheek!
SessionID: 18210
Top 10 Admininistrator Mistakes on SQL Server
Event Date: 13-07-2013 - Session time: 00:00:00 - Track: DBA
Speaker: Kevin Kline
Title: Top 10 Admininistrator Mistakes on SQL Server
Abstract:
SessionID: 18909
Become a SQL Block’stroyer
Event Date: 13-07-2013 - Session time: 00:00:00 - Track: Adv. DBA
Speaker: Kyle Neier
Title: Become a SQL Block’stroyer
Abstract:
In order to implement ACID properties, SQL Server uses locks to control who can have access to what resources. In this session we will discuss how to leverage the different isolation levels within SQL Server to affect locking behavior. Before taking a deep dive into how to detect, mitigate, and possibly eliminate certain types of blocking in the system, we will explore some of the basic lock types and how they interact. Once we have learned how to deal with classic blocks in this fast paced demo filled session, we will explore several real world strategies to mitigate the dreaded deadlock. Be prepared to enter this session as a DBA but leave as a SQL Block’stroyer!
SessionID: 20383
Tablix - The Rubik Cube of Reporting Services
Event Date: 13-07-2013 - Session time: 00:00:00 - Track: BI
Speaker: Mickey Stuewe
Title: Tablix - The Rubik Cube of Reporting Services
Abstract:
Did you know that the Table, Matrix, and List controls are all based on the highly flexible Tablix Data Region Grid? So really, they are all one control that can be morphed into each other.
Learn how to get the most out of the Tablix controls in this demo-heavy session. We'll go through how to best layout data using multiple Tablix controls. We’ll use parameters to change the layout of the data in these controls to minimize the number of reports that need to be maintained. We’ll create a columnar report that grows vertically as well as horizontally, and we’ll find out about other exciting uses of this highly flexible control.
SessionID: 20648
Unable to Make Lasting Connections?
Event Date: 13-07-2013 - Session time: 00:00:00 - Track: DBA
Speaker: Mike Hays
Title: Unable to Make Lasting Connections?
Abstract:
Attend this session to learn the basics of how SQL Server listens for connections, and uses SQL Server Browser service. Learn which DMVs are available to help troubleshoot connection issues. Also review which tools Windows PowerShell have available to help troubleshoot those TCP/IP network issues.
SessionID: 22459
But it worked great in Dev! Perfomance for Devs
Event Date: 13-07-2013 - Session time: 00:00:00 - Track: Developer
Speaker: Randy Knight
Title: But it worked great in Dev! Perfomance for Devs
Abstract:
If you've ever found yourself stating the above, this session is for you. For many developers, writing T-SQL that works is not the challenge. But too often, functional T-SQL is not the same as good T-SQL. In this session, we will examine why "SQL that works" is not good enough. Understanding indexes, exectuion plans, sargability, and more are all critical to writing good T-SQL. We will also examine several real-world examples of T-SQL that "worked great in dev" but caused major issues when it hit production.
SessionID: 22460
Understanding Transaction Isolation Levels
Event Date: 13-07-2013 - Session time: 00:00:00 - Track: Adv. DBA
Speaker: Randy Knight
Title: Understanding Transaction Isolation Levels
Abstract:
SQL Server offers several isolation levels beyond the default "READ COMMITTED". But understanding when to use each one can be daunting. Whether you are a developer who needs to understand how isolation works and and why NOLOCK is not an appropriate hint in most cases, or a seasoned DBA who needs to understand the less commonly used isolation methods, this session is for you. We will look at each level, how it impacts the engine, and examine appropriate (and inapproriate) use cases for each.
SessionID: 23651
Introduction to the XML source
Event Date: 13-07-2013 - Session time: 00:00:00 - Track: Developer
Speaker: Russel Loski
Title: Introduction to the XML source
Abstract:
XML is all over the place. But how do you get that data into SQL Server? SSIS provides an XML Source, but it is not easy to use. In this session we will handle increasingly complex XML documents. After an introduction to using the XML Source with a single set of elements, we will look at how to work with multiple element sets. This includes hierarchically structured XML documents.
Attendees will be able to import simple XML using SSIS. They will be able to create import routines that pull data from different elements of more complex XML. They will understand the role the XML Schema plays in defining the XML data they import.
SessionID: 23941
Asynchronous programming with Service Broker
Event Date: 13-07-2013 - Session time: 00:00:00 - Track: Developer
Speaker: Sanil Mhatre
Title: Asynchronous programming with Service Broker
Abstract:
SessionID: 24622
OnPremise to Azure
Event Date: 13-07-2013 - Session time: 00:00:00 - Track: Architecture/Design
Speaker: Shannon Lowder
Title: OnPremise to Azure
Abstract:
During this talk I'll walk you through the process actually used to migrate a client's systems from hosted in a company closet to multiple Microsoft Azure data centers. Along the way we'll discuss the planning that went into the migration, the testing we went through, the pain points we hit, all the way to up and running in the cloud. This session covers the roadmap, we won't go through the actual migration itself...that took almost a year to complete.
SessionID: 24867
Add It Up: Analysis Services Aggregations
Event Date: 13-07-2013 - Session time: 00:00:00 - Track: BI
Speaker: Craig Utley
Title: Add It Up: Analysis Services Aggregations
Abstract:
SessionID: 24868
Secure SSAS Data Without Tying Yourself in Knots
Event Date: 13-07-2013 - Session time: 00:00:00 - Track: BI
Speaker: Craig Utley
Title: Secure SSAS Data Without Tying Yourself in Knots
Abstract:
Are you looking for the best way to secure the data in your cube? There are several approaches to applying data security, each with its own pros and cons. Learn about the basic built-in security, and then see approaches for extending this through dynamic security, using security dimensions, and SSAS stored procedures. You'll see examples of each as well as a discussion of when to use which approach.
SessionID: 26747
Index Internals
Event Date: 13-07-2013 - Session time: 00:00:00 - Track: Adv. DBA
Speaker: Tim Chapman
Title: Index Internals
Abstract:
Have you ever wondered what an index actually looks like and performs under the covers? In this talk I'll discuss Index Internals, and how SQL Server creates, maintains, and uses indexes internally for normal operations. I’ll be discussing topics such as index data structures, query optimization (briefly) and maintaining indexes and statistics.
SessionID: 26748
Transaction Log Internals
Event Date: 13-07-2013 - Session time: 00:00:00 - Track: Adv. 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: 28090
Through Gardens Overgrown: PowerPivot to SSAS 2012Tabular
Event Date: 13-07-2013 - Session time: 00:00:00 - Track: BI
Speaker: William E Pearson III
Title: Through Gardens Overgrown: PowerPivot to SSAS 2012Tabular
Abstract:
SessionID: 8958
Introduction to SQL Server 2012 AlwaysOn Availability Groups
Event Date: 13-07-2013 - Session time: 00:00:00 - Track: DBA
Speaker: Adam Belebczuk
Title: Introduction to SQL Server 2012 AlwaysOn Availability Groups
Abstract:
SessionID: 9942
Loading the Windows Azure Cloud
Event Date: 13-07-2013 - Session time: 00:00:00 - Track: Architecture/Design
Speaker: Andy Thiru
Title: Loading the Windows Azure Cloud
Abstract:
Windows Azure provides many options for storing data. SQL Azure is one of Windows Azure’s solutions for working with relational data. If you are familiar with SQL Server, SQL Azure will be a natural extension of your knowledge and skills.
In this session, we will look at the different options for loading data to the Cloud from an on premise SQL server and vice versa. Topics we will cover include:
- SQL Azure Data Sync - 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.
- BACPAC – Importing and Exporting the BACPAC
- CDC - loading the Data to cloud by capturing the incremental Changes at ON-Premise (SSIS)
- Finally, we will query the System Views for the data movement.
What you will learn:
• Overview of SQL Azure
• SQL Azure Data Sync
• BACPAC
• Incremental Load to Cloud
SessionID: 9943
Moving Enterprise database to cloud
Event Date: 13-07-2013 - Session time: 00:00:00 - Track: Architecture/Design
Speaker: Andy Thiru
Title: Moving Enterprise database to cloud
Abstract:
Windows Azure provides several different ways of storing and managing data. Windows Azure SQL Database and SQL Server in Windows Azure Virtual Machines are solutions in Windows Azure for working with relational data. If you are familiar with SQL Server, Windows Azure SQL Database will be a natural extension of your knowledge and skills.
In this session, you will learn:
- Windows Azure SQL Database - Learn how to get started. We will explore how to migrate an existing on-premise SQL Server database to Windows Azure SQL Database. We will then walk through how to manage and administer your Windows Azure SQL servers and databases.
- Provision the SQL Server VM on Windows Azure - We will learn provisioning the Virtual Machine through the Windows Azure Management Portal. Once created, we will open the VM through the Remote Desktop . Finally, we will connect to SQL server using SSMS.