Blogs

How to Check SQL Server Security Part 1

You know you need to be thinking about SQL Server security, but maybe you’re not sure where to start. Topics like firewalls and ports and port scanners and such may be dancing your mind. Those are good things to think about, but they are not under …

Continue reading

How to Build a SQL Server Inventory Using PowerShell

You’re a data professional and you’ve been given the keys to a new SQL Server environment. You know you need to build a SQL Server inventory so you know what is in your environment, but how do you get that information? One of the things I have talked …

Continue reading

How to Build a SQL Server Inventory Using T-SQL Scripts

You need to create a SQL Server inventory. Without this information, you’ll be unaware of critical information about the environment your responsible to manage. We’re on a journey to make sure that you as a DBA know what SQL Servers are in your …

Continue reading

Is it ok to use proprietary database features

 I was recently thinking of SQL Server temporal tables and how there is a perspective that you shouldn’t use proprietary features of a product because it locks you into that product. I want to be your guide on this matter. Database platforms are …

Continue reading

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