Osolage

Real Name: Ra Osolage
Location: Richmond, VA, USA
Joined:6-6-2006
Make Osolage a Guide: follow clipper
About me
32-year-young afro-american male human living on planet Earth in a city called Richmond in the state of Virginia of the Unites States. So with the demographics out of the way, I could say I've been described as a walking paradox of sorts.

I'm a handsome man married to a gorgeous and jaw-droppingly intelligent woman who, on the daily, enriches my stay on planet far beyond what I'd experience on my own.

Usually when I'm not with my wife, I'm working. I'm a database administrator and application developer on the week days. I'd like to claim that I'm furthering the enhancement of our global society, but truth be told, I pay my bills by working for money making corporations which could never be directly tied to social enhancement. Oh well, at least I did work for a biotech firm for 3 years.

I enjoy many different types of music as you can see on my Last.fm profile. I also enjoy gaming and photographing things I find interesting, which you can see on my Flickr account. And am really trying to find ways to enjoy the web.
Why I use Clipmarks
I use Clipmarks to track information that I find interesting and to leave my notes about that information. I also use it to find interesting information/opinions that the Clipmarks community finds interesting.

And now that I can post a clip to my blog, I've begun to use Clipmarks as a convenient way of collecting the pieces of content that I want to be part of my blog post. This is a very powerful feature in my opinion.
Where to find me on the web
Instant Messenger: osolage
Website/Blog: http://ra.osolage.net
Bookmarks: http://del.icio.us/osolage
Photos: http://www.flickr.com/photos/osolage/







   
 
 
 
   
 
top scroll end
1
POPS
SQL Server 2005 List all IDENTITY columns
Osolage
by Osolage  12-12-2007   
 When I upgraded one of my databases to MSSQL2K5 compatibility mode, I noticed that many of my insert statements on tables with identity columns started generating primary key violations. I realized that I needed to run DBCC CHECKIDENT on all of those tables to fix the problem. I found this script, which lists all of the tables, in a database, that have identity columns. Then a copy/paste and regex search/replace generated a script for me to run the DBCC CHECKIDENT for each table listed. After running the DBCC CHECKIDENT, the problem went away.
1
POPS
Synonyms in SQL Server 2005
Osolage
by Osolage  10-25-2007   
 I think this is going help me out quite a bit in the future.
— end of the list —

Osolage's Database Development ClipCast

loading clips...
Filter
rss tools
Clipmarks
About   Clippers   Privacy   EULA   Copyright   Site Map

OK