SQL Server Consulting, SQL Server Experts, SQL Server Migrations, SQL Server Performance, SQL Server High Availability, SQL Server Operations

info@techdevops.com | 437-991-3573 | Data Engineering Services

TechDevOps.com

Resources	Tools

Experts in Microsoft SQL Server on Windows, Linux, Containers | Clusters, Always On, FCI | Migrations, Cloud, Performance

< Back

November 23, 2018

Use Extended Events to monitor SQL Server Transactional Replication

by BF (Principal Consultant; Architecture; Engineering)

ring_buffer

Tags ExtendedEvents

June 13, 2018

Find the root cause of a TEMPDB LOG growth issue

by BF (Principal Consultant; Architecture; Engineering)

Extended Events, DBCC OPENTRAN, INPUTBUFFER & SYSPROCESSES

Tags ExtendedEvents

March 23, 2018

Using Microsoft Data Migration Assistant and Extended Events to capture any Deprecated Features

by BF (Principal Consultant; Architecture; Engineering)

sqlserver.deprecation_announcement, sqlserver.deprecation_final_support

Tags ExtendedEvents

March 22, 2018

Using Extended Events to capture failed logins

by BF (Principal Consultant; Architecture; Engineering)

Enter Short Description Here

Tags ExtendedEvents

March 10, 2018

Using Extended Events to capture Stored Procedure calls, Log & Extract Duration Buckets of % and/or #

by BF (Principal Consultant; Architecture; Engineering)

CREATE EVENT SESSION, ADD EVENT, ADD TARGET

Tags ExtendedEvents

December 1, 2016

Find out when an AlwaysOn Availability Group Failover occurred

by BF (Principal Consultant; Architecture; Engineering)

sys.dm_xe_sessions, sys.dm_xe_session_targets, sys.messages

Tags ExtendedEvents

November 19, 2016

Using Extended Events to Monitor Microsoft SQL Server AlwaysOn Availability Groups

by BF (Principal Consultant; Architecture; Engineering)

Capture DDL, Capture Availability Replica State Changes, Capture Total Events Captured

Tags ExtendedEvents

August 28, 2016

Use Extended Events to capture Deadlocks in SQL Server

by BF (Principal Consultant; Architecture; Engineering)

Histogram, XQuery

Tags ExtendedEvents

June 22, 2016

Capture Slow Stored Procedure Calls in Microsoft SQL Server using Extended Events

by BF (Principal Consultant; Architecture; Engineering)

sqlserver.rpc_completed

Tags ExtendedEvents

March 6, 2016

Azure Extended Events session return ShowPlan XML

by BF (Principal Consultant; Architecture; Engineering)

query_post_execution_showplan

Tags ExtendedEvents

November 2, 2015

Create an Extended Events session - Azure SQL Database

by BF (Principal Consultant; Architecture; Engineering)

sqlserver.sql_batch_completed, ring_buffer

Tags ExtendedEvents

November 2, 2015

Create an Extended Events session - On-Prem

by BF (Principal Consultant; Architecture; Engineering)

sqlserver.rpc_completed, sqlserver.sql_batch_completed, ring_buffer

Tags ExtendedEvents

Future Events

DevIntersection

Microsoft Ignite

PASS Summitt

Pinned Posts

Microsoft SQL Server Always On Availability Groups Architecture Design

Create a Microsoft SQL Server Audit Report using Powershell

SQL Space Monitor - Version 2

T-SQL - Constants vs Parameters vs Local Variables - Execution Plans, Statistics, Assumptions

SQL Server - File IO - Sizes, Usage, Stats - Write(Insert) vs Read(Select)

Azure Virtual Machines running SQL Server 2016 STD AlwaysON Availability Groups w/ Transactional Replication

T-SQL Transform Row Data into Columns using PIVOT

List all SQL Server Reporting Services Subscriptions

Calculate RTO(Recovery Time Objective) in AlwaysON Availability Groups

T-SQL Get Maximum Value from a list of Columns Values

SQL Server 2016 Compress() & Decompress()

JSON in SQL Server 2016

Temporal Tables in SQL Server 2016

T-SQL Merge

T-SQL Pivot Data