Find Active Node In Cluster With SQL
Here’s another couple ways to easily find the active node in a clustered environment with SQL:
How To Install Latest MongoDB Community Edition In Linux
To install the latest version of MongoDB Community Edition on Linux; from the terminal: 1: Import the MongoDB GPG key to ensure package authenticity: 2: Create a list file for MongoDB: Note: […]
Get Simple Create Script For SQL Logins And Domain Groups Accounts
Here is another bit of SQL logic to produce scripts for SQL Logins. This is nothing new, and was written forever ago but still works well. Thought I would include here. This […]
Create SQL Drive Alert With Visual Chart Using SQL, HTML, Powershell And Json (Updated 2023)
Here’s an updated version of the SQL Drive Alert notification built using basic SQL and HTML with inline CSS styling. Resulting alert works perfectly in Outlook Dark theme. This was created for […]
Create SQL Drive Alert With Visual Chart Using SQL And HTML
Here’s a another Drive Alert notification built using basic SQL and HTML with inline CSS styling. Resulting alert works perfectly in Outlook Dark theme. This was created for SQL Versions up to […]
Run DBCC CHECKDB Across All Databases
Here’s short and simple way to run CHECKDB statements across all databases. I’ve included the process for basic DBCC CHECKDB and another script for DBCC CHECKDB with REPAIR_ALLOW_DATA_LOSS It is recommended that […]
Markdown and ShortCode Test
another test use master; set nocount on;
Disable SQL Audits With SQL
Here’s a quick way to disable SQL Audits with SQL. This should save you a few clicks. Hope you find it helpful.
Get Cluster Drive Letters With SQL
Here’s a quick little script to return the drive from shared storage when running a database server with Failover Cluster.
Move All Get-ClusterResource Results Into SQL Table With SQL And JSON
In case you need all the results from Powershell Get-ClusterResource sent to a table; this bit of logic should help you get there. Hope you find it helpful.
Import Powershell Get-ClusterResource results Into SQL Tables
Here’s another import process to get Powershell results into an SQL table using JSON data conversion. In this example; we’ll be using the Get-ClusterResource results. Hope you find it helpful.
Get All Drive Size Information With SQL, JSON, and Powershell – Works Across Versions
Universal SQL Query using Powershell and JSON to determine all drive space.
Use SQL and JSON To Easily Convert Powershell Format-List Results Into An SQL Table
Here’s another way to use JSON values from SQL table data. In this example I am using results from a Powershell Get-ClusterResource script. The results will be imported into an SQL Table, […]
Get All Drive Space With SQL
Here’s yet another way you can get the drive space with SQL. This draws drive information with alittle powershell. Hope you find it helpful.
Recent Comments