sqlsathistory

Nr: 125

Back to Main list

SQLSaturday #125 - Oklahoma City 2012

Start Time (24h)	Speaker	Track	Title
00:00:00	Bryan Smith	Business Intelligence	Building Writeback Applications in SSAS
00:00:00	Carlos Bossy	Business Intelligence	Real-time Data Warehouse and Reporting Solutions
00:00:00	Corey Brune	DBA	Instant Scale, High Avail. Performance for SQL
00:00:00	Grant Fritchey	Developer	Top Tips for Writing Better T-SQL Queries
00:00:00	Jennifer McCown	Developer	T-SQL Brush-up:The Best Things You Forgot You Knew
00:00:00	Jeff Johnston	Business Intelligence	Analytical MDM with Master Data Services 2012
00:00:00	John Sterrett	DBA	Performance Tuning for Pirates
00:00:00	Kathy Gibbs	Bonus	Best Practices for Monitoring Databases on VMware
00:00:00	Kristofer Hutchinson	Business Intelligence	Cross Platform Database Monitoring
00:00:00	Mark Mastrangeli	Bonus	Building a Better Database Security Strategy
00:00:00	Rob Sullivan	Developer	SQL Server in the Cloud
00:00:00	Ryan Adams	Bonus	SQL 2012 AlwaysOn Quickstart
00:00:00	Sean McCown	Bonus	Mouth Wide Shut: Coherent Interviewing
00:00:00	Sean McCown	DBA	Understanding Backups
00:00:00	Kevin Boles	DBA	Transaction Log Deep Dive
00:00:00	Kevin Boles	Developer	SQL Injection
00:00:00	Kevin Boles	Bonus	SQL Server 2012 TSQL Enhancements and Additions
00:00:00	Tim Mitchell	Business Intelligence	Top 10 New Features of SSIS in 2012
00:00:00	Tim Costello	Business Intelligence	Pro Tips: Performance Tuning SSIS
00:00:00	William E Pearson III	Bonus	SSAS 2012 Tabular vs. Multidimensional
00:00:00	Joe Celko	Developer	Declarative versus Procedural Programming
00:00:00	Mike Hotek	Developer	Performance Analysis – Finding What Needs Tuning
00:00:00	Mike Hotek	DBA	Fixing SQL Server–Complete Mess 2 Smooth Operation
00:00:00	William E Pearson III	Bonus	Entity Strategies: Structuring Your Consultancy
00:00:00	Wesley Brown	DBA	Benchmarking, Baselines and Monitoring Storage
00:00:00	AJ Mendo	DBA	Without A SQLTrace-Getting To Know Extended Events
00:00:00	Allen Smith	Business Intelligence	Beyond Basics in SSRS

SessionID: 11053

Building Writeback Applications in SSAS

Back to calendar

Event Date: 25-08-2012 - Session time: 00:00:00 - Track: Business Intelligence

Speaker: Bryan Smith

Title: Building Writeback Applications in SSAS

Abstract:

Write-back is a powerful feature of Analysis Services that provides the ability to input data directly into complex models. In this session, you will learn the basic techniques for Analysis Services write-back and how these techniques may be applied to address various business needs.

SessionID: 11315

Real-time Data Warehouse and Reporting Solutions

Back to calendar

Event Date: 25-08-2012 - Session time: 00:00:00 - Track: Business Intelligence

Speaker: Carlos Bossy

Title: Real-time Data Warehouse and Reporting Solutions

Abstract:

In this demo-rich session, we will explore database and ETL architectures that let you smoothly move data from your application databases across the enterprise in real-time to your data warehouse. You will see how to use SQL Server features such as replication, Change Data Capture, SSIS, and other techniques to extract, transform, and load data fast and dependably. We will develop an actual sample system during the session and discuss and walk through alternative real-time architectures, including the use of Data Vault methodologies. We will then see how to use Reporting Services and Power View to present data with a minimum amount of latency.

SessionID: 11866

Instant Scale, High Avail. Performance for SQL

Back to calendar

Event Date: 25-08-2012 - Session time: 00:00:00 - Track: DBA

Speaker: Corey Brune

Title: Instant Scale, High Avail. Performance for SQL

Abstract:

Achieving scale-out quickly and easily for MS SQL Server environments can be extremely difficult, if not impossible. Other areas that are difficult or costly to achieve for SQL Server environments include transparent caching of Read queries, as well as instrumentation and Analytics of all SQL queries in real-time. In this session, you will learn how ScaleArc has developed SQL Server infrastructure software that achieves instant scale-out, caching, load balancing, firewall/filtering and higher availability…without any changes or modifications to existing applications or SQL Server databases. For those interested in migrating to SQL Server 2012, we will also discuss how ScaleArc can assist and add-value in a 2012 migration.

SessionID: 14758

Top Tips for Writing Better T-SQL Queries

Back to calendar

Event Date: 25-08-2012 - Session time: 00:00:00 - Track: Developer

Speaker: Grant Fritchey

Title: Top Tips for Writing Better T-SQL Queries

Abstract:

T-SQL provides many different ways to accomplish the same task, and as you might expect, some ways are better than others. In this session, you will learn specific techniques, that if followed, will make you a better T-SQL developer. The session is jam-packed with practical examples and is designed for administrators and developers who want to bring their T-SQL skills to the next level. In fact, you will be able to immediately implement these tips in your current projects once you get back to your office.

SessionID: 16475

T-SQL Brush-up:The Best Things You Forgot You Knew

Back to calendar

Event Date: 25-08-2012 - Session time: 00:00:00 - Track: Developer

Speaker: Jennifer McCown

Title: T-SQL Brush-up:The Best Things You Forgot You Knew

Abstract:

You’re a good SQL professional – you attend conferences and webinars, you read articles and books, and you know your way around SQL Server. But sometimes – just SOMEtimes – some piece of T-SQL slips by you unnoticed, or falls out of memory. Most of us are working with at least two or three out of the last five versions of SQL Server, so who can blame us for missing a feature or two? Come and revisit old favorites, and brush up on new T-SQL features and enhancements. In this session you will see SELECT turned inside-out. You’ll get really, really excited about OVER and PARTITION BY. You’ll learn that Common Table Expressions are, in fact, very cool. This session is chock full of code examples, including before-and-after demos and how-tos.

SessionID: 16869

Analytical MDM with Master Data Services 2012

Back to calendar

Event Date: 25-08-2012 - Session time: 00:00:00 - Track: Business Intelligence

Speaker: Jeff Johnston

Title: Analytical MDM with Master Data Services 2012

Abstract:

In this session we will take a deep dive in to Analytical Master Data Management and how it differs from Operational Master Data Management. We will examine how you can leverage SQL 2012 Master Data Services to manage your data warehouse dimensions and hierarchies. Come learn how you can leverage the new features of SQL 2012 Master Data Services to enroll business users in the process of master data management to reduce the burden on IT and as a result, maximize the value of your Master Data Management solution.

SessionID: 17689

Performance Tuning for Pirates

Back to calendar

Event Date: 25-08-2012 - Session time: 00:00:00 - Track: DBA

Speaker: John Sterrett

Title: Performance Tuning for Pirates

Abstract:

If you follow baseball you will notice that the Pittsburgh Pirates (this speaker’s favorite team) has to do more with less to be successful. This trend can also exist within IT shops. If you need to improve the performance of your SQL Server instances and cannot purchase 3rd party tools this session is for you. Learn to improve your performance tuning process by using several free tools. This session will cover wait stats, dynamic management objects, perfmon, PAL, SQL Trace, ClearTrace, SQL Nexus and SQLDiag.

SessionID: 17969

Best Practices for Monitoring Databases on VMware

Back to calendar

Event Date: 25-08-2012 - Session time: 00:00:00 - Track: Bonus

Speaker: Kathy Gibbs

Title: Best Practices for Monitoring Databases on VMware

Abstract:

SQL Server on VMware??? Many of our customers are either virtualizing databases or planning to do so soon. I hear from many groups that attempted running their database on VMware but went back to physical hardware because of performance issues. There are many reasons this may have happened, but quite often the decision to go back to physical was not based on hard facts. This presentation will explore the fundamentals of monitoring databases running in a VMware environment. If you are using classic O/S monitoring tools, you may be getting misleading data. Understand what metrics are important and how to get to that data.

SessionID: 18836

Cross Platform Database Monitoring

Back to calendar

Event Date: 25-08-2012 - Session time: 00:00:00 - Track: Business Intelligence

Speaker: Kristofer Hutchinson

Title: Cross Platform Database Monitoring

Abstract:

Cross Platform Database Monitoring session presented by Quest Software.

SessionID: 19674

Building a Better Database Security Strategy

Back to calendar

Event Date: 25-08-2012 - Session time: 00:00:00 - Track: Bonus

Speaker: Mark Mastrangeli

Title: Building a Better Database Security Strategy

Abstract:

Mark will be speaking on the topic of the need for dedicated database security, and going into detail about McAfee's approach to securing business-critical databases.

SessionID: 23170

SQL Server in the Cloud

Back to calendar

Event Date: 25-08-2012 - Session time: 00:00:00 - Track: Developer

Speaker: Rob Sullivan

Title: SQL Server in the Cloud

Abstract:

With Microsoft going "All in" on the cloud and marketing teams being relentless in their promotion, it seems like the cloud isn't going to just be a fad. What does cloud even mean and why should people in the trenches like us care? We will answer those questions and more as we leave the confines of locahost and look at various cloud implementations including Microsofts own cloud service : SQL Azure.

SessionID: 23716

SQL 2012 AlwaysOn Quickstart

Back to calendar

Event Date: 25-08-2012 - Session time: 00:00:00 - Track: Bonus

Speaker: Ryan Adams

Title: SQL 2012 AlwaysOn Quickstart

Abstract:

In this presentation I'll explain what the new SQL 2012 AlwaysOn high availability

and disaster recovery solution is all about. I'll talk about the different levels of protection it provides through Windows Clustering, SQL Clustering, and Availability Groups. We'll discuss how these three things come together to protect your databases. We'll finish with a dive into availability group configuration and the new capabilities it gives us.

SessionID: 24265

Mouth Wide Shut: Coherent Interviewing

Back to calendar

Event Date: 25-08-2012 - Session time: 00:00:00 - Track: Bonus

Speaker: Sean McCown

Title: Mouth Wide Shut: Coherent Interviewing

Abstract:

The MidnightDBAs will guide you through the most important part of the interview: the tech screening. We’ve both interviewed so many DBAs who fail to meet even the lowest expectations during this portion of the interview. You’ll learn how to answer both tech questions and HR questions in a way that’ll actually get you hired. We’ll also teach you how to avoid common traps that mean certain death. This will be a very fun and interactive session and you’ll wish you’d been doing these things all along. Come to this session.

SessionID: 24266

Understanding Backups

Back to calendar

Event Date: 25-08-2012 - Session time: 00:00:00 - Track: DBA

Speaker: Sean McCown

Title: Understanding Backups

Abstract:

One of the most important functions a DBA can perform is the backup. And far too many DBAs rely on the wizard to perform this task. Here I'll take you through everything you need to know about understanding command line backups, writing backup routines, and making the right decisions on how to do what kind of restore and when. I will take you through basic backup syntax and fully explain how things work the way they do and why. If you ever wanted to understand the ins and outs of SQL Server backups then this session will give you what you're after.

SessionID: 26301

Transaction Log Deep Dive

Back to calendar

Event Date: 25-08-2012 - Session time: 00:00:00 - Track: DBA

Speaker: Kevin Boles

Title: Transaction Log Deep Dive

Abstract:

Time for another deep dive from TheSQLGuru, this time on the transaction log. Architecture and internals, monitoring, tuning/optimizing will all be covered. A great learning experience on another pillar of the SQL Server relational engine.

SessionID: 26303

SQL Injection

Back to calendar

Event Date: 25-08-2012 - Session time: 00:00:00 - Track: Developer

Speaker: Kevin Boles

Title: SQL Injection

Abstract:

Well, we have all heard about the horror stories of data loss due to SQL Injection and how costly (in many ways) they can be. This in-depth discussion covers various forms of SQL Injection attacks and offers some guidelines on how to avoid them. Lots of code examples in both .NET and TSQL. Watch me hack a website and retrieve user data in just 3 hits on an unprotected html page!

SessionID: 26308

SQL Server 2012 TSQL Enhancements and Additions

Back to calendar

Event Date: 25-08-2012 - Session time: 00:00:00 - Track: Bonus

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: 26619

Top 10 New Features of SSIS in 2012

Back to calendar

Event Date: 25-08-2012 - Session time: 00:00:00 - Track: Business Intelligence

Speaker: Tim Mitchell

Title: Top 10 New Features of SSIS in 2012

Abstract:

The release of SQL Server 2012 brings a number of new and exciting changes to SQL Server Integration Services, making it the most significant release of SSIS since that product replaced DTS in 2005. In this session, we'll explore the top 10(ish) new features of SSIS in SQL Server 2012, including:

-- The new project deployment model -- Scripting enhancements -- Logging ... among others. We'll also walk through demonstrations of each of these new behaviors.

SessionID: 26755

Pro Tips: Performance Tuning SSIS

Back to calendar

Event Date: 25-08-2012 - Session time: 00:00:00 - Track: Business Intelligence

Speaker: Tim Costello

Title: Pro Tips: Performance Tuning SSIS

Abstract:

Synchronous and asynchronous components, memory buffers, data type choices. Tuning the data flow is all about choices. In this session we'll explore some of the choices that can give you the biggest performance boosts in your ssis data flow. Together we'll walk through creating a performance baseline, the differences between synchronous and asynchronous components and a few simple patterns we can implement to improve performance in our SSIS packages.

SessionID: 27852

SSAS 2012 Tabular vs. Multidimensional

Back to calendar

Event Date: 25-08-2012 - Session time: 00:00:00 - Track: Bonus

Speaker: William E Pearson III

Title: SSAS 2012 Tabular vs. Multidimensional

Abstract:

The Analysis Services 2012 Business Intelligence Semantic Model (BISM) unifies Multidimensional (OLAP) and Tabular (relational) options for organizational BI. BI professionals can implement Multidimensional cubes, or they can deploy Tabular models developed by business users to a dedicated server. Those new to Tabular, or those embarking upon BI for the first time with Analysis Services 2012, may find it difficult to choose between the two paths. In this session, BI Architect and MVP Bill Pearson overviews the nature and design goals of each option, comparing Multidimensional and Tabular features. He then offers guidance on selecting the appropriate model, providing real world examples to illustrate approaches for given scenarios.

SessionID: 30588

Declarative versus Procedural Programming

Back to calendar

Event Date: 25-08-2012 - Session time: 00:00:00 - Track: Developer

Speaker: Joe Celko

Title: Declarative versus Procedural Programming

Abstract:

Switching your mindswet from proceural code to decllaraive SQ progreamming is a majot shift. Here are some hints about goign from if-then-else to CASE expressiuons, from loops to joins and set operators, makign DDL do the harfd work and so forth.

SessionID: 31731

Performance Analysis – Finding What Needs Tuning

Back to calendar

Event Date: 25-08-2012 - Session time: 00:00:00 - Track: Developer

Speaker: Mike Hotek

Title: Performance Analysis – Finding What Needs Tuning

Abstract:

Everyone wants to tell you WHAT to do when you have a performance problem. Of course, the bigger issue is in determining what the actual performance problem is before you can apply the correct solution to the correct problem. Most of those same people producing the cookbooks will also tell you that performance analysis is an “art form” – code-speak for “you need to hire me and spend a lot of money”. This session will blow away the myth of “it’s an art form” and show you how to apply the tools you already know how to use coupled with some basic understanding of a database engine and use that to find the actual problems with enough time to spare so that you can actually fix them.

SessionID: 31733

Fixing SQL Server–Complete Mess 2 Smooth Operation

Back to calendar

Event Date: 25-08-2012 - Session time: 00:00:00 - Track: DBA

Speaker: Mike Hotek

Title: Fixing SQL Server–Complete Mess 2 Smooth Operation

Abstract:

You’ve either been there or have walked into one and I certainly hope it isn’t your current environment. There are SQL Server environments which quite simply do not work. The business doesn’t trust the data, people are running around playing whack-a-mole, everyone is pointing fingers at everyone else, and the tension is so thick you can cut it with a knife. When everything is failing, how do you figure out where to start so that you can build a foundation to work from? How do you then build on that foundation to systematically fix all of the problems while still being home for dinner every night? Join us for this real world look at “you’re the DBA, you own it, and you fix it”.

SessionID: 34475

Entity Strategies: Structuring Your Consultancy

Back to calendar

Event Date: 25-08-2012 - Session time: 00:00:00 - Track: Bonus

Speaker: William E Pearson III

Title: Entity Strategies: Structuring Your Consultancy

Abstract:

Independent BI consultant, MSSQL Server MVP, and practicing CPA Bill Pearson examines the various options available for organizing and protecting your consulting business. In this section, he covers C Corp, S Corp, LLC, Partnership, and Sole Proprietorship (“Schedule C”) options, as well as other practical advice (trademarks, etc.) useful in forming your business entity. Specific questions are encouraged throughout this session!

SessionID: 9023

Benchmarking, Baselines and Monitoring Storage

Back to calendar

Event Date: 25-08-2012 - Session time: 00:00:00 - Track: DBA

Speaker: Wesley Brown

Title: Benchmarking, Baselines and Monitoring Storage

Abstract:

Benchmarking, Baselines and Monitoring Storage

There are several steps in the life cycle of your storage systems. We have several tools to help us understand our storage systems from initial deployment through its useful life. We will cover: SQLIO, a specific SQL Server benchmarking tool. Iometer, a general IO benchmarking tool and simulator. SQLIOSim a specific SQL Server base lining tool and simulator. TPC style testing focused on TPC-C, TPC-E and TPC-H. Monitoring your system using WMI and virtual file stats. Finally, what it all really means, how to read these results and compare them with each other. With these tools you can plan, deploy and manage your storage for years to come!

SessionID: 9117

Without A SQLTrace-Getting To Know Extended Events

Back to calendar

Event Date: 25-08-2012 - Session time: 00:00:00 - Track: DBA

Speaker: AJ Mendo

Title: Without A SQLTrace-Getting To Know Extended Events

Abstract:

If you have wanted to learn how to use Extended Events and have had a hard time trying to figure out where to start then this session is for you. This session is designed for someone that has never used Extended Events before. After this session you will know the basics of how to setup and use this highly scalable and configurable architecture to trouble shoot server issues. You will see how to use them in SQL 2008 and how they have been beefed up in SQL 2012. This will be a demo rich session so come prepared to finally get to know Extended Events.

SessionID: 9924

Beyond Basics in SSRS

Back to calendar

Event Date: 25-08-2012 - Session time: 00:00:00 - Track: Business Intelligence

Speaker: Allen Smith

Title: Beyond Basics in SSRS

Abstract:

Learn about working with SSAS cube data in SSRS. Excel users appreciate the 'Drill Down' functionality so in this session we mimic that experience in an SSRS report. We also look at custom formatting options available using member properties from MDX queries. Don't be afraid of a little MDX, no experience necessary for this session.

This site is open source. Improve this page.