Search


	Podcast:		voiceofthedba's podcast
	Episode:		Disable or Drop
	Category:		Technology
	Duration:		00:03:20
	Publish Date:		2018-01-11 20:00:00
	Description:		When I started working with SQL Server and Windows, it seemed that the administrative side of many actions was limited. We could add and drop many items, but that was it. Relatively few tools allowed setting limits or disabling them, which was a pain. After all, I'd gotten used to setting up accounts for vendors and contractors in Active Directory, often disabling them when they weren't in use. I couldn't do this in SQL Server for many objects, which was a pain and an administrative burden to reset them up when troubleshooting issues. This was pre-PowerShell and .NET when any SMO access was a project in and of itself. These days SQL Server has done a great job of adding in the ability to pause or disable many objects. We've had the ability to lock out an account for many versions, which is a great way to setup a vendor tech support account when it's needed. This is especially important for security these days, as we may want to be sure that we prevent access by any suspect accounts. Disabling them allows us to prevent their use, but keep all their rights and permissions in the even they are valid accounts. Read the rest of Disable or Drop
	Total Play:		0