sqlsathistory

Nr: 262

Back to Main list

SQLSaturday #262 - Boston 2014

Start Time (24h) Speaker Track Title
00:00:00 Ayad Shammout Constitution Building BI Semantic Model Tabular in 60 minutes
00:00:00 Bradley Ball Bunker Hill Trimming Indexes Getting Your Database In Shape
00:00:00 Brian McCaig Lexington SQL Server cell level and transparent data encryption a case study
00:00:00 Bob Pusateri Longfellow Whatcha Doin'? Passive Security for Hostile Environments
00:00:00 Brandon Leach Lexington Treating Tables Like Legos, Partitioning Basics
00:00:00 Brandon Leach Constitution Implementing a HIPAA Compliance Strategy with SQL Server
00:00:00 Bryan Cafferky Constitution So you think you know SSIS? What about Scripting?
00:00:00 Bryan Cafferky Concord Dimensional Modeling: The Heart of the Data Warehouse
00:00:00 Chris Bell Thoreau Optimizing Protected Indexes
00:00:00 Jack Corbett Concord Inroduction to Triggers
00:00:00 David Bermingham Concord High Availability with Windows Server 2012 R2 and SQL Server 2014
00:00:00 Edward Pollack Concord Dynamic SQL: Writing Efficient Queries on the Fly
00:00:00 Edward Pollack Thoreau Diving Into Query Execution Plans
00:00:00 George Walters Longfellow SQL Server 2012 AlwaysOn Availability Groups
00:00:00 Grant Fritchey Hawthorne Statistics and Query Optimization
00:00:00 Joseph D'Antoni Concord In-Memory Columnstore Indexes--Make Your Data Warehouse Fly
00:00:00 John Flannery Lexington What the Hekaton
00:00:00 John Miner Lexington Effective use of temporary tables
00:00:00 Kevin Kline Hawthorne SQL Server Internals and Architecture
00:00:00 Michael Corey Thoreau Virtualizing SQL Server: Doing It Right – The SeQueL
00:00:00 Mike Hillwig Lexington Recovery and Backup for Beginners
00:00:00 Mike Walsh Thoreau What I Wish I Knew Before Becoming a DBA
00:00:00 Paresh Motiwala Hawthorne Database Forensics - Part 1
00:00:00 Mohammad Yusuf Longfellow An Introduction to Database Design And Management
00:00:00 Stacia Varga Hawthorne (Way Too Much) Fun with Reporting Services
00:00:00 Steve Simon Bunker Hill Mind your language!! Cursors are a dirty word
00:00:00 Sunil Kadimdiwan Bunker Hill Develop Impressive Dashboards using SSRS 2012
00:00:00 Tim Radney Bunker Hill Know Backups and Know Recovery
00:00:00 Tim Radney Bunker Hill You Inherited a Database, Now What?
00:00:00 Timothy McAliley Constitution Floating on a Hybrid Cloud: SQL Server 2014 Windows Azure
00:00:00 Varsham Papikian Constitution Yes, you can do it in SSMS: tips and tricks.
00:00:00 Aaron Bertrand Hawthorne T-SQL : Bad Habits Best Practices
00:00:00 Allan Hirt Thoreau Patch Management Strategies for SQL Server
00:00:00 Adam Machanic Longfellow Query Tuning Mastery: Clash of the Row Goals
00:00:00 Andy Leonard Longfellow Designing an SSIS Framework

SessionID: 10070

Building BI Semantic Model Tabular in 60 minutes

Back to calendar

Event Date: 29-03-2014 - Session time: 00:00:00 - Track: Constitution

Speaker: Ayad Shammout

Title: Building BI Semantic Model Tabular in 60 minutes

Abstract:

SQL Server 2012 introduces the new Analysis Services Tabular Mode. BI Semantic Model (BISM) Tabular is in-memory database in Analysis Services using state-of-the-art compression algorithms. BI Semantic Models can be developed in either Visual Studio or in Excel using the SQL Server 2012 PowerPivot add-in. In this session, I will show you how to build a complete solution in Tabular and creating one from the ground up, deploy a rich semantic model and discover a simpler method for analyzing business data. You also learn the basics of DAX language and how to manage role based security and partitioning in a Tabular model. You will be able to create your BISM Tabular models, and gain a solid background to enable you starting your next project.

SessionID: 10149

Trimming Indexes Getting Your Database In Shape

Back to calendar

Event Date: 29-03-2014 - Session time: 00:00:00 - Track: Bunker Hill

Speaker: Bradley Ball

Title: Trimming Indexes Getting Your Database In Shape

Abstract:

Indexes are a wonderful thing. We should be using them, and we should be maintaining them. But over time our production databases start to look a little pudgy around the mid-section. Maybe they are a little bloated with Unused Indexes, maybe they have Duplicate Indexes, and possibly even Reverse Indexes. The first step to fixing these problems it so see if you have them, and if you do the second is to set about fixing them. You could be costing yourself CPU cycles, I/Op’s, and space and never even know it.

SessionID: 10526

SQL Server cell level and transparent data encryption a case study

Back to calendar

Event Date: 29-03-2014 - Session time: 00:00:00 - Track: Lexington

Speaker: Brian McCaig

Title: SQL Server cell level and transparent data encryption a case study

Abstract:

The session will cover a practical implementation of the use of cell level encryption combined with the protection of transparent data encryption.

Agenda: Encryption Options for SQL Server. For this session, SQL Server 2008 R2 will be the reference Model. What is Cell Level Encryption What is Transparent Data Encryption Can they be deployed together The session will include a practical implementation example. A demo will be threaded into the presentation to provide clarity and understanding of the code required for implementation. Technical Level: 200

SessionID: 10591

Whatcha Doin'? Passive Security for Hostile Environments

Back to calendar

Event Date: 29-03-2014 - Session time: 00:00:00 - Track: Longfellow

Speaker: Bob Pusateri

Title: Whatcha Doin'? Passive Security for Hostile Environments

Abstract:

Ideal database security settings usually exist in books, but rarely in reality. Is your CIO a member of the sysadmin role because they demanded it? Or maybe some users have rights for purely political reasons? Just because you can't enforce security through typical means doesn't mean you're powerless. Attend this session to learn about the features SQL Server provides that will allow you to keep track of what your users are up to at all times and sleep a little easier. Through various scenarios and demos, see how technologies such as event notifications, auditing, and extended events can help ensure nothing happens on your system without you knowing about it. Even in optimally secured environments these techniques can still come in handy. The best security is often that which cannot be seen.

SessionID: 10670

Treating Tables Like Legos, Partitioning Basics

Back to calendar

Event Date: 29-03-2014 - Session time: 00:00:00 - Track: Lexington

Speaker: Brandon Leach

Title: Treating Tables Like Legos, Partitioning Basics

Abstract:

Partitioning allows us to isolate parts of our table as small chunks called partitions. In turn, these partitions allow us to do some really cool tricks for manageability and performance. In this session we'll look at the concepts surrounding partitioning and how we can apply them. We'll reinforce what we cover with some cool demo's showing some really neat tricks.

SessionID: 10672

Implementing a HIPAA Compliance Strategy with SQL Server

Back to calendar

Event Date: 29-03-2014 - Session time: 00:00:00 - Track: Constitution

Speaker: Brandon Leach

Title: Implementing a HIPAA Compliance Strategy with SQL Server

Abstract:

HIPAA puts a lot of responsibility on our companies and compliance can be hard to maintain. Today medical data is more valuable on the black market than a social security number or a credit card. As DBAs we're charged with the security of our data and thus act as front line defense.

In this hour long session We'll delve into the Health Insurance Portability and Accountability Act (HIPAA) and what implications it has for us as data professionals. We'll discuss SQL Server best practices that can help protect ourselves, our company, and the people whom we serve. We'll also dive into features in SQL Server that can help in this endeavor.

SessionID: 11024

So you think you know SSIS? What about Scripting?

Back to calendar

Event Date: 29-03-2014 - Session time: 00:00:00 - Track: Constitution

Speaker: Bryan Cafferky

Title: So you think you know SSIS? What about Scripting?

Abstract:

If you don’t know how to extend the power of SSIS through the Script Task and Script Component, you don’t know SSIS. Empower your SSIS skills by learning how to add .Net scripts to your packages using C# or VB.Net code to access the full power of Windows and its object models. In this presentation Bryan will walk through the basics of SSIS scripting building to more complex examples using real world cases. Learn how to load any external flat file by taking direct control, how to leverage the power of the SQL Server Object Model (SMO), ActiveX Data Objects (ADO.Net), and use the power of Regular Expressions for advanced string parsing. You will leave with the basics you need to start scripting and a number of useful scripts you can add to your packages.

SessionID: 11025

Dimensional Modeling: The Heart of the Data Warehouse

Back to calendar

Event Date: 29-03-2014 - Session time: 00:00:00 - Track: Concord

Speaker: Bryan Cafferky

Title: Dimensional Modeling: The Heart of the Data Warehouse

Abstract:

In this presentation, Bryan will explain the principles of Dimensional Modeling, the foundation of a data warehouse. He will identify best practices and pitfalls to avoid especially if you come from a relational database background. The focus is to show how dimensional modeling is applied and provide you with the skills to build your own dimensional models.

SessionID: 11258

Optimizing Protected Indexes

Back to calendar

Event Date: 29-03-2014 - Session time: 00:00:00 - Track: Thoreau

Speaker: Chris Bell

Title: Optimizing Protected Indexes

Abstract:

As a SQL Server DBA I see my role having 2 main focuses. First is to protect the data and second is to ensure performance is maximized. More often than not companies forget about data security when they focus on performance tuning. In this presentation I will mention a few cases where encryption could have saved a lot of hassle. I will then demo a method that can be used to "index" commonly searched on encrypted values (ex: SSNs, Credit Card, etc) helping reduce the impact on the performance of a query.

SessionID: 11851

Inroduction to Triggers

Back to calendar

Event Date: 29-03-2014 - Session time: 00:00:00 - Track: Concord

Speaker: Jack Corbett

Title: Inroduction to Triggers

Abstract:

This session will give a brief overview of the different types of triggers available in SQL Server (DDL DML) and then go into more detail on how and when to use DML triggers. This session will cover misconceptions about how triggers work, when triggers should and shouldn't be used (we will discuss options), common mistakes, and how to fix the most common mistakes. After attending this session a person will: 1. Identify different types of triggers and when to use them. 2. Be able to identify when a trigger is the right solution 3. Be able to write triggers that perform well

SessionID: 12378

High Availability with Windows Server 2012 R2 and SQL Server 2014

Back to calendar

Event Date: 29-03-2014 - Session time: 00:00:00 - Track: Concord

Speaker: David Bermingham

Title: High Availability with Windows Server 2012 R2 and SQL Server 2014

Abstract:

This lecture (20% slides, 80% demonstrations) takes a close look at the new features of Windows Server 2012 R2 clustering and how it affects your SQL Server availability. In addition, the new availability features of SQL Server 2014 will be reviewed. This session is geared for those new to Windows Server clustering and SQL Server AlwaysOn but will also be beneficial to those with experience looking to learn about the new high availability features in both Windows Server 2012 R2 and SQL Server 2014.

SessionID: 13831

Dynamic SQL: Writing Efficient Queries on the Fly

Back to calendar

Event Date: 29-03-2014 - Session time: 00:00:00 - Track: Concord

Speaker: Edward Pollack

Title: Dynamic SQL: Writing Efficient Queries on the Fly

Abstract:

Dynamic SQL can be a powerful tool that allows you to write fast efficient queries when the specifics may not be known until run-time. It can also be complex, difficult to read and debug, and the source of some of the most confusing TSQL you'll ever see.

Explore the many uses for dynamic SQL as well as best practices for writing, testing, debugging, and maintaining it, with the bonus of helping to improve the sanity of your coworkers (and your own) in the process!

SessionID: 13832

Diving Into Query Execution Plans

Back to calendar

Event Date: 29-03-2014 - Session time: 00:00:00 - Track: Thoreau

Speaker: Edward Pollack

Title: Diving Into Query Execution Plans

Abstract:

There is no better way to understand how TSQL is executing than through the execution plan. We will go into detail about the more complex parts of execution plans, relating them to other query statistics, and use this information to improve overall query performanc. Be sure to bring your safety helmet!

SessionID: 14520

SQL Server 2012 AlwaysOn Availability Groups

Back to calendar

Event Date: 29-03-2014 - Session time: 00:00:00 - Track: Longfellow

Speaker: George Walters

Title: SQL Server 2012 AlwaysOn Availability Groups

Abstract:

The AlwaysOn Availability Groups feature is a high-availability and disaster-recovery solution that provides an enterprise-level alternative to database mirroring.

SessionID: 14731

Statistics and Query Optimization

Back to calendar

Event Date: 29-03-2014 - Session time: 00:00:00 - Track: Hawthorne

Speaker: Grant Fritchey

Title: Statistics and Query Optimization

Abstract:

There are any number of tricks and traps around getting the query optimizer to provide you with an optimal execution plan that gets you your data quickly and efficiently. But, at the end of the day, the principal driving factor of the optimizer, and therefore of your queries, are the statistics that define your data. This session teaches you how those statistics are put together and maintained by SQL Server. Different types of maintenance results in different levels of accuracy within statistics so we detail what the structures and information looks like after this maintenance. Your understanding of how the optimizer works with statistics will better enable you to understand why you’re getting the performance and types of execution plans that you are getting. Understanding enables you to write better t-sql statements and deal with performance problems such as bad parameter sniffing.

SessionID: 16205

In-Memory Columnstore Indexes--Make Your Data Warehouse Fly

Back to calendar

Event Date: 29-03-2014 - Session time: 00:00:00 - Track: Concord

Speaker: Joseph D'Antoni

Title: In-Memory Columnstore Indexes--Make Your Data Warehouse Fly

Abstract:

Columnstore indexes were introduced in SQL Server 2012, along with a new type of query processing "batch mode". In SQL 2014 they get even better--we can use a Columnstore index as a clustered index and update it. In this session we will explore the basics and beyond of Columnstore indexes and how they can help your warehouse performance.

SessionID: 16731

What the Hekaton

Back to calendar

Event Date: 29-03-2014 - Session time: 00:00:00 - Track: Lexington

Speaker: John Flannery

Title: What the Hekaton

Abstract:

In SQL Server 2014 – Microsoft is introducing In-Memory OLTP. (Formally known as project Hekaton.) In this session – we will introduce this technology, optimize an existing AdventureWorks stored procedure to use In-Memory OLTP, and discuss other applications such as ETL.

SessionID: 17044

Effective use of temporary tables

Back to calendar

Event Date: 29-03-2014 - Session time: 00:00:00 - Track: Lexington

Speaker: John Miner

Title: Effective use of temporary tables

Abstract:

Every developer eventually comes against business logic that can’t be handled with a single simple or complex query. TSQL provides the developer with several constructs that can store temporary result sets that are passed to the next query in the script.

I will be covering these various TSQL techniques with examples using the [AdventureWorks] database as well as a toy database called AUTOS. The pros and cons of each construct will be examined. Advanced options like enabling trace flag 1118 will be explored.

Coverage:

1 – Derived tables. 2 – Local temporary tables. 3 – Global temporary tables. 4 – Table variables. 5 – Common Table Expressions (CTE). 6 – User databases in [tempdb]. 7 – Trace Flag 1118.

SessionID: 18197

SQL Server Internals and Architecture

Back to calendar

Event Date: 29-03-2014 - Session time: 00:00:00 - Track: Hawthorne

Speaker: Kevin Kline

Title: SQL Server Internals and Architecture

Abstract:

Let’s face it. You can effectively do many IT jobs related to SQL Server without knowing the internals of how SQL Server works. Many great developers, DBAs, and designers get their day-to-day work completed on time and with reasonable quality while never really knowing what’s happening behind the scenes. But if you want to take your skills to the next level, it’s critical to know SQL Server’s internal processes and architecture. This session will answer questions like:

SessionID: 20242

Virtualizing SQL Server: Doing It Right – The SeQueL

Back to calendar

Event Date: 29-03-2014 - Session time: 00:00:00 - Track: Thoreau

Speaker: Michael Corey

Title: Virtualizing SQL Server: Doing It Right – The SeQueL

Abstract:

A database is a very resource intensive by its very nature and one of the most resource intensive applications you will ever virtualize. If best practices are not followed, the database will never perform as needed. This presentation will teach the DBA best practices for Virtualizing SQL Server databases with a heavy emphasis on VMware. Topics include Design, Storage, Processor, and Memory Network considerations. This presentation is based upon the very popular presentation given at VMworld in San Francisco and Barcelona.

SessionID: 20540

Recovery and Backup for Beginners

Back to calendar

Event Date: 29-03-2014 - Session time: 00:00:00 - Track: Lexington

Speaker: Mike Hillwig

Title: Recovery and Backup for Beginners

Abstract:

We all know that backups are important. But are we building a backup strategy that can recover in a manner that meets business needs? All too often, we plan a backup strategy without a recovery strategy.

In this session, veteran DBA Mike Hillwig will start with understanding the recovery strategy and work toward implementing the right backups to meet that recovery strategy. He'll also set the record straight around some very common myths around database recovery and backups.

SessionID: 20621

What I Wish I Knew Before Becoming a DBA

Back to calendar

Event Date: 29-03-2014 - Session time: 00:00:00 - Track: Thoreau

Speaker: Mike Walsh

Title: What I Wish I Knew Before Becoming a DBA

Abstract:

Are you interested in becoming a DBA? Would you consider yourself an accidental DBA?

In this talk, Mike Walsh will share some thoughts on the role of DBA - How to become one, What a DBA's priorities should be and what the pros and cons of being one are.

He'll look through his 13 years of DBA experience and share some of the lessons he wish he learned before he started out.

SessionID: 21643

Database Forensics - Part 1

Back to calendar

Event Date: 29-03-2014 - Session time: 00:00:00 - Track: Hawthorne

Speaker: Paresh Motiwala

Title: Database Forensics - Part 1

Abstract:

These are the days of increasing cyber and computer crimes.

As DBAs and guardians of corporate data, it is your paramount duty to not only prevent any data loss but also discover lost , damaged or sabotaged data. But how can you do that without destroying evidence? Remember electronic evidence is extremely fragile. In this the first of the two part session, we will explore the following:

  1. Fundamentals of Computer Forensics
  2. Tools to use in Computer Forensics--Data Acquisition
  3. Processing a crime scene
  4. Network Forensics and Live Acquistions.
  5. Submitting reports

SessionID: 23794

An Introduction to Database Design And Management

Back to calendar

Event Date: 29-03-2014 - Session time: 00:00:00 - Track: Longfellow

Speaker: Mohammad Yusuf

Title: An Introduction to Database Design And Management

Abstract:

Introduces students to basic concepts used in database design. Student is first introduce to what is a database and gradually introduces students to more advanced topics that include creating a database, tables, constraints and relationships, normalization, Structured Query Language (DML, DDL, DCL), data modeling, design and implementation.*** This is a full semester course condensed into 4 hours. ****

SessionID: 24658

(Way Too Much) Fun with Reporting Services

Back to calendar

Event Date: 29-03-2014 - Session time: 00:00:00 - Track: Hawthorne

Speaker: Stacia Varga

Title: (Way Too Much) Fun with Reporting Services

Abstract:

Head starting to explode from all the technical information you’re absorbing? Come spend a session with us while we play games with Reporting Services…literally! Come watch as Stacia Misner and a special guest introduce you to some word play, all wrapped up in SQL Server Reporting Services. She'll push the limits with what can be built in SSRS and show you how to have fun while doing it. Board games and SQL…who could ask for more?

SessionID: 25370

Mind your language!! Cursors are a dirty word

Back to calendar

Event Date: 29-03-2014 - Session time: 00:00:00 - Track: Bunker Hill

Speaker: Steve Simon

Title: Mind your language!! Cursors are a dirty word

Abstract:

Although many SQL Server folks become irate at the thought of using cursors, like anything else in life there is a time and place.

In this hands-on presentation, we shall be looking at practical cases where the utilization of a cursor can prove to be the most efficient and effective solution and THIS is based upon actual execution plans.

SessionID: 25874

Develop Impressive Dashboards using SSRS 2012

Back to calendar

Event Date: 29-03-2014 - Session time: 00:00:00 - Track: Bunker Hill

Speaker: Sunil Kadimdiwan

Title: Develop Impressive Dashboards using SSRS 2012

Abstract:

Microsoft Reporting Services 2012 has many exciting features. You can show your business data on Maps, Charts including Sparklines, Data bars and Indicators. Make them interactive, so that your users can drilldown to details. In this session I will show you how can make use of these and other enhancements in SSRS 2012.

SessionID: 26709

Know Backups and Know Recovery

Back to calendar

Event Date: 29-03-2014 - Session time: 00:00:00 - Track: Bunker Hill

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 I 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: 26710

You Inherited a Database, Now What?

Back to calendar

Event Date: 29-03-2014 - Session time: 00:00:00 - Track: Bunker Hill

Speaker: Tim Radney

Title: You Inherited a Database, Now What?

Abstract:

You have recently inherited the support of a new or existing database, what are the things you should immediately check and start monitoring and what are the things that you should address over the next few weeks. When taking over support of a database or system, you cannot ASSUME anything. At the end of this session you will have a nice checklist of things you should check and be doing on ALL your databases not just the one you inherited. Whether you are a seasoned DBA or just starting out, this session should be informative and something you can relate to.

SessionID: 26822

Floating on a Hybrid Cloud: SQL Server 2014 Windows Azure

Back to calendar

Event Date: 29-03-2014 - Session time: 00:00:00 - Track: Constitution

Speaker: Timothy McAliley

Title: Floating on a Hybrid Cloud: SQL Server 2014 Windows Azure

Abstract:

In this session we will discuss and demonstrate the cloud integration capabilities of SQL Server 2014, the Windows Azure Platform, and scenarios for leveraging hybrid cloud infrastructure. We will discuss and demonstrate deploying SQL Server 2014 running on a Windows Azure Virtual Machine and also discuss and demonstrate the Windows Azure SQL Database. We will also discuss best practices and demonstrate techniques for managing both on-premises and cloud-based resources.

SessionID: 27546

Yes, you can do it in SSMS: tips and tricks.

Back to calendar

Event Date: 29-03-2014 - Session time: 00:00:00 - Track: Constitution

Speaker: Varsham Papikian

Title: Yes, you can do it in SSMS: tips and tricks.

Abstract:

SQL Server Management Studio (SSMS) is probably the most frequently used tool by SQL Server Professionals. Yet it has many features or 'extra flexibility' that some people are not aware of. This session is going to be a fully demo-driven, practical demonstration of many such features. The tips will help you to become more productive at work.

SessionID: 8909

T-SQL : Bad Habits Best Practices

Back to calendar

Event Date: 29-03-2014 - Session time: 00:00:00 - Track: Hawthorne

Speaker: Aaron Bertrand

Title: T-SQL : Bad Habits Best Practices

Abstract:

Bad habits: we all have them. SELECT * is the obvious one; but in this session you will learn about various other habits and why they can be bad for performance or maintainability. You will also learn about best practices that will help you avoid falling into some of these bad habits. Come learn how these habits develop, what kind of problems they can lead to, and how you can avoid them - leading to more efficient code, a more productive work environment, and - in a lot of cases – both.

SessionID: 9242

Patch Management Strategies for SQL Server

Back to calendar

Event Date: 29-03-2014 - Session time: 00:00:00 - Track: Thoreau

Speaker: Allan Hirt

Title: Patch Management Strategies for SQL Server

Abstract:

We all have to deal with applying some sort of update to Windows, SQL Server, and/or hardware. Keeping things up to date is crucial for supportability, not to mention other things like security, performance, and stability. Since patching often involves downtime, you need to be careful not only what you apply to avoid problems, but also find ways to minimize the impact to the business and end users. This session will cover topics such as how to approach patching including what changes you should and should not consume, features that may help you automate or script patching, and developing your own long term patch management strategy.

SessionID: 9364

Query Tuning Mastery: Clash of the Row Goals

Back to calendar

Event Date: 29-03-2014 - Session time: 00:00:00 - Track: Longfellow

Speaker: Adam Machanic

Title: Query Tuning Mastery: Clash of the Row Goals

Abstract:

The fight for better performance is a battle of wits: your mind, your intelligence, and your honor pitted against the less-than-dependable whims of the Query Optimizer. But alas, the arbitrary rewrites and clunky hints leveraged by most developers to get around optimization deficiencies make things feel less like a proper duel and more like a skirmish at the sandbox. To truly engage your enemy you must comprehend his inner workings, and in the case of the Query Optimizer, that means you must delve into the mysteries of "row goals." These internal metrics are tracked and enforced within Top iterators--and they exhibit a considerable amount of influence over plan shape and flow, both at compile time and as your query runs. Attend this session to learn how to take charge of optimization, expertly mold your query plans, and gain a new set of tools for eliminating bottlenecks in even your most complex problem queries. En garde!

SessionID: 9511

Designing an SSIS Framework

Back to calendar

Event Date: 29-03-2014 - Session time: 00:00:00 - Track: Longfellow

Speaker: Andy Leonard

Title: Designing an SSIS Framework

Abstract:

In this “demo-tastic” presentation, SSIS trainer, author, and consultant Andy Leonard explains the what, why, and how of an SSIS framework that delivers metadata-driven package execution, connections management, and centralizes logging. Key takeaways: 1) Developers can migrate packages from Development, through their lifecycle, to Production without editing SSIS Connection Managers properties. 2) A metadata-driven approach to SSIS package execution. 3) Demonstration of a centralized logging reporting application.

This site is open source. Improve this page.