Vijeesh


Technical Article

PowerShell script to create SQL Server alias name

This script is useful for your environment having multiple always-on with replication setup and your listener value is persisted with RegisterallIP set to 1. When initiating the always-on failover, It will create/update the alias in the distributor server by pointing to the new primary server without RDP to each distributor server and that makes the […]

4.33 (3)

You rated this post out of 5. Change rating

2021-07-07 (first published: )

1,268 reads

Blogs

SQL Prompt Quick Access to Helper Code

By

We’ve been doing some events as part of the Redgate Roadshow, and at one...

Eleven chapters of my data architecture book are available

By

As I have mentioned in prior blog posts, I have been writing a data...

Speaking at SQL Saturday Boston 2023

By

I’m happy to announce that I will be speaking at SQL Saturday Boston on...

Read the latest Blogs

Forums

Database recovery

By sharathgt

Hi, My .mdf file is accidentally deleted at client's place and without bothering the...

Works on all other sql2022 servers but not on production. - must be dropped

By krypto69

HI We have a small utility that is giving us a "#table is missing...

Convert common Separated number to # table

By ralahari

@reportParameter 1008,1009,1011,1014 values need to insert to #Table Note: @reportParameter is not returning values...

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers