I ´m honored to have my name again at sqlauthority.com. Thanks a lot my good friend :)
Originally posted on Journey to SQL Authority with Pinal Dave:
Earlier I asked a very interesting question related to Powershell and T-SQL command. Read my earlier blog post SQL SERVER – Start Services or Stop Services with PowerShell – Question to Readers?.
Here is the question which I asked – Stop-Services ‘mysqlserver‘ in powershell is equivalent to Shutdown or Shutdown With Nowait in T-SQL?
Well, I asked this question because I really had no idea about the answer. However, my personal friend and Powershell Guru Laerte Junior immediately took the challenge to find answers to this question. He comes up with a fantastic explanation of the answer with proper findings and experiments.
Laerte did multiple test to figure out the answer to the question. He used traceflags 2592 and 3605 and to log the status of the checkpoint to the SQL Server log files. I strongly encouraged everyone to read his blog post as it will absolutely teach you something…
View original 100 more words