Nr: 79
SQLSaturday #79 - South Florida 2011
SessionID: 28707
Meet the PASS Board of Directors
Event Date: 13-08-2011 - Session time: 00:00:00 - Track: Misc1
Speaker: Andy Warren
Title: Meet the PASS Board of Directors
Abstract:
Here is an opportunity to meet the PASS Board of Directors, ask them questions, and get up-n-personal with this great group!
SessionID: 28708
Building a Professional Development Plan
Event Date: 13-08-2011 - Session time: 00:00:00 - Track: Misc2
Speaker: Andy Warren
Title: Building a Professional Development Plan
Abstract:
A good professional development plan has to go far beyond ‘learning more technology’, it has to encompass the wide variety of skills you need to build the next step in your career, and it has to include a variety of learning methods. We’ll discuss how much time and money you should budget when building your plan, and how the distribution of time and money changes as your career evolves. We’ll look at the growth phases you’ll encounter, learning how you learn best, how to keep up with new technology without burning out, and even how things like blogging and Twitter can be an interesting part of your plan.
SessionID: 28709
Introduction to SQL Server Statistics
Event Date: 13-08-2011 - Session time: 00:00:00 - Track: BI2
Speaker: Andy Warren
Title: Introduction to SQL Server Statistics
Abstract:
SessionID: 29069
0 to SSRS Presentation
Event Date: 13-08-2011 - Session time: 00:00:00 - Track: BI1
Speaker: David Liebman
Title: 0 to SSRS Presentation
Abstract:
In this presentation I will show you how to create a simple report and deploy the report to the Report Server using SQL Server Business Intelligence Development Studio(BIDS).
SessionID: 29141
Page and Row Compression How, When, and Why
Event Date: 13-08-2011 - Session time: 00:00:00 - Track: DBA1
Speaker: Bradley Ball
Title: Page and Row Compression How, When, and Why
Abstract:
Page and Row Compression are powerful new tools. Vardecimal shipped with SQL 2005 SP2, Page Row with SQL 2008 RTM, and Page Row with Unicode Compression with SQL 2008 R2. Get an overview into how each version of compression works internally. Learn how your Allocation Units will determine if your data is a candidate for compression. Understand how your tables Update and Scan pattern’s affect the compression types you should consider. And what you should you take into consideration for additional overhead.
SessionID: 29142
Transprent Data Encryption Inside and Out
Event Date: 13-08-2011 - Session time: 00:00:00 - Track: DBA1
Speaker: Bradley Ball
Title: Transprent Data Encryption Inside and Out
Abstract:
Security is a very important part of your job and in how data is utilized. We have many tools to make data more secure, and starting in SQL 2008 we were able to add Transparent Data Encryption to that list. Find out What it does, What it doesn’t do, how it effects Read-Only Filegroups, Performance, Compression (Backup and Row/Page), and other Advance Features as well as some tips on how to manage it.
SessionID: 29143
SQL Internals, Recovery Modes, Backups! OH MY!
Event Date: 13-08-2011 - Session time: 00:00:00 - Track: DBA1
Speaker: Bradley Ball
Title: SQL Internals, Recovery Modes, Backups! OH MY!
Abstract:
The more you know about SQL Server the more you understand how it works. SQL Server is a product we use every day, and most of us know the big concepts. At the 10,000 foot view we know what Databases, Tables, and Columns are. But what makes up those Databases, Tables, and Columns. What are Records, Pages, Extents, and Allocation Units? What are Full, Simple, and Bulk-Logged Recovery? What are the differences between Full, Transaction Log, Differential, or Filegroup backups? This is an introduction to these concepts. In this session you will learn about the internal Structure, Recovery Modes, and Backups and be better prepared to for Future Learning and Managing SQL!
SessionID: 29258
Scaling your BI solution
Event Date: 13-08-2011 - Session time: 00:00:00 - Track: BI3
Speaker: Brian Mitchell
Title: Scaling your BI solution
Abstract:
You've built your BI solution, but its just not performing the way you expect it. Regardless of the size of your solution, all can use these basic techniques of triaging our SSAS and SSRS environments. We will discuss the main culprits that affect scale and how to track them down using the tools available to you.
SessionID: 29325
Introduction to SSIS
Event Date: 13-08-2011 - Session time: 00:00:00 - Track: BI1
Speaker: Bradley Schacht
Title: Introduction to SSIS
Abstract:
In this session Brad will help get you past the learning curve of SSIS. He will cover the basics of the development environment, the control flow and data flow. Brad will show you how to create an end to end package to demonstrate best practices and illustrate design concepts. This is a great session for anyone who is new to SSIS.
SessionID: 29326
Configuring and Extending SSIS
Event Date: 13-08-2011 - Session time: 00:00:00 - Track: BI1
Speaker: Bradley Schacht
Title: Configuring and Extending SSIS
Abstract:
In this session Brad will walk you through some of the best practices for configuring SSIS. Each of the configuration types will be covered from XML to registry entries. The use of expressions for configuring your SSIS package will also be covered. Finally he will walk you through some best practices for moving your packages between environments and keeping your configurations up to date.
SessionID: 29863
Column Level Encryption
Event Date: 13-08-2011 - Session time: 00:00:00 - Track: Dev2
Speaker: David Dye
Title: Column Level Encryption
Abstract:
This session will introduce column level encryption using t-sql. We will discuss the introduction of cryptographic services in SQL Server and how this enables native encryption as well as real life scenarios and uses of column level encryption.
SessionID: 29864
Implementing auditing in SQL Server
Event Date: 13-08-2011 - Session time: 00:00:00 - Track: DBA2
Speaker: David Dye
Title: Implementing auditing in SQL Server
Abstract:
SessionID: 29919
Anti-patterns in Database design and T-Sql code
Event Date: 13-08-2011 - Session time: 00:00:00 - Track: Dev1
Speaker: Dmitri Korotkevitch
Title: Anti-patterns in Database design and T-Sql code
Abstract:
Simplicity and power of Microsoft SQL Server allows us to design and develop the working solution in virtually no time. Although there is a significant difference between the system that just works and the system that works efficiently. One of the challenges architects and developers often face is that the best practices and methods commonly used in the client development cannot be applied in the database world and rather hurt the systems than help them.
The session focuses on a few obvious and not-so-obvious anti-patterns commonly encountered in production database systems. It shows how to refactor them and improve the system performance.
SessionID: 29920
Data Sharding in OLTP Systems
Event Date: 13-08-2011 - Session time: 00:00:00 - Track: BI3
Speaker: Dmitri Korotkevitch
Title: Data Sharding in OLTP Systems
Abstract:
This session demonstrates several data sharding techniques that can be used to partition the data across multiple database servers focusing on the task of separating production and historical data in OLTP systems
SessionID: 29947
The Art of the Trace
Event Date: 13-08-2011 - Session time: 00:00:00 - Track: DBA2
Speaker: Don Stevic
Title: The Art of the Trace
Abstract:
Have you ever been asked to troubleshoot an issue and then learned it happened a few days ago, and they wanted an root cause by 5PM?
Have users complained that the "Slowness" has been plauging them all day, but by the time you are told, you can't find a bottleneck?
If you have and couldn't find answers, you need Server Side Traces.
In this session, I will take you through the creation of a process to setup server side trances, and how to use them to baseline and
protect your servers.
SessionID: 29948
The Fundamentals of DBA-ism
Event Date: 13-08-2011 - Session time: 00:00:00 - Track: DBA2
Speaker: Don Stevic
Title: The Fundamentals of DBA-ism
Abstract:
When I was a freshly minted DBA and trying to learn the ropes, my manager used to tell me “You should know that, that’s DBA 101”. As much as it frustrated me, he was right. There is a core set of knowledge that DBA. Correct SQL installation and configuration, how’s and whys of backups, how to make your role proactive, and many other things fall under that heading. This session is for the “freshly minted” DBA to help them find and define their own set of best practices.
SessionID: 30237
SQL “Denali” AlwaysOn High Availability Solutions
Event Date: 13-08-2011 - Session time: 00:00:00 - Track: Dev1
Speaker: Geoff Hiten
Title: SQL “Denali” AlwaysOn High Availability Solutions
Abstract:
AlwaysOn is the new High Availability branding for Microsoft SQL Server that combines the best in Clustering, Mirroring, and Log Shipping for a simple, seamless experience. See what Microsoft is building into SQL Server Codename “Denali” and how you can plan for this new way to increase database availability in your shop.
SessionID: 30331
Import data into SQL Azure with SqlBulkCopy
Event Date: 13-08-2011 - Session time: 00:00:00 - Track: Dev1
Speaker: Herve Roggero
Title: Import data into SQL Azure with SqlBulkCopy
Abstract:
SessionID: 30621
Designing and Optimizing SSAS Hierarchies
Event Date: 13-08-2011 - Session time: 00:00:00 - Track: BI1
Speaker: Jose Chinchilla
Title: Designing and Optimizing SSAS Hierarchies
Abstract:
In this session Jose will do an overview of the different types of hierarchies and how to design user hierarchies in SSAS by defining attribute relationships and key columns the right way. Attendees will learn how to implement natural unnatural hierarchies, balanced and ragged hierarchies, and Parent-Child hierarchies. Jose will show how to optimize SSAS hierarchies by specifying attribute and dimension types, member uniqueness, and aggregations. Jose will also do quick intro on querying hierarchies with MDX.
SessionID: 30622
What is BI Semantic Model and why should you care?
Event Date: 13-08-2011 - Session time: 00:00:00 - Track: BI3
Speaker: Jose Chinchilla
Title: What is BI Semantic Model and why should you care?
Abstract:
Microsoft has shifted gears towards the new Business Intelligence Semantic Model (BISM), but what does it mean to Analysis Services cube developers? Join Jose to understand what BISM is and the Analysis Services roadmap. Jose will demo how to develop and deploy BISM models to the new Vertipaq engine and how to interface with them.
SessionID: 30833
Data Options on Windows Phone "Mango"
Event Date: 13-08-2011 - Session time: 00:00:00 - Track: Misc1
Speaker: Joe Healy
Title: Data Options on Windows Phone "Mango"
Abstract:
During this session we'll cover the options for storing data on a Windows Phone including isolated storage, SQL Compact, and Sterling DB. If time allows we'll also take a look at pulling data into the phone using various service layers.
SessionID: 30834
Introduction to Kinect SDK
Event Date: 13-08-2011 - Session time: 00:00:00 - Track: Misc1
Speaker: Joe Healy
Title: Introduction to Kinect SDK
Abstract:
During this session we'll explore the basics of Kinect Programming using the Kinect SDK. This has nothing to do with SQL, but should offer a refreshing respitre from SSxS, SQL and other database stuff for any programmers attending.
SessionID: 30871
Share The Code, Man
Event Date: 13-08-2011 - Session time: 00:00:00 - Track: Dev2
Speaker: James McAuliffe
Title: Share The Code, Man
Abstract:
How to Incorporate Enterprise Code in SSIS Processing.
For many SSIS scenarios, a desired outcome is to implement logic or rules that are used in existing enterprise applications, only to do so in an a bulk data loading scenario. Many times the logic being applied is complex and multi-step. We will examine various scenarios where complex logic from shared code sources can be applied in SSIS processing scenarios.
- How to implement complex logic using code in SSIS
- How to use code from shared enterprise sources
- Using logic from external services
- Performance comparisons.
SessionID: 30872
Data Late Than Never
Event Date: 13-08-2011 - Session time: 00:00:00 - Track: Misc1
Speaker: James McAuliffe
Title: Data Late Than Never
Abstract:
How to Fill in the Gaps for Missing Data
When ETL lookups don’t match this can be a problem. In the case of ETL processing over large data sets, having to figure out the missed match conditions for large numbers of rows can be a problem. In the case of a dimensional warehouse, when you are processing large numbers of fact rows that have a lookup dependency, and you cannot get a match, what can you do? We’ll discuss strategies such as
- Late Arriving Dimensions and Facts
- Using a default values.
- Use multiple default values.
- Creating a partially populated dimension row for a late arriving dimension.
- Using “Level Of Confidence” pattern matching techniques
SessionID: 31046
An Introduction to Project Management
Event Date: 13-08-2011 - Session time: 00:00:00 - Track: Misc2
Speaker: Richie Rump
Title: An Introduction to Project Management
Abstract:
SessionID: 31057
Mission Possible: Pervasive BI
Event Date: 13-08-2011 - Session time: 00:00:00 - Track: BI3
Speaker: Bob Abernethy
Title: Mission Possible: Pervasive BI
Abstract:
Making Business Intelligence pervasive throughout an organization has proven to be the “Holy Grail” for many companies – recognized as of immense value but also difficult to attain. In this session we will take a look at the definition, benefits, obstacles, and requirements of Pervasive BI, as well as techniques and technologies which have made SQL Server-based Pervasive BI a “Mission Possible” for many organizations. We will then take a look at a case study of a large internal corporate deployment of Pervasive BI built on SQL Server Analysis Services.
SessionID: 31085
MS Access with SQL Server Strategies and Tips
Event Date: 13-08-2011 - Session time: 00:00:00 - Track: Dev2
Speaker: Juan Soto
Title: MS Access with SQL Server Strategies and Tips
Abstract:
SQL Server DBA's face a lot of challenges now days, from maintaining servers to putting out fires. One of them is how to properly deal with Access databases in the workplace. Quite frequently they contain mission critical data and grown to be important to your business. Upsizing them to SQL Server is just the first step, you need to change Access's forms, reports, queries and code to avoid issues with your server. In this session we will discuss strategies; from importing data to optimizing the relationship between Access and SQL. Users will leave having a much better understanding of how to incorporate Access in the workplace and safeguard their data.
SessionID: 31271
Paging DR Availability, Recovery Room STAT!
Event Date: 13-08-2011 - Session time: 00:00:00 - Track: BI2
Speaker: Kendal Van Dyke
Title: Paging DR Availability, Recovery Room STAT!
Abstract:
There are a lot of options when it comes to disaster recovery and high availability with regards to SQL Server. Most business owners (and many DBA's) lump disaster recovery (DR) high availability (HA) together and while they do share some pieces, they call for different strategies. Do you pick one or more than one of these options, and what criteria do you use to make the choice? It’s incredibly important that you understand the decision tree that helps you pick the right options(s) for your business and that you can explain the choices clearly to the stakeholders. It’s not as complicated as it sounds, but it is complicated. This presentation will give you a high level understanding of the options, the costs, complexities, reasons for t
SessionID: 31272
Working with XML in SQL Server
Event Date: 13-08-2011 - Session time: 00:00:00 - Track: Dev2
Speaker: Kendal Van Dyke
Title: Working with XML in SQL Server
Abstract:
SessionID: 31638
Let’s talk about SQL PowerShell
Event Date: 13-08-2011 - Session time: 00:00:00 - Track: Misc1
Speaker: Maximo Trinidad
Title: Let’s talk about SQL PowerShell
Abstract:
SessionID: 31639
Extend your T-SQL Scripting with PowerShell
Event Date: 13-08-2011 - Session time: 00:00:00 - Track: Misc1
Speaker: Maximo Trinidad
Title: Extend your T-SQL Scripting with PowerShell
Abstract:
I’ll be covering some of the different way we can use PowerShell to extend our T-SQL scripting. This session will include a mix of using SMO, .NET classes, and SQLPS to help you understand the power for new scripting technology. At the end we’ll be creating a solution that put together all this techniques.
SessionID: 31660
Denali SSIS Features and Best Practices
Event Date: 13-08-2011 - Session time: 00:00:00 - Track: BI2
Speaker: Mike Davis
Title: Denali SSIS Features and Best Practices
Abstract:
A great session
SessionID: 31811
Introduction to PowerPivot for Excel
Event Date: 13-08-2011 - Session time: 00:00:00 - Track: Dev1
Speaker: Michael Antonovich
Title: Introduction to PowerPivot for Excel
Abstract:
This session focuses on the basics of how to use PowerPivot with Excel to create simple pivot tables (cubes) and pivot charts using both data already in Excel as well as how to connect to SQL tables as your data source. It will also cover how add slicers, how to add calculated columns and how to define hierarchies in your pivot tables.
SessionID: 31812
Pivot Tables Charts from T-SQL thru SharePoint
Event Date: 13-08-2011 - Session time: 00:00:00 - Track: Dev1
Speaker: Michael Antonovich
Title: Pivot Tables Charts from T-SQL thru SharePoint
Abstract:
SessionID: 31834
Cool Things MSDB Will Tell You (If you ask)
Event Date: 13-08-2011 - Session time: 00:00:00 - Track: DBA1
Speaker: Mike Hillwig
Title: Cool Things MSDB Will Tell You (If you ask)
Abstract:
We all have tasks that run through the SQL Server Agent. Every once in a while, we need to provide a history, a schedule, or even just a listing of what jobs and steps are being run. And lets not forget about backups and maintenance plan history. Nothing is more frustrating than sifting through multiple screens and logs to put this into a meaningful format. Mike Hillwig will show you how to query and present this data without needing third party tools.
SessionID: 31835
Top Ten Rules for Managing a Production Environmen
Event Date: 13-08-2011 - Session time: 00:00:00 - Track: DBA2
Speaker: Mike Hillwig
Title: Top Ten Rules for Managing a Production Environmen
Abstract:
Mike Hillwig has ten rules for managing a SQL Server environment regardless of the size. His rules cover things from server configurations to planning for a disaster and a few things that should never be done.
SessionID: 31836
Top Ten Operational Mistakes to Avoid
Event Date: 13-08-2011 - Session time: 00:00:00 - Track: BI3
Speaker: Mike Hillwig
Title: Top Ten Operational Mistakes to Avoid
Abstract:
SessionID: 32334
Funding Your Software Project in Two Easy Steps
Event Date: 13-08-2011 - Session time: 00:00:00 - Track: Misc2
Speaker: Jared Nielsen
Title: Funding Your Software Project in Two Easy Steps
Abstract:
Software Development is EXPENSIVE! Jared Nielsen, a local Jacksonville SEO Expert will share with you his techniques for rounding up the capital and funding you need to launch that software development project you have always wanted to do. Comprehensive discussions on sources of funds, ways to attract capital, ways to attract revenue and who to ask will be covered in this highly lucrative discussion.
SessionID: 32335
SQL and SEO - a DBA's Guide to Search Engines
Event Date: 13-08-2011 - Session time: 00:00:00 - Track: Misc2
Speaker: Jared Nielsen
Title: SQL and SEO - a DBA's Guide to Search Engines
Abstract:
Complex data structures, Google metrics, and SQL code will be shared as Jacksonville SEO Expert Jared Nielsen demonstrates how he used databases and search engines in the mortgage industry, sports apparel, legal, and other industries.
SessionID: 32651
Business Intelligence dashboards with Share Point
Event Date: 13-08-2011 - Session time: 00:00:00 - Track: BI1
Speaker: Phillip E Rosen
Title: Business Intelligence dashboards with Share Point
Abstract:
I will demonstrate how to develop MS Excel BI Dashboards in the following ways:
- Workbook style with Office data connections stored on local PC or networked document drive
- excel services style using Reports Library SP 2007 for storage of the Office data connections workbook that excel services will render
- Convert excel pivot table into excel OLAP formulas
- Discuss SP 2010 BI Center
- Discuss references to cap off session.
SessionID: 32780
Delivering BI to the Masses at Microsoft
Event Date: 13-08-2011 - Session time: 00:00:00 - Track: BI2
Speaker: Sanjay Soni
Title: Delivering BI to the Masses at Microsoft
Abstract:
See live demos of how Microsoft IT is delivering BI to the masses (39,600+ users globally) at Microsoft using SharePoint, using Excel, PerformancePoint, SQL Server, SQL Azure, Windows Azure and other Microsoft BI products. Hear about 6 years of Microsoft IT BI success story. Learn best practices and technical details on how to implement large scale self-service Business Intelligence systems in your organization and enable BI for the masses in real life.
SessionID: 33006
DIY Hyper-V, Clustering and SQL Server
Event Date: 13-08-2011 - Session time: 00:00:00 - Track: Dev1
Speaker: David Cobb
Title: DIY Hyper-V, Clustering and SQL Server
Abstract:
Hyper-V in Windows Server R2 is a playground for the I.T. Geek! Learn how to use Hyper-V, SQL Server 2008 R2 and free iSCSI software to create a virtual SAN, windows failover cluster, and Active-Active SQL cluster, all in a single physical server, for learning and development purposes.
SessionID: 33051
Monitoring Databases in a Virtual Environment
Event Date: 13-08-2011 - Session time: 00:00:00 - Track: DBA1
Speaker: Thomas LaRock
Title: Monitoring Databases in a Virtual Environment
Abstract:
SessionID: 33052
SQL Server Memory Management
Event Date: 13-08-2011 - Session time: 00:00:00 - Track: DBA2
Speaker: Thomas LaRock
Title: SQL Server Memory Management
Abstract:
SessionID: 33053
Waits and Queues and You
Event Date: 13-08-2011 - Session time: 00:00:00 - Track: DBA2
Speaker: Thomas LaRock
Title: Waits and Queues and You
Abstract:
SessionID: 33101
Enterprise Data Mining with SQL Server 2008 R2
Event Date: 13-08-2011 - Session time: 00:00:00 - Track: BI3
Speaker: Mark Tabladilo
Title: Enterprise Data Mining with SQL Server 2008 R2
Abstract:
Starting with SQL Server Management Studio (SSMS), the demo includes the interfaces important for professional development, including Business Intelligence Development Studio (BIDS), highlighting Integration Services, and PowerShell. The interactive demos are based on Microsoft's Contoso Retail sample data. Finally we will evaluate where Microsoft data mining can help you in a practical business environment, which may include Oracle and SAS.
SessionID: 33102
Social Marketing 2011 for Microsoft Professionals
Event Date: 13-08-2011 - Session time: 00:00:00 - Track: Misc2
Speaker: Mark Tabladilo
Title: Social Marketing 2011 for Microsoft Professionals
Abstract:
Developing a social media platform is a challenge for high-end professionals and consultants. The presenter has successfully leveraged web media to establish a blog (http://marktab.net), cofound an online journal (http://solidq.com/sqj), become a paid video presenter, secured a spot at Microsoft TechEd 2011, and earned credit toward his first Microsoft MVP. This presentation introduces the basic elements for 2011 of a successful web strategy, starting with discovering your own best personal focus given current market needs. The presenter includes experiences with website development, WordPress blog hosting, leveraging social media services (including Twitter, Linked in, YouTube and Facebook), and working with Microsoft.
SessionID: 34179
An Overview of PowerPivot in SharePoint
Event Date: 13-08-2011 - Session time: 00:00:00 - Track: Dev2
Speaker: William E Pearson III
Title: An Overview of PowerPivot in SharePoint
Abstract:
Gain exposure to the Server side of PowerPivot with Microsoft BI Architect and SQL Server MVP Bill Pearson. The targeted audience of this session includes professionals who will be planning, deploying and maintaining the server side of PowerPivot. Among other BI architects and developers, this overview will be of particular interest to SharePoint Admins who are new to capabilities for sharing and managing PowerPivot applications created with PowerPivot for Excel.
SessionID: 34182
Beyond Plateaux: Optimize SSAS with Best Practices
Event Date: 13-08-2011 - Session time: 00:00:00 - Track: BI3
Speaker: William E Pearson III
Title: Beyond Plateaux: Optimize SSAS with Best Practices
Abstract:
SessionID: 34550
For Love or Money, Your IT Career
Event Date: 13-08-2011 - Session time: 00:00:00 - Track: Misc2
Speaker: Alex Funkhouser
Title: For Love or Money, Your IT Career
Abstract:
• Contracting at the cutting edge of technology is exciting and produces great rates. But what happens when the contract ends and the mortgage payments must continue?
• Maintaining a steady job with a direct deposit salary is comforting. But do you ever feel technologically “stuck” at your job when so many other I.T. professionals are learning and using the latest, most marketable technologies?
In this seminar session, you will learn multiple I.T. career strategies for maximizing both the Love and the Money of your multidimensional I.T. career.