Live Query Statistics in SQL 2014, not just SQL 2016

• Post author:Rob Farley
• Post published:August 31, 2015
• Post category:Uncategorized
• Post comments:9 Comments

Continue ReadingLive Query Statistics in SQL 2014, not just SQL 2016

Can you still use DBCC PAGE to access data in dropped tables if TDE is turned on?

• Post author:Rob Farley
• Post published:August 12, 2015
• Post category:Uncategorized
• Post comments:4 Comments

Continue ReadingCan you still use DBCC PAGE to access data in dropped tables if TDE is turned on?

Always Encrypted with SQL 2016

• Post author:Rob Farley
• Post published:August 11, 2015
• Post category:Uncategorized
• Post comments:0 Comments

Continue ReadingAlways Encrypted with SQL 2016

Corruption, corruption, more corruption

• Post author:Rob Farley
• Post published:July 18, 2015
• Post category:Uncategorized
• Post comments:0 Comments

Continue ReadingCorruption, corruption, more corruption

Check the settings when installing SQL Server

• Post author:Rob Farley
• Post published:July 14, 2015
• Post category:Uncategorized
• Post comments:10 Comments

Continue ReadingCheck the settings when installing SQL Server

DBAs and the Internet of Things

• Post author:Rob Farley
• Post published:June 9, 2015
• Post category:Uncategorized
• Post comments:3 Comments

Continue ReadingDBAs and the Internet of Things

Monitoring skew in PDW

• Post author:Rob Farley
• Post published:May 12, 2015
• Post category:Uncategorized
• Post comments:0 Comments

Continue ReadingMonitoring skew in PDW

Tuning slow spatial queries in SQL Server

• Post author:Rob Farley
• Post published:April 29, 2015
• Post category:Uncategorized
• Post comments:1 Comment

Continue ReadingTuning slow spatial queries in SQL Server

SHOWPLAN permission denied even if the database isn’t actually used

• Post author:Rob Farley
• Post published:April 14, 2015
• Post category:Uncategorized
• Post comments:0 Comments

Continue ReadingSHOWPLAN permission denied even if the database isn’t actually used

T-SQL v MDX: Pick the hierarchy and populate the report parameter values

• Post author:Rob Farley
• Post published:April 2, 2015
• Post category:Uncategorized
• Post comments:0 Comments

Continue ReadingT-SQL v MDX: Pick the hierarchy and populate the report parameter values