Triangle NC Business Intelligence User Group (tripassBI) Rotating Header Image

Calendar

Pragmatic Works: Intro to .NET for DBA

[ March 1, 2011; 11:00 am to 12:00 pm. ] http://pragmaticworks.com/Resources/webinars/Default.aspx?seoctl00_ContentPlaceHolder2_Webinarlist=page1

Intro to .NET for DBA
Ben Evans

In this session, Ben will show you a basic overview of developing with C# presented from the prospective of a DBA. This webinar will provide basic information on the .Net framework as well as how to..

Pragmatic Works: Designing your Data Warehouse Platform

[ March 2, 2011; 11:00 am to 12:00 pm. ] Speaker: Brian Knight
Topic: Designing your Data Warehouse Platform
Date: March 2, 2011 11:00 a.m. EDT
Find out how successful data warehouse projects are architected and designed. Brian 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 [...]

Pragmatic Works: Microsoft’s BI Stack: How to Choose a Technology

[ March 3, 2011; 11:00 am to 12:00 pm. ] Speaker: Mark Stacey
Topic: Microsoft’s BI Stack: How to Choose a Technology
Date: March 3, 2011, 11:00a.m. EDT

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, [...]

Pragmatic Works: Caching and Cache-Warming in Analysis Services

[ March 8, 2011; 11:00 am to 12:00 pm. ] http://pragmaticworks.com/Resources/webinars/Default.aspx?seoctl00_ContentPlaceHolder2_Webinarlist=page1

Caching and Cache-Warming in Analysis Services
Chris Web,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 ..

Pragmatic Works: Caching and Cache-Warming in SSAS

[ March 8, 2011; 11:00 am to 12:00 pm. ] Speaker: Chris Web
Topic: Caching and Cache-Warming in Analysis Services
Date: March 8, 2011 11:00 a.m. EDT

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 [...]

Cancelled DBA VC: Introduction to Change Data Capture

[ March 9, 2011; 10:00 am to 11:00 am. ] Date: March 9, 2011 — Cancelled due to speaker conflict

Noon Mountain time — http://www.timeanddate.com/worldclock/fixedtime.html?month=3&day=9&year=2011&hour=12&min=0&sec=0&p1=75

There will be a brief presentation by our sponsor.

Topic: Introduction to Change Data Capture – sponsored by Idera.

 

Presenter: Patrick LeBlanc

 

Abstract:

In this session Patrick will introduce the basic concepts for configuring Change Data Capture (CDC). He will explain how to [...]

Pragmatic Works: Implementing the New Fast Track 3.0 Architecture

[ March 9, 2011; 11:00 am to 12:00 pm. ] Speaker: Tom Pizzato
Topic: Implementing the New Fast Track 3.0 Architecture
Date: March 9, 2011 11:00 a.m. EDT

In this sessions join Tom Pizzato, 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, core calculator!

http://pragmaticworks.com/Resources/webinars/WebinarReg.aspx

Marathon Tech: Controlling SQL Server Sprawl

[ March 9, 2011; 11:00 am to 12:00 pm. ]

Controlling SQL Server Sprawl:
The Consolidation Conundrum and Always-On Imperative.

Reducing SQL Server Instances is Only Part of the Answer.

SQL Server sprawl describes far-flung SQL Server deployments scattered across an organization. SQL Server sprawl has many disadvantages, including management challenges, poor resource utilization, and high infrastructure costs.

Join fellow PASS member, [...]

Idera: Security, Performance and Mx Advantages to Using SPs over ORM Tools

[ March 9, 2011; 1:00 pm to 2:00 pm. ]

You’re invited! This Month’s Live Webcast:

Date:
Wednesday, March 9, 2011
Add To Calendar

Time:
2:00 PM – 3:00 PM CST

Speaker:
Jack Corbett, SQL Server DBA/Developer

Hosted By:
Idera | MSSQLTips

Security, Performance, and Maintenance Advantages to Using Stored Procedures over ORM Tools

In today’s environment many developers are extolling the merits of ORM tools like NHibernate, Linq to SQL, and Entity Framework. [...]

MSSQLTips: Security, Performance, and Maintenance Advantages to Using Stored Procedures over ORM Tools

[ March 9, 2011; 1:00 pm to 2:00 pm. ] Security, Performance, and Maintenance Advantages to Using Stored Procedures over ORM Tools

Date:
Wednesday, March 9, 2011

Time:
2:00 PM – 3:00 PM CST

