Long Running Transactions Cause SQL Server Transaction Log to Grow (MSSQLTips 01/20/2017)

[View MSSQLTips newsletter online] [Tutorials] | [Tips] | [Videos] | [DBA] | [Developer] | [Business Intelligence] [Have a SQL Server Assistant on Hand with SQL Doctor] [Long Running Transactions Cause SQL Server Transaction Log to Grow] I noticed that when some queries run a lot of transaction log space is utilized. Can you explain how the transaction log gets used and why it doesn't always free up space after issuing transaction log backups.... [Simple script to check SQL Server Replication Jobs] We have SQL Server replication configured on our servers and every once in a while we find the SQL Agent replication jobs are stopped and data is not being replicated. We can find the status of the replication agents either using replication monitor or t... [Identify SQL Server Security Vulnerabilities with SQL Secure] o you really know who has access to your SQL Server database? With data breaches becoming more common, DBAs must be proactive in verifying and controlling what access permissions are assigned to database users. Join us to learn how to effectively man... [Create a High Performance SANLess SQL Server Cluster] Making SQL Server deployments resilient to failures is a goal most want to achieve. Whether you are trying to account for high availability and/or disaster recovery, there are various methods to achieve the end goal. One of the most popular approache... [Free SQL Server Tutorial on Backups] One of your last lines of defense for just about any system is to have a backup in place in case there is a need to recover some or all of your data. Become an expert on SQL Server Backups.... [How to hide SQL Server user databases in SQL Server Management Studio] I have a SQL Server instance that has hundreds of databases. Navigating the database tree in SSMS is a pain and I was wondering if there was a way to limit the list of databases that I see in SSMS? In this tip we cover the options to do this.... [Creating Linked Tables in PowerPivot for Excel] I have read a tip on Importing Data from Multiple Data Sources into PowerPivot for Excel. I have data in Excel which is frequently updated and I want to know if I can consume that data from Excel in PowerPivot, while I continue to modify the data in Excel... [What does it mean to be a SQL Server DBA] I am aspiring to become a SQL Server DBA. I have seen numerous sets of information related to SQL Server tests, conferences, user groups, your tips and more, but what does it really mean to be a SQL Server DBA? What should I really aspire to become as a... [Twitter] [Facebook] [LinkedIn] [Google+] You are receiving this as a subscriber of MSSQLTips.com. If you wish to discontinue receiving email, please send us an email to [unsubscribe]. Edgewood Solutions LLC PO Box 682 | Wilton, NH 03086 [Privacy Statement] Sent to: {EMAIL}