Month: February 2009

Got an Event!

If you have an event..local or otherwise that is open to the IT community that you would like to have me make an entry for promotion then please just drop me a line and I will get something up for you arie.jones@perptech.com ….my only criteria are as follows: Be freely open to the community Be related to IT...

Read More

SMO:Working with Extended Properties

One of the nice things about Server Management Objects(SMO) is how the modeling of the classes folows almost exactly how items are aligned in the database structure. Sadly, one of the least used items in a database it that extended properties that are on almost every level(database, table, column) of the SQL Server database architecture. However, these objects allow you to tag the database objects with your own metadata thus allowing to to almost infinitely extend the amount of information held in that particular object. Forget about the data ….we are talking about how to tell what the data means or is used for. I like to use the extended properties so that the database becomes a self documenting entity.  You can make the process easier by using SMO. Check my earlier post and presentations about the usage of SMO if you are unsure. Anywho, each major database layer will have an ExtendedProperties collection on it. So….I can write some code to traverse a list of extended properties(EPList) …if the name does not exist in the list of extended properties for the database then it is added with the default value.   For Each EPName As String In EPList If Not db.ExtendedProperties.Contains(EPName) Then Dim ep As New ExtendedProperty(db, dbext, “Default Value”) ep.Create() End If Next So all you need to do to add an extended property to an object is to have a...

Read More

Rocky Mountain Tech Tri-Fecta Presentations

Well, the 1st annual Rocky Mountain Tech Tri-Fecta has come and gone. It was a blast from beginning to end. The pre-event was a lot of fun as my group really killed Scott Hanselman’s group at bowling. Thanks to Julie for coordinating a great event as everything went off without too many hitches. I was lucky enough to be able to give 4 presentations during the day( 1 due to a cancellation) which were all a real blast. One guy actually said he was going to recommend me for an MVP..LOL. Hopefully, he is in tight with Bill and Melinda…. So for all those people whom wanted the slides and demos….(remember SMOoggle is already Trademarked and Copyrighted )..here they all are convienently zipped up in a single package. Rocky Mountain Stuff Cheers,Aj Tags: demos, asp.net, sql+server, sql+server+2005, sql+server+2008, ado.net+entity+framework, smo, server+management+objects, databases,...

Read More

South Florida Code Camp Presentation: Reporting Services 2008

Sorry for the delay. I had to head up to Philadephia right after the conference. Thanks to all of the people whom showed up. The place was totally packed for the final presentation and there were some great conversations with people aterwards for nearly 20 minutes or so..Thank goodness Russ’s TV show ran over so I wasn’t late to the prize give away session! Additionally,from talking with people at the conference I will be setting up a Event Speaker item in LinkedIn here soon so that people can give me recommendations. Thanks for the great idea! And here are the slides and examples from the presentation… Slides Cheers,AJ...

Read More

South Florida Code Camp: SMO Presentation

Good Afternoon, from Miami. Things are popping here with several hundred developers/DBAs roaming around here. As promised here are my presentation slides and examples from my first talk of the day on SMO. Included are the coding examples for the SMOoggle example and the Security Checker. Please note the disclaimer below: AJ Disclaimer: These code examples are being provided for example only and should not be considered a production ready application. They are merely an attempt to demonstrate some of the cool things that can be accomplished using SMO. Please do not expect any support as such. Of course, all work is strictly copyrighted and tradedmarked and all that jazz. So don’t let me catch you trying to release a corporate version of SMOoggle without my permission. Presentation Material...

Read More