Speaker:
Jack Corbett, SQL Server DBA/Developer

Hosted By:
Idera | MSSQLTips

In today’s environment many developers are extolling the merits of ORM tools like NHibernate, Linq to SQL, and Entity Framework. Jack will share the reasons why he still [...]

BI VC: Denali Column Store: Data Does the Twist and Analytics Shout

[ March 10, 2011; 10:00 am to 11:00 am. ] Thu Mar 10th 10AM EST Denali Column Store: Data Does the Twist and

Analytics Shout

URL:https://www.livemeeting.com/cc/usergroups/join?id=9CTG96&role=attend&pw=B%60HdjGm22

 

Topic Description:

A columnar data store is an implementation of the relational theory, but with a twist. The data storage layer does not contain records. Due to the variable column lengths within a row, a small column with low cardinality, or [...]

Pragmatic Works: Pimp Your Report

[ March 10, 2011; 11:00 am to 12:00 pm. ] http://pragmaticworks.com/Resources/webinars/Default.aspx?seoctl00_ContentPlaceHolder2_Webinarlist=page1

Pimp Your Report
Sherri McDonald

In this session Sherri McDonald will show you how to take an average looking report, add bling, and make it pimptastic. So put a feather in your hat and come for a good time

Pragmatic Works: Rock Your Report

[ March 10, 2011; 11:00 am to 12:00 pm. ] Speaker: Sherri McDonald
Topic: Rock your Report
Date: March 10, 2011 11:00 a.m. EDT

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.

http://pragmaticworks.com/Resources/webinars/WebinarReg.aspx

BI VC: Intro Microsoft’s Enterprise Data Info Mgt Products

[ March 11, 2011; 12:00 pm to 1:00 pm. ] RESCHEDULED TO FRIDAY – per email on Tuesday evening

Wed Mar 9th 12PM EST Introducing Microsoft’s Enterprise Data Information

Management Products

URL: https://www.livemeeting.com/cc/usergroups/join?id=Q9S2W7&role=attend&pw=nj%40rk8mrZ

Topic Description:

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.  [...]

BI VC: Governance Program using Master Data Services

[ March 14, 2011; 12:00 pm to 1:00 pm. ] Mon Mar 14th 12PM EST Governance Program using Master Data Services

URL: https://www.livemeeting.com/cc/usergroups/join?id=GG3RWB&role=attend&pw=hb3%7EBW%60%5Cz

Topic Description:

In this session we will focus on developing an Information Governance Program and how this can be delivered with Microsoft Master Data Services. Listed below are some of the key factors to a successful Information Governance Program. This session will focus on [...]

24 Hours of PASS (PASS Webcast)

[ March 15, 2011; ] http://www.sqlpass.org/Events/ctl/ViewEvent/mid/521.aspx?ID=546

The next 24 Hours of PASS event is taking place March 15 and 16. We are sticking to the two day format with 12 sessions presented each day.

Since March is also Women’s History month we’ll be carrying that theme through to the online event. As a result we plan to feature 24 prominent female speakers [...]

Pragmatic Works: Zero to Cube

[ March 15, 2011; 11:00 am to 12:00 pm. ] http://pragmaticworks.com/Resources/webinars/Default.aspx?seoctl00_ContentPlaceHolder2_Webinarlist=page1

0 to Cube
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 ..

Pragmatic Works: 0 to Cube

[ March 15, 2011; 11:00 am to 12:00 pm. ] Speaker: Adam Jorgensen
Topic: 0 to Cube
Date: March 15, 2011 11:00 a.m. EDT

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 [...]

tripass Chapter: Lightning Talks

[ March 15, 2011; 6:30 pm to 8:30 pm. ]  

(excerpt from Brett’s e-mail) Next March we are going to host our first ever Lightning Talks.  This meeting is going to consist of a series of 5 minute presentations given by YOU, our user group members, about anything at all SQL Server related.  I am sending out a call for speakers who have always wanted [...]

Pragmatic Works: Scaling a DW with EDW

[ March 16, 2011; 11:00 am to 12:00 pm. ] Speaker: Microsoft and HP Speakers
Topic: Scaling a Data Warehouse with EDW
Date: March 16, 2011 11:00 a.m. EDT

See how the EDW appliance infrastructure can scale your data load into the hundreds of terrabytes. Watch some amazing demos on how to load and scan trillions of records blazingly fast.

http://pragmaticworks.com/Resources/webinars/WebinarReg.aspx

BI VC: Working with Cube Writeback in SSAS

