Denny Cherry is an independent consultant with 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 for SQL Server 2008 as well as being a Microsoft MVP for several years and a VMware vExpert.
You can find more information about Denny on mrdenny.com and more information about his book Securing SQL Server on it's site securingsqlserver.com.
|
May
15 |
|
comment |
Missing or lost transaction and no errors to show what went wrong The bug mentioned in that forum post is with the ExecuteNonquery which in this case is a Java component not a SQL Server component. |
|
May
15 |
|
comment |
Missing or lost transaction and no errors to show what went wrong If SQL Server returns a message that the command was completed then it was. That means that it was written to the transaction log. There are no internal timeouts that would cause it to rollback the two messages besides that. Even if the database had gone offline and come back online at that point SQL Server would still have the records in the transaction log. You'll need to read through all the log backups from the time of the insert to verify they were inserted until you find the deletion commands for those records. The functions fn_dblog and db_dump_dblog will read the log and backups. |
|
May
15 |
|
answered | Missing or lost transaction and no errors to show what went wrong |
|
May
15 |
|
answered | App got press, then servers got owned. I added 8 more servers, STILL too slow |
|
May
15 |
|
comment |
Restore a Single File from FileStream I am mrdenny, the bringer of bad news. |
|
May
14 |
|
comment |
Windows Server 2012 File name too long? Backwards compatibility is a pain. If Server 2012 allowed it and a Windows XP machine connected to it the client wouldn't be able to use the folder name. And given that most Fortune 500 companies are still using Windows XP that sort of thing has to be taken into account. |
|
May
13 |
|
answered | Restore a Single File from FileStream |
|
May
13 |
|
answered | How to check if I am hitting the Express Edition size limit? |
|
May
13 |
|
comment |
How to merge data from 2 databases Yep, I'm assuming SQL Server as it's tagged SQL Server and says SQL Server in the question. |
|
May
13 |
|
comment |
Upgrade Server 2008 R2 to Server 2012, failover cluster problems? That could be permissions. Are you a local admin on the server? |
|
May
13 |
|
answered | How to merge data from 2 databases |
|
May
13 |
|
answered | SQL Server service shutdown due to 'bad?' SSL cert |
|
May
13 |
|
answered | Windows Server 2012 File name too long? |
|
May
13 |
|
answered | Upgrade Server 2008 R2 to Server 2012, failover cluster problems? |
|
May
13 |
|
comment |
Vsphere VMware thin provisioning free space I think we are going to need a lot more details about what steps you'll be taking and what kind of upgrade you are doing before a good solid answer can be given. |
|
May
12 |
|
comment |
File locations for Full Text Catalogs using SQL Server 2005 on VMware It's a standard rule of UAC that non-privileged accounts (anything but the local administrator account) can't create files in the root of hard drives. |
|
May
12 |
|
answered | File locations for Full Text Catalogs using SQL Server 2005 on VMware |
|
May
12 |
|
answered | Simple model database transaction log full 'CHECKPOINT' |
|
May
12 |
|
comment |
Can't query one view from another? Makes total sense. Have you looked at BizSpark from Microsoft? It's a program to get you all your Microsoft licenses for free for I believe 3 years. microsoft.com/bizspark/default.aspx Might make life easier. |
|
May
9 |
|
answered | If I fail over one database, do the others that share the same mirror endpoint fail over as well? |
