Blogs

What Are SQL Server Logins and Users

You’re a data professional learning about managing SQL Server and you’ve been asked to grant permissions for SQL Server to an individual or a group of individuals. What do you need to understand in order to accomplish this? I’ll be your guide to …

Continue reading

Building a SQL environment inventory with the MAP Toolkit

 The MAP Toolkit, also called the Microsoft Assessment and Planning Toolkit, is a standard way to obtain information about your Microsoft environment. This includes your SQL Server. The tool is so common that a link to it is included in the SQL …

Continue reading

6 Ways to Advance Your IT Career

The “Great Resignation” is upon us, or so the internet tells us. People want better working conditions, better wages, just… better. Large swaths of people are trying to advance their careers. Here are 6 ways to advance your IT career. Accept that …

Continue reading

Error Messages 8114 or 22122 When Performing Change Tracking Cleanup

 You’re a data professional and you’re trying to keep up with patching a wide range of SQL Server versions and editions. How do you know what’s in the CU and whether you should apply it or not? My favorite way to read up on CUs is to go to …

Continue reading

Thoughts On Pass Data Community Summit 2021

 Pass Data Community Summit was November 10-12 and was hosted and sponsored by RedGate along with other supporting sponsors like Microsoft and smaller companies like MinionWare. Having been to last year’s virtual Summit, I think this one was done …

Continue reading

6 Steps to Build a Training Plan

 As an athlete there is a certain amount of preparation that goes into being selected to be on a team, competing for a starting role and then being competitive with the opponent. For tennis players to be competitive and go to the finals in Wimbledon, …

Continue reading

6 things to consider when presenting

 Things to consider when presenting I’ve presented a few times recently and discovered I like doing it. Presenting is a great way to give back to the I.T. community - in this case the SQL Server community. I’ve previously blogged about things I …

Continue reading

What is it like to be a presenter at the News Stars of Data virtual conference

 Back in early July 2021, I presented at the SQL Server Meetup I co-host with Anthony Fortner. We had a speaker no show a couple of months prior and then for the July meeting a speaker had to cancel about a week before the meeting. I couldn’t let …

Continue reading

Four Areas to Focus on When You Start A New DBA Role

 You’ve just been hired into a DBA role at a new company, or you’ve been given the DBA keys at your current company. Maybe you’re a SysAdmin and your boss has informed you that you are now supposed to manage the SQL Servers as well as everything else …

Continue reading

Three Keys to SQL Server Performance

Everyone wants good performance from their database systems. Some even expect and need a high performing Ferrari all the time. How is this achieved though? What do you need to understand about SQL Server specifically in order to make your company’s …

Continue reading