21,788 reputation
22352
bio website dcac.co
location Oceanside, CA
age 37
visits member for 4 years, 3 months
seen Mar 23 at 0:56

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.


Mar
23
comment What permissions does db_owner not have? (In SQL Server 2008)
If you are going to downvote a correct answer, you should at least tell me why.
Mar
17
answered Restoring SQL Server 2000 database to SQL Server 2008
Mar
17
answered What permissions does db_owner not have? (In SQL Server 2008)
Mar
17
comment How to change the instance name of SQL Server Express 2008?
This has not changed and probably never will.
Feb
25
comment What is the name for a table that keeps track of operations that have been performed on the database?
Sounds like a general auditing table to me. I assume this is something that was built into your application and isn't provided by your RDBMS automatically?
Feb
16
comment how to restrict user to run sql server database only on partiular ip only?
Are you trying to make it so that users can only connect from one IP address, or does the server have multiple IPs and you only want users to be able to connect to one IP address?
Feb
15
comment Is there a reason not to use white spaces for column names?
Because spaces are the devils handy work.
Feb
9
comment Is 'Avoid creating a clustered index based on an incrementing key' a myth from SQL Server 2000 days?
I said preferred, not required. For normal applications that make up 98% of the databases in the world a clustered key on an identity column works just fine.
Jan
28
answered Best way to migrate a huge SQL Server database with low downtime over network
Jan
28
comment SSMS IntelliSense doesn't work on particular database
What compatibility level is the database and what version is the server?
Jan
27
answered SQL Alert: 020 - SSPI handshake failure. Tracking the cause?
Jan
21
awarded  Enlightened
Jan
20
awarded  Nice Answer
Jan
20
answered Datawarehouse bad practice?
Jan
20
comment What is the permission needed to add permissions?
OK, I looked up securityadmin in BOL and you still have to be a user within the database to grant rights within the database. So if the user which you are using isn't inside the database, then you'll need to be sysadmin in order to change stuff within the database.
Jan
14
comment Backup and FTP SQL Server databases
I would go with option #2.
Jan
13
answered What is the permission needed to add permissions?
Jan
13
answered How do you copy a TDE-encrypted SQL Server database using T-SQL programatically?
Jan
13
comment Allow public use of functions without giving them database control
That'll work as well, as long as you are OK with them being able to execute every stored procedure and function within the dbo schema.
Jan
13
comment Does partitioning help if you don't query on the partition value?
Based on your sample query, performance will be worse than if you didn't partition. For a table with 10M rows I wouldn't bother partitioning. How large do you plan on the table getting?