21,297 reputation
22151
bio website dcac.co
location Oceanside, CA
age 36
visits member for 3 years, 11 months
seen Dec 17 at 15:14

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.


Dec
17
answered Suspect (Torn) Pages recorded in TEMPDB? (SQL Server 2005 SP3)
Dec
2
revised Controlled shutdown/startup of a cluster
added 261 characters in body
Dec
2
answered Controlled shutdown/startup of a cluster
Nov
18
awarded  Nice Answer
Nov
17
comment This instance of (MS) SQL Server has been using a process id of X since dd/mm/yyyy
Did you connect to SQL in management studio to view the logs? Then everything is fine.
Nov
11
comment Adding a distributor for availability groups
That KB article is talking about using SQL Server replication with an AlwaysOn Availability Group. This is not required. Replication and AlwaysOn Availability Groups are two different things.
Oct
27
comment Invalid object when selecting from temporary table
About the only different is that the code isn't all red.
Oct
22
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?