Categories
Babbling Me

Self Introduction in 3rd person in BLOG ?? Or it is actually written by another person ??

Just like many people, internet is my another playground (after our backyard Open-mouthed smile). I use google for many things, for work related stuff, to search cheap deal of computer hardware or just to find some crazy video. And every time I go to some personal blog or site, it always amazes me that why people like to like about them in 3rd person view ?? I mean come on, if it is my own blog then why the hack I will write about myself in 3rd person view ?? Unless I am just one of many poster of that blog and every author has their own bio written by some professional dude (which will be weird because … you blog because you want to write something not let others write for you, aren’t you ??) … I think it is totally OK to write bio in 3rd person view but when it is done by real 3rd person on his/her blog not yours.

I usually when find any blog, I try to find “About Me”. It is really entertaining to read those self posted 3re person bio. Some classic examples are, “S/He has XX years of experience in field of XYZ. And s/he is expert in XWYX technology.” Hell I have even seen some linkedIn profile like that !!

Anyways, I think me too can add something in 3rd person view,

Categories
Database SQL Server

Isolation levels in SQL Server … part II

In previous post I explained basics of ISOLATION levels in general. This post is a sort of demo of isolation levels in SQL Server. In SQL Server, Isolation property can be configured using “SET ISOLATION” command. This command can be used to set isolation at any given transaction.

SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED
GO
-- Check user settings
DBCC USEROPTIONS
GO 

For this post, I will be setting up isolation level to Read Uncommitted. As I explained in previous post, this isolation level is of the lowest in group. This will give users highest concurrent access as this isolation level will cause least amount of locks on resources. And users will even see uncommitted transactional data from another transaction.

First step for this test is to create a transaction to update some field in a table, I will be using my TestDB for this demo which can be created using following script,

Categories
Database SQL Server

Isolation levels in SQL Server … part I

Just like any reliable transaction system, SQL Server supports ACID properties. If you have never heard of ACID properties before than it is actually set of four properties Atomicity, Consistency, Isolation and Durability. These set of properties makes sure that what ever transaction we do in SQL Server (or any DBMS) and database performs consistently every time.

One of the ACID property is Isolation. Which basically makes sure that one transaction is completely independent of another transaction and one transaction can’t access resources being used by another transaction. This basically controls concurrent access to any given resource in database. And it is implemented using locking of database resources.

Issues due to improper isolation level selection,

Categories
Babbling Me

Overclocking my Radeon HD 6770

With my new rig I bought an average graphic card as well. I am not hardcore gamer at all but I do sometimes like to shoot some zombies or build my galactic empire Open-mouthed smile … so I bought this cheap but very nice graphic card from ATI Radeon 6770 HD from Sapphire. And I must say that I am really impressed with this little beast. Thought it is not top of the line card, so far it is able to let me play all latest games I throw at it.

After my successful attempt to OC my AMD Processor, my hands were sort of twitching to OC my GPU as well. Just like all ATI cards, mine was also using “ATI Catalyst” software for control and setting up advance graphic options. While just browsing these options I found that it has a rather interesting option, ability to overclock the GPU and it’s RAM !! I googled a little bit about OCing my graphic card model, but I didn’t found any helpful settings which I can use for my graphic card. So, I decided to do my own little trial and error thing.

OverClock_3

Categories
Bugs SQL Server

Resolving … Agent XPs disabled issue in SQL Server 2005

SQL Server sometimes behaves very strangely for no apparent reason. Few days back I was playing with our staging server and I had to stop SQL Server service for some testing purposes. When I started it back, I saw that SQL Server Agent was disabled and next to it a message showing that “Agent XPs disabled”

From my experience it generally means that SQL Server Agent service is not running. But looking at SQL Server Configuration Manager I found that service was just OK. But just to try, I restarted SQL Server Agent but I was still getting same message and disabled SQL Agent !!

After some googling I found that it is rather very common issue with SQL Server Agent !! Apparently sometimes for no reason, Agent XPs gets disabled in SQL Server environment. When I ran,

EXEC sp_configure 'Agent XPs'
Categories
How To SSIS

Using configuration file for SSIS package

SQL Server Integration Services (SSIS) are really nice ELT tool for data transformation, conversion and transfer.  But they not of much use if they can’t be configured to accept different parameters. For example, a once task to move file is designed if it can’t be used to look for file in different folder or FTP task can’t connect FTP site other than the one coded in task itself. In these cases a configuration file generated to be used with DTSX package can be really handy. Configuration files for SSIS package allows us to make our package more flexible (or say configurable). We can store all kind of parameters into this configuration file, which will allow use to change package behavior by changing package parameters.

For sake example, I have created a sample project with file transfer task. This package just looks into specified folder and moves any txt file exist in that folder to another location. This project is using a configuration file which allows user to change target and source folder location, and we can also change what type of file this package will move (e.g. Text, PDF or all files).

Steps to create configuration file:

1) Create three variables using variables window. One will be source folder path, second will be destination folder path and third one is just a file name. (if Variable window is not open, it can be accessed from View –> Other Windows –> Variables)

Variables

2) Drop “Foreach Loop Container” into control flow tab. And then place “File System Task” inside of “Foreach Loop Container”. This basically means that this “Foreach Loop Container” will execute that “File System Task” every time it loops through.

Categories
.NET How To Windows

Setting up personal Source Control Server using Visual SVN Server

I was working on one of my personal projects and I thought that it would be really cool if I have my own source control mechanism so I can always rollback to older versions if I ever need to do it. Till now, I was always just keep multiple copies of each project so if I have to rollback or even just have to compare files then I just open them up and compare it. But with my prolonged exposure to SVN, I found that it is more easy if I have some sort of source control server, I can use it to keep all of my repositories and it will make my like more easy. So just last night I finally completed that task.

Tools of trade,

To setup dedicated Visual SVN Server I used virtual machine with Windows 2008 Server (having 16 Gigs of RAM really helps Open-mouthed smile). Just make sure that machine has static IP, because DHCP will have random IP of machine and then it could be wonky for SVN Server.