Nr: 70
SQLSaturday #70 - Columbia 2011
SessionID: 28378
PowerShell for Data Professionals
Event Date: 19-03-2011 - Session time: 00:00:00 - Track: DB Admin 1
Speaker: Aaron Nelson
Title: PowerShell for Data Professionals
Abstract:
SessionID: 28554
Configuring and Troubleshooting Tempdb
Event Date: 19-03-2011 - Session time: 00:00:00 - Track: DB Admin 3
Speaker: Andrew Kelly
Title: Configuring and Troubleshooting Tempdb
Abstract:
SessionID: 28575
A Best Practice Approach to SQL Server CLR
Event Date: 19-03-2011 - Session time: 00:00:00 - Track: DB Development
Speaker: Alex Tocitu
Title: A Best Practice Approach to SQL Server CLR
Abstract:
This talk will go over some of the best practices of software engineering as they apply to
SQL Server CLR projects. We will also show how to build a small library of utilities,
stored procedures, functions, etc., that should help you remove some of SQL Server built-in
functional barriers.
SessionID: 28689
“I See a Control Flow Tab. Now What?”
Event Date: 19-03-2011 - Session time: 00:00:00 - Track: BI 1
Speaker: Andy Leonard
Title: “I See a Control Flow Tab. Now What?”
Abstract:
This highly-interactive, demo-intense presentation is for beginners and developers just getting started with SSIS. Attend and learn how to build SSIS packages from the ground up.
SessionID: 28690
Designing an SSIS Framework
Event Date: 19-03-2011 - Session time: 00:00:00 - Track: BI 3
Speaker: Andy Leonard
Title: Designing an SSIS Framework
Abstract:
SessionID: 28880
All about Indexes
Event Date: 19-03-2011 - Session time: 00:00:00 - Track: DB Admin 3
Speaker: Ashton Hobbs
Title: All about Indexes
Abstract:
This session will cover everything a good SQL Developer needs to know about indexing. Will cover how to identify when needed indexes are missing, how to find bad indexes and remove them, understanding exactly what data is stored within indexes and much more. Understand why having indexes can be both bad and good by understanding your own data and how it is structured and accessed. Will cover various design patterns, SQL Server DMVs, as well as real world examples of good and bad indexes.
SessionID: 28886
T-SQL Awesomeness – 3 Ways to Write Cool SQL
Event Date: 19-03-2011 - Session time: 00:00:00 - Track: DB Development
Speaker: Audrey Hammonds
Title: T-SQL Awesomeness – 3 Ways to Write Cool SQL
Abstract:
• Recursive Common Table Expressions (CTE)
• EXCEPT and INTERSECT
• CROSS APPLY and OUTER APPLY
We will look at data models and scenarios you might encounter that lend themselves to these techniques, see old-school ways to solve T-SQL challenges, and then compare them to newer, leaner ways to get the same result set. Impress your friends and confound your frenemies with your mad T-SQL skills.
SessionID: 28887
Down With Ugly Data - Relational Modeling Basics
Event Date: 19-03-2011 - Session time: 00:00:00 - Track: Professional Dev
Speaker: Audrey Hammonds
Title: Down With Ugly Data - Relational Modeling Basics
Abstract:
Ugly data is the scourge of developers and DBA’s alike. Do your part to rid the world of ugly data models! Beautiful data starts with a beautiful design. In this session we’ll begin with requirements and end with a physical model, discussing how to make sure that your database design equals data integrity, scalability, and good looks.
Topics include:
--Requirements Analysis
--Conceptual Modeling
--Logical Physical Modeling
--Best Practices
SessionID: 28942
Event Date: 19-03-2011 - Session time: 00:00:00 - Track: DB Admin 1
Speaker: Allen White
Abstract:
SessionID: 28944
Automate Policy-Based Management using PowerShell
Event Date: 19-03-2011 - Session time: 00:00:00 - Track: DB Admin 1
Speaker: Allen White
Title: Automate Policy-Based Management using PowerShell
Abstract:
SessionID: 28991
PowerPivot, Idea to Solution in 60 Minutes
Event Date: 19-03-2011 - Session time: 00:00:00 - Track: BI 3
Speaker: Barry Ralston
Title: PowerPivot, Idea to Solution in 60 Minutes
Abstract:
SessionID: 29254
Introduction to Microsoft StreamInsight
Event Date: 19-03-2011 - Session time: 00:00:00 - Track: DB Development
Speaker: Brett Tomson
Title: Introduction to Microsoft StreamInsight
Abstract:
SessionID: 29281
Reporting Services Deep Dive
Event Date: 19-03-2011 - Session time: 00:00:00 - Track: BI 1
Speaker: Brian McDonald
Title: Reporting Services Deep Dive
Abstract:
SQL Server Reporting Services is a fundamental part of Microsoft’s Business Intelligence suite of products which as its name suggests provides a centralized robust reporting solution for organizations. Using a familiar development environment we can create static and interactive reports that can be delivered to consumers in a variety of ways. In this deep dive session, I will cover topics like: - What is reporting services and what can it be used for? - New Features included in 2008 R2 - Architectural Overview - Demonstrations to cover the entire process of developing, deploying and rendering reports using the built in Report Manager and URL Access.
** This session is SQL Saturday favorite and is always packed full. Don't miss it **
SessionID: 29359
Up and Running with SSIS in 5,4,3,2, (Datachix)1 !
Event Date: 19-03-2011 - Session time: 00:00:00 - Track: BI 1
Speaker: Julie Smith
Title: Up and Running with SSIS in 5,4,3,2, (Datachix)1 !
Abstract:
This presentation is for absolute beginners to Integration Services, giving the bare essentials to start working in this environment with confidence. We’ll cover basic architecture, basic development, and basic administration in one hour! List of scary acronyms and terms on the list for “demystification”: SSIS, BIDS, ETL, Configurations, Package Deployment, Package Execution, SQL Server Agent.
SessionID: 29510
Event Date: 19-03-2011 - Session time: 00:00:00 - Track: DB Admin 2
Speaker: Chris Skorlinski
Abstract:
SessionID: 29569
Powerful BI in SharePoint 2010
Event Date: 19-03-2011 - Session time: 00:00:00 - Track: BI 3
Speaker: Cory Loriot
Title: Powerful BI in SharePoint 2010
Abstract:
SessionID: 29636
Database Mirroring in the Real World
Event Date: 19-03-2011 - Session time: 00:00:00 - Track: DB Admin 3
Speaker: Craig Purnell
Title: Database Mirroring in the Real World
Abstract:
A review of Database Mirroring in the context of operations at Baker Hostetler, where mirroring has been a cornerstone high availability tool for over 5 years. A high level look at the key modes of mirroring; specific analysis of setup and configuration problems; various real time monitoring techniques of the mirrored databases; pros and cons of WAN hardware acceleration devices to improve performance; using mirroring to perform a rolling upgrades or to move large databases to a different location.
SessionID: 29721
Making sense of SQL Server availability options
Event Date: 19-03-2011 - Session time: 00:00:00 - Track: DB Admin 3
Speaker: David Bermingham
Title: Making sense of SQL Server availability options
Abstract:
With more mission critical databases being deployed in VMs, availability options for SQL Server have grown immensely. Clustering, vMotion, Live Migration, HA, FT, database mirroring and more. Who is responsible to ensure your database is available 24 x 7? Is it the DBA? Is it the server team? Maybe it is the virtualization team? Maybe it is a joint decision among all of those teams. Regardless of who is ultimately responsible, this session will give you a great understanding of the options available and what they do and do not protect against to ensure the availability of your database.
SessionID: 30027
To click or to type, that is the question
Event Date: 19-03-2011 - Session time: 00:00:00 - Track: Professional Dev
Speaker: David Taylor
Title: To click or to type, that is the question
Abstract:
When adminstering SQL Server, in SSMS are you a clicker or a typer? This session explores the use of the GUI vs. using scripting in SSMS to get day to day tasks accomplished, with a bent toward scripting for increased accuracy, control and speed. Tasks are illustrated through the use of the Day-to-Day section of Brad McGeehee's Sure DBA Checklist at http://www.bradmcgehee.com , Used with Permission and Great Thanks.
SessionID: 30039
Windows PowerShell Best Practices for DBA's
Event Date: 19-03-2011 - Session time: 00:00:00 - Track: DB Admin 1
Speaker: Ed Wilson
Title: Windows PowerShell Best Practices for DBA's
Abstract:
Learn Windows PowerShell best practices as they apply to each stage of the script development lifecycle. See the differences between working interactively from the Windows PowerShell prompt, writing an inline script, adding basic function, advanced functions and finally the implementation of Windows PowerShell Modules. What is a local best practice for Windows PowerShell development is not the same as a global best practice, and this talk covers those differences
SessionID: 30239
Bad SQL
Event Date: 19-03-2011 - Session time: 00:00:00 - Track: DB Admin 2
Speaker: Geoff Hiten
Title: Bad SQL
Abstract:
How do you tell good code from bad? Bad SQL code makes the system work harder for the same results. Bad SQL does not scale well with larger data sizes, nor does it scale with increased server activity. Extreme Bad SQL can bring a server to a grinding halt. This presentation shows you how and why certain commonly used SQL constructions are Bad SQL. Bad SQL is not very useful by itself so each example includes its Good SQL counterpart.
SessionID: 30240
Fast Track Data Warehouse
Event Date: 19-03-2011 - Session time: 00:00:00 - Track: DB Admin 1
Speaker: Geoff Hiten
Title: Fast Track Data Warehouse
Abstract:
Fast Track Data Warehouse is a single-server BI Repository based on the Microsoft SQL Server Parallel Data Warehouse research and technology, but in single-server sizes. The presentation discusses methods, reference configurations, and best practices maximize your hardware investment for moderately sized (4-48 TB) Data Warehouses.
SessionID: 30553
DAX Formulas: Evaluation Context
Event Date: 19-03-2011 - Session time: 00:00:00 - Track: BI 2
Speaker: Javier Guillen
Title: DAX Formulas: Evaluation Context
Abstract:
Data Analysis Expressions (DAX) is an expression language used to develop calculations based on PowerPivot data. A lot of its capabilities are very intuitive to Excel power users as it emulates current functionality but over a much larger set of data. However, Its real power emerges with the ability to create aggregations that are evaluated at different contexts on the data stored in-memory. This session will explore DAX formula context, which is of great benefit when developing business calculations like ratios or weighted averages. A brief comparison with MDX will be established in order to contrast the process followed by each language when establishing the context of a calculation.
SessionID: 30789
Introducing Microsoft's EDIM Products
Event Date: 19-03-2011 - Session time: 00:00:00 - Track: BI 3
Speaker: Jessica Moss
Title: Introducing Microsoft's EDIM Products
Abstract:
Starting in the SQL Server Denali release, data takes on a new life in the business intelligence world. Often forgotten, data management needs to be an integral part of your reporting systems. Learn how Microsoft has made your life easier by incorporating external parameters, environments, and groupings into Integration Services. They have also included impact analysis and data lineage, which can be tied to tables and SSIS packages. Two additional newcomer products, data quality services and master data services, complete the quartet. This session will use the first Community Technical Preview of SQL Server Denali to describe and demonstrate the enhancements to the four products that make up EDIM.
SessionID: 30790
Adding SSRS Report Bells and Whistles
Event Date: 19-03-2011 - Session time: 00:00:00 - Track: BI 2
Speaker: Jessica Moss
Title: Adding SSRS Report Bells and Whistles
Abstract:
Producing a good looking report will wow your business users even if your data isn't all that impressive. If you've ever had trouble finding the best way to display that data or how to show trends appropriately, this is the session for you. We will review grouping logic, graphs, gauges, and more in Reporting Services 2008 R2. With the knowledge in this session, you won't ever need to show a plain, boring report again!
SessionID: 30829
Recipe for a happy DBA
Event Date: 19-03-2011 - Session time: 00:00:00 - Track: Professional Dev
Speaker: Jason Hall
Title: Recipe for a happy DBA
Abstract:
In a world where separation of responsibilities becomes more and more important, the borders between DBAs and developers have grown wider than ever. For the developer seeking to employ the services of SQL Server, Interaction with one or more DBAs at certain stages of the development life cycle is nearly a given. This session discusses tips and techniques to follow that can ensure these interactions are civil, and maybe even pleasant. We will also briefly discuss features included in SQL Server 2008 R2 designed to help abstract DBA and developer division of responsibilities. This topic includes tips on TSQL scripting, deployment techniques, bad habits to avoid beginning execution plan analysis.
SessionID: 30962
Handling Advanced Data Warehouse Scenarios in SSIS
Event Date: 19-03-2011 - Session time: 00:00:00 - Track: BI 1
Speaker: John Welch
Title: Handling Advanced Data Warehouse Scenarios in SSIS
Abstract:
So you’ve used SSIS to populate a simple star schema data mart, and everybody’s happy. But now you have new requirements that require more advanced data warehouse approaches, like late arriving dimensions, bridge tables, parent child dimensions, and Type 3 or Type 6 slowly changing dimensions (SCD). How do you handle those in a scalable, efficient way in SSIS? This session will present some common patterns for handling these scenarios. You’ll learn when to use each advanced approach and the pros and cons associated with each pattern. You will learn how to implement these patterns in SSIS, and how to tune them for high performance.
SessionID: 30963
Do More (ETL) with Less (Effort) - Automating SSIS
Event Date: 19-03-2011 - Session time: 00:00:00 - Track: BI 2
Speaker: John Welch
Title: Do More (ETL) with Less (Effort) - Automating SSIS
Abstract:
SessionID: 31039
SQL University: Class is in Session!
Event Date: 19-03-2011 - Session time: 00:00:00 - Track: Professional Dev
Speaker: Jorge Segarra
Title: SQL University: Class is in Session!
Abstract:
This session is aimed at those who are looking to come fresh into the wonderful world of SQL Server administration. Based off my blog project of the same name, SQL University is aimed at teaching students SQL Server from the ground up. In this session we'll cover some of the essential basics in terminology, tools and general tasks needed to get started in administration. So sharpen your pencils and enroll in SQLU today!
SessionID: 31331
Deploying Visual Studio 2010 Database Projects
Event Date: 19-03-2011 - Session time: 00:00:00 - Track: DB Admin 2
Speaker: Kevin Goode
Title: Deploying Visual Studio 2010 Database Projects
Abstract:
SessionID: 31699
Report Calcs - SSRS Source Query vs. Expressions
Event Date: 19-03-2011 - Session time: 00:00:00 - Track: BI 2
Speaker: Melissa Coates
Title: Report Calcs - SSRS Source Query vs. Expressions
Abstract:
As a report developer, you want to ensure your reports are structured for accuracy, performance, maintenance, and reusability. One of your many decisions includes where to perform report-specific calculations when the source is a SQL Server relational database.
In this session we will compare and contrast a sampling of functions available in T-SQL and SSRS, with an emphasis on handling aggregation, ranking, dates, and strings. A "cheat sheet" will be available online for future reference.
Session Goal: Identify common situations when performing calculations within SSRS is preferred, versus when the T-SQL source query may be more appropriate.
SessionID: 32090
SQL Developer's Intro to SSAS
Event Date: 19-03-2011 - Session time: 00:00:00 - Track: BI 2
Speaker: Nathan Mourfield
Title: SQL Developer's Intro to SSAS
Abstract:
This session is geared around introducing the SQL Dev or Data Analyst to SQL Server Analytical Services. Topics covered:
Intro to SSAS
Welcome to the Cube
Beginning Cube Ninjary
Data Mining Kung Fu
SessionID: 32242
Zen and the Art of Writing SQL Query
Event Date: 19-03-2011 - Session time: 00:00:00 - Track: DB Development
Speaker: Plamen Ratchev
Title: Zen and the Art of Writing SQL Query
Abstract:
Writing a query is an art! Simplicity, focus, and practice is all it takes. Understand the logical processing of a query and discover the art of writing simple and efficient queries. It is a journey that starts with FROM and ends with ORDER BY!
SessionID: 32243
Common SQL Programming Mistakes
Event Date: 19-03-2011 - Session time: 00:00:00 - Track: DB Development
Speaker: Plamen Ratchev
Title: Common SQL Programming Mistakes
Abstract:
Become a better SQL developer by learning the most common pitfalls in the SQL language. Both inexperienced and experienced SQL developers and DBAs can get caught by many of these. Practical examples and internal logical processing explanation will help you understand why mistakes happen and how to develop good SQL coding practices to avoid them.
SessionID: 32450
Service Broker...What's That How Do I Use It?
Event Date: 19-03-2011 - Session time: 00:00:00 - Track: DB Admin 1
Speaker: Brian Davis
Title: Service Broker...What's That How Do I Use It?
Abstract:
Have you heard of Service Broker? Do you know what it is? How about how to use it? This session will answer these questions and more. Service Broker is arguably one of the least known and used features of SQL Server. We'll explore Service Broker and learn what it is and how it works. We'll walk through the setup and configuration along with demonstrating its use. You'll leave this session with a better understanding of Service Broker, its use and implementation, along with ideas of how you can implement it in your own environments.
SessionID: 32497
DW-ETL: 10 Mistakes to Avoid
Event Date: 19-03-2011 - Session time: 00:00:00 - Track: BI 1
Speaker: Rafael Salas
Title: DW-ETL: 10 Mistakes to Avoid
Abstract:
With data being the focal point of a data warehouse, its data integration component becomes a critical point of failure of the whole system, and to make matters worse, we, as developers, face increasingly complex scenarios and requirements such as larger number of systems and volumes of data, data quality problems and complex business logic.
In this session Rafael will share a compilation of pitfalls and mistakes he has seen –and made!– across many implementations, and offers recommendations to avoid them. We will look at problems related to metadata, data quality, monitoring, system reliability and some SSIS specific issues among other common problems.
SessionID: 32772
SSRS Administration - Enter a BIDS Free Zone
Event Date: 19-03-2011 - Session time: 00:00:00 - Track: DB Admin 3
Speaker: Sandra Mueller
Title: SSRS Administration - Enter a BIDS Free Zone
Abstract:
You are about to enter the BIDS Free Zone. Beware! This session is NOT about report design, spatial data, R2 new features or .NET extensions. We will explore what the ReportServer and ReportServerTempDB databases contain. By understanding their purpose we can discuss, for your company, what recovery mode each should be in and select backup strategies. Furthermore, we will talk about two other resources to backup: the ever critical encryption key and XML configuration files. Next, we'll cover the three scalability options: caching, snapshots and scaling out. There are numerous server configurations that are familiar to administrators just hard to find. Some are so hidden you might not know they exist!
SessionID: 32899
SQL Server Internals - how things work?
Event Date: 19-03-2011 - Session time: 00:00:00 - Track: DB Admin 3
Speaker: Sergey Pustovit
Title: SQL Server Internals - how things work?
Abstract:
In this session we will go over areas of SQL Server functionality that always raise questions.
What is SQLOS, scheduler, worker? How does internal scheduling work? How does Resource Governor work?
How does CPU affinity work in SQL Server? What are the preemptive and non-preemptive waits?
Should we be afraid of SOS_SCHEDULER_YEILD and CXPACKET waits?
SessionID: 32900
New features in SQL Server Denali
Event Date: 19-03-2011 - Session time: 00:00:00 - Track: DB Admin 2
Speaker: Sergey Pustovit
Title: New features in SQL Server Denali
Abstract:
In this session we will go over the new features in upcoming SQL Server release with current code name - Denali
SessionID: 33100
Enterprise Data Mining for SQL Servr Professionals
Event Date: 19-03-2011 - Session time: 00:00:00 - Track: BI 1
Speaker: Mark Tabladillo
Title: Enterprise Data Mining for SQL Servr Professionals
Abstract:
This presentation presents SQL Server Data Mining (SSDM) for SQL Server Professionals based on the speaker's past presentations for SQL Saturday. 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: 33252
From DBA to Data Architect: Changing Your Game
Event Date: 19-03-2011 - Session time: 00:00:00 - Track: Professional Dev
Speaker: Stuart Ainsworth
Title: From DBA to Data Architect: Changing Your Game
Abstract:
SessionID: 33253
Dirt, Spit, and Happy FLWOR: Hands on with XQuery.
Event Date: 19-03-2011 - Session time: 00:00:00 - Track: DB Development
Speaker: Stuart Ainsworth
Title: Dirt, Spit, and Happy FLWOR: Hands on with XQuery.
Abstract:
Relational databases have become storage engines for more than just the traditional datatypes; the inclusion of XML in SQL Server 2005 and SQL Server 2008 opens up a host of new avenues for application development. XQuery is a powerful language for querying XML fragments in conjunction with the relational engine; this session is designed to cover the basic FLWOR syntax of XQuery in an interactive fashion. Participants are encouraged to discuss their own challenges with XML as well as seek out solutions from each other.
SessionID: 33303
Shade Tree Mechanic's Guide to SSAS
Event Date: 19-03-2011 - Session time: 00:00:00 - Track: DB Admin 2
Speaker: Steven Wright
Title: Shade Tree Mechanic's Guide to SSAS
Abstract:
SessionID: 33354
Role of Microsoft Solver Foundation In BI
Event Date: 19-03-2011 - Session time: 00:00:00 - Track: BI 3
Speaker: Tejas Patel
Title: Role of Microsoft Solver Foundation In BI
Abstract:
SessionID: 33611
You inherited a database, now what?
Event Date: 19-03-2011 - Session time: 00:00:00 - Track: DB Admin 2
Speaker: Tim Radney
Title: You inherited a database, now what?
Abstract:
SessionID: 33861
Event Date: 19-03-2011 - Session time: 00:00:00 - Track: BI 3
Speaker: Wayne Snyder
Abstract:
SessionID: 34229
Design and Implement BI Like Edison!
Event Date: 19-03-2011 - Session time: 00:00:00 - Track: BI 2
Speaker: William E Pearson III
Title: Design and Implement BI Like Edison!
Abstract:
As the most prolific inventor in American history, Thomas Edison was a master of “Best Practices!” Edison’s creations were not just novel and commercially successful, but many launched entire new industries including electric light and power, sound recording, motion pictures and industrial cement and concrete manufacture. At the heart of Edison’s remarkable record of innovation was his categorization of the innovation process into “competencies,” or bundles of skills supporting the achievement of success in a particular area of endeavor. In this session, we will look at ways that we can use many of these broad success secrets to bring powerful tools and strategies to the recurring implementation of business intelligence.
SessionID: 34235
Entity Strategies: Structuring Your Consultancy
Event Date: 19-03-2011 - Session time: 00:00:00 - Track: Professional Dev
Speaker: William E Pearson III
Title: Entity Strategies: Structuring Your Consultancy
Abstract: