Brent I love your presentation, clearly you know what and what not to do. Your presentation really follows what a DBA must follow in order to, dictate the problem, minimize risks, but more importantly, look after your back and follow process of the enterprise. This is all great and much appreciated, however, I imagine you have some dirty and risky tricks prior to hitting that rollback button. So per as your example, a change was made by Norm, with no Commit, tequilas ruined. Could you please confirm if the following would work: 1) Alter SPROC in replica 2) Change connection strings on client to REPLICA 3) Let roll back complete, replication should prevent data loss ... would this prevent DATA loss and high availability ?
38:32 so true. Microsoft Office/Visio/OneNote can never agree on whether or not my licenses are valid. Thank goodness SQL Server has a different authentication system - but then again, that's a whole different kind of wacky-ness.
In the example, with Norm's begin transaction without a commit which caused the blocking, could a situation like that be resolved with Norm committing the transaction? Wouldn the other queries then be free to access the tables blocked by the transaction? Or am I missing something?
I'm studying to be a jr DBA so pardon the newb question here but why are the log files continuing to grow? What is being recorded during this stalemate of Norm's uncommitted transaction?
2 years late but I would leave a guess anyway. The database writes the contents of the log file to the data file when a commit is entered so I'm guessing that it keeps recording the transactions while waiting for a commit that never came.
good day I have an issue with sql and winfreight .main branch has a server that is a complete overkill and is running perfect but the other branch is 300km away but the system is up to Sh@t takes 30min to load an image on an i5 8th gen 3.2ghz 8gb ram.please help.
Only Brent can make this topic as hilarious as he does.
29:44 - LOL! This is why I like watching Brent.
I JUST GOT INDEX CLASES OM YOUR WEB SITE IS AMAZING
GOOD LUCK BRENT
Brent I love your presentation, clearly you know what and what not to do. Your presentation really follows what a DBA must follow in order to, dictate the problem, minimize risks, but more importantly, look after your back and follow process of the enterprise. This is all great and much appreciated, however, I imagine you have some dirty and risky tricks prior to hitting that rollback button. So per as your example, a change was made by Norm, with no Commit, tequilas ruined. Could you please confirm if the following would work: 1) Alter SPROC in replica 2) Change connection strings on client to REPLICA 3) Let roll back complete, replication should prevent data loss ... would this prevent DATA loss and high availability ?
High quality content! Useful. Trying out the blitz scripts now.
Thank you very much Brent Ozar!
What an absolute gem of a video! Many thanks
Great video, you do make learning fun, Brent!
Great video... Enjoy the IT / DBA humor.
Sir u r amazing....A legend to be exact!!!!
Very helpful, fantastic stuff.. thanks Brent Ozar..
38:32 so true. Microsoft Office/Visio/OneNote can never agree on whether or not my licenses are valid. Thank goodness SQL Server has a different authentication system - but then again, that's a whole different kind of wacky-ness.
Excellent content !!
In the example, with Norm's begin transaction without a commit which caused the blocking, could a situation like that be resolved with Norm committing the transaction? Wouldn the other queries then be free to access the tables blocked by the transaction? Or am I missing something?
Thanks a ton.
thank you somuch :)
I'm studying to be a jr DBA so pardon the newb question here but why are the log files continuing to grow? What is being recorded during this stalemate of Norm's uncommitted transaction?
2 years late but I would leave a guess anyway. The database writes the contents of the log file to the data file when a commit is entered so I'm guessing that it keeps recording the transactions while waiting for a commit that never came.
@@safraz.hosein thanks
good day
I have an issue with sql and winfreight .main branch has a server that is a complete overkill and is running perfect but the other branch is 300km away but the system is up to Sh@t takes 30min to load an image on an i5 8th gen 3.2ghz 8gb ram.please help.
awesome
EXEC sp_Blitz @KeepMyJob = 1
Ur videos make sql from poison to cool drinks