The other day I was doing some research on the Transaction Log of SQL Server and stumbled upon the MS SQL Server MCM Readiness videos, many of which are made by Paul Randal.
After watching just one of these videos I quickly found out how useful they can be for general knowledge, even if you aren’t trying to ramp up for the MCM certification.
Below is a link to over 70 videos about all areas of SQL Server from a detailed perspective. I have found them very useful in growing my own knowledge base and recommend that others pick and chose the topics from this list that relate to them and give them a watch.
MS SQL Server provides a wide range of options to choose from when deciding how to regulate security in our organizations? I’m curious how you handle it?
Do you go full on best practice and run Windows Authentication only, allow service account and security groups only, and define user roles with granular permissions to apply to these accounts?
Do you fold under the pressures of the developers who blame you for their application’s failures and therefore you allow them whatever they claim they need in order to mitigate the blame?
Maybe somewhere in between. I’m eager to hear your methods. Feel free to post comments to elaborate or recommend additional options for the poll. (Mark all that apply)