Featured Post

SQL Server 2008 R2 Hosted Trial

For those of you whom haven’t the time or resources to load a copy of SQL Server 2008 R2 yet to play around with it …they have a set of virtual labs set up that you can sign up for and be able to kick the tires out a bit. SQL Server 2008 R2 – Multi Server Management SQL Server 2008 R2 – PowerPivot...

Read More

Kendra Little is Psyched About #SQLSAT51 in Nashville

Posted by Arie | Posted in Events, Featured | Posted on 29-07-2010 | Viewed: 43 views

Tags: , , ,

0

Check out Kendra’s post here to see how cool you could possibly feel just by attending this free event! Plus, it’s a good introduction to the plethera of culture that is available in the Nashville area. ……Well, and I will be speaking there too :)

http://littlekendra.com/2010/07/28/sqlsat51_nashville/

Cheers!
AJ

Help Build the SQL Rally Selection Process.

Posted by Arie | Posted in Community | Posted on 29-07-2010 | Viewed: 91 views

Tags: , , , , ,

5

SQLAndy blogged about the possible selection process which you can read about from the link below:

SQLAndy’s Blog Post

I like what PASS is trying to do with adding events and trying to make PASS more relevant to the DBAs that are out in the field. However, there are a couple of suggestions that seem to be off a little…..

Pre-Con/Post-Con Sessions

Paying the speakers is nice but limiting it to someone who has presented at PASS Summit before but has not done a Pre-Con/Post-Con at PASS and submitting only one seems too restrictive. I like that they want something of a more thorough abstract/lesson plan guide because I think it makes the speakers ‘think’ a little more about what they are going to do.

Main Sessions

  1. Require speakers to have spoken at the PASS Summit or a SQLSaturday in the past 24 months to be eligible.

Really? Only at PASS events…..Hmmm, like the CodeCamp that they have every year in South Florida doesn’t count or the Rocky Mountain Tri-Fecta in Colorado…

2. Must have presented the topic at least one time prior to submitting it

What about new releases? Guess when this comes around next year not to expect any 2011 talks :)

3. Must upload the deck (doesn’t have to be final) at time of submission.

I don’t like promoting uploading of decks. I myself don’t like decks. That’s why I think I am a good speaker in that I show people technology and teach them the ins and outs without inundating them with slides. People normally come to my sessions because they want to ‘see’ how they can incorporate a technology or a technique into their environment…..Maybe I get that from teaching too much Physics with lots of breaking stuff in demonstrations:)

4. Can submit a max of ?? (2? 4?) presentations

I guess this would be fine but it would need to be 4 instead of 2….Otherwise, the selection committee gets to see the other end of the spectrum….400 Reporting Services submissions…and 12 on other topics:)

 

Don’t get me wrong….I think what they are doing is a good thing…and good for Andy that he is pushing it! However, it is almost like they are playing things really safe and in order to create something vibrant and unique you have to take risks.

I remember the first time that I went to DevConnections, yes Virginia there are other events other than PASS events, there was a really lousy session on programming mobile applications….I mean GOD AWFUL! Yet, I don’t tell my friends about that session ….instead I tell them about Scott Guthrie’s awesomesauce session and how I got to talk directly with him and Matt Nunn afterwards….

So I really think that they need to start going out on a limb a little with these things because in the end, if a handful of sessions were bad then hopefully the truely outstanding ones will make up for it.

Does this mean that the SQLRally needs to become another version of a SQLSaturday free-for-all? Nope! You can do things to limit your downside. Maybe like….

  1. Submit Extended Abstracts for all presentations
    1. Abstract (good paragraph not the ‘I will demo SSRS’)
    2. Lesson Plan Outline – What will you cover and how
  2. Submit and Extended Speaker Form
    1. Regular speaker credentials – Name, Bio, Contact Stuff
    2. Session Presented with Events(how many attended)  and also maybe contact info
    3. Links to other credible things (blogs, books, etc.)

Yeah, you may still get 1000 submissions but surely you could get a couple of people to go through the speakers to do a first pass and weed out the ‘weak cheese’.  I know it laborous and probably a little boring once you hit the 100th SSRS intro ….But I remember specifically in one of my Physics classes that one student asked me why she got marked off for her experiment write-up, I told her, and her response was ‘You mean you actually read all this stuff’…..YES DAMNIT I DO.

Maybe we could use this as an excuse to come up with some sort of cool Silverlight application that the Selection Committee could use. Hmmmm…something like

1. Browse by Speaker

2. Browse by Topic

3. Browse by Track

4 Drag & Drop into Favs Folder

Sounds very intriguing to me :)

Anywho, Good Luck to Andy and the PASS group in getting this thing off the ground!

Cheers!
AJ

Transactional Replication Deep Dive Webcast for PASS DBA Virtual Chapter

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

Tags: , , , ,

0

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

SSRS 2008 R2 Webcast for XRMVirtualUserGroup ( @xrmvirtual )

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

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 | Viewed: 51 views

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