758 reputation
410
bio website oliverasmus.com
location New Jersey
age 29
visits member for 2 years, 8 months
seen Apr 17 '13 at 13:25

SQL Server DBA, Database Consultant, Data Architect, BI Guru, SQL Dev, Math enthusiast, and Star Trek geek.

Follow me @OliverAsmus


Jan
17
awarded  Yearling
Mar
1
awarded  Informed
Jan
17
awarded  Yearling
Jun
8
awarded  Constituent
Jun
8
awarded  Caucus
Apr
11
comment Prevent Data Sources from being deployed outside designated folder
+1 Personally I've used constraints in the past and they seem to work, but I'd love to see what others have done too.
Apr
4
comment SQL Server cluster failover
@SQLLearner Yea, I've done the same thing in the past just to see what would happen :-)
Apr
4
answered SQL Server cluster failover
Apr
4
comment Add columns Query With parameters
Another good option.
Apr
4
answered Add columns Query With parameters
Apr
4
comment Linked servers: Transaction context in use by another session
Have you tried using OPENQUERY() instead? msdn.microsoft.com/en-us/library/ms188427.aspx
Apr
3
comment Using SSIS to get record counts for tables that may not exist
I'm afraid I'd have to disagree. I have seen this configuration work in record time when compared to a COUNT( * ) - could have to do with the index bitmap lookup that accompanies the ( * ).
Apr
3
answered Using SSIS to get record counts for tables that may not exist
Apr
3
comment Survey database design: associate an answer to a user
Looks like you will need another table to handle the many-to-many relationship between Users and Options.
Apr
3
awarded  Enthusiast
Mar
26
comment Get notified when SQL Server 2008 Audit Server logs something?
Hmm . . . it's been a while since I implemented the Event Viewer class in .NET but I believe it is in System.Diagnostics.Eventing.Reader. I only suggested it since SQL Server lacks in some of these higher level async functions. There is a sample here: msdn.microsoft.com/en-us/library/bb671203(v=vs.90).aspx
Mar
24
answered Get notified when SQL Server 2008 Audit Server logs something?
Mar
23
answered Chart creation in BIDS 2008
Mar
15
comment Keep original column names in SSRS report designer 3.0?
Hmm . . . I have not seen this feature as an option in SSRS. However, you can use regular expressions in the column headers to manipulate how the text is displayed - msdn.microsoft.com/en-us/library/ms157328.aspx
Mar
15
comment Keep original column names in SSRS report designer 3.0?
Is this happening in the designer, in the output of the report (CSV, XLS, etc.), or both?