Kathleen Long

SQL Server Lead DBA & Delivery Manager

Kat is a SQL Server Lead DBA and Delivery Manager at XTIVIA. She is responsible for the architecture design, installation, configuration, and management of a wide range of SQL Server databases for multiple clients. Kat has 20+ years of experience with SQL Server. She is a member of PASS, as well as a part of the local SQL Server Community in Colorado Springs. She has presented at SQLSaturdays, as well as several of the National conferences. When not working with SQL Server, she enjoys hot air ballooning and crafting, with her latest focusing on free motion quilting.

Why Migrate to SQL Server 2022

Introduction Businesses rely on robust database systems to manage critical information in today’s data-driven world. SQL Server, a stalwart in the database landscape, has evolved over the years, and SQL Server 2022 brings a host of compelling features that make... read more

The Vital Role of DBAs in Cloud Alert Management

In the era of cloud computing, where data is the new currency, databases are the backbone of modern businesses. They store, manage, and retrieve critical information for decision-making and operations. However, ensuring cloud databases’ seamless functioning... read more

SQL Server 2016 End of Mainstream Support and How It Affects Your Business

July 13th, 2021 is quickly approaching. This is the date Microsoft has announced as the end of Mainstream Support for SQL Server 2016. What does this mean for the large number of Servers and applications using SQL Server 2016? You feel like you just completed your... read more

SQL Server Instance, Login, Database, Schema, User

What’s in a name? When it comes to different Relational Database Management systems (RDMS) it can be confusing. The same words have different meaning depending on the software. SQL Server Database Engine has Instances, Logins, Databases, Schema, and User. When a... read more

Firewalls at the database Level for Azure SQL

Azure SQL has introduced the ability to set firewall rules at the database level. A database firewall is different than the server firewall which can be configured via the Azure Portal. The database firewall gives you the ability to not only limit connections at the... read more

Different High Availability Offerings in SQL Server 2016

This is a high-level description of the different High Availability Offerings in SQL Server 2016, meant to give a general idea of what is offered and the limitations for each offering. AlwaysOn High Availability Groups When most people use the terms AlwaysOn they are... read more