MS SQL Archives • Our Tech Ideas

Category: <span>MS SQL</span>

Mirror database stuck in the state of “(Mirroring, Disconnected / In Recovery)”

by Sanjay Humania November 23, 2021

Scenario We have an interesting situation after configuring a mirror setup. We have configured mirroring between a list of databases…

Database, Miscellaneous, MS SQL

Do Linkedin Courses & Showcase Your Knowledge

by Sanjay Humania October 5, 2021

LinkedIn Learning offering a huge list of video courses. Instantly we can access more than 15,000 courses in different languages…

Database, MS SQL

How To Change Default TCP Port in SQL Server

by Sanjay Humania September 22, 2021

Database, MS SQL

Things You Must Do After Installing SQL Server

by Sanjay Humania July 13, 2021

Database, MS SQL

How to find database size when it is offline in sql server

by Sanjay Humania July 1, 2021

Database, MS SQL

How to Change Product Key for SQL Server

by Sanjay Humania June 30, 2021

Database, MS SQL

Convert or make SQL Server Named instance look like a Default instance

by Sanjay Humania June 29, 2021

Database, MS SQL

How to find database growth size in sql server

by Sanjay Humania June 28, 2021

Database, MS SQL

Change the startup options in SSMS to open a NEW QUERY WINDOW

by Sanjay Humania April 24, 2021

Database, MS SQL

Find blocking by T-SQL Queries

by Sanjay Humania August 27, 2020

Database, MS SQL

Find who dropped Database at what time

by Sanjay Humania January 12, 2020

Database, MS SQL

Provide a SQL Login ‘profiler access’ by ‘ALTER TRACE permission’

by Sanjay Humania January 5, 2020

Database, MS SQL

Extended Security Updates for SQL 2008/2008 R2

by Soyeluddin Biswas December 22, 2019

Database, MS SQL

How to change ‘TempDB’ file location in SQL Server

by Sanjay Humania December 18, 2019

Database, MS SQL

A to Z SQL Server Installation Process on Windows Server

by Sanjay Humania December 6, 2019

Database, MS SQL

ETA of Backup and Restoration for SQL Server Databases

by Basudeb Sutradhar December 4, 2019

Database, MS SQL

How to send Disk space report daily by a Job

by Sanjay Humania November 29, 2019

Database, MS SQL

How to send Database backup report daily by a Job

by Sanjay Humania November 28, 2019

Database, MS SQL

Display all Server Information by using TSQL script

by Sanjay Humania November 26, 2019

Database, MS SQL

How to get script of backup and restore of multiple databases

by Basudeb Sutradhar November 25, 2019

Database, MS SQL

Fixing Orphaned Users in SQL Server

by Sanjay Humania November 25, 2019

Database, MS SQL

How to find cached execution plan and delete if required.

by Soyeluddin Biswas November 21, 2019

Database, MS SQL

Configure Database mail in SQL Server

by Sanjay Humania November 17, 2019

Database, MS SQL

Error 26 in SQL Server

by Sanjay Humania November 17, 2019

Database, MS SQL

Find the SQL Server Cluster details

by Soyeluddin Biswas November 8, 2019

Database, MS SQL

Create a login using command prompt (CMD)

by Soyeluddin Biswas November 7, 2019

Database, MS SQL

Best Practices for SQL Database setting

by Soyeluddin Biswas November 6, 2019

Database, MS SQL

Find all the users for a particular database

by Soyeluddin Biswas November 6, 2019

Database, MS SQL

How to run a SQL query using command prompt without SQL SSMS

by Soyeluddin Biswas October 31, 2019

Database, MS SQL

Find IP and Port using SQL SSMS

by Soyeluddin Biswas October 31, 2019

Database, MS SQL

How to find out user activity on database without any particular Auditing

by Soyeluddin Biswas October 28, 2019

Database, MS SQL

Apply latest service pack to standalone SQL Server

by Sanjay Humania October 28, 2019

Database, MS SQL

Find SQL Server/Instance details using SQL query

by Soyeluddin Biswas October 24, 2019

Database, MS SQL

Login failed for user ‘XXXX’ (Microsoft SQL Server, Error: 18456)

by Soyeluddin Biswas October 23, 2019

Database, MS SQL

Error : FILESTREAM feature is disable

by Sanjay Humania October 17, 2019

Database, MS SQL

Run a Job on few specific dates of every month in SQL Server

by Sanjay Humania October 16, 2019

Database, MS SQL

Install SQL Server 2008R2 on Windows 2012R2

by Sanjay Humania October 15, 2019

Database, MS SQL

Unable to begin a Distributed Transaction

by Soyeluddin Biswas October 14, 2019

Database, MS SQL

Rename a Database in SQL Server

by Sanjay Humania October 11, 2019

Database, MS SQL

Reduce the size of a large database log file in SQL Server

by Sanjay Humania October 10, 2019

Database, MS SQL

Find the database file growth for all the databases in SQL Server

by Soyeluddin Biswas October 7, 2019

Database, MS SQL

What are the Database-Level Roles in SQL Server?

by Sanjay Humania October 7, 2019

Database, MS SQL

How to get all statistics information for a database in SQL Server

by Soyeluddin Biswas October 4, 2019

Database, MS SQL

Table backup in SQL Server

by Sanjay Humania October 4, 2019

Database, MS SQL

Install SQL Server 2016 on Windows Server 2012R2 step by step

by Sanjay Humania October 3, 2019

Database, MS SQL

Database Backup & Restore in SQL server

by Sanjay Humania October 2, 2019

Database, MS SQL

List of jobs associated with database in SQL Server

by Sanjay Humania September 30, 2019

Database, MS SQL

All about database size, file size & table size in SQL Server

by Sanjay Humania September 30, 2019

Database, MS SQL

SQL Instance Last restart date and time in SQL Server

by Soyeluddin Biswas September 29, 2019

Database, MS SQL

Database restore history in SQL Server

by Soyeluddin Biswas September 27, 2019