24,526 reputation
22558
bio website dcac.co
location Oceanside, CA
age 36
visits member for 5 years, 8 months
seen Dec 19 at 19:07

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
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.
Sep
3
answered SSIS/ETL jobs fail with network related errors, when network is OK
Sep
3
answered Are there any naming conventions for services and their associated domain?
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
31
answered Connect over WiFi to SQL Server from another computer
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
answered Real trouble for opening port in SQL Server 2008
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.
Jul
14
answered Static IP Address to Redirect to Azure VIP Address
Jun
27
answered Latency between IIS and SQL on same physical, two VMs
Jun
19
answered Failover Cluster Migration Wizard (SQL Install Portion)