SQL Server model database and custom filegroups

As I wrote in the “Designing databases for rapid resilience” article, it is a good idea to keep the user data away from the PRIMARY filegroup.

When installing a new system which relies on several databases, it comes to mind to automate somehow the creation of additional filegroups and setting one of them as a default.

One

Continue reading […] SQL Server model database and custom filegroups […]

 

A few words on SQL Server security

Well, lately there has been quite some talk about security.

Security is a very flaky matter, since it is so easy to compromise.

Even the most sound security strategy can be half compromised just by sending a screenshot of your SQL Server Management Studio over the internet.

For example, you have a consultant helping you to solve a

Continue reading […] A few words on SQL Server security […]