[ March 16, 2011; 12:00 pm to 1:00 pm. ] Wed Mar 16th 12PM EST Working With Cube Writeback in Analysis Services

URL: https://www.livemeeting.com/cc/usergroups/join?id=9PHGD3&role=attend&pw=HxK.-p%609T

Topic Description:

Many people will be familiar with Analysis Services cubes as a “read-only” experience, in that they effectively deliver rapid ad hoc access to data, and allow users to slice and dice to reveal the answers to their questions. This session explores [...]

Pragmatic Works: Perf Tuning the Cube

[ March 17, 2011; 11:00 am to 12:00 pm. ] http://pragmaticworks.com/Resources/webinars/Default.aspx?seoctl00_ContentPlaceHolder2_Webinarlist=page1

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 P..

Pragmatic Works: Performance Tuning the Cube

[ March 17, 2011; 11:00 am to 12:00 pm. ] Speaker: Brian Knight
Topic: Performance Tuning the Cube
Date: March 17, 2011 11:00 a.m. EDT

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. [...]

SQL Sat 70 – Columbia, SC

[ March 19, 2011; 8:30 am to 5:00 pm. ] SQL Saturday 70 will be in Columbia SC — a short drive from Raleigh. 

SQLSaturday is a training event for SQL Server professionals and those wanting to learn about SQL Server. This event will be held Mar 19 2011 at Columbia, SC. Admittance to this event is free, but we do charge a lunch fee of [...]

Zero to SSIS Class (5 day Paid)

[ March 21, 2011 to March 25, 2011. ] MVP Andy Leonard will be hosting another great SSIS training course — a 5 day opportunity in Virginia…

http://sqlblog.com/blogs/andy_leonard/archive/2010/12/23/announcing-the-next-from-zero-to-ssis-class.aspx

Pragmatic Works: BI Decaffeinated

[ March 22, 2011; 11:00 am to 12:00 pm. ] http://pragmaticworks.com/Resources/webinars/Default.aspx?seoctl00_ContentPlaceHolder2_Webinarlist=page1

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.

Pragmatic Works: HP BDA Appliance: Accelerating Decisions using SharePoint BI and PowerPivot

[ March 23, 2011; 11:00 am to 12:00 pm. ] Speaker: Mark Mortimore and Mark Stacey
Topic: HP BDA Appliance: Accelerating Decisions using SharePoint BI and PowerPivot
Date: March 23, 2011 11:00 a.m. EDT

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 [...]

BI VC: SSRS and Report Builder: Now that is self service

[ March 23, 2011; 12:00 pm to 1:00 pm. ] Wed Mar 23rd 12PM EST SSRS and Report Builder: Now that is self service

URL: https://www.livemeeting.com/cc/usergroups/join?id=9WCJHC&role=attend&pw=G%2C%7Czk3b%7EW

Topic Description:

Microsoft has made a huge push towards self-service. In the past most DBAs often find themselves in the role as a role Report Writer any addition to their normal tasks. With the advent of the new SSRS R2 reporting features [...]

Pragmatic Works: BI Decaffeinated

[ March 24, 2011; 11:00 am to 12:00 pm. ] Speaker: Jose Chinchilla
Topic: BI Decaffeinated
Date: March 24, 2011 11:00 a.m. EDT

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.

http://pragmaticworks.com/Resources/webinars/WebinarReg.aspx

March 2011 User Group Meeting – Parallel Data Warehouse

[ March 24, 2011; 6:00 pm to 8:30 pm. ] Meeting slides are now available for download.

March tripassBI meeting will be 24 Mar 2011 from 6:30-8:30.  Please register to ensure seating is available!

Location:

FM:Systems, Inc.
4515 Falls of Neuse Road, STE 420
Raleigh, NC  27609

Title:
SQL Server 2008 R2 Parallel Data Warehouse
Speaker:
Sergey Pustovit

Category:
SSAS

Abstract:
During this session we will go over the architecture of the new scale out solution [...]

Pragmatic Works: Deploying SSIS Packages

[ March 29, 2011; 11:00 am to 12:00 pm. ] Speaker: Jose Chinchilla
Topic: Deploying SSIS Packages
Date: March 29, 2011 11:00 a.m. EDT

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 [...]

Pragmatic Works: Performance Tuning the BI Platform

[ March 30, 2011; 11:00 am to 12:00 pm. ] Speaker: Brian Knight
Topic: Performance Tuning the BI Platform
Date: March 30, 2011 11:00 a.m. EDT

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 [...]