Nr: 154
SQLSaturday #154 - St. Louis 2012
SessionID: 10399
Event Date: 15-09-2012 - Session time: 00:00:00 - Track: Track 5
Speaker: Brian Flynn
Abstract:
SessionID: 10419
Kama Sutra of SSIS: A guide to loving ETL
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
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!
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:
SessionID: 12568
Event Date: 15-09-2012 - Session time: 00:00:00 - Track: Track 4
Speaker: David Klee
Abstract:
SessionID: 13750
Microsoft's Monitoring Options for SQL Server
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
Event Date: 15-09-2012 - Session time: 00:00:00 - Track: Track 3
Speaker: Dan Guzman
Abstract:
SessionID: 14992
SQL Server Detective Duo – Change Tracking and CDC
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
Event Date: 15-09-2012 - Session time: 00:00:00 - Track: Track 5
Speaker: Ira Warren
Abstract:
SessionID: 15678
Looney Tuner? No, there IS a method to my madness
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.
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!
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:
SessionID: 18396
SQL Server 2012 T-SQL
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
Event Date: 15-09-2012 - Session time: 00:00:00 - Track: Track 1
Speaker: Melissa Meyer
Title: SQL 2012 Integration with SharePoint
Abstract:
SessionID: 23137
Database Design Done Right
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
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
Event Date: 15-09-2012 - Session time: 00:00:00 - Track: Track 5
Speaker: Scott Shaw
Title: SQL Server in Healthcare
Abstract:
Did you know Microsoft started a new company dedicated to healthcare? Did you even know Microsoft has an electronic health records product and a large suite of security products specifically focused on healthcare solutions? You may not know it but healthcare is driving today's technology. Everything from business analysis, security, and tele-communications is focusing on healthcare solutions. Even Microsoft Kinect is getting in the act. Where there is growth, there is opportunity. This session will define the lingo and point out the trends in order to demystify the industry. I'll start with the big picture and drill down to the specifics. Together we'll navigate the trends and get excited about where all of this is going.
SessionID: 26286
Common TSQL Mistakes
Event Date: 15-09-2012 - Session time: 00:00:00 - Track: Track 3
Speaker: Kevin Boles
Title: Common TSQL Mistakes
Abstract:
SessionID: 27097
Behind the Scenes: SQL Server Statistics
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
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
Event Date: 15-09-2012 - Session time: 00:00:00 - Track: Track 4
Speaker: Wendy Pastrick
Title: Transactional Replication 101
Abstract:
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
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
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:
One of the most widely respected and recommended free tools for SQL Server is Ola Hallengren's MaintenanceSolution.sql. It is a one-stop package to backup your databases, maintain your indexes and statistics, and validate the integrity of databases. Come learn about the solution and how it can help you escape the world of canned maintenance plans as well as the importance of performing the various maintenance tasks.
SessionID: 9817
PWNED! Security, SQL Server, and You!
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
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