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.

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

What questions to ask when planning a SQL Server backup strategy

Every database holds different business data and has its own recovery needs.  Unfortunately, there is not a single solution for all databases. There are many possibilities and solutions. For each database you are responsible for supporting you should be asking... read more

SQL Server History Cleanup Task

This feature in the maintenance plans in SQL Server seems to be either ignored or over used. Either people do not put this step into any maintenance plan causing MSDB database to grow large over time. Or they have this step placed in every maintenance plan not fully... read more