SQL Server Education (by the geeks, for the geeks)
What happened? During the ongoing SQL migration on our TESTING environment cluster, things were not progressing as per plan. Initially the EVA SAN LUN(s) movement from source to target cluster node(s) …
Read MoreIn the month of February, during early morning hours, one of our DBA(s) mistakenly ran a script on a remote SQL instance, APPROVAL environment, which deleted all logins and groups from …
Read MoreIn this section I am going to cover, as to how we went about analyzing the performance counter values captured and then based on the results, arriving to conclusions on the …
Read MoreDear Friends, Please do bear with me as I am going to cover this topic in 3 parts. Part 1 – To give a background on “why was this exercise initiated, …
Read MoreIn this section I am going to cover, how we went about setting up the performance counters to be collected for a duration of 18 hours and which counters were used. …
Read MoreYesterday, afternoon we had a support executive from a remote development approach our DBA team requesting help on understanding why is their SQL error log being flooded with the error message …
Read MoreOne of our DBA team mates got a task remit to refresh the complete testing environment. As part of the pre-implementation steps he was required to script out the various configurations, …
Read MoreMany a times a DBA wishes for the below information, during performance troubleshooting, Can I get to know what was being executed 30 minutes back. Can I get to know which …
Read MoreToday, I was again requested for peer support from one of our DBA team mates who is racing against time to complete the TESTING environment refresh with LIVE data. As part …
Read MoreA couple of months back our infrastructure team had undertaken a project to upgrade server hardware and the OS as part of their objective to make systems more resilient. For the …
Read More