Programmer's Edge is a blog devoted to my passion of programming and database development using Microsoft technologies. Read more...
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’ at Lisa.Weaver@perptech.com or send them [...]
In the coming month, there will be a few changes coming to the site. First of which, is that I will be separating out the site content so that Programmersedge.com will contain mainly application development items.
The SQL Server and database related items will then be moved to a new site SQLSherpa.com. Additionally, over the [...]
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 was built from the ground up [...]
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 problem when I had to [...]
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 come in handy when integrating [...]
** 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 of directors election application a [...]
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 2,…) AS ( [...]
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 attentive. I did hear a [...]
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 Studio. What most DBAs need [...]
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 be a great day to learn some [...]