Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Archives: January 2010

Updating a column

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

0 comments, 154 reads

Posted in DatabaseExpertise.com on 26 January 2010

Developers !

Please post/blog/comment !!

Read more

0 comments, 143 reads

Posted in DatabaseExpertise.com on 26 January 2010

It’s a Toaster

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

4 comments, 295 reads

Posted in The Voice of the DBA on 26 January 2010

Second Normal Form (2NF)


Second Normal Form (2NF) :-A table is said to be in its Second Normal Form if it satisfied the following conditions:-
1) It satisfies the condition for the First Normal Form (1NF),
2) It do not includes any partial dependencies where a column is dependent only a part of…

Read more

0 comments, 359 reads

Posted in Vivek's SQL Notes on 26 January 2010

Third Normal Form (3NF)

Third Normal Form (3NF) :- A table is said to be in the Third Normal form (3NF) if it satisfy the following conditions:-
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…

Read more

0 comments, 455 reads

Posted in Vivek's SQL Notes on 26 January 2010

First Normal form (INF)

First Normal Form (INF):- A table is said to be in a First Normal Form (1NF)if it satisfy the following conditions:-
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…

Read more

0 comments, 317 reads

Posted in Vivek's SQL Notes on 26 January 2010

The Three Events That Brought Me Here


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…

Read more

3 comments, 157 reads

Posted in Joe Webb on 26 January 2010

Another Keyboard Down

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

0 comments, 281 reads

Posted in The Voice of the DBA on 26 January 2010

Database Normalization


Normalization :- Normalization can be defined as the process of organization the data to reduce the redundant table data to the minimum. This process is carried out by dividing the database into two or more than two tables and defining relationship between them so that deletion, updation and insertion can…

Read more

0 comments, 1,170 reads

Posted in Vivek's SQL Notes on 26 January 2010

Proofing Your Resume

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

8 comments, 585 reads

Posted in The Voice of the DBA on 26 January 2010

Tweeting – I took the Dive.

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

1 comments, 188 reads

Posted in SQL RNNR on 26 January 2010

Indexes Out the Window II

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

2 comments, 257 reads

Posted in SQL RNNR on 26 January 2010

Jimmy May coming to our Local Chapter meeting

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

2 comments, 236 reads

Posted in RumblingDBA on 26 January 2010

How to Participate in the SQL Community – Draft #1

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

2 comments, 195 reads

Posted in SQLAndy on 26 January 2010

devLINK 2010 Call for Speakers is Open

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

0 comments, 227 reads

Posted in SQL Aloha on 25 January 2010

A Call to Arms


Phil Factor’s most recent guest editorial over at SQL Server Central has, to a degree, pointed out that the emporer’s spiffy new outfit… well, it’s not exactly there. That’s why he looks so nekkid.

But seriously, the very idea of naming objects inside of the database with Hungarian-style notation really…

Read more

6 comments, 333 reads

Posted in The Scary DBA on 25 January 2010

Working with ADO.Net variables in SSIS scripts

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

0 comments, 201 reads

Posted in SQLRunner on 25 January 2010

Speaking at SQLSaturday #30 in Richmond

I'll be presenting two sessions this Saturday (January 30, 2010) in Richmond - Automate SQL Server Administration with PowerShell and Gather SQL Server Performance Data with PowerShell . The event takes place at ECPI College of Technology, 4305 Cox Rd,...(read more)

Read more

1 comments, 129 reads

Posted in Allen White on 25 January 2010

SQL Saturday 30 – Richmond VA

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

0 comments, 228 reads

Posted in Tim Mitchell on 25 January 2010

Microsoft – Follow best practices – Part 2

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

0 comments, 249 reads

Posted in Dave Ballantynes blog on 25 January 2010

Newer posts

Older posts