|
STOP! Consolidate and Listen!
Jorge Segarra
In today's economic times, we are being asked to do more with less-less budget, less hardware-and yet our data needs keep growing! How do we keep our database infrastructure humming along given these restrictions? In this session, we talk about different options of consolidation, including database-level consolidation, instance-level consolidation, and virtualization. We also discuss some of the tools and methods you can use today to help consolidate your SQL Server environment and do more with less.
|
5/15/2012 11:00 AM
|
View
|
|
SQL Server 2012 AlwaysOn for High Availability and Disaster Recovery
Chad Churchwell
This webinar will explore the new AlwaysOn features of SQL Server 2012 and how this can be used to set up a DR/HA plan. We will discuss the current limitations of database mirroring and clustering as well as cover how these limitations have been accounted for in SQL Server 2012. Topics will be availability groups and failover cluster instances as well as a demo of these features.
|
5/10/2012 11:00 AM
|
View
|
|
BI xPress Launch Party - May 2012
Jeremiah Nazaruk
Join our BI xPress Developer as he walks you through the new features included in the launch of BI xPress v.3.5! Features include SQL Server Integration Services 2012 support and new SQL Server Reporting Services 2012 dashboard and Report Deployment tools!
|
5/10/2012 11:00 AM
|
View
|
|
Technical Track: Multi-Tenancy vs Shared Services in SharePoint 2010
Alistair Pugin
Many organizations start out by deploying SharePoint using a “Shared Services” model but realise that various divisions, companies and or business units want a more individualized control over their platform; enter the Multi-Tenant. In this session we will cover: - The differences between Shared and Tenanted Architecture
- The pitfalls of both platforms
- How to effectively deploy multi-tenancy
- What administrative components are required for either deployment By identifying the capabilities of SharePoint 2010’s tenanted infrastructure upfront, SharePoint Architects will be better equipped to make the correct decisions as to:
- What platform to use
- What features to use within each platform
- Ultimately how to manage SharePoint more efficiently
|
5/3/2012 11:00 AM
|
View
|
|
SQL Server 2012 DMV's & Extended Events: Lightning sand, Flame spurts, & R.O.U.S.'s
Gareth Swanepoel
As a lone DBA in the scary world of the SQL Server 2012 Fire Swamp, you may be wary of the multiple threats of Lightning sand, Flame spurts & Rodents of Unusual Size. In this session, come and learn how to map your way through these threats using the new and improved DMV's and Extended Events that are found in SQL Server 2012.
In this session, you will learn about the new DMV's available in SQL 2012. You will also learn about the improved XEvents interfaces and how to use XEvents to monitor your server and track issues.
|
5/1/2012 11:00 AM
|
View
|
|
CAT Tales on Large BI Installs
Thomas Kejser
Since the great crash in 2008, banks have been busy building risk analytics systems. Several of these are run on SQL Server Analysis Services. In this session, I will present design patterns for large scale, near real time cube. You will learn how to load at millions of rows every second and how to handle hundreds of concurrently executing queries. I will also give you a preview of the cool SQL 2012 features that further improve the scale of Analysis Services cubes.
|
4/26/2012 11:00 AM
|
View
|
|
Upgrading DTS Packages to SSIS
Brian Knight
The Microsoft “End of Life” policy for SQL 2000 has encouraged many organizations to seriously look at migrating their SQL2000 servers to SQL2005 or 2008. One of the biggest obstacles to a rapid migration is the DTS package issue. To gain the performance benefits and a supported path forward for the functionality in DTS, these packages should be converted into native SSIS. As we all know, the conversion is NOT straightforward. SSIS is more powerful and significantly different from DTS. Join Brian as he takes you through the transition!
|
4/24/2012 11:00 AM
|
View
|
|
|
How to manage Big Data, Tips and Tricks
Jorge Segarra
In this session join Jorge Segarra as he dives into Big Data: What it means, if you’ve got it and how to handle it. Jorge will Explore how data is growing in the enterprise, review challenges and current best practices for handling large data volumes in BI, look at industry solutions that help enable massively parallel processing, and help you understand how to take your organization’s data to the next level.
|
4/19/2012 11:00 AM
|
View
|
|
Basic Intro to PowerShell for the DBA
Max Trinidad
This is an Intro level for the SQL DBA wanting to start and learn how to use PowerShell in their environment. It will be divided in two half hour part be covering PowerShell setup essentials, and using the SQLPS module to build SQL PowerShell scripts.
|
4/17/2012 11:00 AM
|
View
|
|
Intro to IRS and SSRS
Mike Davis
Agreed the IRS needs no introduction. This webinar looks at using Reporting Services to create W2's. It is a "fun" way to "celebrate" tax season. The second part of this webinar will show you how to lower your tax bill, get audited, and possibly be arrested. Why get a CPA? No IRS agents allowed. If management is reading this, it was not my idea.
|
4/12/2012 11:00 AM
|
View
|
|
SQL Server PowerShell Extensions
Aaron Nelson
Windows PowerShell is an easy way to automate tasks, gather info, and deploy objects to your SQL Servers but how do you get started? Microsoft MVP Aaron Nelson will discuss easy shortcuts the SQLPSX Module provides for managing multiple SQL Servers. Aaron will also walk you through the hierarchy of some of the core functions and provide you with a sequence that enables you reuse your scripts.
|
4/10/2012 11:00 AM
|
View
|
|
SQL for SharePoint 2010 Farms
Andrew Thornton-Smith
In this session, we will cover the need to know for SQL administrators who are now responsible for SharePoint's DBs. In our journey, topics we will cover will be, Farm sizing's & architecture to considerations for Enterprise Search and considerations for crawling the dreaded G:\, H:\ Z:\ drives, To the myriad of SharePoint Databases and which to watch out for. And finally what tasks in SharePoint are the heavy weights in terms of IOPS, CPU & RAM.
|
4/5/2012 11:00 AM
|
View
|
|
Data Quality Services 2012
Chris Price
We will explore data quality issues that face today’s business and how Data Quality Services 2012 can help IT Pros and Data Stewards meet those challenges. We will start from zero, build a knowledge base, profile data to train our knowledge base and then use that knowledge to highlight both the cleansing and matching capabilities of DQS. This session will also cover the DQS SSIS component that’s available in SQL Server 2012.
|
4/3/2012 11:00 AM
|
View
|
|
Test Driven Development (TDD) in C# using NUnit
Mark Brown
We will provide an introduction to the practice of test driven development, how it compares to unit testing, and what it does not cover. We will build an example using test driven development to illustrate its use. We will identify other types of testing and the tools used for them.
|
3/29/2012 11:00 AM
|
View
|
|
Mastering Date-Time Based Analysis in DAX
Dan Clark
A large volume of analysis that a business typically performs on its data involves dates and/or times. For example, you may need to compare sales from one year to the next or aggregate transactions over time. DAX incorporates many built in time intelligence functions to help make date-time based calculations easier. Although the time intelligence functions are very beneficial, they can be misused and give erroneous results. To avoid this, it is imperative that you understand what functions to use and how to use them.
This webinar is designed to guide you through the various time intelligence functions available in DAX and provide practical examples of how to use them. We will also cover time intelligence best practices and how to avoid the many “gotchas” that can occur by misusing these functions.
|
3/27/2012 11:00 AM
|
View
|
|
Performance Tips and Tricks with SQL Server, real cases with developers
Nabeel Derhem
Application developers don't care much about how SQL Server executes their queries as long as they get what they want. This session introduces common real case scenarios where developers end up with troublesome queries and bad performance. Explanation is linked to a discussion of alternative effective ways to handle such scenarios.
|
3/22/2012 11:00 AM
|
View
|
|
|
Task Factory Launch 2012
Brian Knight
Task Factory is a collection of essential, high-performance components and tasks for SSIS that eliminate the need for programming. Using Task Factory can increase productivity and give you a much higher level of performance. Join Brian as he covers the new and improved features in the latest release of Task Factory.
|
3/21/2012 11:00 AM
|
View
|
|
Advanced SSAS
John Welch
Join John for a demo heavy session that will teach you how to build tier 1 Analysis Services solutions that will scale and explain all the internals to help you back up the best practices implemented in these demos.
|
3/20/2012 11:00 AM
|
View
|
|
|
The Fangorn Forest - ColumnStore Indexes
Gareth Swanepoel
In the fantasy world of Middle-earth, deep in the Fangorn forest live the Ents. The Ents are tall tree-people who help the Fellowship by parallelizing the fight against Saruman. Come and learn how the new SQL Server 2012 feature, ColumnStore Indexes, can parallelize your Data Warehouse aggregations in the same way. I will be doing a deep dive into the inner workings of ColumnStore indexes; how they work, key characteristics, dos and don'ts, restrictions, and more. If you are a production DBA who needs to find out more about some of the additional hot features that have been included with ColumnStore Indexes, like batch mode processing and data segments, then this session is for you. If you are a business intelligence DBA or developer who needs to find out how ColumnStore Indexes can increase the performance of your aggregations and star-joins by up to 40 times, then this session is also for you.
|
3/15/2012 11:00 AM
|
View
|
|
SSIS Log Providers Demystified
Shawn Harrision
Any SSIS developer that wants to save themselves many headaches should be using logging in their SSIS packages. In this session Shawn will explain all the log providers and the pros and cons of each. So, if you aren’t using logging in your packages, and you hate looking at agent job history, then make sure you attend this webinar. Your DBA’s might stop hating you!
|
3/13/2012 11:00 AM
|
View
|
|
|
Create a Virtual Online Learning Environment for Your Organization (and not get FIRED!)
Jorge Segarra
Create and setup a segregated computer lab for your organization in a DMZ (a sexy computer lab). Use virtualization technology to create quick turnover after class completion and maximize uptime (so there is more time for naps in the lab). Create .vhd files to load onto PC’s. Allow employees to utilize online training on campus without compromising security and violating security laws (you get to keep your job). Optimize for Go To Meeting and expand conferencing capabilities. Put the WOW in employee development and online learning.
|
3/8/2012 11:00 AM
|
View
|
|
Introduction to SharePoint BI
Brad Schacht
In this session Brad will provide you an overview of SharePoint 2010 and how it can be integrated with your current or new Business Intelligence infrastructure. He will discuss the general use of SharePoint for BI, basic setup and installation of the farm, as well as an overview of a completed SharePoint site. Brad will take you on a tour of SharePoint Central Administration including how to allow your site to be able to take advantage of many of the BI features such as PowerPivot, Excel Services and Reporting Services. With SQL Server 2012 right around the corner Brad will give you a sneak peak at of some of the improvements that are coming to SharePoint for those of you who want to be on the cutting edge of this growing technology. Slides don't teach anything, this tour will be all demo!
|
3/6/2012 11:00 AM
|
View
|
|
|
Performance Tuning SSIS
Shawn Harrison
SSIS is a powerful ETL tool, but by nature ETL developers are always looking for better performance. In this hour long presentation Shawn will cover many basic options and features that you can use to performance tune any SSIS package. Who wouldn’t want better package performance?
|
3/1/2012 11:00 AM
|
View
|
|
Managing SSIS in Denali
Brian Knight
In this session, you’ll learn how to manage SSIS in SQL Server Denali. You’ll first see how the logging and auditing of your SSIS packages has changed in Denali. Then, you’ll learn how parameterization of packages has been overhauled in Denali to make a zero-touch deployment of your packages. In this demo-packed session, you’ll walk through the entire lifecycle of a package from deployment to longer-term management of the package.
|
2/28/2012 11:00 AM
|
View
|
|
Microsoft Big Data and Apache Hadoop
Lara Rubbelke
Learn how to unlock the value of data stored in Hadoop using Microsoft’s Big Data solutions. Discussion will include Apache Hadoop on Azure, leveraging Sqoop connectors, and building Microsoft’s Business Intelligence solutions with data stored in Apache Hadoop.
|
2/23/2012 11:00 AM
|
View
|
|
|
Beginning Development for Business – Part 4: Running in the Halls
Mark Brown
In this session we look closer at what a databases are and what roles they play in business. We will talk about database design and how it can differ depending on its primary use. We will look at how to create a database by creating the database for our application. We will look at the tools used to create and manage databases. We will go over multiple methods of using the database from within an application.
|
2/21/2012 11:00 AM
|
View
|
|
|
Building Your First Tabular Model
Dan Clark
With the release of SSAS 2012 Microsoft has introduced a new BI storage engine. In addition to the traditional OLAP engine you now have the option to build your BI models on top of the new Vertipaq engine (This is the same engine used by PowerPivot.) To use the new Vertipaq engine you build a Tabular data model. A new query language DAX (Data Analysis Expressions) is used to query the data, create calculations, measures, and KPI’s. DAX is similar to the expression language used in excel and it should be easier to use than MDX and appeal to a broader audience.
This webinar is designed to introduce you to the process of building a tabular model in SQL Server Data Tools (BIDS rebranded). We will import data from a SQL Server relational database into a tabular model project and create relationships between the tables. We will use DAX to create and manage calculations, measures, and Key Performance Indicators. We will then test and explore the model using the Analyze in Excel feature in SQL Server Data Tools.
|
2/16/2012 11:00 AM
|
View
|
|
Chart Anatomy 101
Angel Abundez
SSRS Charts are the next common report item you will use in designing business reports after the Tablix. In this session, we'll deep dive together into the anatomy of a chart: their properties, the different areas of a chart, and how to augment them with titles and custom positioning. We'll cover the most common charts, what data you need to prepare, and which charts you should try to avoid. Based on visualization fundamentals by renowned data viz expert Stephen Few, I will share with you some of his ground rules and how to apply them when designing reports in SSRS 2008 R2.
|
2/14/2012 11:00 AM
|
View
|
|
Moving On Up: Positioning Your Resume Above Your Competition
Cathy Eng
Resumes have evolved a lot since the recession began and the rules have changed. With fierce competition for every job your resume only has about 20 seconds to make an impression or it goes into the trash. Cathy Eng, CARW and owner of Resume Rocketeer, Inc., will provide detailed strategies to help you get noticed, get interviews and move up to the next level. You will learn essentials to an effective resume, techniques to focus it to the job you want, and resume killers that you should never use!
|
2/9/2012 11:00 AM
|
View
|
|
SQL Azure and SqlBulkCopy
Herve Roggero
Are you interested in figuring out what is the fastest way to insert records in SQL Azure and why? In this session I will explore various ways to import data in a SQL Azure database including INSERT commands, BULK operations, BCP and the SQLBulkCopy API. I will also discuss how certain tools work behind the scenes (such as SSIS) and which technique they use. Finally I will share performance metrics comparing the various techniques and explain how each technology works with SQL Azure.
|
2/7/2012 11:00 AM
|
View
|
|
SQL Server 2012 SSIS: New and Improved Features
Anish Sana
With SQL server 2012 release around the corner, there’s been a hype around the new features that comes with this awesome release. For this webinar we’ll be touching on some of the new features in SQL Server 2012 SSIS and how that will improve on development as well as look into the enhancements made to existing features from the previous versions.
|
2/2/2012 11:00 AM
|
View
|
|
Creating KPI's, Actions, and Calculations in SSAS Cubes
Mike Davis
Mike demonstrates different methods for KPI's, actions, and common calculations. After this session you will have a good understanding of how to build all of these functions in your SSAS Cube. Mike will show dynamic KPIs from a table, opening a URL with an Action, and some common MDX calculations.
|
1/31/2012 11:00 AM
|
View
|
|
Performance Tuning with Column Store Indexes
Eric Hanson
SQL Server columnstore indexes and the vector-based batch mode of query execution are new in the SQL Server 2012 release, and can speed up data warehouse queries by 100X or more. In their sweet spot, columnstores give jaw-dropping performance, but there are limitations in the initial release where performance may not improve as much as the technology allows, unless you tune your application. This talk presents how to work around the main limitations in the columnstore feature to get consistently great performance. We’ll address how to compensate for query performance limitations for outer joins and union operations, data type restrictions, and the fact that columnstore indexes make the data read-only (except for the ability to switch in partitions). We’ll also discuss how to capitalize on the new segment elimination feature that can skip million-row chunks of a table with a constant-time check.
|
1/26/2012 11:00 AM
|
View
|
|
Database Consolidation & Private Cloud Appliance – Available NOW!
Mark Mortimore
Advances in core infrastructure and application platform software and hardware technologies create tremendous opportunities to virtualize demanding workloads, including data based applications. Leveraging virtual and scalable infrastructure - 100s of servers can be efficiently, reliably, and manageably consolidated. This session will dive into the NEW DBC Appliance, leveraging virtualization and tuned and balanced infrastructure. We’ll go into detail regarding all phases of consolidation including how to assess environments using the MAP toolkit, how the appliance architecture enables high levels of performance, isolation. and resiliency, and into details around core operational capabilities such as P-to-V and self-service workflow-enabled provisioning of new fully configured servers. Also, we will cover advanced capabilities such as chargeback, sustained engineering (upgrades and patching), load balancing… If you have dozens to hundreds of servers and are interested to understand consolidation / private cloud options available today this is a session you’ll want to attend!
|
1/24/2012 11:00 AM
|
View
|
|
Extending Reporting Services with Custom Code
Devin Knight
The Reporting Services expression language can be a powerful tool for customizing report data and layout, but often times you will find it is lacking functionality that is easily available in .Net. While this session is not designed to teach you .Net it will show you some commonly used .Net functions for Reporting Services. We will also talk about the difference between custom code that is embedded in a report and external assemblies imported into Reporting Services.
|
1/19/2012 11:00 AM
|
View
|
|
Super-size Your SSIS Breakfast Sandwich: Performance Tuning 2012 SSIS Data Loads
Hope Foley
Importing data is as common to SQL Server as bacon is to a savory breakfast sandwich. As most of us love to eat those breakfast sandwiches, SQL Server Integration Services (SSIS) loves to eat data in an Import/Export kind of way. Although a green chain of boxes in SSIS can be the ruling “Happy Dance” of any DBA or SQL Developer, we must all still consider the performance of those tasks. In this session, we will go through performance tuning in SSIS 2012 after a successful SSIS package has been developed. When we are finished with this session, not only will you still have the mystic of green colors of successful execution of your SSIS import and export tasks, but the turbo boosters will be turned on as well.
|
1/17/2012 11:00 AM
|
View
|
|
|
Working SQL Authentication with PowerShell
Max Trinidad
See how can you use PowerShell to get login information and work work with SQL Authentication. See how to create a SQL Authenticated Drive, changing SQL Users passwords, use .NET autogenerated password class, and finally putting everything together create quick script solution to change Admin "SA" password on all SQL Servers.
|
1/12/2012 11:00 AM
|
View
|
|
Master Data Services in SQL Server 2012
Arie Jones
Most DBAs at one time or another have been taught the importance of master data management(MDM), which is comprised of a set of processes and tools in order to keep your non-transactional data in a consistent state. However, with today’s fast paced environment and tightening budgets most DBAs lack the resources to properly implement it. With the upcoming release of SQL Server 2012, Microsoft has taken their second swipe at providing a tool known as Master Data Services(MDS) to aid the DBA in this endeavor. In this session, you will learn the how Master Data Services is implemented in SQL Server 2012, setting up models, working through the Excel plug-in, and utilizing DQS and business rules to help with that dirty data. This session will definitely be an eye opener for some that were on the fence with the first release and those that are coming into the platform with a fresh set of eyes!
|
1/10/2012 11:00 AM
|
View
|
|
Analysis Services for the DBA
Mark Stacey
Many DBAs have heard the term Analysis Services, but don't really know what it's for or who would use it. In this session, Mark will explain the use cases for Analysis Services, illustrate how it improves performance for large data sets and eases report writing, and will go through a practical example of building a first Analysis Services solution, and managing Analysis Services in a production environment.
|
1/5/2012 11:00 AM
|
View
|
|
|
Introduction to PowerPivot
Brian Knight
In this session, you’ll learn how to use PowerPivot to create self-service analytics in your organization. You’ll see how Office 2010 and SQL Server 2008 R2 will help your users answer their own questions and bring together datasets that may be heterogeneous like a SQL Server table and data feed from a website. Then, you’ll see how to take that data and create a striking report for your end users and collaborate with the data in SharePoint.
|
1/3/2012 11:00 AM
|
View
|
|
|
Dynamically Configuring Packages
Brian Knight
In this session, you’ll learn how to control your SSIS packages
in a more powerful way by using expressions. The expression language
is a bit of an elusive language that can be used to make any component
in SSIS dynamic. Then, you’ll learn how to use configuration files to
externalize the configuration of your package and lastly how to pass
variables into a package.
|
12/22/2011 11:00 AM
|
View
|
|
|
Beginning Development for Business – Part 3: Playing in closets
Mark Brown
In the third session, we will finish looking at controlling application flow using standard techniques. We will look at the most commonly used data types in business software development and how to keep our data around after the program closes. We will look at what flat files are and ways to create them, XML files, and provide a brief look at what databases are and how they can be used to store data. Finally, we will talk about how these will tie into our evolving application we started designing in our last session.
|
12/20/2011 11:00 AM
|
View
|
|
Operational Best Practices in SSAS
Adam Jorgensen
Come learn from Adam as he explores all the best practices you should be taking in managing SSAS in your enterprise. Great for developers and administrators.
|
12/15/2011 11:00 AM
|
View
|
|
|
Building Tier 1 SSAS Solutions
Adam Jorgensen
Come listen to Adam as he shares his Tech-ed presentation with the masses. This is focused on building highly scalable cubes and driving ultimate performance in the process.
|
12/13/2011 11:00 AM
|
View
|
|
|
Monitoring SQL Server with SSIS
Mike Davis
So your boss just called and said his database has been getting slower for weeks. Wouldn’t it be nice to have a trend analysis of all of the DMO’s to help determine the issue? Well now you can, with SSIS you can monitor all of your servers and databases. Mike will give you a complete BI solution that you can immediately start using to pull in all of the DMO data to a data warehouse and a cube. You will be able to catch trends that indicate problems before the boss calls.
|
12/8/2011 11:00 AM
|
View
|
|
|
New SSIS Features in Denali
Mike Davis
The newest version of SQL Server is just around the corner. Come see all of the newest features and best practices in SSIS. Learn about the new SSIS parameters, and all of the great improvements that will make your life easier.
|
12/6/2011 11:00 AM
|
View
|
|
Performance Tuning SSAS
Adam Jorgensen
This session will teach you how to identify and resolve performance problems in your SSAS environment along with some internals as to how things work to improve performance.
|
12/1/2011 11:00 AM
|
View
|
|
Intro to SSRS Expressions
Chris Albrektson
In this session, join Chris as he will walk you through the basics of creating SSRS expressions. This will be an all demo session were we cover an array of examples in a short amount of time. This session is designed for someone who might need a crash course into the SSRS expression language or for anyone else that might need a refresher.
|
11/29/2011 11:00 AM
|
View
|
|
|
Beginning Development for Business – Part 2: Building the foundation
Mark Brown
In this second session of the series that focuses on teaching people how to become a software developer, concentrating on business driven software development, we continue to learn the fundamentals of programming and start moving beyond basic data types and move towards custom data types and how they are used. We take a look at basic file creation and loading techniques and how they can be used to do anything from data storage to file generation.
|
11/22/2011 11:00 AM
|
View
|
|
|
Introduction to Dimensional Modeling
Mike Davis
Do you have star schemas in your eyes? Come hang out with Mike Davis as he walks you through the best condensed introduction to dimensional modeling that will get you building a warehouse in an hour.
|
11/17/2011 11:00 AM
|
View
|
|
|
Upgrading DTS Packages to SSIS
Shawn Harrison
The Microsoft “End of Life” policy for SQL 2000 has encouraged many organizations to seriously look at migrating their SQL2000 servers to SQL2005 or 2008. One of the biggest obstacles to a rapid migration is the DTS package issue. To gain the performance benefits and a supported path forward for the functionality in DTS, these packages should be converted into native SSIS. As we all know, the conversion is NOT straightforward. SSIS is more powerful and significantly different from DTS. Join us as SQL Server and author, Shawn Harrison shares his knowledge about why you should upgrade from DTS to Integration Services and options for converting DTS packages to native SSIS.
|
11/15/2011 11:00 AM
|
View
|
|
Expert to Expert SSAS
Joe Salvatore
In this session, Joe will guide another SQL Pro through the construction of a SSAS solution. This demonstration is a great way to observe the power of SSAS, and to find solutions to some of the common stumbling blocks many of you might be facing.
|
11/10/2011 11:00 AM
|
View
|
|
Introduction to Master Data Services
Jose Chinchilla
In this session, Jose will do an overview of Master Data Services and how it can be leveraged with SSIS and SharePoint 2010 to accomplish a Master Data Management framework. Jose will cover concepts like models, entities, attributes and attribute collections, explicit and derived hierarchies, subscription views and business rules. Jose will also demo how to load an MDS entity with SSIS and how to kick start a workflow process in SharePoint 2010 when a business rule is not met.
|
11/8/2011 11:00 AM
|
View
|
|
|
MDX Common Solutions
Adam Jorgensen
Come ride along with Adam as he walks you through some common MDX solutions that you are going to use as you develop your Analysis Services solutions
|
11/3/2011 11:00 AM
|
View
|
|
SQL Internals , Recovery Models, and Backups! OH MY!
Bradley Ball
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!
|
11/1/2011 11:00 AM
|
View
|
|
Speedy SSIS
Craig Love
"¡Ándale! ¡Ándale! ¡Arriba! ¡Arriba! ¡Epa¡ ¡Epa! ¡Epa! Yeehaw!" Speedy Gonzales, 1936 In this one hour webinar Craig Love will share his best tips and tricks for making your ETL processes move really, really, fast! Not only will he get those packages running in parallel, he will explore the new balanced data distributor to prod those extra-large data sets into neatly streamed concurrent processes, adjust your packet and buffer sizes and prepare your ETL tasks for some jumbo frame action! Strap on your seatbelts, adjust your goggles, and put on your racing gloves as he shares his best advice for making SSIS scream!
|
10/27/2011 11:00 AM
|
View
|
|
Introduction to Design Patterns
Ben Evans
What is a design pattern? Why would I need it? Well in this session these topics will be covered as we explore a few of the common patterns and why you should know about them.
|
10/25/2011 11:00 AM
|
View
|
|
|
Beginning Development for Business – Part 1: Getting Your Feet Wet
Mark Brown
This is the first part of a new series that focuses on teaching people how to become a software developer, concentrating on business driven software development. This series will be geared toward the new developer or someone who knows how to program but wants to learn how to develop for a company. In this first part, we will begin by looking at what software development is and how developing software for a business is different than developing a product that any number of people will use inside and outside of a company. We will look at what is required of a developer, give some examples of what to expect in a developers average day on the job, and begin by introducing and planning out the application that will be developed and evolved throughout the series.
|
10/20/2011 11:00 AM
|
View
|
|
|
Data Mining with the Data Mining Plugin for Excel
Brian Knight
In this session, you’ll learn how to install, configure and ultimately use the Data Mining Plugin for Excel. The plugin allows you to do light to moderate data mining inside the Excel interface and simplifies a complex topic to two clicks in many cases. In this session, you’ll learn how to forecast future sales, pick the best customers to chase and how to determine where there are outliers in your data.
|
10/18/2011 11:00 AM
|
View
|
|
SQL Brand Building
Tom Brenneman
The need for SQL and Business Intelligence talent is at an all-time high. This webinar will focus on providing how to best represent yourself when seeking opportunities to grow your career
|
10/13/2011 11:00 AM
|
View
|
|
|
Introduction to ETL Using SSIS
Bradley Schacht
As we all know data is not static. It is constantly changing, constantly moving and just moving data from one place to another is a simple enough task. In this session Brad will explore how to use SSIS to connect to a variety of different data sources and destinations such as Excel, SQL Server, Oracle and Flat Files. He will then discuss some of the DOs and DON’Ts of the SSIS ETL world. We will discuss ways to use SSIS to do a simple data dump, keep tables in sync, do incremental loads, deal with very large data sets that you may not be able to handle all in memory, and bring multiple sources into one destination. Other topics to be covered include the types of transforms (partially blocking vs fully blocking), which transforms are right for which jobs and which transforms to avoid if you want your data to get moved quickly and efficiently.
|
10/11/2011 11:00 AM
|
View
|
|
Indexing your Data Warehouse
Troy Gallant
One of the primary skillsets most database professionals are initially required to “master” is the art of proper indexing in our databases. We learn early on that an effective indexing configuration will go further in making our databases perform efficiently than probably any other single tuning technique. What’s not so commonly discussed though are the varying approaches one may wish to utilize when indexing your SQL Server enterprise data warehouse. Some scenarios warrant a very similar approach, while others require adaptation to an entirely new paradigm. This webinar will attempt to flush out some of these differences, and hopefully cause you to take a good look at your current indexing to see if indeed it could be operating even more efficiently.
|
10/6/2011 11:00 AM
|
View
|
|
|
Exploring the Map Tool in SSRS 2008 R2
Shawn Harrison
In this session, Shawn will cover the uses of the map feature added with R2. He will demonstrate its common uses and even show you how it can be useful during a zombie invasion. Pay attention, this could save your life!
|
10/4/2011 11:00 AM
|
View
|
|
“What not to Wear”…Reporting Services Style
Sherri McDonald
In this session, Sherri McDonald will discuss some of the WORST practices of Reporting Services Designs. Please join us for a 1 hour interactive webinar where your reports will go from leopard spandex print to Louis Vuitton.
|
9/29/2011 11:00 AM
|
View
|
|
|
Introduction to the Repository Design Pattern and Using It In MVC 3
Mark Brown
In this session, we will provide an introduction to the repository design pattern, what benefits it brings, and how to apply it in an MVC 3 project. We will look at using the pattern with custom classes and Linq to Sql generated classes. We will also look at refactoring the auto generated entity framework code from the controller into the repository pattern.
|
9/27/2011 11:00 AM
|
View
|
|
|
Working Smarter Not Harder! Silverlight with Caliburn.Micro
Arie Jones
As a developer one of my personal joys is discovering tools which simplify some of the mundane programming tasks and allow me to concentrate on the more intricate details of the application. Caliburn.Micro is a free open source framework developed by Rob Eisenberg that uses a Convention over Configuration approach to vastly simplify the types of mundane tasks that we would normally do in a typical Silverlight MVVM implementation. Come and join me in this session to learn the ins and outs of the framework and how to leverage it in order to drastically reduce your development timeline. I will be using minimal slides and lots of sample code in order to get you up to speed!
|
9/22/2011 11:00 AM
|
View
|
|
Troubleshooting SSIS Failures and Performance Using BI xPress
Mike Davis
SSIS is a fantastic Microsoft tool for performing Extract Transform and Loading (ETL) procedures. A challenge in SSIS is identifying a problem once you deploy your packages. In this webinar you will learn how to both identify and solve your SSIS issues.
|
9/21/2011 11:00 AM
|
View
|
|
|
SSIS Variables and Expression
Bradley Schacht
Building a dynamic SSIS package can be a daunting task. There are countless locations where expressions and variables can be used throughout SSIS. In this session Brad will walk you through the basics of variables including how SSIS deals with variable scoping. We will then take a look the unique expression language used in SSIS and how that can help in situations such as dynamic file names, connection strings and data cleansing. Next we will bring it all together and show how powerful SSIS can truly be by combing the functionality of variables and expressions. Topics will include user variables, system variables, the expression language, as well as where to use expressions and variables in the control flow, data flow and even event handlers to build a useful custom auditing solution.
|
9/20/2011 11:00 AM
|
View
|
|
SQL Server Denali – What’s in the box?
Adam Jorgensen
Come join Adam and an all start cast of community pros as they show, review and discuss the newest and coolest features of SQL Server Denali! This will be an awesome action packed hour and will have all your favorite speakers as a part of it!
|
9/15/2011 11:00 AM
|
View
|
|
|
Reporting Services – Bringing Sexy Back!
Adam Jorgensen
Crazy Awesome Reporting Visualizations are all the rage so come join Adam as he shows you how to design some of the coolest report visualizations you’ve ever seen. This include cool new chart types, cube browsers and other awesome stuff! Come blow your reporting mind!
|
9/13/2011 11:00 AM
|
View
|
|
|
Building Amazing Reports with Project Crescent
Brian Knight
In this session, you'll learn how to create an environment where your users can build their own interactive reports. Speaker Brian Knight will start by building a tabular semantic model in SSAS for your users to easily navigate the data model and data. Then, your learn how your users will build amazing interactive web-based reports using Crescent, SQL Server's most exciting new feature in Denali.
|
9/8/2011 11:00 AM
|
View
|
|
|
What’s New in SSIS in Denali
Brian Knight
In this session, you’ll go through a whirlwind tour of what’s new in SSIS for you as a developer and administrator. You'll first learn about the new designer experience and the death of configuration files in Denali. You'll then learn how to deploy and administer packages in Denali. This release is going to be huge and you will not want to miss this session about the differences.
|
9/6/2011 11:00 AM
|
View
|
|
|
Swan Dive into Filtered Indexes and Filtered Statistics
Arie Jones
SQL Server 2008 comes with some incredibly handy new indexes and statistics that you could leverage in order to boost performance of your systems. Unfortunately, with new technology also comes possible new hazards that need to be taken into account before making the big plunge. Join me in this session to dive headlong into Filtered Indexes and Statistics to show you the ins and outs of these incredibly powerful features and help you navigate around issues that may hinder smooth implementation.
|
9/1/2011 11:00 AM
|
View
|
|
|
Upgrading DTS Packages to SSIS
Brian Knight
The Microsoft “End of Life” policy for SQL 2000 has encouraged many organizations to seriously look at migrating their SQL2000 servers to SQL2005 or 2008. One of the biggest obstacles to a rapid migration is the DTS package issue. To gain the performance benefits and a supported path forward for the functionality in DTS, these packages should be converted into native SSIS. As we all know, the conversion is NOT straightforward. SSIS is more powerful and significantly different from DTS. Join us as SQL Server and author, Brian Knight, shares his knowledge.
|
8/30/2011 11:00 AM
|
View
|
|
Developing and deploying PerformancePoint scorecards and dashboards
Mark Stacey
In this webinar, Mark will take you through a practical demonstration of Performance Point's business intelligence capabilities, combining analytic charts with scorecards to enable rich visualizations of business data.
|
8/25/2011 11:00 AM
|
View
|
|
|
Page Row Compression, How, When, and Why
Bradley Ball
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.
|
8/23/2011 11:00 AM
|
View
|
|
Zero to Dashboard- Intro to PerformancePoint
Mike Milligan
Come check out the PerformancePoint hotness! Mike will demonstrate the functionality in PerformancePoint services in SharePoint 2010 and show you how to quickly build some dynamic dashboards and reporting functionality your end users will crave.
|
8/18/2011 11:00 AM
|
View
|
|
Fundamentals of Fast Track BI
Troy Gallant
Troy will review the fundamentals of the Fast Track reference architecture and how it can be a tremendous boost in performance and scalability for your BI environment. Pragmatic Works is the leader in Fast Track implementation worldwide and this is a great opportunity to learn from the folks who helped major firms implement this technology.
|
8/16/2011 11:00 AM
|
View
|
|
|
Overview of Common DAX Expressions
Devin Knight
DAX (Data Analysis Expression) is the new language to perform powerful analysis in power pivot. Come see this new technology and see how it can outperform your old Excel functions and take your analysis to the next level.
|
8/11/2011 11:00 AM
|
View
|
|
|
Working with Excel Services in SharePoint 2010
Bradley Schacht
Excel Services is an extremely powerful tool that you can use inside your environment to help improve workflow and collaboration. In this session Brad will take you from start to finish through the process for getting your new SharePoint 2010 site ready to work with Excel Services. Some of the topics discussed will include the service application, associating the application with your SharePoint site, data connections and the unattended service account. Once the site is configured to work with Excel Services we will create a report inside Excel, deploy it and show some of the great features available like embedding portions of the workbook into a dashboard. After this session you will be able to create a new Excel Services web application and use it to share workbooks in your environment.
|
8/9/2011 11:00 AM
|
View
|
|
|
Disaster Recovery for the SQL Server BI Professional
Troy Gallant (@GratefulDBA)
Most database specialists have the need to get involved with their organization’s disaster recovery planning on some level. Information on the myriad of scenarios and options are available widely on the internet, in books, from colleagues, etc. The business intelligence professional though has an additional collection of tools, objects, & components that need to be considered in a comprehensive and thorough DR plan. This webinar will review some of those additional factors and examine how your company’s plans may need to be altered to take your BI components into account.
|
8/4/2011 11:00 AM
|
View
|
|
SQL Server Internals and Architecture
Kevin Kline
This fast paced session will take you through many aspects of the internal operations of SQL Server. if you want to take your skills to the next level, it’s critical to know SQL Server’s internal processes and architecture. This session will answer questions like:What’s different about 32- and 64-bit systems? What are the various areas of memory inside of SQL Server? How are queries handled behind the scenes? What does SQL Server do with procedural code, like functions, procedures, and triggers? What happens during checkpoints? Lazywrites? How are IOs handled with regards to transaction logs and database? What happens when transaction logs and databases grow or shrinks?
|
8/2/2011 11:00 AM
|
View
|
|
|
Introduction to PowerPivot
Devin Knight
Come join Devin as he explores the new PowerPivot technology, how to configure and get it up and running and build exciting reports in a very short amount of time. This will be an all demo session and lots of fun!
|
7/28/2011 11:00 AM
|
View
|
|
Introduction to MVC 3
Ben Evans
In this session Ben will discuss all of the new features in MVC 3, as well as a basic overview of MVC and how it can help provide better architectural organization to your current project.
|
7/26/2011 11:00 AM
|
View
|
|
Reporting on a Cube with SQL Server Reporting Services 2008
Dustin Ryan
In this session Dustin will give you an introduction to reporting on a cube with SQL Server Reporting Services (SSRS). You’ll learn about some of the advantages of using your cube as a source for your SSRS reports, how to build reports based on your cube with minimal knowledge of MDX, as well as a few tricks you can use to increase the usability of your reports.
|
7/21/2011 11:00 AM
|
View
|
|
|
What’s New in BI Denali
Brian Knight
In this session, you’ll go through a whirlwind tour of what’s new in one of Microsoft’s biggest releases of SQL Server in its history: SQL Server code named Denali. You’ll learn about the upcoming Crescent feature, which allows users to build ad-hoc reports easily. You’ll also learn about the BI Semantic Model in SSAS and the huge enhancements to SSIS. Lastly, Brian will cover the database engine enhancements that make BI more accessible and faster.
|
7/19/2011 11:00 AM
|
View
|
|
SSRS Subsriptions
Kyle Walker
Join Kyle session on SSRS subscriptions! In this session, you will get a chance to see some real world subscription requests and how to implement them. Some requests, which are common across a lot of businesses, fall outside of the functionality of Reporting Services so this session will also require some knowledge of SSIS.
|
7/14/2011 11:00 AM
|
View
|
|
|
Operational Best Practices for SSAS
Adam Jorgensen
Come learn with Adam Jorgensen, SSAS Maestro co-course director as he takes you through the ins and outs of operational and administration best practices for Analysis Services.
|
7/12/2011 11:00 AM
|
View
|
|
|
Automating Web Application Deployment with SSIS
Jorge Segarra
Are you a database or system administrator who has looked at SSIS and thought “that’s some cool stuff but I have no idea how I’d use it in my shop”? SSIS is a very powerful and flexible tool in the SQL Server toolkit and can be extended for use beyond simply moving data around. In this session, Jorge will walk through an end-to-end solution for automating the migration of a simple web application from development to production using SSIS!
|
7/7/2011 11:00 AM
|
View
|
|
|
Common Analysis Services Design Mistakes and How to Avoid Them
Devin Knight
Anyone new to developing Analysis Services Cubes will get thrilled when processing a cube successfully for the first time. Even though a cube is built there are many potential design mistakes that are often made. This session reviews common design mistakes that are made when building Analysis Services Cubes. You will learn how you can build a more effective cube that provides faster performance, faster development and simpler maintenance.
|
7/5/2011 11:00 AM
|
View
|
|
|
How awesome are my reports!!!
Sherri McDonald
That’s right, I said it. Do you want to look like an over achiever? Do you want your reports to stand out above the rest so your boss thinks you spent all night at home adding some personal touches? Join my session to learn how to use some of the cool R2 features and raise the bar report writing.
|
6/30/2011 11:00 AM
|
View
|
|
New SSIS Features and Enhancements in Denali
Jamie Thomson
Learn about the new features in SSIS in CTP1 of Denali!
|
6/28/2011 2:30 PM
|
View
|
|
Using Containers in SSIS
Shawn Harrison
In this session, Shawn will cover the different containers used in SSIS packages. He will explain the differences between them and demonstrate how each container is used in different situations.
|
6/23/2011 11:00 AM
|
View
|
|
|
Back That Thang Up!
Jorge Segarra
Backups…they’re worthless. Yeah, I said it. In this session we’ll cover everything you need to know about backups and restores to keep your data safe (as well as your job!). You’ll also find out exactly why backups are worthless…
|
6/21/2011 11:00 AM
|
View
|
|
|
Data Driven Website Design
Ben Evans
Join Ben as he shows you the basics of building a data driven asp.net website. Includes topics such as performance, Caching, and security. There will also be a demonstration of various techniques for you to consider on your next project.
|
6/16/2011 11:00 AM
|
View
|
|
|
Introduction to MDX
Brian Knight
The MDX query language is one of the toughest and most powerful languages in your arsenal as a business intelligence developer. In this session, you’ll start from the ground-up learning how to create a basic MDX statement and then quickly how do you solve complex business problems with this well-structured language.
|
6/14/2011 11:00 AM
|
View
|
|
Data Dude
Robert Cain
Making a database developer happier and more productive, whether you are a dedicated database developer, or a DBA/.Net Developer for whom database development is a secondary job, Visual Studio Database Developer edition, aka "Data Dude" can be a boon to you. In this session we'll start by reverse engineering an existing database into complete scripts to create the tables, indexes, stored procedures, and more. Deployment strategies will be covered, as well as refactoring and unit testing. Finally we'll look at the powerful data generation capabilities built into "Data Dude".
|
6/9/2011 11:00 AM
|
View
|
|
|
Dynamic SSIS: Configurations, Expressions, and Variables
Bradley Schacht
One of the biggest hurdles in any organization is migrating from DEV to PROD with minimal issues. In this session Brad will help get you over the learning curve of making dynamic SSIS packages to make this transition easier. Topics of discussion will include using all the different types of package configurations, the SSIS expression language and variables. After diving into each of these topics Brad will talk about best practices as well as the pros, cons and limitations of using each type of configuration. At the end of this session you will be able to configure your SSIS packages to be simple to modify and move without even opening a package!
|
6/7/2011 11:00 AM
|
View
|
|
|
Building Tier 1 SSAS Solutions for Maximum Performance
Adam Jorgensen
Come join SSAS Guru Adam Jorgensen as he shares the best practices for building Tier 1 solutions learned from working with the SQLCAL team on some of the largest and most complex Analysis Services implementations in the world.
|
6/2/2011 11:00 AM
|
View
|
|
Using Parameters in SQL Server Reporting Services
Mike Davis
In this session Mike shows parameters in many different ways including cascading, Default Values, Available Values, Multi value with the Split Functions in Stored Procedures, and custom code. Learn how to change the formatting of a report using Parameters.
|
5/26/2011 11:00 AM
|
View
|
|
|
Introduction to Report Builder 3.0
Shawn Harrison
This webinar is geared towards the end users of reports. So, if you are an IT Professional and you are tired of developing countless reports for people who know how to operate something as simple as word or excel, tell them to watch this webinar.
|
5/24/2011 11:00 AM
|
View
|
|
|
Using Performance Point and Reporting Services to create an interactive dashboard
Mark Stacey
Performance Point builds a rich interactive experience for the end user. Report Services creates high fidelity charting. Learn how to combine these technologies to build interactive dashboards without losing the power of Reporting Services, with dynamic measures and chart axes
|
5/19/2011 11:00 AM
|
View
|
|
New Web Parts in Foundation and List Management
Veronique Palmer
SharePoint can be used very effectively for small businesses too, especially when you have sales people on the go all the time. Foundation has some cool new group work lists for tracking who’s in and out the office, a way to leave phone messages, who’s who, and what’s new on the site. Then learn about using custom lists to manage and re-use information.
|
5/17/2011 11:00 AM
|
View
|
|
Data Mining with Excel: Fantasy Baseball Made Easier
Tom Lannen
In this session Tom Lannen will show you how you can get started with data mining using the ease and familiarity of Excel with the power of SQL Server Analysis Services.
|
5/12/2011 11:00 AM
|
View
|
|
|
Task Factory Launch Party
Brian Knight
Now launching Task Factory 2.0! New features include Xml Destination, which allows users to export xml within SSIS from source data, Replace Unwanted Characters Transform which allows users to replace unwanted / invalid characters in a data source, Null Handler Transform, which allows the user to replace null or blank data from source data, and much more! Watch a live demo of several million row get loaded 100x faster!
|
5/11/2011 11:00 AM
|
View
|
|
|
Introduction to PowerPivot
Brian Knight
In this session, you’ll learn how to use PowerPivot to create self-service analytics in your organization. You’ll see how Office 2010 and SQL Server 2008 R2 will help your users answer their own questions and bring together datasets that may be heterogeneous like a SQL Server table and data feed from a website. Then, you’ll see how to take that data and create a striking report for your end users and collaborate with the data in SharePoint.
|
5/10/2011 11:00 AM
|
View
|
|
|
Intro to Data Mining- Your Guide to Fantasy Baseball Season
Tom Lannen
The past is the past, but what good is it if we don’t learn from it. In this session Tom Lannen will help you learn from the past and even predict the future. No longer will you have to struggle to decide who to draft next for your fantasy baseball league. Oh and there are business applications for this technology too. Tom will walk you through creating a mining model using SQL Server Analysis Services, that will help you make a decision on who to draft, not only based on past statistical performance, but on projected performance for the upcoming season
|
5/5/2011 11:00 AM
|
View
|
|
Fun with Scoped Assignments in MDX
Chris Webb
Scoped assignments are one of the most powerful features in MDX, but also one of the most difficult to understand. This session will introduce the concept of scoped assignments, how they can be created and what kinds of calculations can be implemented using them. Some previous knowledge of MDX will be assumed.
|
5/3/2011 11:00 AM
|
View
|
|
|
Business Intelligence in SharePoint 2010
Adam Jorgensen
What’s the use of having business intelligence if you can’t make it actionable? In this session you’ll learn how to better collaborate with SharePoint 2010 and Microsoft’s BI suite. You’ll learn how PowerPivot in SharePoint will allow your users to do self-service BI. You’ll also learn how to Performance Point can help you develop scorecards and aid your users in answering questions they didn’t even know they had.
|
4/28/2011 11:00 AM
|
View
|
|
|
Mastering Site Wikis and Permissions
Veronique Palmer
In this webinar is composed of two seprate topics. The first, a session for begginers on site pages, and wikies. Followed by and intermediate to advanced session on 2007 and 2010 permmisions. Primarly a comparision and showing of 2010 better built reporting tools.
|
4/26/2011 11:00 AM
|
View
|
|
|
Reporting Services- Dissecting the Tablix
Joe Salvatore
The Reporting Service Tablix was introduced in SQL Server 2008 and when you create a report that uses a list, table, matrix, chart, gauge, or custom report item under the covers you are using a Tablix. This webinar will help you to understand some of the not so well understood capabilities of the Tablix
|
4/21/2011 11:00 AM
|
View
|
|
|
Understanding Site Wikis in SharePoint 2010
Veronique Palmer
In SharePoint 2007, team site were made up of zones and web parts. In 2010 they are site wikis. The way you edit the page has been simplified, but there are still some tricks and traps that will frustrate business users especially in tables. Learn how to edit site pages, embed pages, manage links, and deactivate the wikis.
|
4/19/2011 11:00 AM
|
View
|
|
|
Using Visio Services to visualise data in Sharepoint
Mark Stacey
Visio is the tool of choice for visualizing process flow - in this session, Mark will demonstrate connecting Visio objects to data from tables and cubes, and deploy this diagram to Visio services to show a updating diagram useful for monitoring process flow.
|
4/14/2011 11:00 AM
|
View
|
|
.Net Revolutions
Jarrod Edge
Take the red pill and step down the rabbit hole with Jarrod Edge to explore the potential of CLR in Sql Server. In this session an introduction to Assemblies, Use of C# and a discussion to dispel the illusions around its use in SQL Server will be explored. Ending with a real world example to show you its true power in the right hands.
|
4/12/2011 11:00 AM
|
View
|
|
|
Using Performance Point and Visio to Create Strategy Maps
Mark Stacey
Visualizing and measuring your strategy is key to executing on it - in this session, Mark will show how to create a strategy map diagram in Visio, KPIs in Performance Point and connect them together to create an interactive visualization.
|
4/7/2011 11:00 AM
|
View
|
|
|
Intro to Variables and Expressions in SSIS
Shawn Harrison
In this Session ,Shawn will demonstrate how to use variables and expressions to make SSIS Packages dynamic
|
4/5/2011 11:00 AM
|
View
|
|
|
Performance Tuning the BI Platform
Brian Knight
Learn how to tune the business intelligence platform by using classic and not so traditional techniques. In this session, you’ll see some of the common ways to tune your SSIS packages and mistakes to avoid. Then, the speakers will show you common ways to tune your SSAS cube environment.
|
3/31/2011 11:00 AM
|
View
|
|
Deploying SSIS packages
Jose Chinchilla
Join Jose Chinchilla on this presentation to learn how to deploy SSIS packages from Development environment into Production, the three different target location options and how to dynamically change data source and destination connection strings and other object properties using SSIS Package Configurations. We will explore the different SSIS package configuration options and provide best practices for production environment deployments.
|
3/29/2011 11:00 AM
|
View
|
|
|
BI Decaffeinated
Jose Chinchilla
In this session, Jose will go over his 10 rules of wisdom for a successful BI solution intended as a roadmap to get you started.
|
3/24/2011 11:00 AM
|
View
|
|
|
HP BDA Appliance: Accelerating Decisions using SharePoint BI and PowerPivot
Mark Mortimore, Senior PM for the BDA Appliance & Mark Stacey
Having a hard time standing up a SharePoint BI environment? In this session, the speakers explain the new Business Decision Appliance (BDA) and when it is a good fit. Pragmatic Works will demo the appliance which will include gains: time to value comparison, performance gains.
|
3/23/2011 11:00 AM
|
View
|
|
|
Performance Tuning the Cube
Brian Knight,SQL Server MVP and Author
What’s the use of having business intelligence if you can’t make it actionable? In this session you’ll learn how to better collaborate with SharePoint 2010 and Microsoft’s BI suite. You’ll learn how PowerPivot in SharePoint will allow your users to do self-service BI. You’ll also learn how to Performance Point can help you develop scorecards and aid your users in answering questions they didn’t even know they had.
|
3/17/2011 11:00 AM
|
View
|
|
Scaling a Data Warehouse with EDW
Roger Moore (Microsoft) and Jeff Spiller (HP)
This session will summarize the HP-Microsoft Infra2 Apps Partnership, with focus on the HP EDW Enterprise Data Warehouse appliance offerings – based on the Microsoft SQL Server Parallel Data Warehouse (PDW) solutions – We will focus on the Massively Parallel Processing (MPP) capabilities – both hardware and software architecture’s – and how our customers can take advantage of the HP/MSFT EDW/PDW appliance offerings to scale their Data Warehouse from multiple Terabytes into the 100’s of Terabytes, addressing enterprise scale user concurrency, query workloads and near real-time data load requirements.
|
3/16/2011 11:00 AM
|
View
|
|
|
0 to Cube in 60 Minutes
Adam Jorgensen
This session is a SQL Saturday legend! Have you wanted to start using Analysis Services to deliver self-service BI to your end users? Have you started a cube project but have trouble using additional functionality like Actions, KPI’s and others? This session is a great all hands on experience where we build a fully functional cube in one hour with all the bells and whistles. This session is ALL demo and very interactive to make sure everyone gets the information and has a good time! Even experienced SSAS developers will learn from Adam Jorgensen, BI Expert and SQL Server pro for more than 15 years.
|
3/15/2011 11:00 AM
|
View
|
|
|
Rock Your Report
Sherri McDonald
In this session Sherri McDonald will show you how to take an average looking report, add bling and make it rock. So put a feather in your hat and come for a good time.
|
3/10/2011 11:00 AM
|
View
|
|
Implementing the New Fast Track 3.0 Architecture
Tom Pizzato (Microsoft) & Jim Hautala (HP)
In this sessions join Tom Pizzato & Jim Hautala , Technology Solution Professional - Parallel Data Warehouse, Microsoft Corporation, as he reviews the latest Fast Track 3.0 architecture including an exclusive overview HP’s latest workhorse,including balanced system, index light, low fragmentation and core calculator.
|
3/9/2011 11:00 AM
|
View
|
|
|
Caching and Cache-Warming in Analysis Services
Chris Webb,co-author Expert Cube Development SSAS 2008
Efficient caching is one of the main techniques that Analysis Services uses to achieve fast query response time. In this session you'll find out about the different types of caching Analysis Services is capable of, easy mistakes you can make that will stop caching happening, and various methods of warming the cache.
|
3/8/2011 11:00 AM
|
View
|
|
|
BI xPress 3.0
Brian Knight
BI xPress 3.0: See how the new 3.0 version will allow you to simplify SSAS and SSIS development. The two new flagship features covered in this session are the SSAS Calculation Builder (no more MDX!) and the configuration manager for SSIS that enables encrypt settings. You’ll also see an even more advanced and deeper auditing framework than ever before released.
|
3/4/2011 2:00 PM
|
View
|
|
|
Microsoft’s BI Stack: How to Choose a Technology
Mark Stacey
The Microsoft BI stack is fairly complex, especially on the front-end. In this session, we will cover when to use Performance Point, Reporting Services or Excel Services. We will also touch on the differences between PowerPivot and Analysis Services, and how to choose the appropriate technology.
|
3/3/2011 11:00 AM
|
View
|
|
Designing your Data Warehouse Platform
Devin Knight
Find out how successful data warehouse projects are architected and designed. Devin will start by covering how to iterate and project manage a BI project. Then he’ll cover best practices around design of a warehouse schema. We’ll end this session on a discussion some of the hardware decisions you’ll have to make for scaling a BI platform on the HP server environment.
|
3/2/2011 11:00 AM
|
View
|
|
|
Intro to .NET for DBA
Ben Evans
In this session, Ben will show you a basic overview of developing with C# presented from the perspective of a DBA. This webinar will provide basic information on the .Net framework as well as how to present data, and best practices which DBA’s can look out for from there developers
|
3/1/2011 11:00 AM
|
View
|
|
Taking SSIS to the Next Level with Task Factory
Chris Rock
See how Task Factory’s 20 new SSIS tasks, sources, transforms and destinations can optimize your SSIS environment and let you do things that you could never do before in SSIS.
|
2/23/2011 11:00 AM
|
View
|
|
|
Building SSRS reports on your cube
Jose Chinchilla
In this session, you will learn how to create SSRS reports based on OLAP cubes, create dynamic data sets with parameters and filters, add calculated SSRS columns using the SSRS Expression language and MDX, integrate hierarchies with drill through, display KPIs and more!
|
2/17/2011 11:00 AM
|
View
|
|
|
Developing BI solutions faster with BI xPress
Shawn Harrison
Learn how to develop faster with package reusability features in BI xPress. Mike will cover the package builder feature, which gives you the ability to reuse components and how show you how to accelerate SSIS script development.
|
2/16/2011 11:00 AM
|
View
|
|
|
0 to SSIS in 60 minutes
Jose Chinchilla
In this session, Jose will cover the some of the most important SSIS control flow and data flow tasks to jump start DBAs and Developers into SSIS with SQL Server 2008-R2.
|
2/15/2011 11:00 AM
|
View
|
|
|
Introduction to SSRS
Sherri McDonald
Still ramping up on SSRS? Sherri McDonald will show you the basics of how to use SSRS in your environment assuming you have never opened the tool before. Go from 0 to fantastic reports in 60 minutes.
|
2/10/2011 11:00 AM
|
View
|
|
|
Administering SSIS with BI xPress
Mike Davis, SQL Server Author and BI Architect
Find out how to administer and performance tunes SSIS packages with BI xPress. You’ll learn how to add auditing framework to track down performance issues and faults in your package. You will also learn how to deploy SSIS packages easily with two clicks and have a discussion on where to deploy your packages to.
|
2/9/2011 11:00 AM
|
View
|
|
|
Building your first SSRS Dashboard
Shawn Harrison
In this session, learn how to build beautiful dashboards for your organization in SSRS using some of the SQL Server 2008 R2 SSRS features. Shawn will show you how to use the indiciators, spark lines, maps and many other things in this very demo heavy session.
|
2/8/2011 11:00 AM
|
View
|
|
Change data capture with SSIS
Patrick LeBlanc , SQL Server MVP and BI Architect
Change data capture is an amazing feature in SQL Server 2008 that allows you to find changes and replicate updates, inserts and deletes to a new system. In this session, SQL Server MVP Patrick LeBlanc will show you how to use this feature with SSIS to easily find and direct changes to the appropriate place.
|
2/3/2011 11:00 AM
|
View
|
|
|
BI xPress Launch Party
Brian Knight,SQL Server MVP and Author
Join us for celebrating our biggest launch yet of BI xPress. See how the new 3.0 version will allow you to simplify SSAS and SSIS development. The two new flagship features covered in this session are the SSAS Calculation Builder (no more MDX!) and the configuration manager for SSIS that enables encrypt settings. You’ll also see an even more advanced and deeper auditing framework than ever before released.
|
2/2/2011 11:00 AM
|
View
|
|
|
Data cleansing in SSIS
Brian Knight,SQL Server MVP and Author
In this session, Brian shows you how to use the Data Profiling Task, Script Transform and Fuzzy logic, new components built into SQL Server Denali for data cleansing.
|
2/1/2011 11:00 AM
|
View
|
|
|
Loading a fact table
Joe Salvatore
In this session, Joe will focus on the many details that should be considered and implemented in SSIS packages that load fact tables.
|
1/27/2011 11:00 AM
|
View
|
|
|
Introduction to PowerPivot
Brian Knight,SQL Server MVP and Author
In this session, Brian explains how to use PowerPivot to create a culture of self-service BI, and how to use SharePoint to share that business intelligence with others
|
1/25/2011 11:00 AM
|
View
|
|
0 to Dashboard in PerformancePoint
Adam Jorgensen, Pragmatic Works, BI Architect
Many of you have seen the coolness that is PerformancePoint in SharePoint 2010. Come get hands on with Adam as we go through the ins and outs of creating your first dashboard. See some of the cool visualizations you can use and how they work together to create a cool user experience
|
1/20/2011 11:00 AM
|
View
|
|
|
SSIS Troubleshooting
Mike Davis, SQL Server Author and BI Architect
In this session, Mike explains how to decipher the package results and show you how to debug control flows and data flows.
|
1/18/2011 11:00 AM
|
View
|
|
|
Building a career with SQL Server business intelligence
Brian Knight and Tim Moolic
The Microsoft Business intelligence market has grown significantly in in the past few years. Today demand is high for experienced SQL Server BI architects, developers, and analyst. In this session Tim and Brian will review the job market opportunities and explain how you can take your career to the next level.
|
12/29/2010 11:00 AM
|
View
|
|
|
Using Script Task and Components in SQL Server Integration Services
Mike Davis, SQL Server BI Architect and Author
Mike shows you how to build script tasks in the control flow and Script components in the data flow of an SSIS package. If there is not a task in the toolbox that can do what you need, then a script task or component is used to complete these steps. Learn when to use them and when not to use them
|
12/28/2010 11:00 AM
|
View
|
|
|
Introduction to Data Mining in SQL Server Analysis Services
Brian Knight, SQL Server MVP and Author
Data mining is one of the key hidden gems inside of Analysis Services but has a steep learning curve for most. In this session, you’ll learn how to create a data mining model to predict who is the best customer for you and learn how to use other algorithms to spend your marketing model wisely. You’ll also learn how to integrate data mining into your application
|
12/23/2010 11:00 AM
|
View
|
|
|
Introduction to Performance Tuning Analysis Services 2008
Chris Webb,co-author Expert Cube Development SSAS 2008
So you've gone to all the trouble of building a cube, and your users are complaining that their queries are still too slow? This session will show you how to tune query performance on Analysis Services 2008, looking at partitioning, designing aggregations and identifying MDX-related bottlenecks.
|
12/21/2010 11:00 AM
|
View
|
|
|
Building calculations in SSAS 2008
Brian Knight
Join Brian Knight as reviews tips and tricks for building simple and complex calculations in SSAS 2008. In this session, Brian will be using a combination of manual tips and automated tricks to create complex calculations fast
|
11/23/2010 11:00 AM
|
View
|
|
|
Introduction to Performance Tuning Analysis Services 2008
Chris Webb, co-author Expert Cube Development SSAS 2008
So you've gone to all the trouble of building a cube, and your users are complaining that their queries are still too slow? This session will show you how to tune query performance on Analysis Services 2008, looking at partitioning, designing aggregations and identifying MDX-related bottlenecks.
|
11/18/2010 3:00 PM
|
View
|
|
|
SSIS Dataflow - Designing for performance
Jamie Thomson, SQL Server MVP
Building highly performance data flows takes more than just dragging a few boxes onto the design surface and wiring them up. In this session I'll talk about SSIS's buffer architecture, synchronous and asynchronous transformations, and, most important of all, designing for performance.
|
11/16/2010 3:00 PM
|
View
|
|
Identifying and Fixing Performance Problems using Execution Plans
Grant Fritchey , SQL Server MVP and Author
This session will demonstrate how SQL Server execution plans can be used to identify problems with the database design, or the TSQL code, and address those problems. The session takes the user through various common issues such as poor or missing indexes, badly written code and generally bad query performance, demonstrating how to identify the issues involved using execution plans. The session will then demonstrate different methods for addressing the issues and show how the fixed query's execution plans differ. Multiple methods for accessing execution plans including graphical, DMV's, and trace events are demonstrated. All this is meant to lay a foundation for a general troubleshooting approach to empower the attendee to make their own queries run faster and more consistently.
|
10/28/2010 11:00 AM
|
View
|
|
Pro SQL Server 2008 Policy-Based Management
Jorge Segarra , MCTS (SQL Server 2005) and Author
Policy based management is a new feature in SQL Server 2008 that allows you to define and implement policies across your SQL Server infrastructure. In this session, join Jorge Segarra as he reviews SQL Server 2008 Policy-Based management best practices.
|
10/26/2010 11:00 AM
|
View
|
|
|
Out with the old in with the new, Migrating DTS to SSIS
Brian Knight, SQL Server MVP and Author
In this session, join Brian Knight as he reviews “tips and tricks” for migrating DTS to SQL Server 2008 SSIS. Including “Must have” SSIS knowledge before you migrate.
|
10/21/2010 11:00 AM
|
View
|
|
SQL Statement Tuning with Indexing Strategies
Kevin Kline , SQL Server MVP and Author
Few things influence the speed and performance of SQL statements within SQL Server as much as indexes. This session will help you understand the basics of good index strategies and the direct impact your indexing strategy has on queries. This session uses a variety of examples to show exactly how indexes can affect query performance, as well as shows a variety of ways that queries can be written to leverage the indexes that are in place.
|
10/19/2010 2:00 PM
|
View
|
|
Data Mining
Jamie MacLennan, CTO Predixion Software, Principal Development Manager of SSAS, Microsoft Corporation
Join Jamie MacLennan, as he reviews the evolution of SQL Server 2008 data mining “add ins”.
In this session Jamie will review the history and direction of the Microsoft data mining “add ins” and their future evolution at Predixion Software including PowerPivot, Excel 2010 64Bit, and the cloud.
|
9/30/2010 11:00 AM
|
View
|
|
|
Performance tuning the cube
Adam Jorgensen, Pragmatic Works, BI Architect
Want to make your SSAS cube lightening fast? Join Adam as he reviews SQL Server Analysis Services (SSAS) and demonstrates little known performance tips and tricks to get the most out of SSAS.
|
9/28/2010 11:00 AM
|
View
|
|
MDX 101: Lost in Cube Space
Bryan Smith, C0-Author SQL Server 2008 MDX
Despite widespread adoption of Analysis Services, the MDX query language remains a bit of an enigma. It’s not until a very simple but seldom explored concept is understood that the power and elegance of the language is revealed. Join Bryan Smith, co-author of Microsoft SQL Server 2008 MDX Step by Step, in exploring this central concept, providing a foundation for your success with the MDX language.
|
9/23/2010 11:00 AM
|
View
|
|
Advanced SSRS Tips and Tricks
Mike Davis, SQL Server Author and BI Architect
Join Mike as he demonstrates advanced concepts in SSRS 2008. Some of the topics included will help you learn how to cascade report parameters, use .Net functions in your reports, and create subscrip..
|
8/26/2010 11:00 AM
|
View
|
|
|
Migrating Crystal Reports to SSRS
Devin Knight, Chris Albrektson, and Brian Knight
SQL Server Reporting Services has drastically increased in popularity over the past decade. Join Devin as he walks through common strategies to migrate Crystal Reports to SSRS.
|
8/24/2010 11:00 AM
|
View
|
|
|
Introduction to SSRS 2008
Mike Davis, SQL Server Author and BI Architect
Join Mike as he’ll help you understand all aspects of SQL Server 2008 Reporting Services (SSRS), the reporting tool of choice for SQL Server developers. Mike will review a variety of tips and tricks and demonstrate how to use SSRS in the real-world.
|
8/19/2010 11:00 AM
|
View
|
|
Microsoft BI (Power Pivot) for Salesforce.com
Brian Knight , SQL Server MVP and Author and Tim Moolic, COO Pragmatic Works
Join Brian and Tim as they teach you how to easily extract your data from Salesforce.com, load a SQL Server database and use Microsoft PowerPivot to get superior business Intelligence out of Salesforce.com.
|
8/17/2010 11:00 AM
|
View
|
|
SQL Server Architectures for High Availability and Disaster Recovery
Ross LoForte, Technology Architect and SQL Server author
SQL Server 2005 and SQL Server 2008 offers many technologies that can be used to minimize downtime and maximize data protection for the business to ensure smooth operation, continuous access to business critical data, and meet availability levels according to various service level agreements.This presentation will start with an overview of the high availability and disaster recovery offered and then describe five commonly-deployed architectures using SQL Server 2005 and SQL Server 2008 that are designed to meet the high-availability and disaster recovery requirements of enterprise applications.
|
7/29/2010 11:00 AM
|
View
|
|
|
SSIS Management for the DBA
Brian Knight, SQL Server MVP and Author
In this session for DBAs, Brian Knight shows you how to configure your SSIS packages for a zero-touch deployment. Then Brian covers how to deploy, schedule and administer SSIS in production.
|
7/27/2010 11:00 AM
|
View
|
|
|
SQL Server 2008 R2 for the DBA
Patrick LeBlanc , SQL Server MVP and BI Architect
In this session, Patrick LeBlanc will cover SQL Server 2008 R2 for the DBA.
Microsoft SQL Server 2008 provides a number of enhancements and new functionality, building on previous versions. Administration, database maintenance, manageability, availability, security, and performance, among others, all fall into the roles and responsibilities of the database administrator. Patrick LeBlanc will go over the new features and functionality that will impact the DBA.
|
7/22/2010 11:00 AM
|
View
|
|
Mid-Level Powershell for DBA’s and Developers
Sean McCown , InfoWorld Editor and SQL Server MVP
Join Sean McCown, SQL Server MVP and Contributing Editor with InfoWorld Magazine to learn Powershell.
Have you been using powershell but want to bring your game to the next level? In this session, Sean will show you mid-level tips and tricks that will enhance your Powershell experience. Come see why the world is so excited about Powershell and join the club of the DBAs who work faster and smarter.
Videos may take up to a 60 seconds to load.
|
7/20/2010 11:00 AM
|
View
|
|
Self service BI using Sharepoint with Mark Stacey
Mark Stacey
In this session Mark will show you how to Create reusable report parts and Performance Point components for end users.
|
7/1/2010 11:00 AM
|
View
|
|
|
Introduction to Solving Problems in MDX
Devin Knight
The MDX query language is one of the toughest and most powerful languages in your arsenal as a business intelligence developer. In this session, you’ll start from the ground-up learning how to create a basic MDX statement and then quickly how do you solve complex business problems with this well-structured language.
|
6/24/2010 11:00 AM
|
View
|
|
|
Powershell for complete beginners: Sean McCown
Sean McCown , InfoWorld Editor and SQL Server MVP
Have you been wanting to learn powershell but don’t know where to get started, or even why you should bother? This is where you start. In this session, Sean will show you what powershell is, what it’s all about, how the language is organized, and how to do some real work in SQL Server. Come see why the world is so excited about Powershell and join the club of the DBAs who work faster and smarter. After this session you won’t be a Powershell guru, but you will be able to understand blog examples and continue your learning from other resources. Don’t put off Powershell any longer.
|
6/22/2010 11:00 AM
|
View
|
|
|
BI Documenter 4.0 Launch Party
Brian Knight
Join Brian Knight, Chris Rock and Jacob Milter of UPS in this demonstration of the newest version of BI Documenter.
Learn how your BI components inter-relate.
|
6/3/2010 12:00 AM
|
View
|
|
Creating Dashboards in Performance Point 2010
Mark Stacey
With the release of Sharepoint 2010, Performance Point Services has evolved into a enterprise ready rapid development dashboarding and scorecarding toolkit. Creating KPIs, scorecards and dashboards has never been easier. During this training session, Mark will show how to connect to disparate data sources such as Analysis Services cubes, databases, and information stored in Sharepoint lists, and present this data in scorecards and charts.
|
5/25/2010 11:00 AM
|
View
|
|
The Role of Solid State Storage a Data Warehouse
Introduction by Steve Wozniak and presentation by Sumeet Bansal
From the first Apple Computer to todays solid state iPad, Steve Wozniak has been revolutionizing technology for more than 30 years. Learn how his latest designs for solid state storage are bringing amazing performance and footprint efficiency to the world of data warehousing. In this session, Steve, chief scientist at Fusion-io, will provide an introduction to his latest solid state designs, followed by a "deep dive" technical presentation by Sumeet Bansal, Fusion-io' principal solutions architect. Youll learn how you can easily implement and benefit from the latest solid state technologies for data warehousing.
|
5/20/2010 12:00 AM
|
View
|
|
SQL Server Parallel Data Warehouseing (PDW)
Bruce Campbell
SQL 2008 R2 Parallel DW Appliance (PDW) – formerly known as Project Madison, PDW, is Microsoft’s first DW Appliance .PDW utilizes Massively Parallel Processing (MPP) and will scale out SQL Server 2008 R2 DW from 10’s to 100’s of TBs. PDW has standard support for MPP, High Availability, Linear Scalability and a HUB and Spoke DW Architecture.
In this session Bruce Campbell will present the underlying architecture of PDW and how Parallel processing will impact your current data warehousing designs.
|
5/18/2010 12:00 AM
|
View
|
|
Virtualization and SAN basics for the DBA
Brent Ozar
These two technologies can make a very big - and very bad - difference in how your SQL Server performs. Wouldnt it be great if you could get the real, honest lowdown from a virtualization administrator, a SAN administrator, and a DBA? Wouldnt it be even better if one person had done all three
|
4/29/2010 11:00 AM
|
View
|
|
Use SSRS and SSIS to Create a DBA
Rodney Landrum
At its heart, the DBA Repository solution employs SSIS and SSRS and in late 2009 was updated for performance and resiliency. This session will cover the original solution, published in SQL Server Magazine, plus the latest enhancements which will delve into some interesting uses of package variables and MERGE in SSIS along with some new reports.
|
4/27/2010 11:00 AM
|
View
|
|
SSIS Scripting and Custom Components
Jessica Moss
Cant find an SSIS Task that does what you need? Script it! The Script Task, Script Component, and Custom Components in SSIS are extremely powerful and flexible. In this session by Jessica Moss begin_of_the_skype_highlighting end_of_the_skype_highlighting you will learn how to customize SSIS functionality using Script objects, best practices for script development, script troubleshooting techniques, and script lifecycle management.
|
4/22/2010 11:00 AM
|
View
|
|
Introduction to Data Mining
Brian Knight
Data mining is one of the key hidden gems inside of Analysis Services but has a steep learning curve for most.In this session, you’ll learn how to create a data mining model to predict who is the best customer for you and learn how to use other algorithms to spend your marketing model wisely. You’ll also learn how to integrate data mining into your application.
|
3/24/2010 1:00 PM
|
View
|
|
Loading a Data Warehouse with SSIS
Brian Knight
Now that you have a data warehouse designed, how would you go about loading the warehouse from your relational database that has been in production for years. Join author Devin Knight in this session on how to use SSIS to load and synchronize a data warehouse.
|
3/23/2010 1:00 PM
|
View
|
|
Designing a Data Warehouse
Joy Mundy
Improve the speed of your production can be as easy as giving your users a new place to report against. In this session, youll learn how a data warehouse can benefit your organization and how to design one for SQL Server. Youll also see at a high level how the data flows into the warehouse in a Microsoft data warehouse ecosystem.
|
3/22/2010 11:00 AM
|
View
|