Home • Our Tech Ideas

Latest Posts more

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

How to Enable or Disable Administrator Account On Windows 10

Find blocking by T-SQL Queries

Find who dropped Database at what time

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

Extended Security Updates for SQL 2008/2008 R2

How to change ‘TempDB’ file location in SQL Server

Installation Process for SQL Server

ETA of Backup and Restoration for SQL Server Databases

Featured Post

Database, MS SQL

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

by OTI April 24, 2021

Hi, as a DBA the first thing we do when we launch SQL Server Management Studio (SSMS) is to open…

Windows

How to Enable or Disable Administrator Account On Windows 10

by OTI April 18, 2021

When we install a fresh OS on a laptop or desktop ‘Administrator’ account is not enabled in Windows 10. We…

Database, MS SQL

Find blocking by T-SQL Queries

by OTI August 27, 2020

Database, MS SQL

Find who dropped Database at what time

by OTI January 12, 2020

Database, MS SQL

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

by OTI January 5, 2020

Database, MS SQL

Extended Security Updates for SQL 2008/2008 R2

by Soyeluddin Biswas December 22, 2019

Latest Posts

Database, MS SQL

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

by OTI April 24, 2021

Hi, as a DBA the first thing we do when we launch SQL Server Management Studio (SSMS) is to open…

Windows

How to Enable or Disable Administrator Account On Windows 10

by OTI April 18, 2021

When we install a fresh OS on a laptop or desktop ‘Administrator’ account is not enabled in Windows 10. We…

Database, MS SQL

Find blocking by T-SQL Queries

by OTI August 27, 2020

Database, MS SQL

Find who dropped Database at what time

by OTI January 12, 2020

Database, MS SQL

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

by OTI 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 OTI December 18, 2019

Database, MS SQL

Installation Process for SQL Server

by OTI 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 OTI November 29, 2019

Database, MS SQL

How to send Database backup report daily by a Job

by OTI November 28, 2019

Database, MS SQL

Display all Server Information by using TSQL script

by OTI 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 OTI November 25, 2019

Social Media, YouTube

How To Download Youtube Private Video

by OTI 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 OTI November 17, 2019

Database, MS SQL

Error 26 in SQL Server

by OTI 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

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 OTI 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 OTI October 22, 2019

Database, MS SQL

Error : FILESTREAM feature is disable

by OTI October 17, 2019

Database, MS SQL

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

by OTI October 16, 2019

Database, MS SQL

Install SQL Server 2008R2 on Windows 2012R2

by OTI 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 OTI October 11, 2019

Database, MS SQL

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

by OTI 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 OTI 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 OTI October 4, 2019

Database, MS SQL

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

by OTI October 3, 2019

Database, MS SQL

Database Backup & Restore in SQL server

by OTI October 2, 2019

Database, MS SQL

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

by OTI September 30, 2019

Database, MS SQL

SQL Instance Last restart date and time in SQL Server

by Soyeluddin Biswas September 29, 2019

Database, Wordpress

Install WordPress – Step by Step

by OTI September 29, 2019

Database, MS SQL

Database restore history in SQL Server

by Soyeluddin Biswas September 27, 2019

Database, MS SQL

How to create database user on secondary node if DB is in readonly mode in SQL Server?

by Pijush Biswas September 27, 2019

Database, MS SQL

Databases sizes in Bytes, MBs & GBs in SQL Server

by OTI September 25, 2019

More posts!