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



Latest in TDO...

January 21, 2019

Log Shipping Real-Time Processing Engine v2

by BF (Senior MSSQL Operations - Enterprise, Cloud, Strategy)
msdb.dbo.restorehistory, msdb.dbo.backupset, msdb.dbo.backupmediaset, msdb.dbo.backupmediafamily
Read More
Tags SQLServer, SQLServerLogShipping, TSQL
January 15, 2019

T-SQL - Using Bitwise Operators to store multiple values in one column

by BF (Senior MSSQL Operations - Enterprise, Cloud, Strategy)
Bitwise operators perform bit manipulations between two expressions of any of the data types of the integer data type category...
Read More
Tags SQLServer, TSQL
January 10, 2019

Restore a SQL Server Database Faster

by BF (Senior MSSQL Operations - Enterprise, Cloud, Strategy)
MAXTRANSFERSIZE, BUFFERCOUNT
Read More
Tags SQLServer, SQLServerPerformance
December 18, 2018

T-SQL - Determine the last DBCC CHECKDB date

by BF (Senior MSSQL Operations - Enterprise, Cloud, Strategy)
DBCC DBINFO
Read More
Tags SQLServer
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
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