780 reputation
29
bio website qcumberland.com
location Houston, TX
age 37
visits member for 2 years, 11 months
seen Feb 4 at 19:40

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 SQL SERVER : CANNOT GRANT EXECUTE ON 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.
Feb
21
comment SQL Server 2012 defrag job runs interactively, but not as a job - why?
Try changing the job owner to "sa" and see if you get the same result; that will run it under the service account context. Also check the procedure to see if you are using an "execute as" in the DDL.
Feb
15
comment SQL Server connection failed for domain user from Mac OS machine
If you are specifying a username and a password in the connection string then you are not using AD/Kerberos security. Those fields in a connection string are used for SQL authentication. You need to run the process under the domain account, which I have no idea how you would do on a mac.