…or the newly Microsoft SQL DBA converted to Oracle by proxy. I think I may be posting quite a few of these in the upcoming days while I slowly move deeper into Oracle DBA territory. The learning curve will be steep, but hope it will be a rewarding trip. Enough nonsense though. Here we [...]
|
||||||
|
So I had a little bit of a quiz not long ago to prove my DBA prowess. The time alloted to complete it was roughly 30 minutes, which I thought was plenty to complete the most of 11 questions. Then came a scenario that left me scratching my head trying to figure it out. As the [...] A while back, I wrote an article for SQL Server Central, describing a neat way for Microsoft SQL DBA’s to clear out connections / SPIDs to a database without breaking much of a sweat. Although I love SSC, I just can’t get past the fact that they require a visitor to register in order to view full articles. So, here it is, a reproduction of the DB script and a rather good explanation on how to use it or apply it. This goes out to all my fellow MSSQL DBAs in peril out there. [...] |
||||||
|
Copyright © 2010 The other blog of Miguel Pereira - All Rights Reserved |
||||||
