Category Archives: Database

Check If SQL Table Exists Using Powershell

      No Comments on Check If SQL Table Exists Using Powershell

Another common request for DBA’s is to search for or validate that certain tables or other objects exist and in what database. This post is a follow-up to our “Check If Database Exists Using Powershell” post where we search look for a database remotely using the “invoke-sqlcmd” commandlet. Note: This… Read more »

How To Generate Random Strings in SQL | GUID and Passwords

Random strings, characters and ID’s are used all the time in development and especially in Database work where some data needs to be unique or uniquely identified. This example code was written many years ago to generate passwords in SQL 2008 with certain complexities for automation purposes using the RAND()… Read more »

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 »

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 »

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 »