Shrink MS SQL transaction log file in the SQL Server database. Find out the best way to know how to shrink SQL transaction log along with checking the size of the log file.

This topic describes how to rename SQL Server database using SQL Server Management Studio(GUI), Transact-SQL(command line) and detach/attach method

This article shows the steps to create a Full database backup in SQL Server using both SQL Server Management Studio and Transact-SQL.

This article describes how to delete SQL Server database from command line and SSMS and know how to drop SQL Server database snapshot

Know how to view the SQL Server Error Log File Location using Transact-SQL, SQL Server Configuration Manager and Windows Application Event Viewer

Know easy methods to enable and disable SQL Server indexes using SQL server management studio and Transact-SQL command

SQL Server Error 26  shows client unable to establish connection. In this article you will know how to fix SQL Network Interfaces Error 26

How to Fix Microsoft SQL Server Error 983 AlwaysOn Availability Groups Failover issue? Find out the best way to troubleshoot this 983 database error.

Learn the secure way to prevent SQL injection in SQL Server database as well as view transactional logs with highly reliable and robust method.

The updated new T-SQL features in SQL Server 2016 elaborates you how the SQL Server enhanced with its powerful T-SQL features.

Dynamic data masking in SQL Server allows user to limit the sensitive data by masking it to unauthorized users. Read this article to know more about it.

Know what are the new features in SQL Server Management Studio for SQL Server 2016 to enhance its performance and servie

Take a look on SQL server profiler usage and know how to configure a trace to monitor database activities.

This blog describes end of life for Microsoft SQL Server 2005 support with its associated security risks and know its no longer version solutions.

Step by step method to install SQL Server 2016 and know what are the pre-requisites before installing SQL Server 2016

SQL Server on Linux has been out for a bit now and I've played around a little (see here) but haven't really used it in "anger" nor will I for the foreseeable future if I'm honest. Nevertheless it's an area that I find very interesting as I know very little when it comes to the…

A simple guide to know how to Clear SQL Server Transaction Log with DBCC SHRINKFILE and Truncate_only command or by using Management Studio