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

Calendar

Pragmatic Works: Data Cleansing in SSIS

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

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.

Pragmatic Works: Change Data Capture with SSIS

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

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.

TechNet: Best Practices for Deploying Itron Applications on SQL Server

[ February 3, 2011; 2:00 pm to 3:00 pm. ] https://msevents.microsoft.com/CUI/WebCastEventDetails.aspx?EventID=1032471025&EventCategory=4&culture=en-US&CountryCode=US
TechNet Webcast: Best Practices for Deploying Itron Applications on SQL Server (Level 200)
Event ID: 1032471025

Language(s): English.

Product(s): Microsoft SQL Server 2008 R2.

Audience(s): IT Decision Maker, IT Generalist.

Event Overview

Join us for this webcast as we share the best practices for deploying Itron applications on Microsoft SQL Server 2008 data management software. We talk in [...]

Pragmatic Works: Building your 1st SSRS Dashboard

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

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

Idera: Security, Perf & Mx Adv to SPs over ORM Tools

[ February 9, 2011; 3:00 pm to 4:00 pm. ] http://www.idera.com/Events/SQL-server-Webcasts/

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. Jack will share the reasons why he still believes that stored procedures are the best way to access data in SQL Server. When the [...]

Pragmatic Works: Intro to SSRS

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

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.

Pragmatic Works: Zero to SSIS

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

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.

Pragmatic Works: Developing BI solutions faster with BI xPress

[ February 16, 2011; 11:00 am to 12:00 pm. ] Register Here:  http://pragmaticworks.com/Resources/webinars/Month.aspx/93

Topic Summary:

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.

Developing BI solutions faster with BI xPress
Featuring:
Shawn Harrison

Secrets of SQL: Improving Performance By Scaling Out With Transactional Replication

[ February 16, 2011; 3:00 pm to 4:00 pm. ] Secrets of SQL Monthly Webcast Series

Improving Performance By Scaling Out With Transactional Replication

As databases grow larger in both size and usage scaling out becomes a natural design evolution to improve performance and availability. This presentation will make the case for using transactional replication as one good way to do this. We’ll look at how transactional [...]

Pragmatic Works: Building SSRS Reports on your Cube

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

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

Pragmatic Works: SSAS Security

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

SSAS Security
Devin Knight

In this session you will learn how you can use Roles to add security to your Analysis Services data. You will see how to add basic security as well as more advanced options like dynamic security

MSSQLTips: Managing SQL Server Source Code

[ February 22, 2011; 11:00 am to 12:00 pm. ] Join MSSQLTips.com on Tuesday, February 22 @ 11am EST (4pm GMT)

Live Webinar: Managing SQL Server Source Code

Now is the time to properly manage source code in SQL Server. Put an end to the chaos and stress of having to manage source code in a haphazard manner. Source control for application code has been the norm [...]

AppDev VC: Service Broker in the Real World

[ February 22, 2011; 8:00 pm to 9:00 pm. ] http://www.sqlpass.org/Events/ctl/ViewEvent/mid/521.aspx?ID=545

This session will discuss some of the techniques used to successfully implement two very different Service Broker implementations.

Service Broker in the Real World

Service  Broker is a largely unknown, and sometimes misunderstood, capability within the SQL Server product.  This session will discuss some of the techniques used to successfully implement two very different Service Broker implementations. How Service Broker’s [...]

Pragmatic Works: Taking SSIS to the Next Level with Task Factory

[ February 23, 2011; 11:00 am to 12:00 pm. ] Register Here:  http://pragmaticworks.com/Resources/webinars/Month.aspx/93

Topic Summary:

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.

Taking SSIS to the Next Level with Task Factory
Featuring:
Patric Leblanc

SQL Mag: SQL Remote Avail: Problems & Solutions

[ February 23, 2011; 12:00 pm to 1:00 pm. ] Featured LIVE Web Seminar:
SQL Server Remote Availability: Problems and Solutions that Work
Wednesday, February 23, 2011 @ 12pm ET

Maintaining business continuity

What would happen to your data if a system-wide failure occurred? What about if you lost an entire data center? Could business still carry on without interruption, or would productivity be brought to a screeching halt?

Attend [...]

DBA VC: Tips & Tricks for Writing Better Queries with Joe Webb

[ February 23, 2011; 12:00 pm to 1:00 pm. ] Date: February 23, 2011

Noon Eastern time

Topic: Tips and tricks for Writing Better Queries– sponsored by Idera.

Presenter: Joe Webb

Abstract:

Transact-SQL is not a very difficult language to learn. As long as the syntax is correct, it can be quite forgiving. However to truly get the best performance from your SQL Server, careful consideration should [...]

BI VC: Multidimensional Reporting: MDX Essentials

[ February 23, 2011; 12:00 pm to 1:00 pm. ] Wed Feb 23rd 12PM EST Multidimensional Reporting: MDX Essentials

for Report Design

URL: https://www.livemeeting.com/cc/usergroups/join?id=3727KK&role=attend&pw=z%60qBcTm8N

Topic Description:

Learn the fundamentals of MDX query design for Analysis Services cubes. Migrate your SQL skills to this simple and elegant language that will enable you to unlock the awesome power of a cube and to gain deep insight from a [...]

February 2011 User Group Meeting – SSRS Administration

[ February 24, 2011; 6:00 pm to 8:30 pm. ] February tripassBI meeting will be 24 Feb 2011 from 6:30-8:30.  As space is limited please REGISTER to attend!

All — we have a location for our first meeting.  This will be a PLANNING meeting, we will not have a featured topic or speaker.  The intent of the meeting is to explain the concept of the user [...]