Ongoing mission to explore strange new SQL problems, to seek out new tools and new routines, and boldly update production systems

  • About

Truth About Working with Tech Recruiting Agencies

SQLGrinder December 12, 2016 IT Career No Comments

The job of tech hiring has been almost completely outsourced and working with recruiting agencies has become a necessity. Recruiting agencies can be either a bridge or another hurdle between you and the job you want. If your target market

Read more

SSMS Best Practices and the Dark Theme

SQLGrinder September 19, 2016 SSMS 7 Comments

Our tools can make us more efficient and productive – if we take the time to learn their secrets. I spend a lot of time in SQL Server Management Studio (SSMS) and have learned valuable tips and features along the way from many others (links provided). SSMS

Read more

Mystery of the Changing CASE WHEN Output and Data Type Precedence

SQLGrinder September 2, 2015 T-SQL No Comments

I was working on a T-SQL query that had some very particular output requirements for decimal places. The problem seemed fairly easy, but when I tried to form a CASE WHEN statement that produced slightly different decimal lengths for each

Read more

Several Habits of a Highly Effective Troubleshooter

SQLGrinder August 12, 2015 IT Career No Comments

As a follow up to my article Anatomy of a Successful Troubleshooter, I began thinking about the habits that I have found effective when troubleshooting. I was trying to coach a teammate with troubleshooting and put together this catalog of what I have

Read more

Anatomy of a Successful Troubleshooter

SQLGrinder August 2, 2015 IT Career No Comments

I recently found myself coaching a teammate with troubleshooting advice, but it seemed like no matter what I offered they were unable to improve their situation or correct bad habits. It seemed like it just wasn’t in their DNA. So,

Read more

Zero-Cost Highly Available Reporting Services within a Failover Cluster

SQLGrinder July 7, 2015 Failover Cluster, SQL 2008, SQL 2012, SSRS 6 Comments

This solution is for anyone that has a SQL failover cluster and wishes Reporting Service to be highly available and have failover capabilities. The solution I implemented seems the most natural and how Reporting Services should work right out of the box – but

Read more

Accessing Multiple Cluster Instances without Instance Names

SQLGrinder July 1, 2015 Failover Cluster, SQL 2008, SQL 2012 No Comments

Since I was installing a dual instance cluster, I had setup two virtual SQL database names with different IP address and the second instance required a non-default instance name. However, I wanted to access both instances using the virtual name

Read more

SQL Setup Checklist – Because SQL Defaults Suck!

SQLGrinder June 24, 2015 SQL 2008, SQL 2012 No Comments

When installing SQL, it is too easy to click next and accept all the default settings. Kevin Boles has preached for years that SQL Server defaults suck! Joseph D’Antoni has also addressed bad default settings in Building Perfect SQL Servers

Read more

Gotchas: Installing SQL 2008R2 on Windows Server 2012R2 Cluster

SQLGrinder June 13, 2015 Failover Cluster, SQL 2008 No Comments

I was building a new cluster with a dual instance of SQL 2012 and SQL 2008R2. Everything went easy with the SQL 2012 but not so well with the SQL 2008R2 install. As many have found out installing SQL 2008R2

Read more

Recent Posts

  • Truth About Working with Tech Recruiting Agencies
  • SSMS Best Practices and the Dark Theme
  • Mystery of the Changing CASE WHEN Output and Data Type Precedence
  • Several Habits of a Highly Effective Troubleshooter
  • Anatomy of a Successful Troubleshooter
  • Zero-Cost Highly Available Reporting Services within a Failover Cluster
  • Accessing Multiple Cluster Instances without Instance Names
  • SQL Setup Checklist – Because SQL Defaults Suck!
  • Gotchas: Installing SQL 2008R2 on Windows Server 2012R2 Cluster

Categories

  • Failover Cluster (3)
  • IT Career (3)
  • SQL 2008 (4)
  • SQL 2012 (3)
  • SSMS (1)
  • SSRS (1)
  • T-SQL (1)
Copyright © 2019 . All rights reserved.
Powered by WordPress. Theme: Explore by ThemeGrill.