SQL RNNR

1 DBA's Professional Blog
rsslink
  • Home
  • Book Reviews
  • Running
  • Blogging
  • About
  •  
  • Home

SQL Server Transaction Log Management

  Tony Davis and Gail Shaw
Rating: Unrated
  Back to library
SQL Server Transaction Log Management

This book has not yet been reviewed.

  • Blogroll

    • Aaron Bertrand
    • Aaron Nelson
    • Adam Machanic
    • Alex Kuznetsov
    • Andy Warren
    • Brad McGehee
    • Brad Schulz
    • Brent Ozar
    • Buck Woody
    • Christophe Laporte
    • Dave Ballantyne
    • David Barbarin
    • Dukagjin Maloku
    • Ewald Cress
    • Gail Shaw
    • Gianluca Sartori
    • Grant Fritchey
    • Hugo Kornelis
    • Jack Corbett
    • Jeremiah Peschka
    • Jimmy May
    • Jorge Segarra (SQLChicken)
    • Josef Richberg
    • Kalen Delaney
    • Kendal Van Dyke
    • Kimberly Tripp
    • Linchi Shea
    • Lynn Pettis
    • Michelle Ufford
    • Paul Randal
    • Paul White
    • Phil Factor
    • SQL Server Protocols
    • Steve Jones SSC
    • Thomas LaRock
    • Tim and Lori Edwards
    • Tim Ford
    • TSQL Challenges

  • Categories

    • Blogging (9)
    • Book Reviews (30)
    • Certification (5)
    • Corner (39)
    • Extended Events (91)
    • Meme Monday (7)
    • Meme15 (2)
    • News (592)
    • Presentations (10)
    • Professional (581)
    • Running (11)
    • Scripts (71)
    • Security (6)
    • SQLServerPedia Syndication (260)
    • SSC (481)
    • SSG Syndication (4)
    • SSSOLV (62)
    • The Corner dep (58)
    • TSQL Tuesday (62)
    • Uncategorized (2)

  • Popular Posts

    • T-SQL Tuesday #38 – Standing Firm (30)
    • T-SQL Tuesday #051: Place Your Bets (28)
    • T-SQL Tuesday #009: Beach Time (22)
    • 12 Days of Christmas 2013 Day 1 (21)
    • MCM Road Less Traveled (14)
    • Last Time CheckDB was Run (13)
    • Having Cake and Eating it too (13)
    • Audit who Dropped the Database (12)
    • Last Known Good CheckDB (11)
    • TableSpace Update (11)

  • SQLHelp

    • @gbargsley: @DBArgenis @psdbatools Thank you for the input. #sqlhelp
    • @DBArgenis: @gbargsley @psdbatools You're welcome to submit feedback on that, though: https://t.co/BWibSEZnh0 #sqlhelp
    • @DBArgenis: @gbargsley @psdbatools I don't think we expose a way to generate that report without using Setup. You need to have… https://t.co/JWs6xhqXLm
    • @DBArgenis: @gbargsley I hear you, but what are you trying to do with the output of said report? Are you trying to use it as a… https://t.co/kIo81plwgV
    • @gbargsley: @DBArgenis I was going to run it remotely with PowerShell, then I remembered that it requires the setup.exe to be t… https://t.co/fCqNAJsb1J
    • @DBArgenis: @gbargsley What are you trying to achieve? #sqlhelp
    • @gbargsley: #sqlhelp Does anyone know if I can engineer the SQL Setup Discovery Report without running the setup.exe /action=RunDiscovery?
    • @LordOfTheData: #sqlhelp SSRS question. Does cdec have an upper limit? I'm getting an error that sum(cdec( is encountering somethin… https://t.co/55uU9qrTvm
    • @stridergdm: @darthbane3825 #sqlhelp I might actually try to do something with powershell to preparse it. I've found it help hel… https://t.co/wHyKOE7kgR
    • @MadPiet: If I want to learn predictive modeling in the MS stack, do what... AzureML? Some PowerBI? Anything else? #sqlhelp


