20,887 reputation
22150
bio website dcac.co
location Oceanside, CA
age 36
visits member for 3 years, 8 months
seen Sep 8 at 5:48

Denny Cherry is the owner and principal consultant for Denny Cherry & Associates Consulting and has over a decade of experience working with platforms such as Microsoft SQL Server, Hyper-V, vSphere and Enterprise Storage solutions. Denny’s areas of technical expertise include system architecture, performance tuning, security, replication and troubleshooting. Denny currently holds several of the Microsoft Certifications related to SQL Server for versions 2000 through 2008 including the Microsoft Certified Master as well as being a Microsoft MVP for several years. Denny has written several books and dozens of technical articles on SQL Server management and how SQL Server integrates with various other technologies.

You can find more information about Denny and Denny Cherry & Associates Consulting at dcac.co and more information about Denny's book Securing SQL Server on it's site securingsqlserver.com.


Sep
14
awarded  Enlightened
Sep
14
awarded  Nice Answer
Sep
3
awarded  Nice Answer
Aug
26
comment Configuring multiple listeners on SQL Server 2012 through High Availability
Are you trying to put multiple listeners in one Availability Group, or one listener per Availability Group with two AGs on the instances.
Aug
26
answered Adding DATETIME() and Status column with xp_FileExist result
Aug
26
answered Log shipping - switchover and failback
Aug
26
comment Specific user can't view database contents
Can you connect to the database is a query window and run queries against the objects in the database? What version of SSMS are you using?
Aug
21
revised how to shoot SQL error 823?
added 221 characters in body
Aug
21
answered Can a High number of Worktables/sec and/or workfiles/sec lead to tempdb Contention?
Aug
21
answered Wait on the Database Engine recovery handle failed. Check the SQL Server error log for potential causes
Aug
21
comment Wait on the Database Engine recovery handle failed. Check the SQL Server error log for potential causes
Yeah, don't to this.
Aug
21
revised SQL Server to MySQL migration using MySQL workbench
Fixed the title
Aug
21
answered how to shoot SQL error 823?
Aug
20
comment Change Data Capture not running when Mirror is Suspended
Then it sounds even more like that might be it. An interesting test would be to see what happens for sync mirroring on a test system.
Aug
20
comment Change Data Capture not running when Mirror is Suspended
I'm betting that pausing the mirror stops the log reader process, which is what async mirroring and CDC are using. This is probably happening on your sync mirror, because (I'm guessing here) that it's just change from sync to async under the covers and then the log reader is disabled. It makes sense that it would work this way. Doesn't give you a fix however.
Aug
14
comment Issue shrinking dev sql server DB's log file
Sounds like it's waiting for a Hekaton checkpoing to complete. Do you have Hekaton enabled? Are you using it?
Aug
14
comment SQL Server 2005 CHECKCATALOG fails
You should be able to connect to the database using the DAC and delete the extra rows from sys.columns.
Aug
14
comment Why is it @@SERVERNAME but not @@DBNAME?
Trust Remus on this one. He knows for sure.
Aug
14
answered Standard Edition High Availability without Shared Storage
Aug
11
comment LDAP in SQL Server 2012
When I wrote that sample code my lab would have been SQL 2012 on Windows 2012. Make sure that you change the domain name from bacon.lab to your domain name.