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.

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

SQL Server 2016 Database Engine: New Features and Enhancements

XTIVIA is highlighting new features in SQL Server 2016! We can set you up with all the exciting new features available in SQL Server 2016. Here’s how implementing new features will benefit your SQL Server environment. Stretch Database Stretch Database allows you... read more

Differences Between Windows and SQL Server Authentication

A common question asked from super users of applications is, “What is the difference between Windows Authentication and SQL Server Authentication?” While there are many details under the covers of SQL Server and Windows Authentication, the differences can... read more