Using WAITFOR to Test Slow Code–#SQLNewBlogger

Another post for me that is simple and hopefully serves as an example for people trying to get blogging as #SQLNewBloggers. One thing I needed to do lately was test how a calling program would respond to slow code. I decided to use a normal query, but add a WAITFOR() to simulate different delay levels. However, I had to look up the syntax for the call and I decided to blog about it. WAITFOR DELAY The WAITFOR call isn’t a function....

Building Better Software for Everyone

When I first started to use the Internet, everything was text. We used Archie and Gopher, crawling through Usenet lists, with most everything in text format. When the WWW gained popularity with Netscape and visual browsing, this was just a new way of getting information for me. It made sense, and seemed easy. These days, using the WWW is something many of us do without a second thought, browsing on mobile devices as well as large...

A Byte of Redgate–Bonus Queso Recipe

As part of the Community Circle effort at Redgate, we’ve released a cookbook: A Byte of Redgate. You can read about the story in this blog, and it was a fun project. Andy Warren had the idea and I suggested it for us since Redgate has a baking club, a cake club, a cooking club, and probably more.  We even have a real cookbook author, Dave Rook. You can download the free book (pdf/epub), and it includes a guacamole recipe from me....

The Build Book of News

Every year Microsoft has held the Build conference for developers. I’ve been lucky enough to go a few times, and I was hoping to get the chance to attend again. With the pandemic, the entire event went virtual, and was held across 48 continuous hours. I was slightly disappointed as a few sessions I wanted to see were early in the morning or late at night, but I am sure most of these will be available on demand later, so I can watch...

Daily Coping 21 May 2020

I’ve started to add a daily coping tip to the SQLServerCentral newsletter and to the Community Circle, which is helping me deal with the issues in the world. I’m adding my responses for each day here. Today’s tip is to find a way to craft what you are doing to give it more meaning. I do a lot, both at work and on the ranch. One of the things that I do regularly is cook dinner. While my kids can cook, they don’t do it much. My...

Rolling Back One Bug for Another

I was working with a customer recently that develops software for use by their clients. They work in a DevOps style flow, regularly completing work and sending that to their clients. In one case, they released a hot fix quickly to resolve a bug in their software. In this case, the developers received the report, triage’d the bug, and released the fix in less than a week. Their clients were happy with the response and speed at which...

Daily Coping 19 May 2020

I’ve started to add a daily coping tip to the SQLServerCentral newsletter and to the Community Circle, which is helping me deal with the issues in the world. I’m adding my responses for each day here. Today’s tip is take a positive action to help in your local community. This is an interesting one. What can you do in your community? You can help someone, or try to help a lot of people. It’s could be a lot of work, or a little...

The Challenge of Chat

I’ve followed 37 Signals (now Basecamp) and Jason Fried for years. I think they’ve built an amazing company and have a philosophy on business and life I admire. They’ve written books, and they blog often. Recently I saw a post on chat, which is something that I’ve struggled with at times. Even before this work-at-home-at-scale experiment we’re all living, the challenges of everyone reaching out have weighed on my...