#tablock

[inevitably-johnlocked]

Heyyyyy any lists and recs for Victorian Johnlock?? Thxxx sm I love all the work u put into this

Hi Nonny!

You know what??? I haven't put up a new list in AGES, but I don't have personal updates of my own recs, BUT I also REALLY NEED a list for this weekend, so GUESS WHAT??? You're the ask that I'm going to just tag-search my MFL list and make a Part Two :) So PLEASE NOTE I haven't read any of these and I'm not 100 on if they are Victorian AUs or ACD Canon. I just go based on what people recced to me or what I saw tagged.

If anyone has any fics that they wuold like to suggest, please do add them below! Enjoy!

VICTORIAN AU Pt. 2 (MFLs)

See also:

Victorianlock

ACD Canon

Long ACD Canon (MFLs)

Granada Holmes Fics (MFLs)

Victorian Meets Modern Johnlock

Regency AU (TO READ) [I know it's a different era but this is so that people know I have a list for "a similar era"]

2 Bits by Ewebie (M, 717 w., 1 Ch. || TABlock/Victorianlock || Shaving Each Other, UST/URT) – It was the quiet moments. The peace behind closed doors and drawn curtains. At the end of a case. At the end of a long day. At the end of their ropes, but away from society’s prying eyes. That was the foundation upon which the rumors were spread. Part 11 of the Tumblr Shorts series

Happy birthday, Sherlock Holmes! by Holmes_WatsonACSAneroxiaDalt (G, 1,665 w., 1 Ch. || Victorian AU || Established Relationship, Love Confessions, Light Angst, First Kiss, Idiots in Love, Hurt Sherlock) – During the journey, Holmes was overcome by a million overwhelming feelings. Today is his birthday. His birthday. And Watson, dear Watson, his sun in the sky, his purpose in life, had not achieved this. Maybe he forgot, but he couldn't blame him. A story were Watson forgot the birthday of Holmes. Or not?

The first time I ever saw your face by Vanimelda4 (G, 2,164 w., 1 Ch. || 1895 Victorian AU / TABlock || PODFIC AVAILABLE || POV Sherlock, Fluff and Angst, Meta Fic) – "Death cannot stop true love. All it can do is delay it for a while."

The Picture of Sherlock Holmes by CarmillaCarmine (M, 3,306 w., 1 Ch. || Victorian Dorian Gray AU || Angst, Paris, London, Travel, Painting, Major Character Death, Opera, Captain John, First Meetings) – Sherlock Holmes, a rich and frivolous man, after a lifetime of debauchery finally falls in love. His heart chooses Captain Watson.

Detectives, balls and proposals by Winxhelina (T, 5,365 w., 1 Ch. || Victorian Femlock || Genderbending, Disguised Sherlock, Misunderstandings, Falling In Love) – The adventures of Miss Sherlock Holmes and her friend Miss Watson. My attempt at writing Victorian Femlock after reading way too much Jane Austen and ACD. In which there is a ball, a case, a murder and a falling in love...

The Soldier And The Demon by LipstickDaddy (G, 8,998 w., 6 Ch. || Victorian / Demon AU || Strangers to Friends to Lovers, Soldier John, Demon Sherlock, Domestic Fluff, Emotional Hurt/Comfort, Protective John, Protective Sherlock, Happy Ending) – Johnlock/Kuroshitsuji AU - 1879. Captain John H Watson of the Fifth Northumberland Fusiliers is dying from a near-fatal gunshot wound in the Kandahar desert; until a demon saves his life. There’s a catch, though; one day, his saviour will eat his soul.

Iris by Leloi (E, 11,302 w., 1 Ch. || Omegaverse || Time Travel, Mpreg, Infertility, Virgin Sherlock, Friends to Lovers, Established Relationship, Omega Sherlock, Jealous Sherlock) –John Watson was quickly learning to hate the Victorian Era. It wasn’t just the lack of proper medical care… Although that was a rather large component. It was the filth. It was the misery and the lack of regard for human life. Ok… So maybe the lack of proper medical care was a major component. It was difficult being a 21st century medical doctor stuck with 19th century technology. There was some sort of time travel involved. The really strange part is that there was a past version of himself living with a past version of Sherlock Holmes. Ok… So maybe that wasn’t the strangest part either. He seemed to be stuck in an alternate universe.

The Reawakening of John Watson by  221b_careful_what_you_wish_for (E, 20,463 w., 14 Ch. || Historical 1800s American/Victorian AU || Artist Sherlock, Writer John, Angst with Happy Ending, Bisexual John, Period Typical Homophobia, Sensuality, Experienced Sherlock, Pining, Past Drug Use, Slow Burn, Love Confessions, Flirty Sherlock, Frottage, Outdoor Sex, Trust Issues, Minor Character Death, Sexual Tension, Colorado / London, Rimming, Anal Sex, Blow Jobs,  POV John) – Trying to escape his troubled past in England, John Watson has started a new life in the American West. When he meets the handsome artist Sherlock Holmes, a smoldering attraction is sparked, complicating his quiet, carefully guarded existence. Maybe taking a risk with Sherlock is exactly what John needs to feel alive again...

The Inferno Club by SwissMiss (E, 20,841 w., 1 Ch. || BDSM Omegaverse AU || Alpha / Alpha, Victorian Kinks, Case Fic, Public Sex, Wax Play, Pain Play, Collars) – "I'm easy to find," said the young woman. "Hell, London, gets me every time." The real story behind The Adventure of the Illustrious Client.

An Unexpected Proposal by black_tea (E, 21,699 w., 6 Ch. || Victorian Omegaverse Johncroft || Beta Sherlock, Alpha Mycroft, Omega John, Bonding, Courting, Sexism, Sexual Harassment, Protective Mycroft) – John returns home from Afghanistan to find himself in a difficult situation. It's not easy being an omega without a mate in Victorian England. Though highly competent, most can't seem to see past his status. To make matters worse, he no longer has access to the suppressants handed out by the army. However, a chance meeting puts him in contact with one Sherlock Holmes and leads to something even more unexpected. Suddenly John has the prospect of a better life, if he can only bring himself to take it.

You’ve Got Mail: A Johnlock Victorian AU by MorganeUK (G, 37,112 w., 17 Ch. || Victorian AU / You’ve Got Mail AU || Friendship, Dev. Rel.) –  In 1881, Doctor John Watson, veteran of the second Afghan war, inherited a small but prosperous bookshop from his uncle. Against all likelihood, he embraced his new life joyfully and lived happily among his books and... other projects.This is, until the day a nearby store, Holmes & Brother, decided to add a book department to their already enormous store... Unable to find a way to stop his little shop from succumbing under Holmes’ expansion, Watson needs to find help! And who’s better than his dear epistolary friend! Part 6 of the Rom-com adaptations...

The Adventure of the Lost Boy by mydogwatson (T, 38,530 w., 11 Ch. || Victorian AU || Victor Trevor, Neurodiversity, Romance, Case Fic, Angst with Happy Ending, Time Jumps) – Sherlock Holmes makes his way through life as an outsider in Victorian England.

Silence by halloa_what_is_this (T, 44,993 w., 13 Ch. || The Piano Fusion || Victorian Sherlock, Dub Con, Voyeurism, Permanent Mutilation, Johniarty, Mute John) – In 1850, John is a mute young man forced to marry to save his father from indebtedness. His sister as his interpreter and his piano to keep him company, he travels to London to live with his husband James Moriarty. Without John's consent, James sells the piano to his friend Sherlock Holmes, who only asks for lessons from John in return. The lessons turn into a power play between the two when Sherlock proposes a deal: John may earn his piano back one key at a time, certain conditions attached. Part 1 of the Aborted Wings series

Always 1895 by standbygo (E, 45,901 w., 19 Ch. || Oxford Time Travel AU || Time Travel, Friends to Lovers, Case Fic, Victorian, Period-Typical Homophobia, Pining, First Kiss/Time, First Meetings, Slow Burn, Angst With Happy Ending) – Time travelling historian John Watson goes to Victorian era England to study, and meets detective Sherlock Holmes. He finds himself torn between the work he was sent to do, the exciting life of solving crimes, and the extraordinary Holmes himself. 

All Our Gifts At Once, or, the Young Sea-man by tiltedsyllogism (T, 48,119 w., 9 Ch. || Victorian Little Mermaid AU || Sacrifice, Pining, Angst, Realistic Fairy Tale, Bittersweet, Botany, Gardens) – John Watson, storyteller and shipwright's son, walks way from his entire life in Portsmouth to follow the mysterious Sherlock Holmes to London.

Vows Made in Wine by love_in_mind_palace (E, 59,837 w., 16 Ch. || Victorian Handmaiden Fusion || Romance, Angst with Happy Ending, Plot Twists, Mystery, Child Abuse, Dubious Consent) – John Watson, a low born young man from the slums of London appears in the farthest corner of country to work as a valet for the young master living in the secluded mansion. Secrets, betrayal, conspiracy. A love blossoming in the most unfortunate circumstances.

The Courtesan by delightful_fear (M, 67,865 w., 20 Ch. || 1860′s Victorian / Prostitution AU || Medical Examination, Alternate First Meeting) – Desperate times call for desperate measures. John takes a job as a live-in doctor in the most exclusive brothel in London, never thinking he would fall under the spell of it's most infamous consort, Sherlock Holmes.

Concurrence by Calais_Reno (M, 70,876 w., 23 Ch. || Historical / Time Travel AU || Mental Institutions, Modern and Victorian Settings, Period-Typical Homophobia, Alternate First Meeting, First Person POV Sherlock) – “How did you come to be in this place?” I have no idea what possessed me. Perhaps the sheer exhaustion of transport had weakened my filter. Or maybe it was simply that as I looked at the young doctor sitting opposite me, his face calm and professional, but bored (Shares a flat with a mate, who is seducing his girlfriend. Down on his luck. Evidence: clothing and shoes are good quality, but worn. Had to pawn his bag, but could have gotten more for the watch. Sentimental…) I had a sudden whim to give him an interesting story. I decided that Dr John Watson would at least have something to tell his flatmate tonight when he arrived back at his shabby little flat. Or maybe his girlfriend, if she hadn’t left him yet. And the truth was even more interesting than anything I could make up. Part 1 of the Concurrence Universe series

Observations on Sentinels and Guides in Victorian London by  RyuuzaKochou (T, 89,181 w., 13 Ch. || Victorian Sentinel / Guides AU || Action/Adventure, Hurt/Comfort, Romance) – A Victorian era AU where Sentinels and Guides are members of everyday society. Starring Sentinel! Holmes and Guide! Watson.

The Stories in Our Veins by victorianpining (E, 101,717 w., 29 Ch. || Dracula Crossover / Victorian / Vampire AU || Unreliable Narrator, Blood and Injury, Blood Drinking, Gaslighting, Mental Instability, Depression, Suicidal Thoughts, Strangers to Lovers, Enemies to Friends to Lovers, Angst with Happy Ending) – You hold in your hands a leather-bound book inscribed with the title The Stories in Our Veins. No author is named by the cover. On the first page, the following passage has been written in an elegant, cursive hand: A confederate who foresees your conclusions and course of action is always dangerous, but one to whom each development comes as a perpetual surprise, and to whom the future is always a closed book, is indeed an ideal helpmate. Sherlock Holmes in “The Adventure of the Blanched Soldier,” written by Sir Arthur Conan Doyle in 1926.

Fin de Siècle Series by Calais_Reno (M, 102,149 w. across 20 works || Victorian AU || Alternate First Meeting, Friends to Lovers, Alternating POV, Misunderstandings, Period-Typicall Homophobia, Love Declarations, Grief/Mourning, Victorian Attitudes, Marriage of Convenience, True Love, Loneliness, Hurt/Comfort) – Holmes and Watson meet and commit themselves to one another, in spite of laws that make their relationship illegal. Holmes confronts Moriarty at Reichenbach hoping to end his influence in the government; he falls, but does not win. Moriarty's machine continues. While Holmes tries to make his way back to England, Watson, believing Holmes dead, suffers the consequences of their opposition to Sebastian Moran, Moriarty's successor. Finally reunited after several years, Holmes and Watson work to end the corruption that has taken over Britain's government.

Riptide Lover by jinglebell (E, 114,090 w., 20 Ch. || PODFIC AVAILABLE || Merfolk & Victorian AU || Mermaid Sherlock, Human John, BAMF John/Sherlock, Possessive Sherlock, Oral Sex, Hand Jobs, Mild Gore, Dubious Interspecies Consent, Stockholm Syndrome, Dark Romance, Dubcon and Morality, Rough Sex, Abstract Mentions of Rape, Size Queen, Switchlock, Foot Fetish) – The year is 1866. When John becomes swept overboard, he never expects to encounter a living creature of myth. When the merman absconds with John, the lost sailor must use every tool at his disposal to convince Sherlock not to kill him. But it seems that killing John Watson is not what the deadly, beautiful creature has in mind at all...

WIPS / SERIES WIPS

Give Him a Mask by AStudyInAlgedonics (T, 10,382+ w., 2/6 Ch. || Sentinel / Guide AU || WiP || Alternate TAB, Sentinel Sherlock, Guide John, Drug Use, Not Nice Mary, Love Confessions) – Sherlock Holmes doesn't zone. Until he does, coming back from his near-exile, so hard that he strips John Watson's shields and draws him into the Victorian enigma of the Abominable Bride Emelia Ricoletti. But what he claims is a simple experiment in the mind palace proves to be far deeper waters than Sherlock meant to plumb, and if John can't break away from the script Sherlock's set him to, this strange zone may drown them both in the dark of the Reichenbach cauldron...

To Belong Series by DrFish (T, 19,400+ w. across 4 works || Series WiP || Victorian / Mythical AU || OctoJohn, Scientist Sherlock, Attempted Kidnapping, BAMF John, Protective / Possessive John, Developing Relationship, Being Lost, Size Difference, Capital Punishment, Happy Ending) – William Sherlock Scott Holmes failed to graduate the University of Cambridge class of 1877. Adrift in London, he accepts a post as assistant naturalist on a scientific expedition to the Western Pacific Ocean aboard Her Majesty's Sailing Ship Frontier. Events do not proceed quite as planned and Sherlock finds himself cruelly cast away by his shipmates. Perhaps he will find salvation in the company of a most unlikely sea creature.

20,000 leagues under the sea: A Victorian Sherlock AU by MorganeUK (G, 30,544+ w., 15/? Ch || Victorian Steampunk AU || WiP || Scientist Sherlock, Submarines) – The Holmes Brothers are living under the sea, protected from the world violence and general stupidity… Alone, with only a small crew, they explore the world inside their submersible. Perfectly satisfied and unaware of their loneliness, until they meet Captain Lestrade and Doctor Watson from the Royal Navy.

This Land We Have Chosen by redscudery (E, 86,309+ w., 16/19 Ch. || WiP || Victorian Canadian Farm AU || Farmer John, Prostate Milking/Massage, Mutual Pining, Colonialism, Demisexual Sherlock, Complicated Relationships, Slow Burns, UST, Awkwardness, PTSD, Panic Attacks, Virgin Sherlock, Canadian Politics, Angst with Happy Ending) – It’s 1866. John Watson is a former army doctor who served in India. He left the service after a mysterious traumatic incident and has been farming in the backwoods of Canada. Sherlock Holmes is an avid botanist and possible hysteric who is a very loud thorn in his brother Mycroft’s side. Since Mycroft wishes to run for Parliament during the first Canadian election, he knows he needs his troublesome younger brother out of their hometown of Carleton before he can precipitate any scandal—and what better place for a botanist than a backwoods farm? Especially when it’s run by someone who just might be able to treat Sherlock’s hysteria? Part 2 of the The Backwoods of Canada series

Untitled Nobility Series by hannahrieu (E, 95,770+w. across 4 works || Series WiP || Victorian AU || Implied/Referenced Drug Use, Dubious Consent, Angst, Mutual Pining, First Time, Friends to Lovers) – John is a servant in Halidon Hall until a tragic accident forces him to leave his home and join the army. After being wounded in battle, he returns to England and finds work as a valet for the Earl of Cornwall's second born son, Sherlock Holmes. Very lightly inspired by Mr. Bates's limp in Downton Abbey.

Fallen Through Time by susandwrites (E, 102,041+ w., 39/? Ch. || Outlander Fusion / Victorian AU || WIP || Time Travel, First Meetings, Meet-Cute, Frottage, Blow Jobs, Anal Sex/Fingering, Riding Crops, Rough Sex, Floor Sex, Breath Play, Light BDSM, Implied/Referenced Drug Use, Switching, Romance, Sex to Love) – Inspired by my love of Outlander, but not exactly an Outlander AU. Sherlock Holmes, the world's only consulting detective, finds himself in Victorian London while investigating a murder. The first person he meets is Doctor John Watson, formerly of the Fifth Northumberland Fusiliers and his world is irrevocably altered.

[lionkingfan]

Galvanized Steel Centrifugal Fan Blades Multi-wing Impeller Double-Inlet Strip Type Blower Wheel

Centrifugal Fan Wheel — Fan Wheel / impeller. Centrifugal strip blower wheel · Centrifugal tablock blower wheel · strip dual wheel · tablock dual wheel · strong type · Centrifugal Strip   Application: HVACR equipment, machinery, burner, oven, dryer, etc. Function: Ventilation, Cooling, heating, air conditioning, draft inducing, air refreshing, air circulation. Features: Configuration Type: Single inlet, Twin-inlet   Order Information: Minimum Order: Negotiate OEM/ODM Product, Branded Product, Buyer's Label Offered FOB: China Ningbo /China Shanghai   Customization Available If you don't find the products you want in our range , please contact us for customization services freely . our profesional engineer team will work out a satisfied stuff with you . Any dimensions of cross flow fans , perfromances of air flow ,air pressure ,noise level , installation positions or other functions are availble for your customizing

Read the full article

[ohmrshudsontookmyskull]

yearning for more TABlock content

[electroika]

Cannon Tab Lock Downrigger Base

Proveedor: Cannon Tipo: Soportes y Abrazaderas para Camara Precio: 28.30

Allows for easy removal and replacement of LakeTroll| SportTroll| Legacy EasiTroll| and MiniMag downriggers Built with heavyduty composite construction for corrosion and UV resistance

Incluye tablock base Se adapta laketroll| sporttroll| easitroll y minimag downriggers Construido con alta resistencia Lexan

Otras caracteristicas

Marca Cannon

Nombre de modelo Tab Lock

Dimensiones del articulo LxWxH 9 x 7 x 1 pulgadas

Color Black

Peso del producto 075 Libras

source https://www.electroika.com/products/cannon-tab-lock-downrigger-base

[marcosplavsczyk]

SQL blocking means that one or multiple SQL queries are waiting for resources that are locked by another SQL Query. SQL blocking can affect data throughput and SQL Server responsiveness significantly. SQL Server response time is a measure that shows how long the end user that has executed a query must wait until he gets a response. So, in case that a query is doing nothing while waiting on another query to release the lock on the target resource, the response time increases thus making the SQL Server less responsive.

At the other hand, when talking about the data throughput, the measure is the number of simultaneous users who are logged and execute their queries in parallel without slowing down the SQL Server. Moreover, this is the SQL Server performance parameter that could be severely affected when blocking chain occurs. In scenarios were complex blocking chains occurs where one SQL query blocks another, and that query then blocks the third one, and the third one blocks the fourth one, and so on the blocking of the critical SQL Server resources for a prolonged time could occur. That creates a sort of artificial serialization in accessing key resources to the level where only one or eventually two users are effectively using SQL Server at one time.

Both of these scenarios are something that should be avoided and prevented.

SQL Server blocking is hard to identify and troubleshoot as it is hard to predict such behavior during development when only a limited number of users, quite often only one or two, are executing and testing the queries against the SQL Server at the same time. It is even worse to predict the situations where a single rarely executed query can cause a lengthy and complex blocking chain, making the troubleshooting process of bad SQL Server performance caused by such a rare and complex blocking chain annoying and often without results.

For more information SQL Server blocking read the Techniques to identify blocking queries and causes of SQL Server blocks article.

As it can be seen in the article, establishing the SQL Server blocks monitoring and tracking of even simple SQL Server blocks is not an easy and straightforward process. Even when the significant time is invested, results could be vague in most cases.

The situation where blocking chain is the cause of the issue is even more complicated for monitoring and troubleshooting. It’s quite tough to pinpoint the head blocker of the blocking chain when there are a number of processes involved. Moreover, if we add the possibility that deadlocks could be involved in the blocking chain as well, there could be quite a mess that has to be resolved and tracked.

Just as an example of the blocking chain, the scenario where a chain of the three SQL blocking processes will be simulated. Simulating such a blocking chain requires four separate connections to the SQL Server database to be created. That means that each query must be executed from a separate query tab in the SQL Server Management Studio. The Adventure Works database will be used in the blocking chain example.

SSMS tab1:

In this window, the query will start a transaction that will select from the database table and then for the purpose of easier simulation the waitfor delay command will be executed to create the 15 seconds wait for more comfortable work and unambiguous results presentation. The query will force the locks just for the purpose of the presentation. Otherwise, that is not recommended without a very particular reason.

begin tran select * from [Person].[Person] with (tablock, holdlock, xlock) waitfor delay '00:00:15' commit tran

SSMS tab2:

The query in tab 2 should be executed immediately after the previous query in tab 1. The transaction will try to select from the same table, and that will conflict with the transaction in the tab1 that holds the lock.

select * from [Person].[Person]

SSMS tab3:

Finally, in tab 3 the select query will be executed after the tab 2 query, and it will conflict with the query in the tab 2.

select * from [Person].[Person]

SSMS tab4:

This query in tab 4 is designed to display the active SQL blocking and should be executed after the query in tab 3 is executed. In our example, SQL Server used for this example had a very few active processes, so we were able to get insight straight into results.

Select Session_ID,Blocking_Session_ID From Sys.DM_Exec_Requests Where Session_ID > 50 And Blocking_Session_Id <> 0

What we can see from this result is that session 65 is waiting for session 56 to release the lock it holds on the resource, and it can be seen that session 56 is waiting for session 55 to release the acquired lock. Moreover, it is evident that session 52 is not waiting for anything, so one could assume that session 52 is the root cause of the SQL blocking or the so-called head blocker.

While this could look like a simple to troubleshoot, it is not the case in the real world. Production servers might have hundreds or thousands processes where numerous blocks could occur and blocking chains could reach tens of levels. Analyzing such results manually and figuring out relations and connections between processes cod take a lot of time and are prone to mistakes or misinterpretations.

At the top of that, this is not the information that is stored somewhere, so it doesn’t allow any insight into the history and frequency of SQL blockings and blocking chains.

Use ApexSQL Monitor to resolve SQL blocking

ApexSQL Monitor SQL blocking and blocking chain tracks are parts of the Query waits feature, or to better say the sub-features of the Query wait feature.

To access the blocking chain section of the Query waits feature:

Select the SQL Server that should be checked for the blocking chain in the server explorer pane on the left

From the Instance dashboard, select the Waits link in the Query section

In the Query waits page, select the Blocking chain radio button

If SQL blocking exists in the selected SQL Server, the information about the blocking chains displays

ApexSQL Monitor displays each SQL Server block in a hierarchical form that allows displaying the relations between all blocked and blockers SPIDs in a SQL blocking chain. The head blockers are displayed by default as they consist of the top nodes in the blocking chain hierarchy. The blocked SPIDs are displayed as parts of the sub-nodes in the blocking chain.

To check the blocked SPIDs, expand the blocking chain using the arrow icon left of the head blocker grid row:

The blocked SPIDs are nested underneath the head blocker, and any subsequent SPID is nested beneath its blocker in the chain, and it can be drilled down the chain by expanding any new subsequent SQL blocking where exists. Such an approach ensures the complete insight in the blocking chain at a first glance.

For each blocker and blocked query, ApexSQL Monitor allows reviewing details about that particular query by expanding the table via the arrow icon on the far right of the row.

The information in the Query details tab contains information about the query involved in the blocking chain that includes the wait type involved, wait time as well as the wait resource.

To help understand the Wait resource details and the way to decipher those, check the article INF: Understanding and resolving SQL Server blocking problems

As SQL blocking is a situation where a process is forced to wait another process to release the acquired lock, SQL Server logs that via the LCK_M_XXX wait type. The adequate wait type will be displayed, in accordance with what lock type blocked queries are waiting to acquire. Click the wait type link to display the helper pop up window with details related to that wait type as well as advice on potential resolution and links to external resources where some additional information about the involved wait type could be researched.

The SQL Text tab contains the full T-SQL of the query.

An additional ability of the block chain feature is that it allows the user to decide whether to display or not the blocking chains where the deadlock as a unique form of SQL blocking is involved. Unticking the Deadlock check box displays only the blocking chains where deadlocks are not involved. By default, the ApexSQL monitor displays all blocking chains including the ones where the deadlock is involved. In addition, each such blocking chain is marked with red DEADLOCK marking, as all blocking chains where the deadlocks are involved requires the special attention.

Quick tip:

The information about the deadlock involvement and ability to filter out blocking chains where deadlock is involved is possible only if the deadlock monitoring is turned on. To learn how to enable deadlock monitoring and track the deadlocks, read How to configure and use deadlock monitoring

Another way to access the blocking chain of interest is via the Blocked section of the Query waits page. While analyzing the blocked queries, if there is a need for a particular query to get details about its involvement in the blocking chain and how it is involved, use the Blocking chain link in the details of that blocked query details.

That will drill down to the specific blocking chain in the Blocking chain section that involves that particular SQL blocking situation.

In this way, only the particular blocking chain related to that particular SQL blocking will be displayed. That could be very useful for reducing the noise that other blocking chains could cause when analysis of the particular blocking chain situation is required.

[inevitably-johnlocked]

do you have any recs for full-series rewrites? ideally ones without the Mary storyline or John lashing out?

thank you for all that you do!!!!

Hey Nonny!

OH Gosh, ah... This is a tough one because like technically "episode specific" and meta-fics can work for this. Check them out:

Pre-ASiP fics

Season 1 Fics

Season 1 Fics Pt 2

TGG Related Fics

TGG: Pool Scene

ASiB Fics

THoB Fix It Fics

THoB Fics Pt. 2

Post-TRF Divergence

Post-TRF No Mary (Jan 2023)

Reverse Reichenbach

Reverse Reichenbach Pt. 2

Reunion and Other Post TRF Fics

Reunion and Other Post TRF Fics Pt. 2

Reunion and Other Post-TRF Fics Pt. 3

John Finds Out About Hiatus

John Joins Sherlock During Hiatus

Johnlock Against the World

Sherlock Returns from Hiatus Injured 

Serbia / Aftermath of Hiatus Fics

The Empty Hearse-Related Fics

TSo3-Related Fics (Updated Sept 2023)

Post John’s Wedding Fics

Gay Bar Scene

Stag Night

HLV Fics

After the Gunshot (HLV)

Tarmac Scene

Post S3 Fics

Long S3/Post-S3 Fics (20K+ w.) [Apr 2020]

TABlock (Apr 2020)

TLD Fix-Its / Aftermath of TLD

TFP Is Canon

Post S4 / S4 Fix Its

Post S4 / S4 Fix Its Pt. 2

Post S4 / S4 Fix Its Pt. 3

Post S4 / S4 Fix Its Pt. 4

Post S4 / S4 Fix Its Pt. 5

S4 Rewrites / MetaFics

S3 / TAB / S4 [FIX IT] Fics (March 2019)

Post S4 and Mental Health

Unseen Moments (Updated Sept 11/23)

=====

I wish I could help you out beyond that, and I'm pretty sure I'm misunderstanding exactly what you're looking for, but I hope these help you out <3 I'm working on an S3 No Mary list, so one day that will be done LOL.

If anyone wants to suggest their own fic or a fave fic, please do <3

[sqljoker]

Tweeted

#SqlServerHelp - TABLOCKX vs TABLOCK + XLOCK https://t.co/P4BKW06KZm via SSC

— SQL Joker (@sql_joker) December 14, 2017

[akemoi]

1 réponse sur Vogels PTS 1224 TabLock iPad Pro 12.9

#technos http://dlvr.it/PSZD6P

[allgeekshop]

Look at http://ift.tt/2qn6zPB Professional PTS 1105 TabLock – Sicheres Gehäuse für Web-Tablet – für Apple iPad 2

[ohmrshudsontookmyskull]

I am both deeply excited about Sentinel/Guide TABLock story & wondering if it's really *necessary*.

Which is to say, I'm certainly not backing out now...

[armsvault]

Birchwood Casey PREGAME Tablock Turkey Kit

Birchwood Casey PREGAME Tablock Turkey Kit

Get Ready For Turkey Season With The New PREGAME™ Tablock™ Turkey Kit From Birchwood Casey® (ArmsVault.com) – The new PREGAME™ TabLock™ Turkey Kit from Birchwood Casey® provides hunters a quick and easy way to pattern their shotguns, or test new loads before the season. The TabLock backer eliminates the need to carry tape or a stapler to your shooting area. Birchwood Casey PREGAME Tablock Turkey…

[ammoland-news]

Get Ready for Turkey Season with Birchwood Casey’s PREGAME Tablock Turkey Kit https://t.co/5z0kEIiRll https://t.co/7lxw4F8yI6

Get Ready for Turkey Season with Birchwood Casey’s PREGAME Tablock Turkey Kit https://t.co/5z0kEIiRll http://pic.twitter.com/7lxw4F8yI6

— AmmoLand (@AmmoLand) March 20, 2017

[quanrel]

Vogels PTS 1225 Safety Enclosure for Apple iPad Mini 4/Home Access Silver/Aluminium

More and more tablet PC’s like the iPad are used for public applications in retail shops, museums, showrooms and exhibitions. Vogel’s Professional has developed a secure enclosure for the iPad mini 4 called TabLock. TabLock prevents theft and unauthorized operation of the tablet. Made out of high quality aluminum and steel we designed a stylish and slim enclosure which protects the iPad in public…

[kpoplockscreen]

Chen Lockscreen

• request

• if use like/reblog

• don’t repost pls

[inevitably-johnlocked]

Five Fics Friday: June 14/24

Happy Friday, everyone! Let's start off the weekend with 5 more fics that I've been suggested recently! Enjoy!!

SIGNAL BOOSTING

the first time, a second time around by JustStandingHere(M, 24,267+ w., 4/? Ch. || WiP || HLV Divergence, Case Fic, Slow Burn, Lucid Dreaming, Mind Ghosts, Drug Use) – While resting and recuperating, Sherlock lucid dreams. John ruminates. In the meantime, two unconnected men have died in eerily similar ways in completely separate parts of London. It's a welcome distraction.

RECENT SHERLOCK BOOKMARKS

Non-Toxic by NinjaNina2 (M, 1,713 w., 1 Ch. || Post S4, Parentlock with Rosie, Established Relationship, Oneshot, Stubborn Sherlock, Worried John, Doctor John, Fluff and Humour, Misunderstandings)  – Based on previous experiences, John has every right to be worried when gone for a medical conference, but what is the extent of damage This time…?!?

RECENT MFLs

The first time I ever saw your face by Vanimelda4 (G, 2,164 w., 1 Ch. || 1895 Victorian AU / TABlock || PODFIC AVAILABLE || POV Sherlock, Fluff and Angst, Meta Fic) – "Death cannot stop true love. All it can do is delay it for a while."

Not My Area by LipstickDaddy (G, 4,319 w., 1 Ch. || Tooth-Rotting Fluff, Feelings Realization, Oblivious John, Mutual Pining, Love Confessions, Bed Sharing, Idiots in Love, Happy Ending) – Growing bored of John’s revolving door of girlfriends, Sherlock decides to see what all the fuss is about— with interesting consequences.

One Last Time by Hobbitsfeet & Tindomerelhloni (E, 239,696+ w., 58/70 Ch. || WiP || Alternate Universe || Emotional Hurt/Comfort, PTSD, Fake Death, Trauma, Therapy, Healing, Angst with Happy Ending) – While Sherlock Watson is allowed to believe that his husband, John Watson, is dead, John is secretly fighting to keep his husband and their children safe from an assassin. This is the story of that fight, of John returning home, and the aftermath of discovering not everything was as he left it and the challenges they both face to get their lives straight again. Part 2 of What's Past is Prologue