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






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
SQL Server LIVE! 2017
Popular Tags
SQLServer
TSQL
Azure
CloudComputing
SQLServerReplication
AzureSQLDatabase
SQLServerHealthCheck
SQLServerPerformance
Powershell
SQLServerReplicationMonitor
AzureVirtualMachine
SQLServer2016
Metrics
QueryTuning
ExtendedEvents
SQLServerManagementStudio
SQLServerAgent
ReportingServices
SQLServerTransactionLog
SQLServerAlwaysOn
SQLServer2017
IntegrationServices
WindowsServer2008
WindowsFailoverCluster
SQLServer2008
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