© 2018 SQL RNNR All rights reserved - Mobile View Fastfood theme by TwoBeers Crew - Powered by WordPress
Recent Posts
  • Change SQL Server Collation… by Jason Brimhall

    Every now and again we have to deal with a sudden requirements change. When that happens, we sometimes just need to take a step back and evaluate the entire situation to ensure we are proceeding down the right path. It is better to be pensive about the course of action rather than to knee jerk into the course of action. Do you want to spend 5 minutes on the solution or 30-40 minutes doing the same thing? Changing collation can be an easy change, or it can be one met with a bit of pain doing a reinstall (more painful if more user databases are present). Keep that in mind and keep cool when you need to make a sudden change.

  • T-SQL Tuesday #101: Essential Tools by Jason Brimhall

    What are the tools you love to use? What are the tools that maybe need a little sharpening? What tools do you have that maybe you wish were the same caliber as somebody else’s tools? And lastly, which tools do you not possess that you wish you possessed?

  • Syspolicy Phantom Health Records by Jason Brimhall

    SQL Server comes with a default SQL agent job installed (for most installations) to help manage the collection of system health data. I would dare say this job is ignored by most people and few probably even know it exists. This job is the syspolicy_purge_history job.

  • SQL Server Extended Availab… by Jason Brimhall

    It may come as no surprise to many that Microsoft has hastened the SQL Server development cycle. Furthermore, it may be no surprise to many that Microsoft has also hastened the patch cycle for SQL Server.

  • Extended Events File Initia… by Jason Brimhall

    One of the recommended methods to trap payload data in an XE session is via the use of the event_file target. Sending data to a file has numerous benefits such as being able to take the trace and evaluate the trace file from a different machine (locally to that machine).

  • Profiler for Extended Event… by Jason Brimhall

    As of SSMS 17.4 we have been given the ability to control XEvents Profiler just a tiny bit more. For what it is worth, we as Database Professionals love to be able to control our database environment. So this teeny tiny bit of new control ability is potentially a huge win, right?

  • SQL Server User Already Exi… by Jason Brimhall

    One of my all-time favorite things in SQL Server is security. No matter what, it always seems that there is a new way to abuse permissions. When people abuse their access level or abuse the way permissions should be set in a SQL Server environment, we get the pleasure of both fixing it and then trying to educate them on why what they did was wrong and how to do it the right way.

  • Database Corruption and IO Errors by Jason Brimhall

    A quick way to have your day turned upside down and rip your gut out with nerves and anxiety is to come in one day to find that users are panicked, applications are not working and the HelpDesk team is curled up in the fetal position in the corner. Why? The sky is falling and everybody thinks the database has blown up. You appear to have a corrupt database and nasty IO errors.

  • Checking the Health of your CLR by Jason Brimhall

    Having a tool to be able to monitor CLR health will be essential as you deploy more and more managed code within SQL Server. Extended Events offers a great lightweight means to do just that. This article shows how to deploy a session that will capture the various changes with CLR objects within our database environment. In addition, you will be able to capture various conditions related to performance or problems with the managed code. You may even recognize some of the CLR events from the system_health session.

  • SQL Server Configurations &… by Jason Brimhall

    One thing that SQL Server does very well is come pre-configured in a lot of ways. These pre-configured settings would be called defaults. Having default settings is not a bad thing nor is it necessarily a good thing.

Categories
  • News ( 592)
    Recent Posts
    • Change SQL Server Collation… by Jason Brimhall
    • T-SQL Tuesday #101: Essential Tools by Jason Brimhall
    • Syspolicy Phantom Health Records by Jason Brimhall
    • SQL Server Extended Availab… by Jason Brimhall
    • Extended Events File Initia… by Jason Brimhall
  • Professional ( 581)
    Recent Posts
    • Change SQL Server Collation… by Jason Brimhall
    • T-SQL Tuesday #101: Essential Tools by Jason Brimhall
    • Syspolicy Phantom Health Records by Jason Brimhall
    • SQL Server Extended Availab… by Jason Brimhall
    • Extended Events File Initia… by Jason Brimhall
  • SSC ( 481)
    Recent Posts
    • Change SQL Server Collation… by Jason Brimhall
    • T-SQL Tuesday #101: Essential Tools by Jason Brimhall
    • Syspolicy Phantom Health Records by Jason Brimhall
    • SQL Server Extended Availab… by Jason Brimhall
    • Extended Events File Initia… by Jason Brimhall
  • SQLServerPedia Syndication ( 260)
    Recent Posts
    • Change SQL Server Collation… by Jason Brimhall
    • Syspolicy Phantom Health Records by Jason Brimhall
    • SQL Server Extended Availab… by Jason Brimhall
    • Extended Events File Initia… by Jason Brimhall
    • Profiler for Extended Event… by Jason Brimhall
  • Extended Events ( 91)
    Recent Posts
    • Extended Events File Initia… by Jason Brimhall
    • Profiler for Extended Event… by Jason Brimhall
    • Checking the Health of your CLR by Jason Brimhall
    • Sharepoint Diagnostics and XE by Jason Brimhall
    • Dynamics AX Event Session by Jason Brimhall
  • Scripts ( 71)
    Recent Posts
    • Incorrect Syntax – What? by Jason Brimhall
    • What’s that SSIS Password by Jason Brimhall
    • Drop That Schema by Jason Brimhall
    • Linked Servers and Stats by Jason Brimhall
    • Endpoint Owners – Bac… by Jason Brimhall
  • TSQL Tuesday ( 62)
    Recent Posts
    • T-SQL Tuesday #101: Essential Tools by Jason Brimhall
    • Summiting that Technical Challenge by Jason Brimhall
    • T-SQL Tuesday #097: Learning Plans by Jason Brimhall
    • T-SQL Tuesday #096: Inspira… by Jason Brimhall
    • T-SQL Tuesday #089: The Clo… by Jason Brimhall
  • SSSOLV ( 62)
    Recent Posts
    • Las Vegas UG This week by Jason Brimhall
    • October 2014 Las Vegas UG Meeting by Jason Brimhall
    • September 2014 Las Vegas UG Meeting by Jason Brimhall
    • SQL Server UG in Vegas Augu… by Jason Brimhall
    • July 2014 Vegas UG Meeting by Jason Brimhall
  • The Corner dep ( 58)
    Recent Posts
    • Dedupe Data CTE by Jason Brimhall
    • SQL Server Standard Reports… by Jason Brimhall
    • DB Benchmarking by Jason Brimhall
    • SQL Bitwise Operations by Jason Brimhall
    • Database Maintenance by Jason Brimhall
  • Corner ( 39)
    Recent Posts
    • Cloud Nirvana by Jason Brimhall
    • Scaring a Database Near you by Jason Brimhall
    • MCM on Life Support by Jason Brimhall
    • Rare Species, Extinction an… by Jason Brimhall
    • T-SQL Tuesday #45 Follow th… by Jason Brimhall
  • [...]
Recent Comments
  • Jason Brimhall about Change SQL Server Collation…
    I didn't show the impact to my existing databases on the test instance because I felt it out of scope.…
  • Jason Brimhall about Change SQL Server Collation…
    Agreed.
  • Garland MacNeill about SQL Server Extended Availab…
    Nicely done. Came across the article at the end of April and was slack jawed. I couldn't figure out how…
  • Blair Christensen about Change SQL Server Collation…
    One thing to note: this was a brand new install with no data in the database. Thus the…
  • AG about Change SQL Server Collation…
    I don't see a mention of how or if, existing databases are affected. IIRC, changing server collation only affects…
  • Alexandros Pappas about Finding Deprecated Uses in …
    I want to upgrade an SQL Server 2008 R2 to SQL Server 2016. I would like to find the queries…
  • Bow about Profiler for Extended Event…
    Great post, thank you! I am definitely going to check out your post on 'learning-extended-events-in-60-days'!
  • Jason Brimhall about Database Corruption and IO Errors
    Thanks Robert.
  • Robert L Davis about Database Corruption and IO Errors
    Great article Jason. When I saw your initial list of things to do and #5 was "Restore", my initial thought…
  • Jason Brimhall about Parse Dynamics AX Context Info
    that is a very good question. AX 2009 did things a little differently. While minimal, at best, the online users…
Welcome , today is Wednesday, April 25, 2018
  Home
  Older Posts
  Top of page
  Bottom of page