Scripts

Technical Article

Migrate and Upgrade SQL Instance (2014/2016) to 2019 version with 1 click

The script includes these steps:   STEP 1: CREATE EMPTY Databases STEP 2 - CREATE Logins WITH SERVER ROLES\PERMISSIONS STEP 3 - COPY LINKED SERVERS STEP 4 - COPY SERVER OPTIONS STEP 5 - COPY CREDENTIALS STEP 6 - COPY AGENT JOBS STEP 7 - COPY DB Mail STEP 8 - COPY CERTIFICATES STEP 9 […]

2020-05-22 (first published: )

1,277 reads

Technical Article

Migrate and Upgrade SQL Instance (2014/2016) to 2019 version with 1 click

The script includes these steps:   STEP 1: CREATE EMPTY Databases STEP 2 - CREATE Logins WITH SERVER ROLESPERMISSIONS STEP 3 - COPY LINKED SERVERS STEP 4 - COPY SERVER OPTIONS STEP 5 - COPY CREDENTIALS STEP 6 - COPY AGENT JOBS STEP 7 - COPY DB Mail STEP 8 - COPY CERTIFICATES STEP 9 […]

2020-05-22 (first published: )

497 reads

Technical Article

Powershell Script - Azure cosmos DB(SQL API)

Scripts contains 4 following functions. Users can create 3 different script from this for inserting, fetching and deleting a document.
1. Function Generate-MasterKeyAuthorizationSignature - This function is used to create connection to Azure cosmos DB. This function codes were taken from Technet.
2. Function Post-CosmosDb - Insert single document in azure cosmos DB. Same function can be used to perform bulkinsert. This function code was taken from following article. To make it useful i made some modification in it.
(https://www.systemcenterautomation.com/2018/06/cosmos-db-rest-api-powershell/)
3. Function Get-CosmosDocument - Fetch single document from azure cosmos DB. Same function can be used to fetch all documents from Cosmos DB.
4. Function Delete-CosmosDbDocument - Delete single document from cosmos DB. Same function can be used to delete more than one document with some additional codes.

To use any of the function like Post,Get, Delete. you have to comment the other 2 function call. If you are using all 3 functions(Post,Get, Delete), Be cautious while using them.

2020-05-11 (first published: )

2,508 reads

Technical Article

Daily Sql Server Health Check

Are you a Senior Sql Server DBA or novice looking for a Daily Sql Server Health Check?   As a Senior DBA for over 15 years I have compile a few scripts I use on a daily basis to check the health of my Sql Servers. Perform a Daily Sql Server Health Check on your Sql […]

2020-05-06

5,686 reads

Technical Article

Output multiple datasets from one INVOKE-SQLCMD command

A common question that I've seen online is how do I return multiple sql datasets from a single query using INVOKE-SQLCMD. Most of the answers out there say it is not possible, but it is in fact possible by using the OutputAs dataset parameter. This parameter outputs a dataset that has all of the information […]

2020-04-24 (first published: )

3,179 reads

Technical Article

Unused Indexes

This script will provide a list of indexes that are not used in a database. Indexes are overhead and any indexes not being used but are being updated cause additional load on a database. This looks at the following  items: User seeks, scans and lookups. If all three of these are zero and the User […]

2020-04-21 (first published: )

2,031 reads

Technical Article

Missing index script

This script on missing indexes that SQL had found. SQL will track queries and provide suggestions on indexes it feels will provide improvements. You should not take this information and create all the indexes. Performance tuning can be an art and takes practice. This information should be reviewed and as a DBA implemented a little […]

2020-04-20 (first published: )

3,354 reads

Technical Article

Calculating Easter in SQL

Several months ago someone commented on a calendar thread that you should not even try to calculate Easter in SQL Server because the math was too hard.  That got me to thinking and I decided to see if that was actually the case. I found that there are several well known algorithms available - but […]

2020-04-06 (first published: )

2,044 reads

Blogs

SQL Homework – July 2022 – Update your resume.

By

Resumes have been on my mind a lot recently. I’ve been thinking that I...

A Blogging Break

By

Outside of coping tips, I’m gonna take a break from blogging. I’ve been aiming...

Extended Events for Anything But Query Tuning: Unique Constraint Violations

By

Most of the time when I talk about or demo Extended Events, I spend...

Read the latest Blogs

Forums

Establishing a Connection to PostgreSQL with GoLang

By sabyda

Comments posted to this topic are about the item Establishing a Connection to PostgreSQL...

Azure Data Lake Storage Gen 2

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Azure Data Lake Storage Gen...

Be Smart

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Be Smart

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers