sqlsathistory

Nr: 154

Back to Main list

SQLSaturday #154 - St. Louis 2012

Start Time (24h) Speaker Track Title
00:00:00 Brian Flynn Track 5 Pivoting Performance Data Pinpointing Problems
00:00:00 Bill Fellows Track 1 Kama Sutra of SSIS: A guide to loving ETL
00:00:00 Bill Fellows Track 5 2012 TSQL Sweets
00:00:00 Dave Fackler Track 2 Get Ready for SSIS in SQL Server 2012!
00:00:00 David Klee Track 4 Database Health and Performance
00:00:00 Eddie Hendrix Track 4 Microsoft's Monitoring Options for SQL Server
00:00:00 Dan Guzman Track 3 Maximizing SQL Server Insert Performance
00:00:00 Hima Nagisetty Track 2 SQL Server Detective Duo – Change Tracking and CDC
00:00:00 Ira Warren Track 5 Creating a Metadata Mart w/ SSIS - Data Governance
00:00:00 Janis Griffin Track 2 Looney Tuner? No, there IS a method to my madness
00:00:00 Janis Griffin Track 4 Don't Panic, DBAs! Databases on VMware made easy.
00:00:00 Jeff Fattic Track 4 Your Database Code is in My TFS!
00:00:00 Kathi Kellenberger Track 3 SQL Server 2012 T-SQL
00:00:00 Melissa Meyer Track 1 SQL 2012 Integration with SharePoint
00:00:00 Rickey Nunn Track 1 Database Design Done Right
00:00:00 Scott Shaw Track 1 Cubicle to Consulting
00:00:00 Scott Shaw Track 5 SQL Server in Healthcare
00:00:00 Kevin Boles Track 3 Common TSQL Mistakes
00:00:00 Travis Whitley Track 1 Behind the Scenes: SQL Server Statistics
00:00:00 Wendy Pastrick Track 3 Read Dirty to Me - Isolation Levels/User Impact
00:00:00 Wendy Pastrick Track 4 Transactional Replication 101
00:00:00 Aaron Nelson Track 2 Time Saving Tips Tricks for SSMS 2012
00:00:00 Andy Galbraith Track 2 Maintain Your DBs with Help from Ola Hallengren
00:00:00 Arie Jones Track 3 PWNED! Security, SQL Server, and You!
00:00:00 Andy Thiru Track 5 Windows Azure SQL database Intro and what’s New

SessionID: 10399

Pivoting Performance Data Pinpointing Problems

Back to calendar

Event Date: 15-09-2012 - Session time: 00:00:00 - Track: Track 5

Speaker: Brian Flynn

Title: Pivoting Performance Data Pinpointing Problems

Abstract:

Have you ever been wrought with end user complaints of database performance issues only to open your tools that show only live performance or limited historical performance and find no answers? After being bit by this many times, I developed my own eye in the sky to monitor CPU Physical IO at the database, user and application levels. This solution logs data continuously and parses it into an Analysis Services cube which can be queried by Excel. No need to requisition funds for 3rd party tools. You can do this with the tools you have and I’ll give you the scripts to get started. Using these tools I have been able to find needles in haystacks and effectively communicate the nature of the problems to people at all levels.

SessionID: 10419

Kama Sutra of SSIS: A guide to loving ETL

Back to calendar

Event Date: 15-09-2012 - Session time: 00:00:00 - Track: Track 1

Speaker: Bill Fellows

Title: Kama Sutra of SSIS: A guide to loving ETL

Abstract:

Slow running packages? SSIS consuming all your resources? No idea what it's doing?

After attending this session, you will come out with an understanding of how Configuration, Logging, Package settings and deployment work in SQL Server Integration Services. You will also be armed with a list of transformations and perfmon counters to watch out for.

SessionID: 10420

2012 TSQL Sweets

Back to calendar

Event Date: 15-09-2012 - Session time: 00:00:00 - Track: Track 5

Speaker: Bill Fellows

Title: 2012 TSQL Sweets

Abstract:

The 2012 release of SQL Server promise a variety of delicious new language features to solve problems. After this session, you'll have a taste for all the sweets they've packed into the language including conversions, date time functions, windowing functions, analytic functions and sequences.

SessionID: 12338

Get Ready for SSIS in SQL Server 2012!

Back to calendar

Event Date: 15-09-2012 - Session time: 00:00:00 - Track: Track 2

Speaker: Dave Fackler

Title: Get Ready for SSIS in SQL Server 2012!

Abstract:

With the next release of SQL Server, BI developers and database professionals need to know what's available and how to take advantage of new features and capabilities. During this session, we'll drilldown on the next release of SSIS and discuss development improvements, the new deployment model, and better managability options. Along the way, we'll look at new SSIS features including project parameters, shared connection managers, team-based development improvements, and a brand new deployment model with significantly improved management features. Come see some of the exciting changes now available in your favorite data integration tool!

SessionID: 12568

Database Health and Performance

Back to calendar

Event Date: 15-09-2012 - Session time: 00:00:00 - Track: Track 4

Speaker: David Klee

Title: Database Health and Performance

Abstract:

Sure, your SQL Server is up and running. Is it healthy? Is it performing the best that it can? Where are your performance bottlenecks? This dynamic dialog session will present a solid process for checking your environment's overall health and performance levels as well as solutions for common problems. Some of the items focused on include dynamic management views (DMVs), Windows Perfmon, and disk performance tools such as IOMeter and SQLIO.

SessionID: 13750

Microsoft's Monitoring Options for SQL Server

Back to calendar

Event Date: 15-09-2012 - Session time: 00:00:00 - Track: Track 4

Speaker: Eddie Hendrix

Title: Microsoft's Monitoring Options for SQL Server

Abstract:

A look at different options for monitoring and debugging your SQL Server environment. We'll start from low level and work our way to enterprise level options. We'll look at traces flags, logs, data collectors, utility control points, and up to system center.

SessionID: 14917

Maximizing SQL Server Insert Performance

Back to calendar

Event Date: 15-09-2012 - Session time: 00:00:00 - Track: Track 3

Speaker: Dan Guzman

Title: Maximizing SQL Server Insert Performance

Abstract:

This session describes how to maximize throughput for high-volume insert applications using both programming and database server techniques. Performance of bulk insert and table-valued-parameter methods will be contrasted with traditional insert methods.

SessionID: 14992

SQL Server Detective Duo – Change Tracking and CDC

Back to calendar

Event Date: 15-09-2012 - Session time: 00:00:00 - Track: Track 2

Speaker: Hima Nagisetty

Title: SQL Server Detective Duo – Change Tracking and CDC

Abstract:

'Change 'is the only constant. It is the undoubted truth for data in our world of OLTP databases. Most of us are required to implement an array of solutions to track data changes, for reasons ranging from simple logging to complex regulatory compliance. So the important question is, how best can tracking be done? To help you make the right choice, this session will list and demonstrate some Change Tracking mechanisms. Some of the highlights will be SQL Server Change Tracking and Change Data Capture (CDC) features.

SessionID: 15476

Creating a Metadata Mart w/ SSIS - Data Governance

Back to calendar

Event Date: 15-09-2012 - Session time: 00:00:00 - Track: Track 5

Speaker: Ira Warren

Title: Creating a Metadata Mart w/ SSIS - Data Governance

Abstract:

This is an expanded and updated version of the session I presented at the SQL Rally in Orlando. We will cover Tactical Data Governance and in detail specific code examples, using Stock and Custom SSIS Transforms ,Data Models, SSAS Cubes used to create and populate a Metadata Mart as defined by Michael Belcher(Gartner). We  will demonstrate incorporating complete custom Data Profiling capabilities (SSIS Transform Scripting, TSQL) capable of Profiling any Source and Targeting any destination. In addition we will implement Data Quality(Address Correction, Fuzzy Matching) and Visualization via PowerPivot , Excel and QlikView. Last will will demonstrate code generation.

SessionID: 15678

Looney Tuner? No, there IS a method to my madness

Back to calendar

Event Date: 15-09-2012 - Session time: 00:00:00 - Track: Track 2

Speaker: Janis Griffin

Title: Looney Tuner? No, there IS a method to my madness

Abstract:

SQL Server query tuning is often more art than science and it can quickly eat up a lot of DBA and/or Developer time. This presentation will outline a method for determining the best approach for tuning queries by utilizing response time analysis and SQL diagramming techniques. Regardless of the complexity of the statement, this quick, systematic approach will lead you down the correct tuning path with no guessing. If you are a beginner or expert, this approach will save you countless hours tuning a query.

