Precision and Scale

As is the case with many of my topics of late, I came across this one by helping somebody else.  In SQL, we should be well aware of Precision...

Prepare Windows 7 to create Hyper-V Virtual lab to implement SQL Server 2008 R2 SP1 Active/Active Cluster

This series of Videos will walk through how to prepare existing windows 7 machine to test and validate active/active node...

Prepare Windows 7 to create Hyper-V Virtual lab to implement SQL Server 2008 R2 SP1 Active/Active Cluster

Prepare Windows 7 to create Hyper-V Virtual lab to implement SQL Server 2008 R2 SP1 Active/Active Cluster

Prepare Windows 7 to create Hyper-V Virtual lab to implement SQL Server 2008 R2 SP1 Active/Active Cluster

Prepare Windows 7 to create Hyper-V Virtual lab to implement SQL Server 2008 R2 SP1 Active/Active Cluster

Replication Agent Logging

To troubleshoot replication agent failures, replication agent profiles can be configured to output verbose agent logs to a text file. ...

Season of Satan - Earthquake, Hurricanes, Jitters & Twitter

I read Andy Leonard's Blog on Earthquakes and Technology, who thought a helicopter was landing in his back yard (LOL), and inspired...

SQL Server – sp_help without arguments.

sp_help returns information about database objects and types.
@object_name argument is optional for sp_help. When executed without any argument it returns...

SQLMCM Training – Day 16

Today Bob spoke the whole day about securing SQL Server, security itself, and encrypting
data. It was really hard content, and...