General

One of the changes that has happened with Windows in recent years is the concept of forced updates. Basically, you’re going to get updates from now on, like it or not. Generally that’s a good thing. You can delay them for a little while but not for that long. In the Advanced options update Updates, you can see this: So you aren’t going to delay them for that long. Now what does this have to do with tempdb I hear you ask?

2018-03-20

I was interested to see our old buddy Pinal Dave recently post a link to one of another old buddy Brent Ozar’s posts from 2015: What’s the difference between a contractor, and consultant, and FTE? Brent defined consultants as giving advice on what the client should do; whereas contractors turn up and do what they’re told. This distinction is pretty clear and I agree with him. I always thought that was a great post but I also always thought it misses one additional category: mentor.

2018-03-06

There is an old saying about not reinventing the wheel yet this is something that I see happening at client sites every day. I see two main reasons why this happens: Discoverability [caption id=“attachment_2809” align=“alignnone” width=“339”] Image by Nathan Dumlao[/caption] There are so many tools and frameworks in this industry, that you can’t be expected to know them all. I remember when I worked a lot with the .NET framework. I’d go into client sites and see them designing and building classes that were already in the framework.

2018-03-06

Many of my customers are software houses (ISVs). In almost all of them, I hear people complaining that they can’t find enough good staff. I think they are trying to tackle the wrong problem. Most of the staff members they are trying to find are developers, and there are so many great developers out there, but you have to accept that they might not be in the location that you hope they’re in.

2018-02-27

A current trend that I can’t say that I love is constant churn within software applications. I have no interest to go back to the days where we got a new version of SQL Server or Power BI, etc. every few years. It’s also not a case of who moved my cheese? In fact, I thrive on change. However, I’ve now become really concerned about how anyone: Learns to use a complex application Remembers how to use a complex application when they don’t use it daily I first really struck this issue with Azure.

2018-02-20

I’ve concluded that many software vendors (particularly large ones) don’t understand how much support users of their software provide to each other, and how critical that support is. The SQL and data communities are a good example of this. When someone has a problem and are wondering how to solve it, they don’t call Microsoft or Google or Oracle (or whichever vendor) first. If they’re lucky, they ask a colleague for help.

2018-02-13

Digital Transformation and Cloud Transformation are phrases that I hear bandied around at nearly every large organization that I currently doing consulting work for. Yet, in so many cases, I can’t see the organization achieving the changes required. This is for two core reasons: The first is that the culture within the organizations is a major hurdle. There just isn’t enough flexibility to think outside the box about alternative ways to work.

2018-02-06

When many SQL Server customers are asked why they haven’t kept up to date with either SQL Server versions, or more importantly, patches to SQL Server, the answers usually boil down to two reasons: They are just slack Their vendors won’t support the later version or patch level Many SQL Server application vendors don’t keep up to date with testing of their applications on released versions or patches for SQL Server.

2018-01-30

Case sensitivity in comparisons is an aspect of computing that I’m surprised is still so widespread. I can’t say it more clearly than this: It’s a pox on computing and needs to be eradicated. I’ve recently been working at a site where a new case-sensitive SQL Server system is being implemented. I cannot begin to describe what a poor idea I think this is. In the end, all that a case sensitive system allows you to do is:

2018-01-23

There’s a nasty trend that I’ve seen at a number of sites in recent years. It’s the tendency to try to block and or censor anything that the company thinks might be an issue. Some companies are so concerned about their IP (intellectual property) that they even try to stop any potential leak of that property. While on the surface, that all might seem to make sense, it’s not sensible. It’s unproductive.

2018-01-09