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://raosolage.net
Bookmarks: http://del.icio.us/osolage
Photos: http://www.flickr.com/photos/osolage/







   
 
 
 
   
 
top scroll end
0
POPS
Finding the physical name of a clustered database instance
Osolage
by Osolage  2-16-2009   
 One of my teammates wanted me to investigate a server problem today. It was a clustered database instance. I wanted to remote into the box, but I didn't know what the phsical machine name was. So I used the SELECT SERVERPROPERTY('ComputerNamePhysicalNetBIOS') to figure it out.
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.
0
POPS
Moving the tempdb database
Osolage
by Osolage  5-18-2007   
 While trying to optimize the performance of some data loads on one of our QA database servers, I decided to move the tempdb to a different disk array hoping that would improve the time it takes to assemble the large set of records to be inserted into a denormalized table. This clip contains the information I used to move the database.
0
POPS
SQL Server 2000 AWE
Osolage
by Osolage  5-17-2007   
 No Remarks
1
POPS
Use fn_get_sql instead of DBCC INPUTBUFFER
Osolage
by Osolage  5-14-2007   
 This is going to help quite a bit as we are getting into evaluating performance and concurrency issues.
0
POPS
DBCC CACHESTATS
Osolage
by Osolage  5-10-2007   
 One of my colleagues was using this. I had never come across it before. Thought I'd read up on it a little bit.
0
POPS
Comparison Operators
Osolage
by Osolage  5-10-2007   
 I don't even know why I was trying to do =<... I guess it's because I'm used to using BETWEEN more than <= >=. At any rate, this may come in handy in the future.
1
POPS
You can use an external editor with sqlcmd
Osolage
by Osolage  5-8-2007   
 I haven't really done much with SQL Server 2005. I'm getting myself in the situation where I must, though, as I am using it as the platform for capturing performance counter data. I let the database grow way out of pocket and am now suffering the consequences. I know back with SQL Server 2000 you could use the osql utility to run commands and scripts from the command line. Looks like you do the same thing using sqlcmd for SQL Server 2005. I'll probably be using this to execute a command file to shrink the transaciton log when it gets too big. I'll be using Performance Monitor's Alert feature to detect when the script needs to be run and have the action be to log a record in the application event log and to execute the script to truncate the log. The other alternative is to use SQL Server Agent to execute a cleanup script in a more meaningful manner. Consider my first suggestion a failsafe.
1
POPS
Why you should carefully monitor DB server disk space
Osolage
by Osolage  5-8-2007   
 No Remarks
0
POPS
Checking how busy a SQL Instance is
Osolage
by Osolage  4-11-2007   
 No Remarks
0
POPS
Sort Warnings
Osolage
by Osolage  4-10-2007   
 I'm pretty sure I've seen plenty of these before also. Mostly I've only used up to 4 columns in a sort, so I have a feeling that RAM is better option.
0
POPS
Execution Warnings
Osolage
by Osolage  4-10-2007   
 I'm not sure I usually have to worry about this one, but we'll see.
0
POPS
Hash Warnings
Osolage
by Osolage  4-10-2007   
 Yep, this is definitely something I should take a look at then.
0
POPS
DBCC SHOWCONTIG WITH TABLERESULTS
Osolage
by Osolage  4-5-2007   
 No Remarks
0
POPS
Table Spool should alert you to a potential problem
Osolage
by Osolage  3-26-2007   
 I was looking at a query plan today and saw a Table Spool icon. I had never seen one of those before. I thought that it might not be so great. I found this little bit of text on spooling data to work tables and thought it was interesting.
0
POPS
Set-based way of determining databases' writeability
Osolage
by Osolage  3-12-2007   
 I'm writing a script that will help me "port" privileges for Windows security accounts of one domain over to equivalent accounts on a different domain. You must first check to see whether any affected databases are read-only. If they are, you must take them out of read-only mode, first, before you revoke or grant any privileges to the database. I am using this procedure to figure out which databases are read-only.
2
POPS
Granting a user Execute Permissions to all stored procs in a database
travislaborde
by travislaborde  2-14-2007   
 No Remarks
0
POPS
Sql Server and the new Daylight Savings Time changes
Osolage
by Osolage  1-17-2007   
 This is very helpful
0
POPS
Example of using FOR XML Explicit
Osolage
by Osolage  12-21-2006   
 No Remarks
— end of the list —

Osolage's Database Administration ClipCast

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

OK