Programmer's Edge

Lol! You have got to check out Steve Jones’ (no relation) post. Obviously, something went a little awry in his committee’s picks for the conference and what actually got published. I cannot blame him…my interactions with PASS on various things in the last couple of years have been

Michael Sorens has an interesting article on Simple Talk [http://www.simple-talk.com] about using SketchFlow which comes with Microsoft Expression Blend to create prototypes for WPF applications. The same is true for Silverlight applications as well. You can read the article here.. http://www.simple-talk.com/dotnet/.net-tools/creating-wpf-prototypes-with-sketchflow/

Louis Davidson has put together an interesting post on some of the issues that he had encountered with one of his talks at the recent SQL Saturday in Columbus,OH (#sqlsat42). It’s almost too bad…..I have run into the same types of initial crowds too…unresponsive…no one

Hey everyone! We have a position for an Oracle ERP specialist E-Business Suite experience. Sorry I don’t have a formal job request sheet on this one but I just was told about it via old school word of mouth. This position would be at our Indianapolis, IN headquarters. So

Hey everyone! We have an opening for an application developer position at our headquarters in Indianapolis, IN. Look at the details below and if you or someone you know fits the bill then shoot me a resume. Cheers! AJ Job Description: The successful candidate will have expert level knowledge in

Hey everyone! We have an opening for a System Administrator position at our headquarters in Indianapolis, IN. Please see the details below and send me your resume or someone you know that would fit the bill. Cheers! AJ Job Title: Systems Administrator Job Description: We are seeking a Systems Administrator

Hey everyone! We have an opening for an Oracle DBA here at our headquarters in Indianapolis, IN . Please check out the information below! Cheers, AJ Job Description: Minimum of 3 years Oracle Database Administrator experience. General UNIX Administration experience. Proven experience with PL/SQL including writing and optimizing code in

I keep running across these badges on other blog sites referring to the Rockstar Rankings [http://thomaslarock.com/rankings/] that Thomas LaRock [http://thomaslarock.com/] 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

I just posted my slides and sample solution on my SQL Sherpa blog site, http://www.sqlsherpa.com . Thanks to everyone that attended the presentation. It was great! Cheers, AJ

At the last SQL Saturday Chicago event a spoke at this year, I had the pleasure of meeting a guy by the name of Michael Kappel. He has a pretty nice HttpModule for Google Analytics in this C# Codeplex [http://www.codeplex.com] project found here. http://cstoolkit.codeplex.com/

Congrats go out to Hope Foley for being in the top 10 speakers for the IndyTechFest event! See the post here! http://www.indytechfest.com/ Everyone make sure to post a congratulations on her blog site! http://hopefoley.wordpress.com/ Cheers! AJ

Well, I have finally completed my submissions to the PASS Summit. Hopefully, if I can get some of my topics picked up then I can get my company to sponsor this year. I am thinking about adding another submission for an all day event for One Day Data Warehouse with

I will be speaking at the Ft. Wayne, In PASS Chapter on June 22nd,2010. This should be an interesting session on data warehousing where I will cook up some front to back demos for all the below. For those of you in the Ft. Wayne area that do not

I will be getting ready to post abstracts for SQL Saturday Nashville here in the next day or so. If you have anything cool or interesting that you would like to see then send me your ideas now and I will try to get them incorporated! Heck, I could speak

For any of those that are currently in the hunt for a job, we are currently looking for a SQL Server DBA to work at Perpetual Technologies here in Indianapolis, IN. I have posted the job requirements below and anyone whom is interested please contact Lisa Weaver our ‘Super Recruiter’

If any of you are doing ASP.NET MVC development right now and are really into doing TDD then more than likely you are using Moq as one of your flavors of mocking libraries. If not then I would advise you to at least give it some consideration as it

One of the main hindrances of the RowCount component in SSIS is that the variable that stores the row count is not updated till the data flow component has finished processing. What if you need to have the row count within the data flow component? I ran into this exact

Sometimes its the simple things that really irritate you as a DBA. Case in point is the lack of a LPAD, RPAD functionality in T-SQL. What makes it slightly more inconvenient is that there is similarly no LEFT and RIGHT functions to compliment the SUBSTRING function. These string functions often

** Disclaimer: I wrote this at 12:58 Saturday Morning. So all bets are off to an overly intelligent argument. Just my thoughts on it all. At least, it shows how passionate I am about the community. Well, lucky ..lucky me.. in the aspect that I had looked over the board

Common Table Expressions have been available to use since SQL Server 2005 and provide a more elegant way in which to handle a temporary result set other than using a temporary table. The syntax is similar to what I show below WITH <expression name> ([column name1,column name

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

One of the more intimating things in the database architecture for DBAs that I meet at events is replication. Especially, if the replication that you need to set up needs to have a little twist in it that is not handled necessarily by the GUI Wizards in SQL Server Management

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

PASS is putting on its 2009 Logreader Awards which can be read about here [http://www.sqlservercentral.com/blogs/andy_warren/archive/tags/Blog/default.aspx] . They are looking for the best blog articles written on the 15th and 16th of October. So now is your chance to email me

What is a ‘filtered’ index? A filtered index is basically a non-clustered index that is created on a subset of the data in a table defined by some query criteria(AKA the filter). Please note that I wrote non-clustered for a reason. You cannot create a filter on a clustered