(888) 685-3101 ext. 2
Sankar Kenguva

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.

Sankar Kenguva

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.

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 2008\2008 R2; by July 9, 2019 Microsoft will have ended all support for 2008\2008 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

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

SQL Server Reporting Service Memory Settings

While doing research for an upcoming add on to our standard Health Checks, I have been reviewing the different option to set in the configuration file for SQL Server Reporting Services. There are memory settings which should be addressed, especially if you are running... read more

Large SQL Server Transaction Log While in Simple Recovery

Bloated Transaction log in Simple recovery mode will not shrink Received a request today from a Virtual-DBA customer asking XTIVIA to help troubleshoot why a database which is only 50MBs in size would have a transaction log of 181GB. My first thought fell to an open... read more