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.
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 2008\2008 R2 Signals Move to Azure Cloud
SQL Server 2008\2008 R2’s retirement is inching closer; now is the best time to weigh your options and decide on the next course of action. Do you migrate your SQL Server database to an Azure environment or do you keep an on-premise system and upgrade to SQL... read more
Industry-Leading Performance from SQL Server 2016/2017
As SQL Server 2008\2008 R2 EOS gets closer and closer, we’ve been reflecting on the numerous versions of SQL Server that have come to meet the same fate. Looking all the way back to 1989, SQL Server has consistently offered top-of-the-line database performance.... read more
SQL Server EOS and the Pitfalls of Failing to Migrate
Security and compliance are two major issues facing users with service for SQL Server 2008\2008 R2 coming to an end. Once support ends, users will no longer have access to security updates to keep their system safe and maintain compliance for data protection... read more
Migration and Compliance in the Face of Microsoft SQL Server 2008\2008 R2 EOS
The end is near for Microsoft’s servicing of SQL Server 20082008 R2; by July 9, 2019 Microsoft will have ended all support for 20082008 R2. It may seem unsettling, but there’s a lot you can do to prepare for the end of service (and increase your database... 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 a 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
SQL Server – How to Setup a Data Source in SSRS to MS Access, MS Excel, and CSV Files
Not all data will come from a SQL Server database when you are creating reports in SSRS. There will be times you will need to create a data source to .CSV files, Excel spreadsheets, and MS Access databases. Recently, I had a customer request setting up sample data... read more
Where did that folderReport go in SQL Server Reporting Services
If you are new to SSRS, or just new to the company and you have a developer promising you they deployed a report to the report server, but it had disappear from the display… Here is a hint of where you might find it. Here you have your report manager interface. The... read more
Using Extended Events to pinpoint performance issues in SQL Server
A while back, I was tasked with using extended events to see what information could be captured to help a customer out with troubleshooting a performance issue. My first step was to see which SQL Server extended events were available on the server. With each version... read more