Hi,

I have a table name CustUsers. In this table, there is a field name: PWD

I have refreshed the production database into the test. This field has about 200 records and these records are passwords created by users from the application. When i restored the  prod database into the… Read more

Please post/blog/comment !!

Read more

I had to install WinZip the other day, having the need to unlock a .RAR file. There’s no native support in Windows for those, and I turned to Winzip. I posted a note on Twitter and got suggestions from people for WinRAR and 7-Zip, but this is one of those… Read more

Read more

Read more

Read more

Read more

I don’t know if they’re making them cheaper and shoddier or what, but it seems that I’m going through a keyboard or two every year. I used to have one that I’d keep for 2-3 years when I got the big old, heavy duty beige ones. Now these cheaper ones… Read more

Read more

The resume that you send out, whether in print or electronically, is the first impression that you will make on a potential employer. For that reason, you want to make a good impression, and that’s one reason that I am trying to get people to manage their brand and present… Read more

In a previous post, I questioned how much Twitter could really do for me.  After some comments made, and some other blog posts that I have read – I decided to take the dive.

Andy Warren and Glenn Berry, both blogged about their twitter experiences after my last… Read more

In Part I, I discussed some of the peculiarities and troubleshooting done in relation to a peculiar execution plan.  In this post, I will discuss some of what I did to further tune the query.

First, a little more background into the design of this query.  This query uses… Read more

This is wonderful news to our new chapter. Jimmy May has agreed to come to give a presentation at our Pass chapter meeting. Yes..!!!! We are a new pass chapter and these kind of contributions will surely help our chapter grow.

It all started sending an email to Sujata mehta.… Read more

I mentioned last year about my plans to write this, and to make it a semi-collaborative effort by incorporating comments back into the finished product (if I like them that is!). I thought I’d start by outlining what I have in mind, and then I’m going to try to post… Read more

The devLINK 2010 Technical Conference’s call for speakers is now open, and you can find information about speaking at the event here.

If you aren’t interested in speaking at devLINK 2010, you can always attend. It will be held August 5-7 in Nashville, TN.

Read more

Read more

I am always looking to improve the performance of my SSIS packages.  I try to do as much work within the package as possible, only going to external stores (databases, flat/raw files) as little as possible.  There are a number of reasons for this.  Raw files are incredibly fast and…

Read more

This weekend, I’ll be headed for the east coast to speak at the SQL Saturday in Richmond, VA on Saturday.  I’ll be presenting my session on SSIS package configurations and expressions as part of the BI track.  As of last week, the event registration was cut off because they’d reached… Read more

In addition to my previous post, another best practice is to not use NOLOCK and READ UNCOMMITTED transaction isolation level.

Here’s an excerpt from a profiler trace

BEGIN TRAN UpdateMediaTables

SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED

DECLARE @BackupSetId int, @MediaSetId int, @LogDevName varchar(512)

SELECT…

Read more