In SQL Server 2005, Microsoft introduced the new Schema object. This allowed us to de-couple the owner from the name of the object. You see, in previous releases the naming convention for a database ...

Everyone talks about “best practices” but what exactly are they? A "best practice" is a professional procedure or tactic that is accepted or prescribed as being correct or most effective. Take a ...

Russell Smith is a technology consultant and trainer specializing in management and security of Microsoft server and client technologies. He is a Microsoft Certified Systems Engineer with more than 15 ...