Category: SQL SERVER

Install-Module -Name 7Zip4Powershell

Misc / PowerShell / SQL SERVER

May 29, 2021

Setting Up Automatic Scheduled Sql Server Database Backups using PowerShell script: Zipping the database backups & Backup auto cleanup / Retention policy enforcement using PowerShell – Part II

In the Part I, I have explained how we can set Automatic...

Import SQLServer

Misc / PowerShell / SQL SERVER

August 25, 2020

Setting Up Automatic Scheduled Sql Server Database Backups using PowerShell script: Supports SQL Server Express Edition also

One of my project was using SQL Server Express Edition which does...

sql server database read only

Database / SQL SERVER

July 13, 2017

How to change database from Read-Only to Read-Write mode in SQL SERVER ?

Recently, I was working on new ASP.NET application and for that I...

Order Database

Database / SQL SERVER

July 9, 2017

SQL Query for Multiple Table SELECT, INSERT, UPDATE and DELETE WITH JOIN CLAUSE

Order Database A. SELECT with multiple table in JOIN clause: –Select records...