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 (599)
    • Presentations (10)
    • Professional (588)
    • Running (11)
    • Scripts (72)
    • Security (6)
    • SQLBP (2)
    • SQLServerPedia Syndication (264)
    • SSC (489)
    • SSG Syndication (4)
    • SSSOLV (62)
    • The Corner dep (58)
    • TSQL Tuesday (65)
    • 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)
    • TableSpace Update (11)
    • Missing Indexes (11)

  • SQLHelp

    • @GamerGeekNews: RT @SQLTJ: DAX: When using ADDCOLUMNS() to add a measure to a table, it gets run for all rows of a table. How do I get it to behave like a…
    • @SQLTJ: DAX: When using ADDCOLUMNS() to add a measure to a table, it gets run for all rows of a table. How do I get it to b… https://t.co/FwfsZY7UFr
    • @splaxi: @SQLHA @cl @DBArgenis Thx for taking the time to respond. I know it depends on a lot of factors which I told the PM… https://t.co/QttaYMuqEI
    • @SQLHA: @cl @splaxi @DBArgenis HA to me is Tier 3/4 type stuff. If your ERP is Tier 0/1, you're generally looking at in gue… https://t.co/bta7RCP781
    • @SQLHA: @cl @splaxi Plain jane HA basically will just restart the VM for you. @dbargenis and I are on the same page here. Y… https://t.co/pwmaU13sCw
    • @SQLHA: @cl @splaxi BY putting it in the hands of vSphere, that means it's the VMware admins who are called when there's an issue :) #sqlhelp
    • @SQLHA: @cl @splaxi SRM is great for D/R, but not HA. Very different concepts it covers. HA is not good enough if you have… https://t.co/HTf9I5N7Ru
    • @DBArgenis: @splaxi @SQLHA VMware HA alone doesn't cover all the scenarios you may experience. It's sort of basic HA. #sqlhelp
    • @splaxi: 3. Party hosting partner says that VMware failover is sufficient as a HA solution for a SQL server installation to… https://t.co/TLkl8DD1WP
    • @lohithchalam: #sqlhelp one more weird issue is with one of sub where it's failing with no lock acquired despite providing lock va… https://t.co/YCHujO0SBl


© 2018 SQL RNNR All rights reserved - Mobile View Fastfood theme by TwoBeers Crew - Powered by WordPress
Recent Posts
  • Quickly Change SQL Job Owners by Jason Brimhall

    It is not unusual to find a server where some random user created a bunch of jobs to be run by SQL Agent. Sometimes, the user creating the job(s) sets themself as the owner of the job. Learn how to efficiently manage the proper change of such job owners.

  • T-SQL Tuesday #104: Just Ca… by Jason Brimhall

    We all have our favorite scripts, tools or utilities. Those are the things that help make our jobs easier. In this article, I share with you a poor mans audit solution to help catch unwanted permissions changes.

  • Summiting that Technical Ch… by Jason Brimhall

    Migrating a wordpress blog comes with its various set of challeneges. This installment covers magically changing percent symbols during that migration.

  • Use SSMS with a Different W… by Jason Brimhall

    Runas should be a very common tool in the toolbox of all IT professionals – not just Data Professionals. Learning how to test different accounts is essential to being an effective and efficient professional that can provide solid results.

  • Single User Mode – Ba… by Jason Brimhall

    Starting SQL Server in single-user mode should be a tool every data professional holds in the bag. This is an essential tool that can be used in multiple scenarios and ensure you are able to fully maintain and control your server. This article will show how to start in single-user mode via two methods.

  • Lost that SQL Server Access? by Jason Brimhall

    Losing access to a SQL instance is never a desirable situation – for the DBA. When the people that are supposed to have access, lose that access, all hope is not lost. There are plenty of methods available to regain the requisite access to manage the server. Today, I shared one such method that I view as being extremely easy. If you lose access, I would recommend taking the steps shown in this article to regain that access.

  • T-SQL Tuesday #102: Giving Back by Jason Brimhall

    This is my diatribe about service and giving back to the community. When done properly, there is a natural born effect of enhancing one’s personal life equal in some way to the amount of effort given towards the community.

  • 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.

Categories
  • News ( 599)
    Recent Posts
    • Quickly Change SQL Job Owners by Jason Brimhall
    • T-SQL Tuesday #104: Just Ca… by Jason Brimhall
    • Summiting that Technical Ch… by Jason Brimhall
    • Use SSMS with a Different W… by Jason Brimhall
    • Single User Mode – Ba… by Jason Brimhall
  • Professional ( 588)
    Recent Posts
    • Quickly Change SQL Job Owners by Jason Brimhall
    • T-SQL Tuesday #104: Just Ca… by Jason Brimhall
    • Summiting that Technical Ch… by Jason Brimhall
    • Use SSMS with a Different W… by Jason Brimhall
    • Single User Mode – Ba… by Jason Brimhall
  • SSC ( 489)
    Recent Posts
    • Quickly Change SQL Job Owners by Jason Brimhall
    • T-SQL Tuesday #104: Just Ca… by Jason Brimhall
    • Summiting that Technical Ch… by Jason Brimhall
    • Use SSMS with a Different W… by Jason Brimhall
    • Single User Mode – Ba… by Jason Brimhall
  • SQLServerPedia Syndication ( 264)
    Recent Posts
    • Quickly Change SQL Job Owners by Jason Brimhall
    • Use SSMS with a Different W… by Jason Brimhall
    • Single User Mode – Ba… by Jason Brimhall
    • Lost that SQL Server Access? by Jason Brimhall
    • Change SQL Server Collation… 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 ( 72)
    Recent Posts
    • T-SQL Tuesday #104: Just Ca… by Jason Brimhall
    • 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
  • TSQL Tuesday ( 65)
    Recent Posts
    • T-SQL Tuesday #104: Just Ca… by Jason Brimhall
    • Summiting that Technical Ch… by Jason Brimhall
    • T-SQL Tuesday #102: Giving Back by Jason Brimhall
    • T-SQL Tuesday #101: Essential Tools by Jason Brimhall
    • Summiting that Technical Challenge 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…
    Thanks for the heads up. I sit here stunned and amazed that a Microsoft Employee did this.
  • Howard about Lost that SQL Server Access?
    You used to be able to do this trick using PsExec from Sysinternals but it stopped working in later SQL…
  • Chris about Change SQL Server Collation…
    Hi Jason, I've been researching collation changes and I've noticed that this article seems to have been…
  • Jason Brimhall about Quickly Change SQL Job Owners
    It would be no more dangerous in this case than to use sp_update_job. I wouldn't classify the job related tables…
  • ScottPletcher about Quickly Change SQL Job Owners
    I generate, and optionally execute, a script that uses sp_update_job to change the owner. Isn't it rather dangerous to…
  • Kevin Karns about T-SQL Tuesday #104: Just Ca…
    What a great script! I've got it running along side sp_Blitz with it's @OutputServerName which can also utilize linked…
  • Jason Brimhall about Use SSMS with a Different W…
    Good insight. Thanks for the info.
  • Larry Husingh about Use SSMS with a Different W…
    I noticed on my Windows 10 system that "Run as different user" was not available on my Start menu, even…
  • Dave Boltman about Use SSMS with a Different W…
    Useful article - thank you. I've often used a much lighter client such as "Query ExPlus" (https://sourceforge.net/projects/queryexplus/)…
  • Jason about Use SSMS with a Different W…
    Another option is using Windows Credential Manager. You can run one instance of SSMS, and connect to different servers with…
Welcome , today is Sunday, September 23, 2018
  Home
  Older Posts
  Top of page
  Bottom of page