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






July 31, 2017

Create a Microsoft SQL Server Audit Report using Powershell
by BFarrell (Senior MSSQL Operations - Enterprise, Cloud, Strategy)
Microsoft.SqlServer.SMO, HTML Report, Email Delivery
Read More
Tags Powershell
March 26, 2017

Microsoft Azure - copy all content from one storage container to another
by BFarrell (Senior MSSQL Operations - Enterprise, Cloud, Strategy)
Get-AzureStorageBlob, Start-CopyAzureStorageBlob, Get-AzureStorageBlobCopyState
Read More
Tags Powershell
December 10, 2016

Verify a remote TCP port connectivity using Powershell
by BFarrell (Senior MSSQL Operations - Enterprise, Cloud, Strategy)
Test-NetConnection
Read More
Tags Powershell
September 26, 2016

Azure SQL Database Geo-Replication - Initiate a Failover using PowerShell
by BFarrell (Senior MSSQL Operations - Enterprise, Cloud, Strategy)
Set-AzureRmSqlDatabaseSecondary, Get-AzureRmSqlDatabaseReplicationLink
Read More
Tags Powershell
September 19, 2016

Azure Powershell Get all Virtual Machines Status in a Subscription
by BFarrell (Senior MSSQL Operations - Enterprise, Cloud, Strategy)
Get-AzureRMResourceGroup, Get-AzureRmVM, PSCustomObject
Read More
Tags Powershell
September 17, 2016

Azure Powershell Create a new Virtual Machine with 1 VNET and 2 SUBNETS
by BFarrell (Senior MSSQL Operations - Enterprise, Cloud, Strategy)
New-AzureRmVM, New-AzureRmVMConfig, New-AzureRmNetworkInterface
Read More
Tags Powershell
August 24, 2016

Create Alert for Azure SQL Database using Powershell Code
by BFarrell (Senior MSSQL Operations - Enterprise, Cloud, Strategy)
Add-AzureRmMetricAlertRule
Read More
Tags Powershell
July 11, 2016

Microsoft Azure SQL Database Copy Operation
by BFarrell (Senior MSSQL Operations - Enterprise, Cloud, Strategy)
Start-AzureSqlDatabaseCopy, Get-AzureSqlDatabaseOperation, Monitor Progress
Read More
Tags Powershell
July 3, 2016

Create Microsoft Azure SQL Database using Powershell
by BFarrell (Senior MSSQL Operations - Enterprise, Cloud, Strategy)
Module AzureRM.sql, New-AzureRmSqlServer, New-AzureRmSqlDatabase, SAAS
Read More
Tags Powershell
June 15, 2016

Delete Microsoft Azure Storage Blob(s) based on specified retention period
by BFarrell (Senior MSSQL Operations - Enterprise, Cloud, Strategy)
Microsoft SQL Server .bak & log files
Read More
Tags Powershell
May 31, 2016

Powershell - Azure Traffic Manager Enable and Disable Endpoints
by BFarrell (Senior MSSQL Operations - Enterprise, Cloud, Strategy)
Azure Traffic Manager Cmdlets
Read More
Tags Powershell
April 5, 2016

Powershell Remoting - Get-Process on Remote Servers
by BFarrell (Senior MSSQL Operations - Enterprise, Cloud, Strategy)
New-PSSession, Invoke-Command, Get-Process, Remove-PSSession
Read More
Tags Powershell
April 5, 2016

Powershell - Interactive Sessions, Legacy Remoting, Powershell Remoting(WSMan, WinRM Service)
by BFarrell (Senior MSSQL Operations - Enterprise, Cloud, Strategy)
help about_remote -ShowWindow
Read More
Tags Powershell
April 1, 2016

Powershell - Get Azure Traffic Manager EndPoints Monitor Status
by BFarrell (Senior MSSQL Operations - Enterprise, Cloud, Strategy)
Azure REST API, Log to file
Read More
Tags Powershell
March 31, 2016

Powershell - Failover Cluster
by BFarrell (Senior MSSQL Operations - Enterprise, Cloud, Strategy)
Using Windows PowerShell cmdlets to Manage a Failover Cluster
Read More
Tags Powershell
March 16, 2016

Get Azure Traffic Manager EndPoints Monitor Status
by BFarrell (Senior MSSQL Operations - Enterprise, Cloud, Strategy)
Powershell, Chrome Postman
Read More
Tags Powershell
August 2, 2015

How to check if SQL Server is running on a Physical or Virtual Machine
by BFarrell (Senior MSSQL Operations - Enterprise, Cloud, Strategy)
Use T-SQL, CMD Prompt or Powershell
Read More
Tags Powershell
June 21, 2015

Use Powershell to capture SQL Server Resources
by BFarrell (Senior MSSQL Operations - Enterprise, Cloud, Strategy)
Use Powershell to capture SQL Server Resources - Test Connection, CPU Usage, MEM Usage & Disk Usage.
Read More
Tags Powershell
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