Kris Gruttemeyer

Senior DBA, SQL Saturday speaker. Carolina Hurricanes fan. Reality TV show junkie, husband, father.

[Kris Gruttemeyer @SQLSnowPlow]

Gonna take some time away from Twitter for my own sanity. It's just exhausting.

[Kris Gruttemeyer @SQLSnowPlow]

@LisaGB_sql @sqlpass There was an apology given, yes. This occurred back in February. As for whether or not the pattern has continued, I don't know. The last few months have been incredibly disappointing with regards acceptance and inclusion for PASS so it's not JUST this incident I'm upset about.

[Kris Gruttemeyer @SQLSnowPlow]

@ALevyInROC

[Kris Gruttemeyer @SQLSnowPlow]

The number of syntax violations I hit when writing sp_rename operations before I get it right is damn impressive.

[Kris Gruttemeyer @SQLSnowPlow]

@kimstjacques TF is incredible. Couple it with Ansobke and the possibilities are endless. One of my favorite parts of where I work is getting to use those for provisioning and change management.

[Kris Gruttemeyer @SQLSnowPlow]

@mike_walsh @SQLBob @AaronBertrand All caps too! (Also how I write to this day).

[Kris Gruttemeyer @SQLSnowPlow]

@SQLBob @AaronBertrand US Navy vet here, this is how dates are expressed in the armed services and I still use it to this day.

[Kris Gruttemeyer @SQLSnowPlow]

@BrentO 4th dial? "Manpower to maintain/operate". Whether that's FTEs or consultants/contractors, still need people to operate and troubleshoot.

[Kris Gruttemeyer @SQLSnowPlow]

@JeremyMcCorkle @BrentO I see what you did there. Well played.

[Kris Gruttemeyer @SQLSnowPlow]

@BrentO To my "cold pizza is better" family, I salute you!

[Kris Gruttemeyer @SQLSnowPlow]

@BrentO I found this series super informative and centering personally. @AMtwo did an amazing job. Keep it up, this is stuff that's so incredibly important and there's tremendous value in these posts.

[Kris Gruttemeyer @SQLSnowPlow]

@PeterDanielsCO Codswallop.

Indexes on "FK" columns will do more than a real FK will for performance aside from join elimination when doing existence checks from child to parent.

What if I were to say have FKs in staging but not prod?

[Kris Gruttemeyer @SQLSnowPlow]

I don't know who needs to hear this but:

Go with bigint and get rid of the FKs

[Kris Gruttemeyer @SQLSnowPlow]

@PeterDanielsCO What's the upside? Enforcing logic that the app should handle? Performance?

[Kris Gruttemeyer @SQLSnowPlow]

@mans048 Front end. Stop having the [super expensive] database make up for poor/lazy data enforcement practices in the app.

[Kris Gruttemeyer @SQLSnowPlow]

@DSFNet I've also done the "one man band" for toughly half of my career (10 years).

I completely empathize with you. That's a tough spot to be in. Drawing boundaries is super important in solo rotations.

[Kris Gruttemeyer @SQLSnowPlow]

The first night's sleep after you go off call is unexplainably amazing...

[Kris Gruttemeyer @SQLSnowPlow]

@awickham I use Dell Easy Arrange. Built in with the drivers for my monitors (I have 3, even the non UW can be broken up and partitioned).

[Kris Gruttemeyer @SQLSnowPlow]

@erikdarlingdata And you don't get upset.

[Kris Gruttemeyer @SQLSnowPlow]

@erikdarlingdata Fair enough! The readable secondary thing though is maddening.....