216 reputation
28
bio website poconosystems.com
location Wilkes-Barre, PA
age 33
visits member for 2 years, 10 months
seen Aug 18 at 15:43

I am a professional software development consultant specializing in Microsoft technologies - in particular C#, Entity Framework, SQL Server, and ASP .NET MVC.

I am available for project work on a limited basis. Please feel free to contact me through any of the following methods:

http://stackoverflow.com/questions/46031/ — easily the best question ever asked on SO.


May
30
comment SQL Server Management Studio is not available
I believe the SQL Browser service is not turned on by default as a security measure. You could try turning that on if you really feel you need it.
May
20
awarded  Caucus
May
20
awarded  Constituent
Feb
20
awarded  Commentator
Feb
20
comment SQL Server 2005 database corruption. Advise
Further, select * from sys.objects where object_id = 60 on my databases is referring to the system table sysobjvalues. This question may be better on DBA.SE and even then you may be SOL.
Feb
20
comment SQL Server 2005 database corruption. Advise
The error Table error: Object ID 0... is troublesome :(
Feb
19
awarded  Informed
Dec
28
awarded  Yearling
Nov
23
comment How to update a table from a another table
+1 Invaluable information. Coming from SQL Server, I tried the approach @jcoleband suggested first. This works like a charm!
Jul
11
awarded  Citizen Patrol
Jul
11
comment Date and time parameter In msrs report
How does this get migrated to DBA? This is purely a programming question.
Jul
11
answered Date and time parameter In msrs report
Feb
1
comment The order of INNER JOIN's
Please post relevant code sections on this site. Don't expect external references to always be available. Without the link, this question is unanswerable.
Jan
24
comment SQL Drive getting full delete millions of rows
@JNK +1 Right you were about being unable to use TRUNCATE.
Jan
24
comment SQL Drive getting full delete millions of rows
Probably mvrak retaliating for someone DV his answer.
Jan
24
comment SQL Drive getting full delete millions of rows
Are you trying to empty the tables completely, or just remove some of the older data?
Jan
18
comment Defragmentation - Rebuilding Indexes SQL Server 2005
@Becky FILLFACTOR is a fairly complex subject. You should ask a separate question if needed, after first searching for "how to choose an appropriate fill factor".
Jan
18
comment Defragmentation - Rebuilding Indexes SQL Server 2005
@JNK Yes, good point. Thanks for catching that.
Jan
18
answered Defragmentation - Rebuilding Indexes SQL Server 2005
Dec
28
awarded  Supporter