info@techdevops.com | 437-991-3573 | Data Engineering Services
TechDevOps.com
Resources Tools Services
Experts in Microsoft SQL Server on Windows, Linux, Containers | Clusters, Always On, FCI | Migrations, Cloud, Performance






November 13, 2022

Compare SQL Agent Job Runtime for a certain day of the week
by BF (Principal Consultant; Architecture; Engineering)
A Migration Performance Check Item
Read More
Tags SQLServerAgent
June 20, 2022

SQL Agent Jobs - Enable, Disable, Stop - Commands
by BF (Principal Consultant; Architecture; Engineering)
sysjobs, sysjobhistory, sysjobschedules, sysoperators
Read More
Tags SQLServerAgent
April 10, 2018

The term 'New-AzureStorageContext' is not recognized as the name of a cmdlet, function, script file, or operable program.
by BF (Principal Consultant; Architecture; Engineering)
SQLPS.exe, New-AzureStorageContext, Get-AzureStorageBlob, Remove-AzureStorageBlob
Read More
Tags SQLServerAgent
November 24, 2017

Troubleshooting SSIS Package Execution using dtexec Utility (SSIS Tool)
by BF (Principal Consultant; Architecture; Engineering)
SQL Server Execute Package Utility
Read More
Tags SQLServerAgent
June 3, 2017

T-SQL List Database or Log Backups
by BF (Principal Consultant; Architecture; Engineering)
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 BF (Principal Consultant; Architecture; Engineering)
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 BF (Principal Consultant; Architecture; Engineering)
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 BF (Principal Consultant; Architecture; Engineering)
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 BF (Principal Consultant; Architecture; Engineering)
Using T-SQL, find a stored procedure call within a SQL Server Job step(s)
Read More
Tags SQLServerAgent
Future Events
DevIntersection
Microsoft Ignite
PASS Summitt
Popular Tags
SQLServer
TSQL
CloudComputing
Azure
SQLServerReplication
SQLServerPerformance
SQLServerHealthCheck
Powershell
AzureSQLDatabase
SQLServerAlwaysOn
DataMigration
SQLServerReplicationMonitor
AzureVirtualMachine
SQLServer2016
ExtendedEvents
Metrics
QueryTuning
ReportingServices
SQLServerAgent
WindowsFailoverCluster
SQLServerManagementStudio
SQLServerTransactionLog
DMVs
AzureStorage
SQLServer2017
Pinned Posts
Microsoft SQL Server Always On Availability Groups Architecture Design
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


©2015 www.TechDevOps.com