SQL Failover Cluster Unattended Install with Multiple Instances Advanced Method Completion Part 2

This is the continuation for using the advanced methods to install a SQL cluster instance unattended. In SQL Failover Cluster Part 1 we created a Configuration file using the wizard and then modified the file to allow a Silent or Quiet unattended installation. This “prepare” install is only used to… Read more »

Using Powershell Check For Pending Reboot and Last Restart on Remote Computer

We want to check for a pending restart. If a server is awaiting a reboot before attempting to to install new software or make OS changes. These powershell examples will help with checking the last reboot date and time as well as return a Yes and No if it is… Read more »

SQL Failover Cluster Unattended Install with Multiple Instances Using The Advanced Prepare Method Part 1

This is an advance process that allows us to prepare a cluster node or likely multiple nodes quickly. We will use the configuration file feature and install the SQL services and instance level resources on each node so they are exactly the same. Then we fail all of the drives… Read more »

Find All SQL Server Instances On The Network Using Powershell

Searching for and cataloging the SQL server instances on your network is a key part of Administration. Powershell offers some quick and simple methods to find servers base on the their name or description in Active Directory. We can use the Powershell module to collect these servers and add them… Read more »

Powershell DataTable Select Distinct or Unique Values

Working with data in a DataTable means understanding how to find, sort and select what you need. Since this blog is about database we are basically looking at selecting data similar to the T-SQL command. The Select distinct statement returns only 1 for each unique record. This includes combinations so… Read more »

How to Connect SQL Server in Python | Username and Password

For the Python experienced Developers & DBA’s I thought I would include an article about connecting to SQL server similar to the SQL server powershell version we wrote recently. I tested this code using PyCharm and a new virtual environment that did not have pyodbc. To connect to SQL Server… Read more »

How To Create A SQL Stored Procedure With An Input Parameter

Learning to create and manage stored procedures in SQL is another useful SQL databases skill for the DBA and developer. The Procedures allow you to create repeatable code that can be executed using just a database single call. We can also design the procedure to handle passing parameters into it…. Read more »

Use Powershell To Get SQL Database Versions Locally or Remote

Collecting version information for your environment is a never ending task but Powershell can be used to make things easier. Each SQL server instance can be different and a single server can have multiple SQL instances with different versions. In SQL server we can use SSMS to run the following… Read more »

Use Powershell To Backup SQL Database Remote

      No Comments on Use Powershell To Backup SQL Database Remote

This is a Powershell script I’ve used for a few years that creates a dated folder and places a backup for a single database in it. This version uses the “Invoke-Sqlcmd” and you may need to install the module before using this script. Install-Module sqlserverGet-Command -ModuleName sqlserver You only need… Read more »