800 reputation
39
bio website qcumberland.com
location Houston, TX
age 38
visits member for 3 years, 6 months
seen 2 days ago

Sep
22
answered SQL Server cluster resource won't come online unless its on port 1433
Apr
25
awarded  Yearling
Nov
22
answered Why is the “The package can not be saved to the file system since its protection level is server storage” error?
Nov
12
answered Cannot grant execute to stored procedure
Oct
15
comment What is a Scalable Storage Mechanism for large TTL data collections
Are you required to store the XML in the database or can you store pointers in the database and put the XML messages on a filesystem somewhere? Seems like that would solve both your growth and grooming issues.
Sep
24
answered Easy replication for SQL Server: Can it be set up like mongodb or Oracle?
Sep
17
answered Select @@identity in Merge Replication
May
30
comment SQL Server 2008r2 Enterprise evaluation expired - Options?
I can confirm that the "this approach with scripts" method works well if you can take the outage. I've used this method several times and as long as the instance name and paths are installed the same as before you should be good.
May
22
comment SQL agent job step's connection managers
That's a good thought, put that in as another answer.
May
22
comment Dropping Hypothetical Indexes
How about a screenshot of what a hypothetical looks like?
May
21
answered SQL agent job step's connection managers
May
20
comment Auditing specific database events
If moving from Enterprise to Standard then check on the differences in SQL Server Audit between the editions; there are EE only features.
May
20
answered Should we periodically 'refresh' the mirrored copy of a SQL Server database?
May
14
awarded  Caucus
May
1
answered Indexes file damaged, was on ramdisk
Apr
25
awarded  Yearling
Apr
23
comment Can I shrink the transaction log file on a mirror database?
Hope no longer. Once the database gets suspended/disconnected and a log backup gets executed on the primary you are pretty much hosed on getting the mirror back in synch without a re-init.
Mar
27
comment Run Multiple Remote Jobs
Gotcha, user's needs are what they are. :)
Mar
26
answered Run Multiple Remote Jobs
Feb
21
comment SQL Server connection failed for domain user from Mac OS machine
Use connectionstrings.com (connectionstrings.com/sql-server-2008) to show you different connection string configurations, specifcally around Integrated Security. The problem with doing it from a Mac is that it doesn't tie into Active Directory that I know of so it is not likely to work and you will need to use standard (SQL) security where you specify the username and password.