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