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





Latest in TDO...

May 24, 2019

Get SQL Server Modules loaded

by BF (Senior MSSQL Operations - Enterprise, Cloud, Strategy)
SQL Server VAS (Virtual Address Space)
Read More
Tags SQLServer, TSQL
May 3, 2019

View SQL Job Last Status in Microsoft System Center

by BF (Senior MSSQL Operations - Enterprise, Cloud, Strategy)
OperationsManager
Read More
Tags SQLServer, SystemCenter, TSQL
April 16, 2019

Powershell - Log CPU - per Process - to a Table & Output File

by BF (Senior MSSQL Operations - Enterprise, Cloud, Strategy)
Get-Counter, Invoke-sqlcmd
Read More
Tags Powershell, SQLServer
April 2, 2019

Azure Powershell - Delete all files in Storage Files Share

by BF (Senior MSSQL Operations - Enterprise, Cloud, Strategy)
Remove-AzureStorageFile
Read More
Tags CloudComputing, Powershell, SQLServer
February 28, 2019

Server-Level Trigger to notify on any Drop Database

by BF (Senior MSSQL Operations - Enterprise, Cloud, Strategy)
ALTER TRIGGER [DropDatabaseNotifier] ON ALL SERVER FOR DROP_DATABASE
Read More
Tags SQLServer, Trigger
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
Future Events
DevIntersection
Microsoft Ignite
IT/Dev Connections
Popular Tags
SQLServer
TSQL
CloudComputing
Azure
SQLServerReplication
SQLServerPerformance
SQLServerHealthCheck
Powershell
AzureSQLDatabase
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