One common misconception about distributed version control systems is that there cannot be a central project repository. This is simply not true – there is nothing stopping you from saying...

SQL Server 2008 R2 licensing is a major change from 2008, It allows a virtual host to have one license for 4 virtual guests for the EE edition and...

We have been mandated to virtualize all of our SQL Servers (Tier 3 -> Tier1). We have had discussions with VMware SQL experts and short of telling us that...

One of the requirements for setting up a mirrored database is that you transfer all the logins from the principal including their SIDS. The easiest way to do it -copy...

Are you using Synchronous or Asynchronous mode? Synchronous requires (2) two hops to commit while async requires only (1) one.

The second point is in reference to a service account that has expired. Many organizations use a service account to manage their SQL Server services for security purposes and...

Is SQL Agent enabled in SSCM?

Also, run sp_configure and check the status of 'Agent XPs',

some security scans set this value to '0' but to run SQL Agent you need it...

Just either right click on the database, go to mirror and you will see the failover button (This button will only be enabled if you are properly mirroring and synchronized)....

I come from a C++ background, but learned VB6 for my first job then VB.NET. Now I am thankful for that knowledge because we are writing SSIS packages for...