24,596 reputation
22559
bio website dcac.co
location Oceanside, CA
age 36
visits member for 5 years, 9 months
seen 17 hours ago

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.


Aug
20
comment How to protect SQL Server from Hackers
@GregAskew just saw your comment. There's no way to use certificates in SQL Server instead of local/Windows auth. You can use certificates in Active Directory, then use that AD account to connect, but that's as good as it gets.
Jul
24
comment EMC PowerPath Support Matrix
I spent hours looking through Powerlink before I posted this question and wasn't able to find anything.
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?
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
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.
Jul
31
comment What software should I use for fault tolerence/high availability for 2 servers
It really depends on what service you are trying to protect as to which solution you should be using. What are you trying to protect?
Jul
29
comment Connecting Windows 7 client to NT4 server share in AD domain
Try disabling Kerberos?
Jul
26
comment SQL and Shadow Protect Server
There's no need to manually backup the SQL Server databases. This can all be automated from within SQL Server by setting up jobs within SQL Server to do the database backups while the database is online and running without any user impact.
Jul
15
comment Disable all installers, but still be able to install via intune
Some questions which will probably need to be asked... What version are the clients? Can they be domain joined? What version servers are you running? What rights do the users need (not want) to have?
Jul
15
comment Real trouble for opening port in SQL Server 2008
Can you screenshot and post the SQL Server config Manager, specifically Config Manager > SQL Server Network Configuration > Protocols for {instance name} > TCP/IP properties on the IP Addresses tab?
Jul
15
comment Real trouble for opening port in SQL Server 2008
Is it a named instance or the default instance?
Jul
15
comment Static IP Address to Redirect to Azure VIP Address
Correct A records only accept an IP Address. CNAME records point to other DNS records such as A records. The client CNAME of something.client.com points to your A record customer.company.com. Customer.company.com points to an IP address. When the DNS lookup for something.client.com happens it finds customer.company.com and returns the IP address for customer.company.com.
Jun
19
comment Failover Cluster Migration Wizard (SQL Install Portion)
The cluster migration wizard is for things like file server resources, not for complex things like SQL Server clusters. Are you just trying to move to new hardware or are you doing an OS upgrade as a part of the process? I assume the end result is that the hostnames and instance names for the SQL Server services remain the same?
Jun
15
comment Windows authentication failure between multiple domains (sites)
Are these domains within the same forest or are they separate forests that are manually trusted together?
Jun
15
comment I put 4 gigs of RAM into a new server, why does it say I have only 3462960k RAM?
Coming? The phone in my pocket is a quad core phone. :)
Jun
13
comment Upgraded SQL server, performance plummets
Odds are this can all be solved within SQL Server. 3rd party LOB support isn't going to be needed, and odds are that WireShark is way overboard for solving this.