21,037 reputation
22150
bio website dcac.co
location Oceanside, CA
age 36
visits member for 3 years, 9 months
seen yesterday

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.


2d
answered Invalid object when selecting from temporary table
Oct
21
comment When is it appropriate to use SQL Server Developer Edition?
There can't be any applications running against a SQL Server instance which is running the Developer Edition. If there's an application running against it, it is in production. Developer Edition is for test/dev, nothing else. Anyone that connects to it, either as a developer or an admin needs to have a developer license (or an MSDN license).
Oct
21
answered Disabled SSL on SQL Server, now connection fails
Oct
12
answered How do I kill a rollback process when I want to drop the database?
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?