SessionID: 15679

Don't Panic, DBAs! Databases on VMware made easy.

Back to calendar

Event Date: 15-09-2012 - Session time: 00:00:00 - Track: Track 4

Speaker: Janis Griffin

Title: Don't Panic, DBAs! Databases on VMware made easy.

Abstract:

More and more companies are virtualizing with VMWare, and databases are the next logical step. This presentation will explore the fundamentals of monitoring databases running in a VMWare environment because it can be much different than when running on a physical machine. You will learn business and technical benefits of virtualization, master new terms and concepts, pick up useful planning tips and tricks, and cover best practices for maintaining optimum performance in a VMWare environment.

SessionID: 16707

Your Database Code is in My TFS!

Back to calendar

Event Date: 15-09-2012 - Session time: 00:00:00 - Track: Track 4

Speaker: Jeff Fattic

Title: Your Database Code is in My TFS!

Abstract:

Tooling for application developers has always surpassed those available for database developers. Microsoft now provides tools that give database developers some love: get database code into source control, branch for concurrent development, automate builds and deployments, refactor, and so much more.

SessionID: 18396

SQL Server 2012 T-SQL

Back to calendar

Event Date: 15-09-2012 - Session time: 00:00:00 - Track: Track 3

Speaker: Kathi Kellenberger

Title: SQL Server 2012 T-SQL

Abstract:

Have you heard about all the great new T-SQL features? Attend this session to learn about new functions, OVER clause enhancements, the Sequence Object and more!

SessionID: 20975

SQL 2012 Integration with SharePoint

Back to calendar

Event Date: 15-09-2012 - Session time: 00:00:00 - Track: Track 1

Speaker: Melissa Meyer

Title: SQL 2012 Integration with SharePoint

Abstract:

This session will showcase what is new in the BI arena in SQL 2012, focusing on BI in SharePoint. Discussion will be centered around Power View, SSRS, PowerPivot 2.0 and the new Tabular Model. Learn what each tool can do and when to use them.

SessionID: 23137

Database Design Done Right

Back to calendar

Event Date: 15-09-2012 - Session time: 00:00:00 - Track: Track 1

Speaker: Rickey Nunn

Title: Database Design Done Right

Abstract:

From beginning to end application development is upside down. So much emphasis is placed on the front end and so little on the analysis of database structure that many application development projects fail to achieve the goals set by the business. This presentation uses an interwoven analogy to illustrate the process currently used by most enterprises, the results, and the short comings. Yet with a change of focus, the same projects can not only be successful; they can be done under budget, with greater flexibility and extensibility. Future projects can benefit from this change of focus with additional savings in timelines and fewer bug fixes downstream. Any business person or data professional who works directly with business people c

SessionID: 24841

Cubicle to Consulting

Back to calendar

Event Date: 15-09-2012 - Session time: 00:00:00 - Track: Track 1

Speaker: Scott Shaw

Title: Cubicle to Consulting

Abstract:

What you do for a living may say a lot about who you are. No where is this as true as in IT. How you learn, how you grow, your passions, and your goals can all be reflected in your job. There are many ways your skills can be delivered and you need to choose the best fit for who you are. This session aims to take an unbiased look at the difference between working in a solid, stable IT environment or trekking out and offering your skills as an IT consultant. The differences are staggering and each has their risks and rewards. Each role has its own myths and, like most myths, some are true and some are not. This session will draw on real-world experience and won't hesitate to point out the successes as well as the failures.

SessionID: 24844

SQL Server in Healthcare

Back to calendar

Event Date: 15-09-2012 - Session time: 00:00:00 - Track: Track 5

Speaker: Scott Shaw

Title: SQL Server in Healthcare

Abstract:

SessionID: 26286

Common TSQL Mistakes

Back to calendar

Event Date: 15-09-2012 - Session time: 00:00:00 - Track: Track 3

Speaker: Kevin Boles

Title: Common TSQL Mistakes

Abstract:

We are going to examine a variety of oopsies MANY developers fall prey too - some obvious, some pretty subtle and some down right sneaky! Lots of code examples with the bad AND good code presented. I GUARANTEE that you will find things here that will either prevent you from getting bad data, throwing unwanted errors or vastly improving your database application's performance. I have given this talk over a dozen times now and it is always very highly rated!

