My name is Arie Jones the Principal Technology Manager for Perpetual Technologies,Inc.
In: SQL Server
2 Apr 2012
Sorry for the delay everyone. Looks like my blog had an issue with pre-scheduled postings. Below you can find the links to all of the recordings from our SQL Server 2012 Firestarter Series just in case you missed them. I will be updating the posting here to keep them coming once new videos are posted to the LiveMeeting service.
We still have plenty of webcasts coming up as well. So if you want to see them feel free to sign up!
The webcast series has completed…BUT you can still see the content by following the links below!
http://www.pti.net/Firestarter/
Previous Webcasts
Cheers!
AJ
Thanks to everyone that attended the presentation last night! It was really great to have everyone there and engaged in the conversation. Also great to see some old comrades as well.
Below you will find the link to my slides and the content from the presentation. Remember that some of the things to consider when setting up the report package.
1. Remember to change the location for the files on the Auditing DB. Please pay attention to the script as it will create secondary files for each month…so there are a few of them. Make sure you have the space available for them or modify the script.
2. Remember that there are store procedures that are run in order to fill the aggregate tables that are not necessarily contained in the SSIS package. Plus, the default behavior is to aggregate the previous days data. If you want it to do the current date then you will need to either pass it a date+1 or modify the stored procs. Remember, however, to take into consideration edge cases…such as if the package runs every thirty minutes then what happens with the stuff from 11:30pm-12:00am when it runs at 12:00am?
Cheers!
AJ
In: SQL Server
26 Jan 2012Well, PTI is ramping up for the release of SQL Server 2012 which is coming out the first half of this year and in order to help get the community up to speed we are putting on TWO MONTHS worth of weekly webcasts based on all of the new goodies that are coming out with the SQL Server 2012 platform! I have been working with the bits now for the past nine or so months and this is going to be a very exciting release. The first one starts next week so sign up now!
Click Here -> http://pti.net/Firestarter/
Here’s the lineup….
2/2/2012 11:00 AM
Master Data Services in SQL Server 2012 (More Info)
2/9/2012 11:00 AM
Utilizing Knowledge with Data Quality Services in SQL Server 2012 (More Info)
2/16/2012 11:00 AM
Throwing T-SQL 2012 Enhancements Against the Wall (More Info)
2/23/2012 11:00 AM
Enhancements to Reporting Services in SQL Server 2012 (More Info)
3/1/2012 11:00 AM
AlwaysOn – Way to get your 9′s? (More Info)
3/8/2012 11:00 AM
SSIS 2012 – New and Improved (More Info)
3/15/2012 11:00 AM
PowerPivot & BISM in SQL Server 2012 OH MY! (More Info)
3/22/2012 11:00 AM
SSAS 2012 – What BISM Means to You! (More Info)
3/29/2012 11:00 AM
Extended Events – The Death Knell of SQL Trace (More Info)
Here’s the speakers
Arie Jones
Arie Jones ‘AJ’ is the Principal Technology Manager for Perpetual Technologies, Inc. in Indianapolis Indiana. Arie has over 10 years experience in SQL Server, Oracle, and .NET development. His main role consists of providing clients with high level BI, database, and application development solutions while mentoring PTI’s extensive staff of consultants on new technologies. Additionally, AJ is an avid community speaker, has written several books such as “Learn SQL in 24 Hours”, blogs extensively at http://www.programmersedge.com , and is the one of the PASS Regional Mentors for the Midwest .
Presenting: Master Data Services in SQL Server 2012, Utilizing Knowledge with Data Quality Services in SQL Server 2012, Testing event timing
Hope Foley
Hope has over 11 years experience in the IT world, she has worked across many industries including small business enterprises, start ups, and Fortune 500 companies, and has a vast knowledge of database design, administration and support, data warehousing and data mining, and custom database solutions. Hope joined PTI in 2007 as a SQL Server Database Administrator/Analyst, and last year took over as Principal Microsoft Consultant, where she now leads a team of expert Database Administrators and Developers. Hope is an active member within the SQL Server community, and is often asked to present at IT events both locally and on a national level. Hope blogs at http://hopefoley.wordpress.com/ and can be followed on Twitter @hope_foley
Presenting: Enhancements to Reporting Services in SQL Server 2012, PowerPivot & BISM in SQL Server 2012 OH MY!
Kyle Neier
Kyle has been working with computers professionally since 1995 in both a development and administrative capacity. For over 10 of those years, SQL Server has been the focus of both a professional and personal passion. Kyle has worked in online retail, manufacturing, EMR software, and pharmaceutical industries. Kyle joined PTI in 2011 as a Senior Microsoft Consultant where he continues to chase his passion of automating DBA processes and doing everything humanly possible to prevent the 0200 page. Kyle serves as the Vice-President of the Indianapolis chapter of PASS (www.indypass.org) and served on the committee to bring SQL Saturday #82 to Indianapolis. He shares his passion for SQL Server with others through speaking and mentoring at local and regional events.
Presenting: Throwing T-SQL 2012 Enhancements Against the Wall, SSIS 2012 – New and Improved, Extended Events – The Death Knell of SQL Trace
Warren Sifre
Warren Sifre has over 13 years of experience in the IT community and has worked in a variety of industries deploying many different products, most of which consisted of using MS SQL Server in one capacity or another. In 2003, he decided to make SQL Server his mastery and has since developed skills in most defined disciplines of MS SQL. After acquiring numerous Microsoft Certifications (MCDBA, MCITP, MCTS, MCP, MCSE, MCSA) and completing his final assignment of defining and implementing the necessary architecture to ensure a DR strategy and successful virtualization of over 70 SQL Server physical machines for a Cloud Services environment, he has joined PTI to ensure his continued mastery in the different disciplines of MS SQL maintains upward momentum.
Presenting: AlwaysOn – Way to get your 9’s?, SSAS 2012 – What BISM means to you!!!
If you think we have left any out then shoot me a line and let me know. I may entertain putting on a couple more if people show an interest in them ….
Cheers!
AJ
In: Community
31 Oct 2011Ah yes, I know…a little corny but every so often at events I run into some interesting people and I actually try to look up almost everyone that I meet in order to see what they are about. So I have decided to start a little Young Developer / Young DBA to Watch track here and put together some quick shout outs to those young individuals that I meet that I think might just be motivated enough to do some great things in the future….
Criteria is as Follows…
Prizes:
This last weekend while at SQL Saturday 87 in Louisville, I ran into a Patrick Riley ( @priley86 | blog ) after my SQL Azure talk. An interesting conversation ensued regarding sharding and the Enzo framework.
So upon looking over his Twitter feed, I ran across some very interesting blog posts by Patrick that I think deserve a read.
Fuzzy matching: a programmer’s view of the Damerau-Levenshtein algorithm
and also
SQL Azure Federations and Enzo Shard Demo
So this week I pick Patrick as the Young Developer to Watch. If you have time you should take a look at his fledgling blog and possibly give him a follow on Twitter…I already have..
Cheers!
AJ
In: Presentations
31 Oct 2011Another SQL Saturday weekend has come and gone. This time it was SQL Saturday #87 in Louisville, KY . The event appeared to be pretty well packed, Malathi Mahadevan ( @sqlmal | Malathi’s Blog ) and crew pulled off another awesome event! Hopefully most people around the area got to attend…if not then there is always next time. A couple of notes that I jotted down ..
First Timers
We need to do a better job of maybe having a couple of the representatives of the local user groups give a short introduction and talk about their groups. Possibly also give a plug for other groups in the region. This is possibly the third event that I have had someone come up to me afterwards and said something similar to the following
Attendee: “Awesome presentation! This is my first event and WOW totally cool free training!”
AJ: “So do you go to the monthly user group?”
Attendee: “Whut? There’s a user group? “
…you get the picture.
This time it was for someone whom travelled from Nashville (3+ HOURS) to attend….and Nashville just had their meeting like earlier in the week. At PASS, I was playing the role of Regional Mentor – Midwest and ran into a couple of people who were freaking attending PASS Summit but had not heard about the IndyPASS group until PASS.
We need to do a better job of bringing in new members into the community at the local level. This is what I argued as PASS’s biggest problem going forward when I was “trying out” for the BoD. It’s not like it’s some kind of secret….I go to a .NET user group meeting….I have 100-150+ people normally attending. I go to a PASS user group meeting and I have generally from 20 – 60. Now I know that there are more DBAs in most regions than that and it pains me that they are not there. The biggest grumble from people most of the time is related to training ….and here is some free training right in your backyard….EVERY MONTH!
Increasing membership at the local level helps to handle several key issues…
And it is not as if it’s that hard to think about how to get more people interested in the local groups. Here’s some from a stream of though right now…..
Maybe you have some better/more ideas? Share them! Jot them down in the Comments section below and maybe we can post them all up and send them up the line.
PASS Community Evangelist
If you didn’t know already ….Karla Kay ( @karlakay22 | blog ) is our new PASS Community Evangelist and I for one believe that she is already doing an awesome job! I think that PASS having someone working with the community who actually understands the complexities of what is going on in the community is a step in the right direction.
So if you are a Chapter Leader or looking to possibly start up a new chapter then you need to hit Karla up and she’ll get you pointed in the right direction.
My Presentations
Okee Dokee! Now for my presentations… I always believe in giving my feedback back and figuring out what needs to be done better next time.
Scoring ( A – Best Ever! - E – Total Waste of My Time )
Master Data Services in SQL Server 2012
A: 7
B: 2
Sample Remarks: Demos helped explain the use effectively. Thanks for sharing today!
My thoughts: This went pretty good and I had good discussions with people. People seem to be psyched for MDS in 2012!
Everything Your Jr. DBSA Won’t Tell You About SQL Azure
A: 18
B: 6
D: 1
Sample Remarks: OMYG – HE’S FREAKING AWESOME! HE’S THE COOLEST EVER!
My thoughts: The one D may have been an Oracle guy ticked because their cloud strategy sucks….
Well that is enough for now… I had a great time and hope to see everyone soon!
Cheers!
AJ
Programmer's Edge is my blog designed around promoting knowledge sharing in the Microsoft Technology arena. Especially in the areas of SQL Server and .NET development.