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

Calendar

Pragmatic Works: Intro to Variables and Expressions in SSIS

[ April 5, 2011; 11:00 am to 12:00 pm. ] http://pragmaticworks.com/Resources/webinars/Month.aspx/95

Speaker: Shawn Harrison
Topic: Intro to Variables and Expressions in SSIS
Date: April 5, 2011, 11:00 a.m. EDT
In this session, Shawn will demonstrate how to use variables and expressions to make SSIS Packages dynamic.

Pragmatic Works: Using Performance Point and Visio to Create Strategy Map

[ April 7, 2011; 11:00 am to 12:00 pm. ] http://pragmaticworks.com/Resources/webinars/Month.aspx/95

Speaker: Mark Stacey
Topic: Using Performance Point and Visio to Create Strategy Maps
Date: April 7, 2011 11:00 a.m. EDT
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 [...]

Pragmatic Works: Using Performance Point and Visio to create Strategy maps

[ April 7, 2011; 11:00 am to 12:00 pm. ] 04/07/2011 11:00 AM (EST)

Register

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

Pragmatic Works: .Net Revolutions

[ April 12, 2011; 11:00 am to 12:00 pm. ] http://pragmaticworks.com/Resources/webinars/Month.aspx/95

Speaker: Ben Evans
Topic: .Net Revolutions
Date: April 12, 2011, 11:00a.m. EDT
Take the red pill and step down the rabbit hole with Robert Harris, and Benjamin Evans 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 [...]

AppDev VC: Building Applications that a DBA will Love (with Andy Warren)

[ April 12, 2011; 12:00 pm to 1:00 pm. ] Building Applications That A DBA Will Love
April 12, 2011, 12 PM Eastern
Presenter: Andy Warren
http://appdev.sqlpass.org

It’s natural for the focus to be on the end user when we build applications, but it’s important and worthwhile to build into our design some things that make it easier for the DBA to provision, tune, and support the product we [...]

DBA VC: Server Consolidation – Using Virtualization, Lessons Learned & Roadmap – sponsored by Idera

[ April 13, 2011; 2:00 pm to 3:00 pm. ] Date: April 13, 2011
Noon Mountain Daylight time — http://www.timeanddate.com/worldclock/fixedtime.html?month=4&day=13&year=2011&hour=12&min=0&sec=0&p1=75

Topic: Server Consolidation – Using Virtualization, Lessons Learned & Roadmap – sponsored by Idera.

Presenters: Lindsey Allen & Prem Mehra

Abstract:
Please attend this session for a comprehensive understanding of SQL Server consolidation using virtualization and available tools to help you plan, deploy, and manage [...]

Pragmatic Works: Using Visio Services to Visualize Data in SharePoint

[ April 14, 2011; 11:00 am to 12:00 pm. ] http://pragmaticworks.com/Resources/webinars/Month.aspx/95

Speaker: Mark Stacey
Topic: Using Visio Services to Visualize Data in SharePoint
Date: April 14, 2011 11:00 a.m. EDT
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 [...]

TRIAD User Group Meeting: Deploying Visual Studio 2010 Database Projects

[ April 14, 2011; 6:00 pm to 8:00 pm. ] Topic:
Deploying Visual Studio 2010 Database Projects
Date:
Thursday; April 14, 2011
Speaker:
Kevin Goode

Contact URL: http://www.goodesql.com

Kevin has15 years of IT experience, 12 years of which has been SQL Server focused starting with version 6.5. I have worked in many industries including manufacturing, distribution and logistics, financial services, IT outsourcing [...]

BI VC: Efficient and effective processing of OLAP CUBES with AMO and XMLA

[ April 15, 2011; 12:00 pm to 1:00 pm. ] Fri April 15th 12PM EST (US)
Efficient and effective processing of OLAP CUBES with AMO and XMLA
Speaker: Steve Simon

URL: https://www.livemeeting.com/cc/usergroups/join?id=RPN4J9&role=attend&pw=J%25%7E*7r%229d

