I recently changed the user account that my SQL Server instance was running under from "sql.user" to "sql.user2". When I attempted to have my application server connect via integrated Windows Authenti...

I've recently been researching SQL Server database compression in an effort to save disk space in my company's production and non-production environments. Much of our database contains text that would...

I am currently in the process of migrating my company's SQL Server replication strategy from Log Shipping to Always On Availability Groups. This involved the addition of several new VMs to my producti...

I was recently building a SQL Server failover cluster and had an issue where I had two SAN-connected drives to be connected to two separate nodes, but only one drive would appear as available in the W...

Most modern web languages these days offer some function to parse a "list" of text items, which is usually a text string with multiple values separated by a delimiter, often a comma. SQL Server unfort...

My firm is migrating our SQL Server 2008 R2 Cluster to new infrastructure. Our first attempt is to set it up running Windows 2012 R2 Server, a difference from our current Windows 2008 R2 Server enviro...

Older versions of SQL Server did not have a role that allowed execution of all stored procedures. You can get around this by granting EXECUTE on an entire schema: GRANT EXECUTE ON SCHEMA :: dbo T...

It turns out that installing a SQL Server 2008 R2 cluster on Windows Server 2012 R2 is a little more involved than point-and-click. ## Install Windows Failover Cluster Support Feature The SQL Server...

SQL Server AlwaysOn High Availability is an excellent replication option if you have the need for standby or read-only database servers. In order to use it in SQL Server Management Studio, you first ...