TechDevOps.com
Explore Tools
Experts in Microsoft SQL Server Operations, Performance, Replication, Cloud & Migrations



Latest in TDO...

December 6, 2018

T-SQL Monitor TempDB Usage

by BF (Senior MSSQL Operations - Enterprise, Cloud, Strategy)
sys.database_files, sys.dm_os_performance_counters, sys.dm_db_file_space_usage
Read More
Tags SQLServer, SQLServerPerformance, TempDB, TSQL
December 4, 2018

Extracting Metrics from MSlogreader_history - "Approximately 45000000 log records have been scanned..."

by BF (Senior MSSQL Operations - Enterprise, Cloud, Strategy)
Distribution.dbo.MSlogreader_history, Distribution.dbo.MSlogreader_agents
Read More
Tags SQLServer, SQLServerReplication, SQLServerReplicationMonitor
December 3, 2018

T-SQL - Dynamically Re-Size TempDB Files

by BF (Senior MSSQL Operations - Enterprise, Cloud, Strategy)
Alter Database tempdb Modify File
Read More
Tags SQLServer, TSQL
December 3, 2018

Distribution Database in Recovery Pending State

by BF (Senior MSSQL Operations - Enterprise, Cloud, Strategy)
Alter Database Modify File
Read More
Tags SQLServer, SQLServerReplication, TSQL
November 23, 2018

Use Extended Events to monitor SQL Server Transactional Replication

by BF (Senior MSSQL Operations - Enterprise, Cloud, Strategy)
ring_buffer
Read More
Tags ExtendedEvents, SQLServer, SQLServerReplication
November 23, 2018

SQL Server Reporting Services - Report Usage Stats

by BF (Senior MSSQL Operations - Enterprise, Cloud, Strategy)
ExecutionLog2
Read More
Tags ReportingServices, SQLServer, TSQL
November 23, 2018

T-SQL List Permissions for an Object

by BF (Senior MSSQL Operations - Enterprise, Cloud, Strategy)
sys.objects, sys.database_permissions, sys.database_principals
Read More
Tags SQLServer, TSQL
November 22, 2018

SQL Server Reporting Services - File Share Account

by BF (Senior MSSQL Operations - Enterprise, Cloud, Strategy)
Reporting Services Configuration Manager
Read More
Tags ReportingServices, SQLServer
November 20, 2018

Migrating a Giant to the Cloud

by BF (Senior MSSQL Operations - Enterprise, Cloud, Strategy)
Microsoft Azure Cloud Computing
Read More
Tags Azure, CloudComputing, SQLServer
November 18, 2018

T-SQL - Get all Distribution Agents, UndelivCmdsInDistDB & DelivCmdsInDistDB

by BF (Senior MSSQL Operations - Enterprise, Cloud, Strategy)
MSdistribution_agents, MSdistribution_status, MSARTICLES, SYS.Servers, MSagent_profiles
Read More
Tags SQLServer, SQLServerReplication
Future Events
DevIntersection
Microsoft Ignite
IT/Dev Connections
Popular Tags
SQLServer
TSQL
CloudComputing
Azure
SQLServerReplication
SQLServerPerformance
SQLServerHealthCheck
AzureSQLDatabase
Powershell
DataMigration
AzureVirtualMachine
SQLServerReplicationMonitor
SQLServerAlwaysOn
SQLServer2016
ExtendedEvents
Metrics
QueryTuning
ReportingServices
SQLServerManagementStudio
SQLServerTransactionLog
SQLServerAgent
WindowsFailoverCluster
DMVs
AzureStorage
SQLServer2017
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