meta user
network profile
| bio | website | oliverasmus.com |
|---|---|---|
| location | New Jersey | |
| age | 28 | |
| visits | member for | 1 year, 4 months |
| seen | Apr 17 at 13:25 | |
| stats | profile views | 32 |
SQL Server DBA, Database Consultant, Data Architect, BI Guru, SQL Dev, Math enthusiast, and Star Trek geek.
Follow me @OliverAsmus
|
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? |
|
Feb 29 |
awarded | Organizer |
