Speaking at SQL Saturday Jacksonville 2022

SQL Saturday is coming back to Jacksonville this May. I’m excited to go as I’ve like the city, but I’ve never been to this particular SQL Saturday. On May 14, 2022, I’ll be in town for the first live SQL Saturday of 2022.

I’m delivering a couple sessions on DevOps topics, but there is quite a spread of OLTP and BI topics listed. Some impressive speakers are coming, and I’m looking forward to seeing a few sessions. I’m also looking forward to catching up with John Sterrett and Jay Falck, who I haven’t seen in some time.

There are some pre-con sessions available for all day training on Friday, May 13. If you are missing the chance to learn in a live environment and not online, check those out.

You can get more details at: https://sqlsaturday.com/jax and register today.

Come join us as we get back to in-person events, learn a few things, and network with other data professionals in the north Florida area.

Posted in Blog | Tagged , , | Comments Off on Speaking at SQL Saturday Jacksonville 2022

Daily Coping 7 Apr 2022

I 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. All my coping tips are under this tag.

Today’s tip is to discover joy in the simple things in life.

I work in tech, like many of you that read this. We use various tools to do our jobs, some of which we appreciate and enjoy. Some are innovative, and certainly some of us are blessed with more resources and access to things.

When I saw this tip, I thought of a few simple things that I enjoy.

I have a few wireless chargers: one on my desk, one on my nightstand, and one in the Tesla. I think it’s amazing I can drop my phone onto a surface and it charges. That’s one little tech thing that makes me smile on a regular basis.

My office gets chilly at times. I’m near the garage and dog door, and at times I get a bit of a draft. I can wear more clothes, but I got a chair massager/heater, and I use the heat often on cold days. It reminds me of the seat heaters in the cars, which I also enjoy often.

The last thing I enjoy regularly is having a wireless mouse. I had to use my kid’s laptop to do something recently and noticed he had a plugged in mouse. I have a wireless one on my desk, and I carry one when I travel. Batteries seem to last for years, and the convenience of moving it around, the smooth optical tracking, and lack of a wire getting in the way bring me joy every day.

Bonus, I have a custom mouse mat with pictures of my kids. I love that as well.

Posted in Blog | Tagged , , | Comments Off on Daily Coping 7 Apr 2022

Advanced Incident Response

Early in my career, I worked at a few smaller companies where a problem with the computer systems meant I went into the office and stayed until things were working. As I went to a few larger companies, I wasn’t alone when a system went down, but the process was mostly the same. We figured out what was wrong and found a way to fix or replace things, occasionally with help from a vendor. Those were the (not necessarily) good days before our internal networks were connected to a public Internet.

Companies developed formal incident response plans to deal with various issues, whether these were problems we caused ourselves or failures of an application. I had the fortune, or misfortune, to be involved in more than a few issues and learned a great deal in how to solve problems as well as how to manage the impact to a large number of employees.

As email and Internet use grew, so did the attacks with viruses and other sorts of malware. Antivirus software helped a great deal, but these days ransomware seems to be a common problem that isn’t as preventable as I would have hoped. Quite a few friends have dealt with ransomware issues, most of which have not been widely reported in the news.

I saw an article about a few things that you might want to consider adding to your incident response plan. While some of these items might be unique to the ransomware threat, the thing that struck me was that there is a need to react quickly, in real-time, in response to any detection of an issue. I can only assume this means that there needs to be some advanced monitoring of nodes to detect issues, and I’m not sure how many organizations would adopt this, but in today’s world where we want systems available 24/7, perhaps they will.

Being on call is a part of working in many IT departments. Having a response plan, even the general outline of one, helps to coordinate resources and ensure that we use people effectively. Tools are important, especially in today’s complex world, and it is important that one of those tools is a simple backup, preferably air-gapped from your main systems. If you don’t have these things in place, you might suggest someone start assembling them. These days it seems it’s not if you will get attacked, but when.

Lastly, I don’t often see this addressed in plans, but make sure you have spelled out some guidelines on rotating staff and getting rest. Far too many companies want “all hands on deck” and forget that normal business still needs to occur. Any incident could last longer than a day, and you want to ensure that some of your staff is fresh and ready to take over from those that do need rest. Don’t be afraid to send some people home, or better yet, don’t call them in the first place.

Steve Jones

Listen to the podcast at Libsyn, Stitcher, Spotify, or iTunes.

Posted in Editorial | Tagged , | Comments Off on Advanced Incident Response

Removing a LocalDB Instance

Another post for me that is simple and hopefully serves as an example for people trying to get blogging as #SQLNewBloggers.

This might be obvious and easy, but I spent a couple minutes learning how to remove a LocalDB instance.

I tried to use remote, but that didn’t work:

2022-03-03 09_17_39-C__Windows_System32_cmd.exe

There error reminded me that in my day, most commands use –? or /? to get help. A lot of CLIs these days use –help (two dashes). That doesn’t work here. But /? does.

2022-03-03 09_18_33-C__Windows_System32_cmd.exe

This shows me the delete option is the one to use. I tried that, but I needed to stop the instance.

2022-03-03 09_19_55-C__Windows_System32_cmd.exe

Running stop and then delete allowed this to succeed.

2022-03-03 09_20_51-C__Windows_System32_cmd.exe

SQL New Blogger

After writing a previous post, which took me 10 minutes or so, I went to clean up my environment. I realized this was easy, but also worth a post about how I learned this.

Just 5 minutes. You could write posts like this to further your knowledge and help your career.

Posted in Blog | Tagged , , , | Comments Off on Removing a LocalDB Instance