SSMS18-Preview4

Download SQL Server Management Studio 18.4

SSMS 18.4 is the latest generation of SQL Server Management Studio that has full support for SQL Server 2019 Preview. SSMS 18.4 was released on 04 November 2019 and it’s…

Read more »
SSMS18-Preview4

Download SQL Server Management Studio (SSMS) 18.0 (Preview 6)

SSMS 18.0 (Preview 6) is the latest generation of SQL Server Management Studio that has full support for SQL Server 2019 Preview. SSMS 18.0 (Preview 6) was released on 18…

Read more »

Microsoft SQL Server 2017 Downgrade Rights

Microsoft SQL Server’s licensing model is complex and so is its down grade rights mechanism. Several deployment options are available for customers of SQL Server 2017 to support a variety…

Read more »

Download SQL Server Management Studio 17.6

Microsoft recently released a new version of SQL Server Management Studio called version 17.6. SQL Server Management Studio 17.x is the latest generation of SQL Server Management Studio and provides…

Read more »

STUFF command in SQL Server

This command is used to replace a string with another string within a text. This command can sometimes be a savior. You can see the shape of this command along…

Read more »

dbcopytool – SQL Server Database Copy Tool

dbcopytool is a simple, light weight and easy to use program to copy a sql server database from one server to another by backing it up, copying the backup file…

Read more »
plan-explorer-deadlock

Plan Explorer – a free SQL query analysis and optimization tool

Plan Explorer by SentryOne is a free SQL query analysis and optimization tool that helps you quickly get to the root of the toughest SQL Server query problems. With Plan…

Read more »

How to check if a table exists in SQL Server database

There are several methods to check if a table exists in SQL Server database. Using INFORMATION_SCHEMA.TABLES Query like below can be used to check if a Table exists in the…

Read more »

SQL Server Performance Monitoring Software by AppDynamics

The AppDynamics Database Monitoring product module for Microsoft SQL Server is a comprehensive 24×7 deep-dive tool used to monitor versions 2000, 2005, 2008, 2012 and 2014 of SQL Server instances…

Read more »

Understanding SQL Comparison tool and Operators

Contrasting different operands or factors in view of various conditions is the essential thing which is done in each program we make for deciding uniformity or imbalance between two operands,So…

Read more »