Author Archives: Jay

What are you known for?

As I mentioned before, I’ll be touching on a few marketing topics over the course of the next several weeks. Taking a top-down approach, I’m starting with the question, “What are you known for?” I hang around the IndyCar paddock … Continue reading

Posted in Uncategorized | Tagged | Leave a comment

Marketing

I write software for a living, and my posts are generally about topics that I think are useful to other people who do the same. This is the first in a series that is a slight diversion from that. I … Continue reading

Posted in Uncategorized | Tagged | 1 Comment

SQL Saturday #597, Phoenix

I’m at another SQL Saturday again this weekend, this time in Phoenix, Arizona. I’m looking forward to meeting the Arizona SQL Server Users Group folks and being back in the Phoenix area for the first time in over a decade. … Continue reading

Posted in Uncategorized | Tagged | Leave a comment

Threading

A while back, I wrote an app that spawned a collection of threads to run some work in parallel, using the resources in the System.Threading namespace of the .NET Framework. Some time after that, I worked on another app that … Continue reading

Posted in Uncategorized | Tagged , , | Leave a comment

T-SQL Tuesday, Microsoft Connect Edition

This is a bit of a deviation from my usual post. You can thank Brent Ozar for that. He decided to host Adam Machanic‘s T-SQL Tuesday this month. Since Brent Ozar Unlimited‘s newsletter is about the only one I read … Continue reading

Posted in Uncategorized | Tagged , , | 3 Comments

SQL Saturdays

Sharpening my technical skills has been an ever-present goal since I started assembling computers for a guy named Dale around 1990. Over the years, some work better than others. There’s definitely nothing that can compare to hands-on experience, but that’s … Continue reading

Posted in Uncategorized | Tagged , | Leave a comment

A Christmas Wishlist

I finally had the chance to catch up on some reading last week, and it got me thinking about sharing this list. If you are in software development, then I would consider these four books to be required reading. I’m … Continue reading

Posted in Uncategorized | Tagged | Leave a comment

Fonts and Frustration

TL;DR – There are a couple of XML files at the end of this post. If you regularly present technical material using SSMS, download these. I present technical sessions now and then – my local PASS group, SQL Saturdays, internal … Continue reading

Posted in Uncategorized | Tagged , | 1 Comment

NULL Pain Revisited

In an earlier post, I covered an issue with special characters in Transact-SQL. I ended up creating a scalar function to handle it. Well, fast-forward a few months and now my query’s inability to go parallel is really starting to … Continue reading

Posted in Uncategorized | Tagged | Leave a comment

Compile Time Part 2

TL;DR – Square brackets do not save the optimizer any time. If you didn’t already read Part 1, you might want to go back and do that. I will easily admit that I can be rather obsessive about code formatting … Continue reading

Posted in Uncategorized | Tagged | Leave a comment