D
Database CRUD scripts
The use of a database is always a good idea and not giving users any direct access to the tables is an even better idea but wrapping the tables with stored proc…
3 posts
#SQL Server
D
Database documentation
Documentation is the bane of my life you design a fantastic database and someone tells you that they would like to know how it works, so the task begins. This s…
S
SQL Server Audit
Who did what and when did they do it? SQL Servers has some fantastic audit capability but sometimes a client will want to hand craft their own and this script c…