21,636 reputation
22352
bio website dcac.co
location Oceanside, CA
age 36
visits member for 4 years, 1 month
seen 23 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.


2d
answered Best way to migrate a huge SQL Server database with low downtime over network
2d
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?
Jan
13
comment Convert Select statement results into binary and insert into a varbinary column
Why on earth are you storing CSV files which are simply the output from a query in a column within the database table? I think we need to rethink the database design a bit.
Jan
13
answered Where are connections to databases made from when using SSRS?
Jan
13
answered Allow public use of functions without giving them database control
Jan
13
answered Snapshot replication - How to detect when a snapshot has arrived on the Subscriber from the Subscriber DB
Jan
3
awarded  Yearling
Dec
30
comment Trace Flag 3688 not working on SQL Server 2014
We can check. Pretty sure the answer will be that the MSKB isn't documentation. Worth asking.
Dec
30
answered Trace Flag 3688 not working on SQL Server 2014
Dec
29
comment Email address unique or primary key?
Yes I could have dove down the rabbit whole of filtered indexes but a simple question usually needs a simple answer. Without a database platform and version I keep my answers generic.