Topic Description:
Within the financial industry, rapid and effective decision making is critical to our client relationships. Analytical tools such as OLAP cubes help make this a reality. In many 24 X 7 [...]

April 2011 User Group Meeting

[ April 16, 2011; 8:30 am to 3:30 pm. ]

April tripassBI meeting will start our learning bucket on Report Building.  It will be Saturday – 16 Apr 2011 from 8:30-3:30.  (originally the 23rd which was Easter weekend. Feb mtg attendees voted to move to 16th)

Please Register Here!  Space will be limited on a first come basis.  Lunch will be provided by sponsors.

Topic: Introduction to [...]

Pragmatic Works: Understanding Site Wikis on SharePoint 2010

[ April 19, 2011; 11:00 am to 12:00 pm. ] http://pragmaticworks.com/Resources/webinars/Month.aspx/95

Speaker: Veronique Palmer
Topic: Understanding Site Wikis on SharePoint 2010
Date: April 19, 2011 11:00 a.m. EDT
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 [...]

tripass User Group Mtg: What’s New in SQL Server 2011 (Denali)

[ April 19, 2011; 6:30 pm to 8:30 pm. ] Our sister chapter – triPass is meeting on Tuesday, April 19.  Jason Hall and Steve Wright with SQL Sentry will be presenting “What’s New in SQL Server 2011 (Denali)”.  This session will cover all of the new features coming our way in the next major version of SQL Server.  So be sure not to miss out on what’s coming down [...]

BI VC: Designing Cubes for Performance

[ April 20, 2011; 12:00 pm to 1:00 pm. ] Wed April 20th 12PM EST(US)
Designing Cubes for Performance
Speaker: Stacia Misner

URL: https://www.livemeeting.com/cc/usergroups/join?id=FCK6BC&role=attend&pw=49%3Esn%3DDfs

Topic Description:
Building a cube is simple. After all, you have a lot of wizards at your disposal to do the development work. But building a cube that delivers data quickly requires you to make additional changes to the database design. [...]

Pragmatic Works: Reporting Services- Dissecting the Tablix

[ April 21, 2011; 11:00 am to 12:00 pm. ] http://pragmaticworks.com/Resources/webinars/Month.aspx/95

Speaker: Joe Salvatore
Topic: Reporting Services- Dissecting the Tablix
Date: April 21, 2011 11:00 a.m. EDT
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 [...]

DataArch VC: Database Normalization

[ April 21, 2011; 1:00 pm to 2:00 pm. ] http://dataarch.sqlpass.org

Subject: Database Normalization
Start Time: Thursday, April 21, 2011 12:00 PM US Central Time (6:00 PM GMT)
End Time: Thursday, April 21, 2011 1:00 PM US Central Time (7:00 PM GMT)
Presenter: Thomas LeBlanc (blog|@TheSmilingDBA)
Live Meeting Link: https://www.livemeeting.com/cc/usergroups/join?id=28NR92&role=attend&pw=PTSs%26%5E%282Z
Database Standards SOP
Join Normalization nut Thomas LeBlanc for a review of a standard operating procedure used [...]

ProfDev VC: Networking to Build Your Professional Connections

[ April 21, 2011; 1:00 pm to 2:00 pm. ] Online: *** April 21, 10:00 AM PDT / 1:00 EDT ***

April Meeting Link

Networking to Build Your Professional Connections

Webinar by Don Gabor for the PASS Professional Development Virtual Chapter

Networking—everyone’s doing it, but are you getting the results you want? Whether you want to move up in your company, consult on your own or make professional [...]

Pragmatic Works: Mastering SharePoint Permissions

[ April 26, 2011; 11:00 am to 12:00 pm. ] http://pragmaticworks.com/Resources/webinars/Month.aspx/95

Speaker: Veronique Palmer
Topic: Mastering SharePoint Permissions
Date: April 26, 2011 11:00 a.m. EDT
SharePoint 2007 and 2010 permissions are similar but 2010 has better built in reporting tools. This session will show you how this works as well as explain some traps when creating sites and exercising item level permissions.

BI VC: Developing Date and Role-Playing Dimensions

[ April 26, 2011; 12:00 pm to 1:00 pm. ] Tues April 26th 12PM EST(US)
Developing Date and Role-Playing Dimensions
Speaker: Sandra Mueller

URL: https://www.livemeeting.com/cc/usergroups/join?id=RKQD4F&role=attend&pw=7%60%27HmS%275b

Topic Description:
Let’s go from Cradle to Grave with the one dimension in 99.99999% of cubes, the dreaded Date dimension. Without this dimension users wouldn’t know if it is worth staying open on a holiday or which day of [...]

AppDev VC: Characteristics of a Great Relational Database

[ April 26, 2011; 8:00 pm to 9:00 pm. ] http://appdev.sqlpass.org

Characteristics of a Great Relational Database
April 26, 2010, 8 PM Eastern
Presenter: Louis Davidson
Attendee URL: LiveMeeting

When queried, most database professionals would mention normalized as one of the most important characteristics that tell the difference between a good and bad database design. I won’t disagree in the least, but there is so much more to be considered. [...]

BI VC: Tuning Analysis Services Processing Performance

[ April 27, 2011; 12:00 pm to 1:00 pm. ] Wed April 27th 12PM EST(US)
Tuning Analysis Services Processing Performance
Speaker: John Welch

URL: https://www.livemeeting.com/cc/usergroups/join?id=HH5D8J&role=attend&pw=cpzkD%3CF4x

Topic Description:
You’ve got your Analysis Services cube created, and deployed in production. However, you notice that every night, the cube is taking longer and longer to process, and users are starting to complain about their data not being [...]

DBA VC: Getting to know your DB

[ April 27, 2011; 12:00 pm to 1:00 pm. ] April 27th, Noon Eastern

http://dba.sqlpass.org/

Jason Brimhall will present “Getting to know your DB”

SQL Lunch: SQL Azure Performance

[ April 27, 2011; 12:30 pm to 1:30 pm. ] #49-SQL Azure Performance
Speaker: Scott Klein

http://www.sqllunch.com/Default.aspx

Date and Time: 4/27/2011 11:30:00 AM CST

BIO: Scott Klein is co-founder of Blue Syntax Consulting, a company that specializes in Azure training and consulting. Scott is also a veteran author, having written a number of books including Professional SQL Server XML, Professional LINQ, Pro ADO.NET Entity Framework 4.0, and the [...]

Pragmatic Works: Business Intelligence in SharePoint 2010

[ April 28, 2011; 11:00 am to 12:00 pm. ] http://pragmaticworks.com/Resources/webinars/Month.aspx/95

Speaker: Brian Knight
Topic: Business Intelligence in SharePoint 2010
Date: April 28, 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 [...]

Oracle VC: Table Partitioning in Oracle RAC Environment – Design and Deployment Techniques

[ April 29, 2011; 11:00 am to 12:00 pm. ] Next Meeting
Topic:
Table Partitioning in Oracle RAC Environment – Design and Deployment Techniques

Date:
Friday, April 29, 2011
11:00AM EDT

Speaker:
Deepak Wadhwa
Vice-President
State Street Corporation

Location:
https://www.livemeeting.com/cc/UserGroups/join?id=R529W7&role=attend

Overview:
Sponsor: Table Partitioning in Oracle RAC Environment – Design and Deployment Techniques

Table partitioning [...]

BI VC: Creating dynamic calculations using DAX formulas in PowerPivot

[ April 29, 2011; 12:00 pm to 1:00 pm. ] Fri April 29th 12PM EST(US)
Creating dynamic calculations using DAX formulas in PowerPivot
Speaker: Javier Guillen

URL: https://www.livemeeting.com/cc/usergroups/join?id=SZSB5Q&role=attend&pw=BdD%5B_7.%2CG

Topic Description:
Data Analysis Expressions (DAX) is the expression language used to create custom calculations in PowerPivot. In a similar way to MDX, it can evaluate an expression in different ways depending on the context in which [...]