PTI SQL Server 2012 Webcast Series Banner

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?

 

SQL Audit Presentation Files

Cheers!
AJ

Well, 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
Arrow Bullet Master Data Services in SQL Server 2012 (More Info)

2/9/2012 11:00 AM
Arrow Bullet Utilizing Knowledge with Data Quality Services in SQL Server 2012 (More Info)

2/16/2012 11:00 AM
Arrow Bullet Throwing T-SQL 2012 Enhancements Against the Wall (More Info)

2/23/2012 11:00 AM
Arrow Bullet Enhancements to Reporting Services in SQL Server 2012 (More Info)

3/1/2012 11:00 AM
Arrow Bullet AlwaysOn – Way to get your 9′s? (More Info)

3/8/2012 11:00 AM
Arrow Bullet SSIS 2012 – New and Improved (More Info)

3/15/2012 11:00 AM
Arrow Bullet PowerPivot & BISM in SQL Server 2012 OH MY! (More Info)

3/22/2012 11:00 AM
Arrow Bullet SSAS 2012 – What BISM Means to You! (More Info)

3/29/2012 11:00 AM
Arrow Bullet 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

Ah 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…

  • Younger than me … <28 years old(Cough,Cough)
  • Needs to do cool things based upon an arbitrary scale determined by a point in time of my choosing.
  • Needs to be .NET developer or SQL Server DBA ….cause seriously why would anyone use anything else?

Prizes:

  • Admiration of your fellow Developers/DBAs
  • Maybe one day I will make a cool logo or something

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

Another 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…

  • Speakers: Bigger attendance numbers would “inspire” more speakers to attempt to come and speak at groups.
  • PASS Membership: Bigger attendance = bigger PASS membership
  • Microsoft Influence: Bigger PASS Membership = Greater influence with Microsoft
  • PASS Summit: More PASS membership = more people hearing about the Summit

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

  • .NET User Groups: Get the .NET User Group leader to allow the PASS User Group leader to introduce themselves during the first 5 minutes of the meeting. Explain to the developers that if they learn the database side of things then it will make them better developers
  • Microsoft Mentors: Seriously, Microsoft wants the groups to extoll the virtues of the Microsoft platform then get someone to volunteer as a mentor for the group and have Microsoft recognize the “touch time” that they have with the group/groups that they mentor. A Microsoft mentor could assist with things like promotion ideas…speakers…etc.
  • Microsoft SQL Server Community Champion: Microsoft needs to set someone up at the head level to help coordinate this stuff with the SQL Server community out there. If it were me then I would nominate Jimmy May ( @aspiringgeek ) . Why because when he was in Indy I almost always saw him at meetings and he seems to have a good grasp on community.

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 )

Here are the Slides!

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

 

Well that is enough for now… I had a great time and hope to see everyone soon!

Cheers!

AJ

About this blog

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.

PTI SQL Server 2012 Webcast Series Badge
382 people follow programmersedge
recruiterleighhaugxnlharrinSQLQuillMEhrenmueJasonBurtntippmannsantiagojdiverprogSqlBritaaron_doumarkvsqlkirsirineSQLforEvemytechusaMSystemsICatherynDcalvinhpkharm92whitlushfrozenfisEmreMotanmikelbergmssqltipscstrick3sbrkcwhymicrospkansaCeciliaKinathanfra

Who’s Reading?

  • Goqhdilk: Have you seen any good films recently? http://cunigorynecak.de.tl Amazing Teen Model she is so hot [...]
  • Hujanjmt: I'd like to change some money http://moculoluy.de.tl Leg Model Sexy i hate this stpid fke dick shi [...]
  • Bojnynjz: Go travelling http://yeedabyduf.de.tl Teen Model Fucks It was a very good movie WITH OUT THE SOUND [...]
  • Flvrfwct: I'm not sure http://yasyymaraqi.de.tl Models Amateur Nonude every time a wake up i see that beauti [...]
  • Lqfxdidt: Excellent work, Nice Design http://oleuioo.de.tl underaged preteen bbs Talk about beautiful pussys, [...]