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






April 10, 2018

The term 'New-AzureStorageContext' is not recognized as the name of a cmdlet, function, script file, or operable program.
by BF (Senior MSSQL Operations - Enterprise, Cloud, Strategy)
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 (Senior MSSQL Operations - Enterprise, Cloud, Strategy)
SQL Server Execute Package Utility
Read More
Tags SQLServerAgent
June 3, 2017

T-SQL List Database or Log Backups
by BF (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 BF (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 BF (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 BF (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 BF (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
DevIntersection 2018
Microsoft Ignite 2018
IT/Dev Connections 2018
Popular Tags
SQLServer
TSQL
CloudComputing
Azure
SQLServerReplication
SQLServerPerformance
SQLServerHealthCheck
AzureSQLDatabase
Powershell
AzureVirtualMachine
SQLServerReplicationMonitor
SQLServer2016
Metrics
SQLServerAlwaysOn
QueryTuning
ExtendedEvents
SQLServerTransactionLog
SQLServerAgent
ReportingServices
SQLServerManagementStudio
DMVs
AzureStorage
SQLServer2017
WindowsFailoverCluster
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