Users: 30k; Pages Per Session: 2.5pg; Avg. Session Duration: 1:35mi
TechDevOps.com
Explore Tools
{Featuring Microsoft Technologies + Enterprise Data + Cloud Computing}






June 13, 2018

Find the root cause of a TEMPDB LOG growth issue
by BF (Senior MSSQL Operations - Enterprise, Cloud, Strategy)
Extended Events, DBCC OPENTRAN, INPUTBUFFER & SYSPROCESSES
Read More
Tags ExtendedEvents
March 23, 2018

Using Microsoft Data Migration Assistant and Extended Events to capture any Deprecated Features
by BF (Senior MSSQL Operations - Enterprise, Cloud, Strategy)
sqlserver.deprecation_announcement, sqlserver.deprecation_final_support
Read More
Tags ExtendedEvents
March 22, 2018

Using Extended Events to capture failed logins
by BF (Senior MSSQL Operations - Enterprise, Cloud, Strategy)
Enter Short Description Here
Read More
Tags ExtendedEvents
March 10, 2018

Using Extended Events to capture Stored Procedure calls, Log & Extract Duration Buckets of % and/or #
by BF (Senior MSSQL Operations - Enterprise, Cloud, Strategy)
CREATE EVENT SESSION, ADD EVENT, ADD TARGET
Read More
Tags ExtendedEvents
December 1, 2016

Find out when an AlwaysOn Availability Group Failover occurred
by BF (Senior MSSQL Operations - Enterprise, Cloud, Strategy)
sys.dm_xe_sessions, sys.dm_xe_session_targets, sys.messages
Read More
Tags ExtendedEvents
November 19, 2016

Using Extended Events to Monitor Microsoft SQL Server AlwaysOn Availability Groups
by BF (Senior MSSQL Operations - Enterprise, Cloud, Strategy)
Capture DDL, Capture Availability Replica State Changes, Capture Total Events Captured
Read More
Tags ExtendedEvents
August 28, 2016

Use Extended Events to capture Deadlocks in SQL Server
by BF (Senior MSSQL Operations - Enterprise, Cloud, Strategy)
Histogram, XQuery
Read More
Tags ExtendedEvents
June 22, 2016

Capture Slow Stored Procedure Calls in Microsoft SQL Server using Extended Events
by BF (Senior MSSQL Operations - Enterprise, Cloud, Strategy)
sqlserver.rpc_completed
Read More
Tags ExtendedEvents
March 6, 2016

Azure Extended Events session return ShowPlan XML
by BF (Senior MSSQL Operations - Enterprise, Cloud, Strategy)
query_post_execution_showplan
Read More
Tags ExtendedEvents
November 2, 2015

Create an Extended Events session - Azure SQL Database
by BF (Senior MSSQL Operations - Enterprise, Cloud, Strategy)
sqlserver.sql_batch_completed, ring_buffer
Read More
Tags ExtendedEvents
November 2, 2015

Create an Extended Events session - On-Prem
by BF (Senior MSSQL Operations - Enterprise, Cloud, Strategy)
sqlserver.rpc_completed, sqlserver.sql_batch_completed, ring_buffer
Read More
Tags ExtendedEvents
Future Events
DevIntersection 2018
Microsoft Ignite 2018
IT/Dev Connections 2018
Popular Tags
SQLServer
TSQL
CloudComputing
Azure
SQLServerReplication
SQLServerPerformance
SQLServerHealthCheck
AzureSQLDatabase
Powershell
AzureVirtualMachine
SQLServerReplicationMonitor
SQLServerAlwaysOn
SQLServer2016
Metrics
ExtendedEvents
QueryTuning
ReportingServices
SQLServerManagementStudio
SQLServerTransactionLog
SQLServerAgent
WindowsFailoverCluster
DMVs
AzureStorage
SQLServer2017
IntegrationServices
Pinned Posts
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
T-SQL - Recursive CTE's


©2015 www.TechDevOps.com; Contact us: info@techdevops.com