Author Archives: Jay

VSCode Extensions in SQL Ops Studio

The list of extensions for SQL Ops Studio is still pretty small. But since it’s a fork of VSCode, it’s possible that any given VSCode extension just might work fine in Ops Studio. If that’s the case, here’s what you … Continue reading

Posted in Uncategorized | Tagged | Leave a comment

T-SQL Tuesday #106

This is a response to T-SQL Tuesday #106, Trigger Headaches or Happiness, by Steve Jones. I can only recall one time in the past several years (at least a decade) that I’ve found triggers to be useful. It involves data … Continue reading

Posted in Uncategorized | Tagged | 1 Comment

Running PowerShell files in SQL Operations Studio

As I’ve used SQL Operations Studio more and more, I’ve also been finally using PowerShell in more situations. Given that I like the editor and that there’s a built-in terminal, I’ve been running those in my Ops Studio instance. But … Continue reading

Posted in Uncategorized | Tagged , | Leave a comment

Tigers in the Rain

This is the first in what may become a series of anecdotal posts about what I’ve learned as a coach and how I think it translates to becoming a good manager… After the match, my brother told me he knew … Continue reading

Posted in Uncategorized | Tagged | Leave a comment

tsqllint

My PASS local group, IndyPASS, has its monthly meeting tonight. At my insistence, first-time presenter Nathan Boyd is showing off a SQL tool called tsqllint. Nathan, a coworker of mine at Salesforce, is the leading developer behind this GitHub project. … Continue reading

Posted in Uncategorized | Tagged , , | Leave a comment

T-SQL Tuesday #104

My thanks to Bert Wagner and his chosen topic for T-SQL Tuesday, Code You Would Hate To Live Without. It was just enough of an excuse to dust off the cobwebs here and get back to posting. Anyway, since half … Continue reading

Posted in Uncategorized | Tagged , , | 1 Comment

The 2017 Summit

As I adjust poorly to the three-hour time difference in Seattle this morning, I thought I’d share a few highlights of this week that are personal to me: The Panel Sessions I had a hand in bringing three panel sessions … Continue reading

Posted in Uncategorized | Tagged | Leave a comment

PASS Local Groups

I’m speaking tomorrow evening at Michiana PASS. What’s my topic? Performance, of course! Actually, it’s about querying partitioned tables. Quickly. Because that’s how I roll. But that’s not my point today. Like any good technical community, the success of PASS … Continue reading

Posted in Uncategorized | Tagged | Leave a comment

#PASS24HOP

In the past couple of years, I’ve had the opportunity to speak at a few SQLSaturdays, and presented to my local chapter, IndyPASS, a couple of times. I gained a new experience a few weeks ago, one that I had … Continue reading

Posted in Uncategorized | Tagged , , | Leave a comment

T-SQL Tuesday, Late to the DevOps Party

This is what I get for slacking off on my blogging… So, I totally missed this month’s T-SQL Tuesday. Which is a shame, because it’s an area I have a lot to talk about. Grant Fritchey hosted T-SQL Tuesday #91, … Continue reading

Posted in Uncategorized | Tagged | Leave a comment