Featured Post

Rockstar Blog Rankings

I keep running across these badges on other blog sites referring to the Rockstar Rankings that Thomas LaRock puts out and have always thought it was a great idea to get people blogging about stuff.  So in an attempt to motivate myself just a wee bit more in keeping up with the both my blogs (SQLSherpa.com...

Read More

CRAZY! You Can Haz More Free Training in September in Indianapolis! #sql

Posted by Arie | Posted in Events, Featured | Posted on 19-08-2010

Tags: , , , , , , , , ,

1

It’s true! Come Saturday September 25th ,2010 Perpetual Technologies, my parent company, is putting on an ALL DAY free training event for both Microsoft and Oracle people in the Indianapolis area! This is our 3rd annual event and has finally been moved to a Saturday so that more people from the adjoining areas(Cincinnati, Chicago, Ft. Wayne, Louisville, Evansville. etc.) can attend!

You can sign up to attend here: https://events.perptech.com

This year’s event is going to be sweet as it contains a SQL Server track, Developer track, Platform track, and an Oracle track with an awesome lineup of speakers such as:

Joe Carver  -  Microsoft

Hope Foley  – PTI

Eddie Wuerch  – Exact Target

Kyle Neier  -  Herff Jones

Robert Bogue  -  Thor Projects LLC   <—Yeah! That guy!

Arie Jones   -  PTI   <—Yeah! That @&^&@#!

Vance Upshaw   -  PTI

Dave Leininger  – DEFENDER Direct, Inc   <—Him too?

Scott Archer – VMWare

Erik Ives & Scott Singer  – Utility Financials Consulting

Chris Ruel  – PTI

 

Cheers!
AJ

 

BackToSchool10Flyer

SSRS 2008 R2 Webcast for XRMVirtualUserGroup ( @xrmvirtual )

Posted by Arie | Posted in Featured, Presentations | Posted on 29-07-2010

Tags: , , , , , , , , , , ,

0

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

SQL Saturday #51: Nashville ( #sqlsat51 )

Posted by Arie | Posted in Events, Featured | Posted on 27-07-2010

Tags: , , , , , , ,

1

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

SQL Server Saturday – Louisville

Posted by Arie | Posted in Community | Posted on 26-10-2009

Tags: , , , , ,

0

I had a great time presenting at the SQL Server Saturday event in Louisville over the weekend. Thanks to all of the people whom volunteered their time to put it on as I think that everyone there generally enjoyed themselves. Attendance was good and the crowd seemed to be fairly attentive. I did hear a couple of people saying that their brain hurt so maybe the session could have been a little longer to allow everyone’s brain to expand slowly:)

For everyone that wanted to grab my slides and samples there are attached below…

Cheers!

AJ

SQL Saturday #23 – Louisville,KY

Posted by Arie | Posted in Community | Posted on 13-10-2009

Tags: , , , , , , , , ,

0

Just a quick hit to let everyone know again that I will be speaking at the SQL Saturday event in Louisville,KY on October 24th! If you haven’t signed up for the event then make sure you get onto the SQL Saturday site and do so today. It should be a great day to learn some interesting aspects of SQL Server.  So people in the adjoining region should be looking to come on by. If they have enough space and rooms available then I may even be talked into doing a couple of impromptu sessions…like Jim Cramer’s Lightning Round! Maybe on some cool new features of 2008 or maybe even some handy ones like customizing transactional replication! Here is the current line up:

Track

Starts

Session Title

Speaker

Track 2

04:15 PM

Analysis Services 2008 End-to-End

Craig Utley

Track 2

11:15 AM

Attunity CDC: Enabling the Real-Time SSIS Story

Derek Comingore

Track 1

11:15 AM

Comparing Clustering Methods

Alexander Prusakov

Track 1

09:00 AM

Demystifying Transact-SQL

Jason Follas

Track 2

03:15 PM

Do It Right: Best Practices for Analysis Services

Craig Utley

Track 2

09:00 AM

ETL from the Trenches: SSIS in the Real World

Dave Fackler

Track 1

03:15 PM

Powershell in SQL Server 2008

Arie Jones

Track 2

01:15 PM

Project Gemini

Derek Comingore

Track 1

01:15 PM

Scalable SQL Server Virtualization

Sarah Barela

Track 1

04:15 PM

SQL Server 2008: Extended Events

Arie Jones

Track 2

10:15 AM

SSRS in SQL Server 2008 R2 (Kilimanjaro)

Dave Fackler

Track 1

10:15 AM

the XML Capabilities of SQL Server 2008

Jason Follas

Track 1

02:15 PM

Tuna Helper – Proven Process for Tuning SQL

Janis Griffin

Track 2

02:15 PM

Why Data Warehousing Projects Fail

Craig Utley

 

Cheers,
AJ