Are you a salaried employee looking to switch to a W-2 or 1099 contractor? (For an explanation of W-2 and 1099, click Consultants: 1099 or W-2?)  If so, what hourly pay rate would you need to at least match your salary? When trying to decide the equiva...

If you are using Visio 2010 and creating tables via the Database Model Diagram template, you may be surprised to learn there is not a way to build CREATE TABLE scripts from your resulting diagram.  The last release that supported that was the Enterprise...

Behind the scenes in SSIS, the data flow engine uses a buffer-oriented architecture to efficiently load and manipulate datasets in memory.  The benefit of this in-memory processing is that you do not need to physically copy and stage data at each step o...

DBAs find it easier to manage large Database Server environments when checklists are used. This Stored procedure checklist will stimulate some ideas you could use For acceptance into the SQL Server environment, I’ve developed some scripts that s...

Learn about SQL Server DBA, SQL Server database performance,SQL Server optimisation,database tuning,t-sql,ssis...

Career advice for the IT professional...