SQL Server model database and custom filegroups

RIL_button( “http://sqlconcept.com/2012/11/09/sql-server-model-database-and-custom-filegroups/”, “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

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

November 9th, 2012 | Category: SQL Server Limitations | Comments are closed
Work on itWell, now...OKGoodGood job! (1 votes, average: 5.00 out of 5)

If you gave a rating less than the maximum, you must leave a comment with suggestions on how to improve the post. :)

Loading ... Loading ...

 

A few words on SQL Server security

RIL_button( “http://sqlconcept.com/2012/10/25/a-few-words-on-sql-server-security/”, “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,

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

October 25th, 2012 | Category: Security, SQL Server Limitations | 2 comments - (Comments are closed)
Work on itWell, now...OKGoodGood job! (2 votes, average: 5.00 out of 5)

If you gave a rating less than the maximum, you must leave a comment with suggestions on how to improve the post. :)

Loading ... Loading ...

 

Development paths and other demons

RIL_button( “http://sqlconcept.com/2012/10/13/development-paths-and-other-demons/”, “Development paths and other demons” );

A common trend nowadays is to follow a specific development path, especially if your survival depends on it.

This can be applied in any aspect: personal, work related, professional, communal etc.

And why would it be different? For us as humans, having a goal seems to be the usual cure

Continue reading [...] Development paths and other demons [...]

October 13th, 2012 | Category: Ramblings, Some thoughts, SQL Server Limitations, SQL Server metadata, SQL Services | 2 comments - (Comments are closed)
Work on itWell, now...OKGoodGood job! (1 votes, average: 5.00 out of 5)

If you gave a rating less than the maximum, you must leave a comment with suggestions on how to improve the post. :)

Loading ... Loading ...

 

 
  Older Entries »