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






February 3, 2024

Microsoft SQL Server Fleet Backup Report Using PowerShell
by BF (Principal Consultant; Architecture; Engineering)
Invoke-Sqlcmd
Read More
Tags Powershell
June 20, 2020

Windows Failover Cluster - Using Paxos Tag to monitor cluster configuration synchronization across the system
by BF (Principal Consultant; Architecture; Engineering)
WSFC, Always On Availability Groups
Read More
Tags Powershell
October 7, 2019

Powershell - Disk Space Alert
by BF (Principal Consultant; Architecture; Engineering)
Get-WmiObject
Read More
Tags Powershell
April 16, 2019

Powershell - Log CPU - per Process - to a Table & Output File
by BF (Principal Consultant; Architecture; Engineering)
Get-Counter, Invoke-sqlcmd
Read More
Tags Powershell
April 2, 2019

Azure Powershell - Delete all files in Storage Files Share
by BF (Principal Consultant; Architecture; Engineering)
Remove-AzureStorageFile
Read More
Tags Powershell
October 27, 2018

Use Powershell to monitor S2D(Storage Spaces Direct) Performance
by BF (Principal Consultant; Architecture; Engineering)
Get-StorageSubSystem, Get-StorageHealthReport
Read More
Tags Powershell
June 21, 2018

Use Powershell to Stop & Start SQL Server Service
by BF (Principal Consultant; Architecture; Engineering)
Get-Service, Stop-Service, Start-Service
Read More
Tags Powershell
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 Powershell
February 24, 2018

Using PowerShell to spin up Windock's Docker Containers running SQL Server with Cloned Databases
by BF (Principal Consultant; Architecture; Engineering)
Clone Terabyte data in seconds
Read More
Tags Powershell
January 19, 2018

Powershell Functions to check if TLS 1.2 updates are required
by BF (Principal Consultant; Architecture; Engineering)
Check if SQL Server Native Client can support TLS 1.2, Check if Microsoft ODBC Driver for SQL Server can support TLS 1.2
Read More
Tags Powershell
December 2, 2017

Troubleshooting Azure VM SQL Server Database Mail using SmtpClient class, PowerShell and SendGrid
by BF (Principal Consultant; Architecture; Engineering)
System.Net.Mail.MailAddress, System.net.mail.smtpclient, System.Net.NetworkCredential
Read More
Tags Powershell
October 4, 2017

Automate Azure SQL Database (As-A-Service) Copy From a Logical Server to another Logical Server
by BF (Principal Consultant; Architecture; Engineering)
Import-AzureRmContext, Get-AzureRMResource, New-azurermsqldatabasecopy
Read More
Tags Powershell
July 31, 2017

Create a Microsoft SQL Server Audit Report using Powershell
by BF (Principal Consultant; Architecture; Engineering)
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 BF (Principal Consultant; Architecture; Engineering)
Get-AzureStorageBlob, Start-CopyAzureStorageBlob, Get-AzureStorageBlobCopyState
Read More
Tags Powershell
December 10, 2016

Verify a remote TCP port connectivity using Powershell
by BF (Principal Consultant; Architecture; Engineering)
Test-NetConnection
Read More
Tags Powershell
September 26, 2016

Azure SQL Database Geo-Replication - Initiate a Failover using PowerShell
by BF (Principal Consultant; Architecture; Engineering)
Set-AzureRmSqlDatabaseSecondary, Get-AzureRmSqlDatabaseReplicationLink
Read More
Tags Powershell
September 19, 2016

Azure Powershell Get all Virtual Machines Status in a Subscription
by BF (Principal Consultant; Architecture; Engineering)
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 BF (Principal Consultant; Architecture; Engineering)
New-AzureRmVM, New-AzureRmVMConfig, New-AzureRmNetworkInterface
Read More
Tags Powershell
August 24, 2016

Create Alert for Azure SQL Database using Powershell Code
by BF (Principal Consultant; Architecture; Engineering)
Add-AzureRmMetricAlertRule
Read More
Tags Powershell
July 11, 2016

Microsoft Azure SQL Database Copy Operation
by BF (Principal Consultant; Architecture; Engineering)
Start-AzureSqlDatabaseCopy, Get-AzureSqlDatabaseOperation, Monitor Progress
Read More
Tags Powershell
July 3, 2016

Create Microsoft Azure SQL Database using Powershell
by BF (Principal Consultant; Architecture; Engineering)
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 BF (Principal Consultant; Architecture; Engineering)
Microsoft SQL Server .bak & log files
Read More
Tags Powershell
May 31, 2016

Powershell - Azure Traffic Manager Enable and Disable Endpoints
by BF (Principal Consultant; Architecture; Engineering)
Azure Traffic Manager Cmdlets
Read More
Tags Powershell
April 5, 2016

Powershell Remoting - Get-Process on Remote Servers
by BF (Principal Consultant; Architecture; Engineering)
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 BF (Principal Consultant; Architecture; Engineering)
help about_remote -ShowWindow
Read More
Tags Powershell
April 1, 2016

Powershell - Get Azure Traffic Manager EndPoints Monitor Status
by BF (Principal Consultant; Architecture; Engineering)
Azure REST API, Log to file
Read More
Tags Powershell
March 31, 2016

Powershell - Failover Cluster
by BF (Principal Consultant; Architecture; Engineering)
Using Windows PowerShell cmdlets to Manage a Failover Cluster
Read More
Tags Powershell
March 16, 2016

Get Azure Traffic Manager EndPoints Monitor Status
by BF (Principal Consultant; Architecture; Engineering)
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 BF (Principal Consultant; Architecture; Engineering)
Use T-SQL, CMD Prompt or Powershell
Read More
Tags Powershell
June 21, 2015

Use Powershell to capture SQL Server Resources
by BF (Principal Consultant; Architecture; Engineering)
Use Powershell to capture SQL Server Resources - Test Connection, CPU Usage, MEM Usage & Disk Usage.
Read More
Tags Powershell
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
SQLServerArchitecture
DMVs
AzureStorage
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