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






June 3, 2017

T-SQL List Database or Log Backups
by BFarrell (Senior MSSQL Operations - Enterprise, Cloud, Strategy)
Backupset - Contains a row for each backup set. A backup set contains the backup from a single, successful backup operation. Backupmediafamily - Contains one row for each media family.
Read More
Tags SQLServerAgent
June 2, 2017

Use AzCopy to copy SQL Server Backup Files to Azure Blob Storage
by BFarrell (Senior MSSQL Operations - Enterprise, Cloud, Strategy)
Within our Microsoft Cloud Environment we use a 3rd party product from Red-Gate - SQL Backup - to perform SQL Server backups for our both our System...
Read More
Tags SQLServerAgent
June 29, 2016

T-SQL Check the last X days for any SQL Agent Job steps that were retried
by BFarrell (Senior MSSQL Operations - Enterprise, Cloud, Strategy)
MSDN function dbo.agent_datetime for Date & Time, Filter out Replication Jobs
Read More
Tags SQLServerAgent
November 7, 2015

Find Microsoft SQL Server Agent Job History Retention Settings using T-SQL
by BFarrell (Senior MSSQL Operations - Enterprise, Cloud, Strategy)
Max Records, Max Records Per Job, xp_instance_regread
Read More
Tags SQLServerAgent
August 2, 2015

Find a stored procedure call within a SQL Server Job
by BFarrell (Senior MSSQL Operations - Enterprise, Cloud, Strategy)
Using T-SQL, find a stored procedure call within a SQL Server Job step(s)
Read More
Tags SQLServerAgent
Future Events
Microsoft Ignite 2017
IT/Dev Connections 2017
SQL Server LIVE! 2017
Popular Tags
SQLServer
TSQL
CloudComputing
Azure
SQLServerReplication
SQLServerHealthCheck
AzureSQLDatabase
SQLServerPerformance
Powershell
SQLServerReplicationMonitor
AzureVirtualMachine
SQLServer2016
Metrics
QueryTuning
ExtendedEvents
SQLServerManagementStudio
ReportingServices
SQLServerTransactionLog
SQLServerAlwaysOn
SQLServer2017
SQLServerAgent
WindowsServer2008
WindowsFailoverCluster
SQLServer2008
IntegrationServices
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