Blog • Our Tech Ideas

Linux

List of Useful Linux Commands

by Sanjay Humania January 7, 2022

Here is a list of basic Linux commands: SYSINFO Server Release Info cat /etc/redhat_release lsb_release Server Type dmidecode Hardwareinfo lspci…

Database, MS SQL

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

Miscellaneous

WhatsApp multi-device feature

by Sanjay Humania September 23, 2021

Database, MS SQL

How To Change Default TCP Port in SQL Server

by Sanjay Humania September 22, 2021

Miscellaneous

How to Check All Mobile Connection Linked With Your Aadhaar Card

by Sanjay Humania September 19, 2021

Miscellaneous

Simple ways to view saved passwords on chrome

by Sanjay Humania September 11, 2021

Miscellaneous

Increase Download Speed On Google Chrome

by Sanjay Humania September 9, 2021

Web Dev., Wordpress

Create a Website For Free in Five Easy Steps

by Sanjay Humania July 24, 2021

Database, MS SQL

Things You Must Do After Installing SQL Server

by Sanjay Humania July 13, 2021

Miscellaneous

Unlock Your Computer using Your Phone

by Sanjay Humania July 8, 2021

Apache, Database, Mysql, Web Dev., Windows

How To Change XAMPP Apache Server Port

by Sanjay Humania July 3, 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

Miscellaneous

How to Auto Refresh any webpage in google chrome tab

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

Miscellaneous

Office 365 POP, IMAP and SMTP settings

by Sanjay Humania May 11, 2021

Database, MS SQL

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

by Sanjay Humania April 24, 2021

Windows

How to Enable or Disable Administrator Account On Windows 10

by Sanjay Humania April 18, 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

Miscellaneous

How To Download Youtube Private Video

by Sanjay Humania November 22, 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, Oracle

Data & Database

by Abinash Sahoo November 10, 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

Miscellaneous

How to delete Naukri account

by Sanjay Humania 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

Windows

Windows Server 2016 installation on Hyper-v

by Sanjay Humania October 22, 2019

Database, MS SQL

Error : FILESTREAM feature is disable

by Sanjay Humania October 17, 2019