09Feb 2022 by Grant Fritchey 6 Comments

SQL Server, PostgreSQL and the Future

PostgreSQL, SQL Server
This is just a quick note to talk about the future, mine, yours and this blog. First, I'm not abandoning SQL Server. I'm actively working on a revision of the query performance tuning book (something I should be working on instead of writing this post). SQL Server is my first, and best, database love. We're not going anywhere, SQL Server and I. You can expect more posts on SQL Server, query tuning, execution plans, DevOps, community, #sqlfamily, and everything I've blogged about for the last, ooh, 14 years next month. Second, our family is growing. Just like when a family brings home a new baby, well, I'm adding another database. It doesn't mean I don't love my first database. I still do. We're just going to ALSO be talking about…
Read More
29Mar 2017 by Grant Fritchey 1 Comment

Random Blogging Challenge Results

Professional Development
The winner is: Everyone. Hey, the challenge was random. I didn't promise a prize or a winner. Instead, I suggested everyone blog based on an image of the great Tom Baker: In no particular order we have: Persist and Aggregate Index Stats Across Server Restarts by Eric Cobb Nice use of the image, incorporating it into an interesting technical post on how to persist your index usage stats. Useful information since this DMV is reset when you restart the server (or fail it over or...). Good technical blog on a useful topic, data about your system. Working with SQLSaturday SpeedPass by Wayne Sheffield +10,000 points for both using the image well and for the PowerShell. -10,000 points for making me comment on a post about PASS (I'm the EVP of…
Read More
30Sep 2013 by Grant Fritchey 9 Comments

An Experiment Concludes

Misc, Professional Development
[caption id="attachment_2548" align="alignleft" width="300"] That was hard work[/caption] You may or may not have noticed, but every single week day for the month of September, I've put up a blog post. Some were short little blurbs linking to some other person's blog or an article that I decided to comment on. Some were the normal, longer, type of posts that I put up, explaining some bit of technical behavior that has interested me or that I've had questions about. This is the last week day of the month and I'm excited to be able to go back to blogging 1-2 times a week again. There was no small amount of stress ensuring that I had posts scheduled out for each day, coming up with ideas, getting them written up. Whew!…
Read More
05Dec 2012 by Grant Fritchey 11 Comments

Experimenting with Social Media

Professional Development
After multiple talks with Jason Strate (blog|twitter) and Denny Cherry (blog|twitter) about how they are working on automating more of their blogging and social media interactions, I'm going down that road... a little ways. The first thing that I'm trying out is Pocket. It's a way to capture web sites that you want to read later. You don't want to have to try to manage book marks in your browser. They all suck (and Google Chrome on the Mac sucks even worse) in this task. So this app lets you quickly mark a site and tag it for reading later. Further, you have an account that you can access from multiple devices. I'm already trying out two different readers that will work with Pocket on the Surface and I already…
Read More
14Jan 2011 by Grant Fritchey 11 Comments

Failed Blog Posts

Misc
Over the last week I've started and trashed two blog posts. Let me tell you, that's painful. You get some great idea and then it all goes south. For example, I was going to explain the difference between a table/heap scan and a clustered index scan. The problem was, I ran into gaps in my knowledge, some outright errors in my beliefs on how data was stored, and really faulty conclusions drawn from those facts and a less than thorough set of tests. I'm not even going to tell you what went wrong with the other notion. Luckily, all this was behind the scenes so I didn't post my ignorance for all to see.  Since I'm not offering you a chance to point & laugh (in this instance), you might…
Read More
24Nov 2010 by Grant Fritchey 4 Comments

FreeCon

Misc
I got my FreeCon. What's more, I did it in public and didn't get in trouble. FreeCon is the brain child of Brent Ozar (blog|twitter). Basically Brent gathered together a few bloggers & writers from the SQL Server community, some extremely well known, like Tom LaRock (blog|twitter), some in the middle, like me, and others that are clearly up & coming like David Stein (blog|twitter).  He jammed us all in a room and made us talk to one another. OK, that's a lie. He invited us out to this lovely little poetry space in Seattle the day before the PASS Summit was due to start, where we imbibed good food & coffee and had the opportunity to share a lot of great information with each other. The basic concept was…
Read More