24,272 reputation
22556
bio website dcac.co
location Oceanside, CA
age 36
visits member for 5 years, 2 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.


Jul
2
awarded  Curious
Jun
19
answered SQL Server Failover Cluster on Azure (HA Strategy)
Jun
18
comment 5.7.1 SMTP error when running stored proc using DB Mail in SQL Server 2012
Are you sure this is the only account on the server?
Jun
18
comment Cannot access my database, it says database inaccessible
Try restarting management studio. If that doesn't work I'll need a screenshot to see what's going on.
Jun
18
comment Cannot access my database, it says database inaccessible
Are there any errors? Can you post a screenshot of Object Explorer? Are you sure you are connected to the correct instance of SQL Server?
Jun
16
awarded  Nice Answer
May
2
awarded  Yearling
May
1
awarded  Notable Question
Apr
17
awarded  Notable Question
Mar
25
answered AWS Multi-AZ SQL?
Mar
21
awarded  Revival
Mar
19
answered Can't get AD inter-site replication to work over VPN
Mar
15
awarded  security
Feb
20
answered Intermittent performance issues on Azure Web Application with ASYNC_NETWORK_IO errors
Dec
27
awarded  Nice Answer
Dec
26
comment How to protect SQL Server from Hackers
If someone is connecting to the SQL port from a public IP Address, then the firewall isn't configured correctly. If they are coming from an internal IP then you've got some other kind of problem. SQL by it self doesn't support certificates. You have to do this via AD and certificate mappings.
Dec
24
answered How to protect SQL Server from Hackers
Dec
5
comment Server Performance Issue - Server 2008, SQL 2008 and Hyper-V [screenshots]
Depends on how the queries are written in Linq. I've seen some truly horrible stuff out there with different columns in the where clause for different situations bloating the hell out of the plan cache. Also Linq tends to make the parameters which it uses the same size as the value, so when passing in "Bob" and "Fred" you get two plans because the parameters are different sizes.
Dec
5
comment Windows Azure Blob Storage Data Migration
Yep, just was announced in October or November.
Sep
3
comment Are there any naming conventions for services and their associated domain?
These days so little is directly accessible from the public internet that most of my clients are hosting everything from www using content redirection within their load balancers to route stuff to different servers so that everything is masked to the user.