Archives: January 2010
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
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
1) It should be in the 2NF
2) It should not contain any transitive dependency which means that any non key column of the table should not…
1)If the columns of the table only contain atomic values (Single, indivisible).
2)Primary key is defined for the table
3)All the columns of the table are defined on the…
Recently Paul Randal (twitter, blog) instigated another meme in the SQL Server community – What three events brought you here. If you’re not familiar with memes, I’ve explained them in another post entitled “What’s Your Biggest Weakness?” And as I mentioned in that post, I…
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
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.
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.
But seriously, the very idea of naming objects inside of the database with Hungarian-style notation really…
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…
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
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…