Programmer's Edge

The webcast recording is up for my presentation to the XRM Virtual User’s Group on SSRS 2008 R2 in CRM. In it I go over some of the new features as well as some gotchas for people looking to upgrade to the newer version. 

http://www.xrmvirtual.com/events/ssrs_crm

Thanks to Julie Yack et all for putting everything together!

Cheers,
AJ

SQLSaturday #51 Nashville is coming up this weekend and it looks like it is going to be great. Where else are you going to get totally FREE training in the Nashville area? Slide decks are ready to go and I am just now trying to create some more awesome demos for my presentation on Change Data Capture. I will be sure to chock it full of tons of sneaky ninja DBA tricks that you can use in your environment to make yourself look like a pro!

You could be cool like all the people who are already going!

Registration is still open here so sign up and quit procrastinating .

Cheers!
AJ

I will be giving a presentation to the PASS DBA Virtual Chapter on Aug 11,2010. Be sure to attend as they are giving away $50.00 Amazon gift card! The details are below so be sure and sign up!

Event Link:   http://www.sqlpass.org/Events/ctl/ViewEvent/mid/521.aspx?ID=457

Date:
8/11/2010

Start Time:    
12:00:00 PM

End Time:    
1:00:00 PM

Timezone:    
(GMT-07:00) Mountain Time (US & Canada)

Short Description

DBA Virtual Chapter Live Meeting Event

Event Description

Topic: Transactional Replication Deep Dive (presented by Arie Jones) and What a DBA Needs to Know About Data Modelling (Sanjay Shirude)

Presenter: Arie Jones

Abstract:

Transactional Replication is often one of those black box features where if you are using the wizard in a standard implementation then you are fine. Yet, what do you do when you have to do something like transactional replication across non-trusted domains. In this session, we will discuss the internals of transactional replication, how it works, and what you can do to manage your implementations more effectively by understanding what going on underneath the covers.

Presenter Bio:

Arie "AJ" Jones is Principal Technology Manager for Perpetual Technologies, Inc. (PTI) in Indianapolis, Indiana. PTI provides mission-critical database and information systems support for SQL Server and Oracle environments nationwide. Arie leads PTI’s team of experts in planning, design, development, deployment, and management of database environments and applications to achieve the best combination of tools and services for each client. He has authored several books on SQL and related topics including Learn SQL in 24 Hours, Learn SQL in 1 Hour a Day, SQL Functions, and Live Lessons: SQL as well as maintaining the popular web blogs: programmersedge.com and sqlsherpa.com

Cheers!
AJ

Okay, so I will be presenting another webcast on SQL Server 2008 R2 Features….this time specifically with a slant towards CRM for the XRMVirtualUserGroup on Aug 26th,2010.

SSRS in CRM with Arie Jones

Join Arie Jones, Principal Technology Manager of Perptech, as he shares with us what’s new in SSRS 2008 R2. This session will cover reporting basics and will have some deeper technical content as well. System customizers, power user, DBAs, developers, technical users, numbers people (pretty much anyone USING or MAKING CRM) will learn a great deal in this session.

**** Please note the timezone below !!!

**** PST = Pacific Standard Time   PST <> Pretty Standard Time

Schedule:

• SSRS in CRM
  8/26/2010 9:00:00 AM (PST) – 8/26/2010 10:00:00 AM (PST)

You can Register here!

 http://www.xrmvirtual.com/events/ssrs_crm

For those of you that don’t know the XRMVirtualUserGroup(http://www.xrmvirtual.com/ ) covers all things related to XRM(CRM) and is coordinated by the (in)famous Julie Yack(MVP) (http://julieyack.com/)  from an undisclosed location deep in the Colorado mountainside. The virtual group is fairly large I believe with over 1000 members internationally…….so you may be asking yourself why you haven’t joined yet??…….yes, it is because you are a noob so stop wasting time and just do it!

Cheers,
AJ

Well, I will be seeing everyone in Nashville at the SQL Saturday #51. My session will be on Monitoring Data Changes With Change Data Capture so I am already checking into trying to do some kind of really crazy type of demo to really underpin the technology and the speed and resourcefulness that it brings to the DBAs arsenal…Mwahahahahaha!..(cough)..excuse me. Anywho, Perpetual Technologies, Inc (PTI), my employer is also a sponsor of the event so look for me to be by the table at least part of the day….I am thinking that I will maybe blog all day about the event in a series of miniblogs …..have to tie that in to twitter maybe by using the hashtag in the title…Hmmmm….

Or maybe the lunch room will be free and I will just do some ad hoc stuff…..that would be pretty cool as well….in any case, it should be a really good time….So if you haven’t signed up yet then be sure to do so or risk being labeled a LAMO!

Here’s the whole schedule below….A little messy but hey you can only do so much with cut and paste:)

Start Time
Business Intelligence
Cafeteria
Database Administration
Database Development
Professional Development
Session Mix

08:30 AM
Rafael Salas
Planning your ETL architecture with SSIS
Thomas LaRock
DBA Survivor
Aaron Nelson
The Dirty Dozen: PowerShell Scripts for Busy DBAs
Daniel Evans
EPM using R2 and SharePoint 2010
John Welch
Creating Custom Components for SSIS
Alan Brewer
SQL Server 2008 R2 Utility and Data-tier Apps

9:45 AM
Douglas McDowell
Realizing ROI for Business Intelligence Projects
Allen White
Gather SQL Server Performance Data with PowerShell
William Pearson
Design and Implement Like Edison!
Stuart Ainsworth
The Social DBA: Resources for Career Building
Andy Leonard
Database Design for Developers

11:00 AM
Wayne Snyder
Information Visualization – Designing great Charts
Jason Strate
Are You Following Your Own Best Practices?
Hope Foley
Working with Spatial Data in SQL Server 2008
Mark Tabladillo
Data Mining with PowerPivot 2010
Jeremiah Peschka
Fundamentals of SQL Server Internals

12:15 PM
Kevin Kline
Keynote

01:00 PM
Craig Utley
Analysis Services 2008 End-to-End
Arie Jones
Monitoring Data Changes with Change Data Capture
Dan Crawford
SQL Server Service Broker
Jack Cannon
From Access To SQL Server
Glenn Berry
DMV Emergency Room!

02:15 PM
Jessica Moss
Make Reporting Services Work For You
Kendra Little
Take the Awesomeness Home: the Data Collector
Kevin Boles
Common TSQL Mistakes
Andy Warren
Building a Professional Development Plan
Brian Kelley
Fortress SQL Server

03:30 PM
Barry Ralston
Introduction to MDX for SQL Programmers
Thomas LaRock
What Are You Waiting For?
Robert Cain
Data Dude – Making DB developers more productive
Drew Minkin
Data Mining in Action: A case study
Andy Warren
Introduction to SQL Server Statistics

4:45 PM
Experts Panel
Stump the "Experts"

Cheers,
AJ