TechDevOps.com
Explore Tools
Experts in Microsoft SQL Server Operations, Performance, Replication, Cloud & Migrations
What Can We Help You Accomplish Today?





Latest in TDO...

February 15, 2019

SQL Server Transactional Replication - Get all Publication Article Columns, Get all Publication Article Filtered Rows

by BF (Senior MSSQL Operations - Enterprise, Cloud, Strategy)
Run in each Published Database
Read More
Tags SQLServer, SQLServerReplication
January 30, 2019

SQL Jobs Monitor

by BF (Senior MSSQL Operations - Enterprise, Cloud, Strategy)
Receive alerts on any SQL Jobs Failed
Read More
Tags SQLServer, SQLServerDatabaseMail, TSQL
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
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