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 (33)
    • Certification (5)
    • Corner (39)
    • DatabaseMasters Syndication (2)
    • Extended Events (114)
    • Meme Monday (7)
    • Meme15 (2)
    • News (644)
    • Presentations (10)
    • Professional (633)
    • Running (11)
    • Scripts (74)
    • Security (9)
    • SQLBP (4)
    • SQLServerPedia Syndication (301)
    • SSC (534)
    • SSG Syndication (4)
    • SSSOLV (62)
    • The Corner dep (58)
    • TSQL Tuesday (77)
    • Uncategorized (1)
  • 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)
    • Learning Extended Events in 60 Days (14)
    • Last Time CheckDB was Run (13)
    • Audit who Dropped the Database (13)
    • Having Cake and Eating it too (13)
    • Last Known Good CheckDB (12)
  • SQLHelp

    • @AliRazeghi: @NedOtter @SQLSoldier @NedOtter #SQLHelp would you know by what mechanism the tnx is written to the log on the prin… https://t.co/BLSUR4JNuT
    • @NedOtter: @AliRazeghi From the epic tome "Pro SQL Server 2008 Mirroring", written by our beloved @SQLSoldier : txn written t… https://t.co/Wqds6GGaHw
    • @AliRazeghi: #SQLHelp docs say it works 'on the physical record on the log level' but I'm not sure by what mechanism it uses to send that data over.
    • @AliRazeghi: #SQLHelp Need help figuring out how mirroring sends transaction data to the mirrored node. Log Shipping restores l… https://t.co/0lYDcX71E8
    • @SeekWell_io: RT @Kevin3NF: #sqlhelp I've never tried this before... SQL Service is stopped, as is the Agent. Starting the agent then auto starts the…
    • @shadyrudy: @sqlstudent144 When I've done this, I used a "real" table: create table tempdb.dbo.taco (someid int identity (1,-1)… https://t.co/Us9gCgpf7D
    • @sqlstudent144: Just to confirm something, this doesn't work and has never worked correct? SELECT * FROM <linkedserver>.tempdb.dbo… https://t.co/m0Jr8QLrT6
    • @AngryPets: @oriordanrichar1 You can query https://t.co/gavuNW55U2_exec_procedure_stats : https://t.co/BoTtH5ihje There are… https://t.co/wOxuszma8Q
    • @oriordanrichar1: #SQLHelp Any idea how to get runtime statistics per stored procedure as opposed to query from Query Store?
    • @k_t_schmidt: #sqlhelp Reporting ?: When you have users that want to see all the data or some of the data, what are good standar… https://t.co/zSv0RE8psn


© 2019 SQL RNNR All rights reserved - Mobile View Fastfood theme by TwoBeers Crew - Powered by WordPress
Recent Posts
  • Passion, Challenges, and SQL by Jason Brimhall

    One of my biggest reasons why I do what I do, boils down to the challenges that I frequently get to encounter. There is a wild satisfaction to working on a very difficult and challenging task, product, tool, profession, skill, etc. This satisfaction often involves reward and a sense of accomplishment.

  • Interview Trick Questions by Jason Brimhall

    Anybody that has interviewed for a job has most likely run into the trick question. Some interviewers like to throw out multiple trick questions all in an effort to trip up the candidate and get the candidate to doubt him/her self.

  • Defaults In msdb Database by Jason Brimhall

    The defaults in the msdb database are about what is missing. It’s missing quite a few things that could be critical to your environment.

  • Easy Permissions Audit by Jason Brimhall

    This is an introductory level method demonstrating how to quickly audit database objects and principals for granted permissions.

  • Audit SQL Agent Jobs by Jason Brimhall

    One probably seldom thinks of the SQL Agent jobs scheduled on the SQL Server instance – unless they fail. What if the job failed because something was changed in the job? Maybe you knew about the change, maybe you didn’t.

  • Quick Permissions Audit by Jason Brimhall

    DBAs often need to figure out who has access to what. When that need arises, it is frequently adequate to just perform a quick permissions audit.

  • Automating like an Enterprise DBA by Jason Brimhall

    One of the things that should seem very commonplace to a data professional is the effort to become a lazy DBA. A lazy DBA is not a bad thing. It just means the DBA works hard to automate the repetitive mundane tasks that may be tedious and/or time consuming.

  • ArithAbort and SQL Agent Failures by Jason Brimhall

    ARITHABORT can be a short termed head scratcher.  Pay close attention to what has changed in the environment.  Test alternatives.  And check those connection strings.

  • Short Circuiting Your Session by Jason Brimhall

    It isn’t very often that one would consider a short circuit to be a desired outcome. In SQL Server we have a cool exception to that rule – Extended Events (XE).

  • Automatic Tuning Monitoring… by Jason Brimhall

    Thanks to Extended Events (XE), we have access to a guide of sorts that will help us better understand if our shiny new tool (automatic tuning) is operating as desired.

