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 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

Improving Foreign Key Performance with Indexing

A Foreign Key is a constraint. Due to this definition, it only places a limitation on what data can be inserted into a column(s) and does not address the indexes needed to help performance when joining tables Take the following design. If you wanted to join the 2... read more