Mike Lynn

Mike got his start in computers in college after taking a class about Excel for an accounting major. After that class, he started taking more computer science courses and decided to change majors. After graduation, Mike took a job in Little Rock, AR as a Developer / DBA. The job was working with a .net 1.1 application, a SQL Server 2000 backend, and Microsoft Access/SSRS as the reporting tools. Mike quickly learned how much he enjoyed working with databases and has never looked back. The parts he enjoys most are helping people solve their pain points with data, whether that is helping with a performance problem or designing a new system to solve a particular need. He also enjoys automating work because it allows the person who was doing the work more time to focus on new business problems. Mike has worked with every major version of SQL Server since 2000, with the majority of his time spent on the 2008 R2, 2014, and 2016 releases of SQL Server.

SQL Server Partition Management Job Failure After Migration to Availability Group.

October 12, 2025October 10, 2025 by Mike Lynn

This is the first post in our new Case of the Week series — short write-ups from the real SQL Server issues our team of 17 SQL Server experts helps clients solve every day. Case of the Week: SQL Server Partition Job Failure after Migration from AWS FCI to AWS AG. Quick Summary A client … Read more

What the SQL Server TDE Certificate Expiration Date Does (and does not) Mean

June 26, 2024 by Mike Lynn

This post is part of our SQL Server security blog series, 30 SQL Server Security Checks in 30 Days. We’re publishing a new security check every day in the month of June. Visit our sp_CheckSecurity page to learn about our free SQL Server tool you can download and run to check your own server. Transparent … Read more

Adding SQL Server Access When You’re Locked Out

August 29, 2023 by Mike Lynn

As consultants we are sometimes asked the following question: “We have an old version of SQL that we can’t turn off and no one has access to it. Is there a way to create an account on a server you don’t have access to?” The answer is YES, and it isn’t as difficult as you … Read more

High Availability and Disaster Recovery With SQL Server Standard Edition

December 9, 2022December 8, 2022 by Mike Lynn

There are many ways to setup High Availability and Disaster Recovery, most of which are focused on SQL Server Enterprise edition. However, the licensing for Enterprise edition gets costly fast. One less talked about approach to building a cost-effective HA/DR solution is building a failover cluster instance using SQL Server Standard with SIOS Datakeeper. SQL … Read more