SessionID: 27097

Behind the Scenes: SQL Server Statistics

Back to calendar

Event Date: 15-09-2012 - Session time: 00:00:00 - Track: Track 1

Speaker: Travis Whitley

Title: Behind the Scenes: SQL Server Statistics

Abstract:

An informative, entry level session regarding SQL Server statistics and the importance of their accuracy. The presentation will cover, in detail, the statistics object - how they are generated and how the optimizer utilizes them, along with some foundation SQL Server internals principles. Examples will be provided that construct situations where the optimizer chooses poor execution plans due to issues with statistics. Finally, a free stored proc will be provided that allows for comprehensive statistics management by the DBA.

SessionID: 27798

Read Dirty to Me - Isolation Levels/User Impact

Back to calendar

Event Date: 15-09-2012 - Session time: 00:00:00 - Track: Track 3

Speaker: Wendy Pastrick

Title: Read Dirty to Me - Isolation Levels/User Impact

Abstract:

Issue a "SELECT {data} FROM {myTable}" statement and users need to trust the data returned is accurate. What happens when multiple processes access the same data? What happens further if one of those process is an UPDATE or even a DELETE statement? How about if both processes will be updating that data? Understanding Isolation in SQL Server is paramount in ensuring data integrity in your system. We will cover the different levels of isolation and how they impact what a user views when accessing the data at a given point-in-time.

SessionID: 27799

Transactional Replication 101

Back to calendar

Event Date: 15-09-2012 - Session time: 00:00:00 - Track: Track 4

Speaker: Wendy Pastrick

Title: Transactional Replication 101

Abstract:

Replication simplified! Learn the basic parts that make up replication, what tools are included to help you along plus a look into monitoring.

We will cover the players in the game: Pubishers, Subscribers and Distributors, then delve into the data delivery process with Publications, Subscriptions and Articles, finishing up with the Log Reader and how to make sure everything is working and running smoothly.

SessionID: 8864

Time Saving Tips Tricks for SSMS 2012

Back to calendar

Event Date: 15-09-2012 - Session time: 00:00:00 - Track: Track 2

Speaker: Aaron Nelson

Title: Time Saving Tips Tricks for SSMS 2012

Abstract:

SQL Server Management Studio can be really annoying sometimes. Over the years a few really nice features have been added that you may have overlooked or just couldn’t find. This session will focus some time saving tips and tricks for SSMS 2008 R2. We’ll also cover a few great new features being introduced in SSMS 2012. Since I can’t provide scripts for this session I guess I better get started working on some screen shots on where they hid all this stuff!

SessionID: 9612

Maintain Your DBs with Help from Ola Hallengren

Back to calendar

Event Date: 15-09-2012 - Session time: 00:00:00 - Track: Track 2

Speaker: Andy Galbraith

Title: Maintain Your DBs with Help from Ola Hallengren

Abstract:

SessionID: 9817

PWNED! Security, SQL Server, and You!

Back to calendar

Event Date: 15-09-2012 - Session time: 00:00:00 - Track: Track 3

Speaker: Arie Jones

Title: PWNED! Security, SQL Server, and You!

Abstract:

With an ever increasing workload, security is often hoisted upon the DBA. So where do you start? Sometimes it's better to start off by understanding what an attacker could do to you in order to get a clearer picture of what you need to do to prevent it. In this session, we will delve into the key features of the SQL Server and explain what the various attack vectors are, what an attack can do with them, and what you can do about them. We'll also look at important features such as SQL Audit that, while not helping to prevent, can definitely help in figuring out what is going on. It'll be AWESOME!

SessionID: 9955

Windows Azure SQL database Intro and what’s New

Back to calendar

Event Date: 15-09-2012 - Session time: 00:00:00 - Track: Track 5

Speaker: Andy Thiru

Title: Windows Azure SQL database Intro and what’s New

Abstract:

Windows Azure provides many options for storing data. Windows Azure SQL Database is one of the Windows Azure’s solution 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, you will get introduced to: Windows Azure SQL Database and 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 walkthrough how to manage and administer your Windows Azure SQL servers and databases. We will take a look at how to connect and build applications using Windows Azure SQL. Next, we will look at more advanced scenarios using new capabilities like reporting with SQL Azu