Categories
  • News ( 644)
    Recent Posts
    • Passion, Challenges, and SQL by Jason Brimhall
    • Interview Trick Questions by Jason Brimhall
    • Defaults In msdb Database by Jason Brimhall
    • Easy Permissions Audit by Jason Brimhall
    • Audit SQL Agent Jobs by Jason Brimhall
  • Professional ( 633)
    Recent Posts
    • Passion, Challenges, and SQL by Jason Brimhall
    • Interview Trick Questions by Jason Brimhall
    • Defaults In msdb Database by Jason Brimhall
    • Easy Permissions Audit by Jason Brimhall
    • Audit SQL Agent Jobs by Jason Brimhall
  • SSC ( 534)
    Recent Posts
    • Passion, Challenges, and SQL by Jason Brimhall
    • Interview Trick Questions by Jason Brimhall
    • Defaults In msdb Database by Jason Brimhall
    • Easy Permissions Audit by Jason Brimhall
    • Audit SQL Agent Jobs by Jason Brimhall
  • SQLServerPedia Syndication ( 301)
    Recent Posts
    • Passion, Challenges, and SQL by Jason Brimhall
    • Interview Trick Questions by Jason Brimhall
    • Defaults In msdb Database by Jason Brimhall
    • Audit SQL Agent Jobs by Jason Brimhall
    • Automating like an Enterprise DBA by Jason Brimhall
  • Extended Events ( 114)
    Recent Posts
    • Easy Permissions Audit by Jason Brimhall
    • Audit SQL Agent Jobs by Jason Brimhall
    • Quick Permissions Audit by Jason Brimhall
    • Short Circuiting Your Session by Jason Brimhall
    • Automatic Tuning Monitoring… by Jason Brimhall
  • TSQL Tuesday ( 77)
    Recent Posts
    • Passion, Challenges, and SQL by Jason Brimhall
    • Automating like an Enterprise DBA by Jason Brimhall
    • T-SQL Tuesday Participation… by Jason Brimhall
    • T-SQL Tuesday 109: Influenc… by Jason Brimhall
    • To Influence or Be Influenced? by Jason Brimhall
  • Scripts ( 74)
    Recent Posts
    • T-SQL Tuesday #108: New Hor… by Jason Brimhall
    • Audit Database Offline Events by Jason Brimhall
    • T-SQL Tuesday #104: Just Ca… by Jason Brimhall
    • Incorrect Syntax – What? by Jason Brimhall
    • What’s that SSIS Password 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 Defaults In msdb Database
    Yes it is a good idea. A fillfactor of 100 is great if the data in the table is always…
  • Jason Brimhall about Endpoint Owners – Bac…
    When the ad account disappears, then you could see various abnormalities that could be intermittent.
  • Jason Brimhall about Upgrading From SQL Server Profiler
    That is fine.
  • Jason Brimhall about Interview Trick Questions
    I like to use that one as well.
  • Bill Bergen about Easy Permissions Audit
    In your outstanding script called "Script to auto generate a security report for your SQL Server instance" where can I…
  • Dave Dustin about Interview Trick Questions
    One I ask is "How would you go about identifying and removing duplicate rows from a table…
  • Mike about Easy Permissions Audit
    Nice quick, and easy check on db object security...thanks.
  • Fermin about Upgrading From SQL Server Profiler
    Ɗo you mind if I quote a feѡ ⲟf your articles ɑs ⅼong ɑs I provide credit аnd…
  • John about Endpoint Owners – Bac…
    Thanks for sharing your knowledge. Do you happen to know what would happen if the owner of the endpoint…
  • Henrik Staun Poulsen about Defaults In msdb Database
    You have set fill factor = 90. This makes your index 10% bigger than they need to be. Is this…
Welcome , today is Wednesday, February 20, 2019
  Home
  Older Posts
  Top of page
  Bottom of page