How to add node to SQL Server Failover Cluster from SQL Server 2008 onwards ?

Steps : How to add node to SQL Server Failover Cluster from SQL Server 2008 onwards ?
1) Open SQL Server Installation...

Resume Generating Event (RGE)

No, I haven't lost my job. This is just one of those topics that's good to get out there. There...

SQL Agent Error During Windows Failover Cluster Setup

Problem: You had just finished up installing cluster setup in your Primary node. After verifying your setup is complete and...

When issue is not exactly "issue"

In last release of SQL Code Guard (2.4.5222) I've added few issues which can cause confusion.Eg - ST012 "Consider using temporary table instead of...

PROBLEM - ERROR EXECUTING SSIS PACKAGE FROM SQL JOB. Error Message would be something like this - failed to load xml file...

SOLUTION...

New Permissions in SQL Server 2014: IMPERSONATE ANY LOGIN, SELECT ALL USER SECURABLES, CONNECT ANY DATABASE and the old CONTROL SERVER

(DE)
SQL Server 2014 bringt insgesamt 5 neue Berechtigungen. Zwei von diesen sind auf Datenbank-Ebene und nur in der Windows...

DAX #1 – Learning DAX

I recently attended a virtual training of Tabular and Power Pivot for Developers taught by Kathy Vick at Pragmatic Works....

Powershell Goodies

If you haven’t seen some of the other blog post, or the Microsoft Powershell Blog, Microsoft recently release Script Browser for...

Reblog: April 18 to April 24

Photo credit – JStove
Old posts are like unicorns. You might see them just once, but it’d sure be nice to have...

Out for a day

I’m hoping I’m only out for a day. As I write this, I’ll be recovering from my ACL surgery, though...