SQL Server security best practice

Security! This is the word comes in mind of every concerned person when it come...

1/22/2010

Embed security and secure your data

Security!! A word – that everybody want, whatever it may for - a life, money or a job. In an IT world this term is often used, and asked by the client, the customer or the end user because it is closely attached to the information they are providing or storing or exchanging with each other. It can create a chaos if an ounce of the information is leaked or spread publicly; refer the case about classified US Military info available, reported in July-2007 by Network World.   So, what we really have to care about that every piece...

1/01/2010

Common Mistakes in SQL Server - Part 5

Last to Last week we discussed how Null Values can cause a trouble in Common Mistakes in SQL Server – Part 4. This I will discuss about Auto Growth feature of SQL Server, and how it can impacts us. What is Auto Growth? Auto Growth is a feature that allowed database files (primary, secondary and log) to expand when database file becomes full - without manual intervention. Auto Growth feature is really useful when we do not want to increase...