One of the most common issue you can find when source controlling the database is about the security. How to manage the users and the related permissions?
If you use to apply permission to users and to assign users to the database, this can be a problem, especially when you are in the deployment phase (or else when getting latest versions from the source control). Let’s see these two scenarios:
Recently Michael suggested me a lightweight framework for accessing and manipulating data with SQL Server. I’ve tried it and I’ve found some misunderstanding on the official documentation. The framework I’m speaking for is Simple.Data, a very user-friendly, simple-to-install, quick-to-apply, open and lightweight framework.
After some tests I’ve started to write down an article, that should be taken like a reference due to missing information on official documentation.
Every day a DBA (or a developer), has to reply to questions like “who changed that table?” or “who tried to login on our production database?”. These answers are not so simple to find out, actually. LepideAuditor for SQL Server is a tool that can helps us to audit operations on a SQL Server instance and to monitor both the server and the database level.