20,687 reputation
22048
bio website dcac.co
location Oceanside, CA
age 36
visits member for 3 years, 7 months
seen Jul 26 at 18:46

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
16
answered Security implications of restoring a backup from an unknown source?
Jul
11
comment Log File Management - Space on Disk
Why would you want to switch the system from simple to bulk logged when the problem is that the transaction logs are filling up? That'll make it worse not better.
Jul
10
answered Export data from a CCURE 800/8000 System using a pair of ODBC data sources?
Jul
10
answered Log File Management - Space on Disk
Jul
10
comment Why cannot login to restored SQL Server 2012 database?
Is the account listed in sys.database_principals with the same SID that is in sys.server_principals?
Jul
10
comment Why does the service broker require a master key after restoring to a different server?
If you do a begin dialog without specifying that there's no encryption you should get an error back, or at least logged into the sys.transmission_queue DMV.
Jul
10
comment How do I give file system access to SQL Server's SQLSERVERAGENT virtual account?
Based on the error that you added and removed, the account which the SQL Agent is running under isn't a sysadmin within the SQL Server instance.
Jul
9
answered Why does the service broker require a master key after restoring to a different server?
Jul
9
comment Why does the service broker require a master key after restoring to a different server?
Don't enable trustworthy on your service broker database by default. Turning on Trustworthy opens up some major security holes in SQL Server and can allow for privilege escalation.
Jul
9
comment How do I give file system access to SQL Server's SQLSERVERAGENT virtual account?
That's not an NTFS problem, that specific error is that it can't access the msdb database. Is that database corrupt, restoring, etc? If the account NT SERVICE\SQLSERVERAGENT has sysadmin rights already it's got access to the database.
Jul
9
comment Why cannot login to restored SQL Server 2012 database?
This a Windows account that the app uses or a SQL Account?
Jul
9
comment How do I resume log shipping?
Because I don't know how well the logshipping that comes with SQL Server is going to handle the database being deleted and manually restored into no-recovery. It might work just fine, or it might give you all sorts of problems as older logs can't be applied. Either way at the very least you'll need to backup the production database and restore it to your secondary server.
Jul
8
comment best possible index on this situation
Then I'd use a filtered index WHERE name IS NULL as that'll help a lot.
Jul
8
comment Why cannot login to restored SQL Server 2012 database?
Any state information next to the database. Be sure to refresh the object explorer to get the current data as it doesn't update in real time.
Jul
8
answered How to update a single record in a table based of foriegn key ID in another table?
Jul
8
answered best possible index on this situation
Jul
8
comment How do I resume log shipping?
When a failover happens you wouldn't need to do that, but this wasn't a failover event. When you failover the LSN chains aren't broken so the two databases are still in sync. When you brought the backup databases online you broke the LSN chain so you have to start the restore process over.
Jul
8
comment Dealing with large transaction logs in a cluster
Setting backups to expire doesn't cause them to be deleted. You need to add a task to your job which deletes the backups. It's the "Maintenance Cleanup Task" which has the option to delete the files.
Jul
8
answered Are #tables and #procedures 'not best practice' or 'bad practice'?
Jul
8
answered How do I resume log shipping?