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 Powershell
February 24, 2018

Using PowerShell to spin up Windock's Docker Containers running SQL Server with Cloned Databases
by BF (Senior MSSQL Operations - Enterprise, Cloud, Strategy)
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 (Senior MSSQL Operations - Enterprise, Cloud, Strategy)
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 (Senior MSSQL Operations - Enterprise, Cloud, Strategy)
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 (Senior MSSQL Operations - Enterprise, Cloud, Strategy)
Import-AzureRmContext, Get-AzureRMResource, New-azurermsqldatabasecopy
Read More
Tags Powershell
July 31, 2017

Create a Microsoft SQL Server Audit Report using Powershell
by BF (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 BF (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 BF (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 BF (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 BF (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 BF (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 BF (Senior MSSQL Operations - Enterprise, Cloud, Strategy)
Add-AzureRmMetricAlertRule
Read More
Tags Powershell
July 11, 2016

Microsoft Azure SQL Database Copy Operation
by BF (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 BF (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 BF (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 BF (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 BF (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 BF (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 BF (Senior MSSQL Operations - Enterprise, Cloud, Strategy)
Azure REST API, Log to file
Read More
Tags Powershell
March 31, 2016

Powershell - Failover Cluster
by BF (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 BF (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 BF (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 BF (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
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