Skip to main content

SQL Server Tools - Microsoft Recommended Tools

Graphic User Interface (GUI-based Tools)

SQL Server Management Studio (SSMS)

SQL Server Management Studio - SSMS
SSMS

SSMS is Free!! SQL Server Management Studio (SSMS) is an integrated environment for managing any SQL infrastructure, from SQL Server to Azure SQL Database. SSMS provides tools to configure, monitor, and administer instances of SQL Server and databases. Use SSMS to deploy, monitor, and upgrade the data-tier components used by your applications, and build queries and scripts. Use SSMS to query, design and manage your databases and data warehouses, wherever they are - on your local computer, or in the cloud.

SSMS - Prerequisites for Installation:

SSMS supports the following 64-bit platforms when used with the latest available service pack:

Supported Operating Systems:
  • Windows 10 (64-bit) version 1607 (10.0.14393) or later
  • Windows 8.1 (64-bit)
  • Windows Server 2019 (64-bit)
  • Windows Server 2016 (64-bit)
  • Windows Server 2012 R2 (64-bit)
  • Windows Server 2012 (64-bit)
  • Windows Server 2008 R2 (64-bit)
Supported hardware:
  • 1.8 GHz or faster processor. Dual-core or better recommended.
  • 2 GB of RAM; 4 GB of RAM recommended. (2.5 GB minimum if running on a virtual machine)
  • Hard disk space: Minimum of 2 GB up to 10 GB of available space.

SSMS - Latest Release Download:


Version Details:
Release number: 18.6
Build number: 15.0.18338.0
Release date: July 22, 2020

Previous Five Releases:

Version Details:
Release number: 18.5.1
Build number: 15.0.18333.0
Release date: June 09, 2020

Version Details:
Release number: 18.5
Build number: 15.0.18330.0
Release date: April 07, 2020

Version Details:
Release number: 18.4
Build number: 15.0.18206.0
Release date: November 04, 2019

Version Details:
Release number: 18.3.1
Build number: 15.0.18183.0
Release date: October 02, 2019

Version Details:
Release number: 18.2
Build number: 15.0.18142.0
Release date: July 25, 2019

Azure Data Studio

Azure Data Studio
Azure Data Studio 

A light-weight editor that can run on-demand SQL queries, view and save results as text, JSON, or Excel. Edit data, organize your favorite database connections, and browse database objects in a familiar object browsing experience. Azure Data Studio runs on Windows, macOS, and Linux.








Download and install the latest release:

Platform: Windows
Release date: August 12, 2020
Version: 1.21.0

Platform: macOS
Release date: August 12, 2020
Version: 1.21.0
Download: .zip

Platform: Linux
Release date: August 12, 2020
Version: 1.21.0
Download: .deb / .rpm / .tar.gz

Supported Operating Systems:
Azure Data Studio runs on Windows, macOS, and Linux, and is supported on the following platforms:

Windows
  • Windows 10 (64-bit)
  • Windows 8.1 (64-bit)
  • Windows 8 (64-bit)
  • Windows 7 (SP1)
  • Windows Server 2019
  • Windows Server 2016
  • Windows Server 2012 R2 (64-bit)
  • Windows Server 2012 (64-bit)
  • Windows Server 2008 R2 (64-bit)

macOS
  • macOS 10.15 Catalina
  • macOS 10.14 Mojave
  • macOS 10.13 High Sierra
  • macOS 10.12 Sierra

Linux
  • Red Hat Enterprise Linux 7.4
  • Red Hat Enterprise Linux 7.3
  • SUSE Linux Enterprise Server v12 SP2
  • Ubuntu 16.04
Recommended System Requirements:

CPU Cores: 4 (Recommended) / 2 (Minimum)
Memory/RAM: 8 GB (Recommended) / 4 GB (Minimum)

SQL Server Data Tools (SSDT)

SQL Server Data Tools (SSDT)

SSDT

SSDT is a modern development tool for building SQL Server relational databases, databases in Azure SQL, Analysis Services (AS) data models, Integration Services (IS) packages, and Reporting Services (RS) reports. With SSDT, you can design and deploy any SQL Server content type with the same ease as you would develop an application in Visual Studio.



SSDT - Prerequisites for Installation:

Supported Operating Systems:
  • Windows 10 version 1507 or higher: Home, Professional, Education, and Enterprise (LTSC and S are not supported)
  • Windows Server 2016: Standard and Datacenter
  • Windows 8.1 (with Update 2919355): Core, Professional, and Enterprise
  • Windows Server 2012 R2 (with Update 2919355): Essentials, Standard, Datacenter
  • Windows 7 SP1 (with latest Windows Updates): Home Premium, Professional, Enterprise, Ultimate
Supported hardware:
  • 1.8 GHz or faster processor. Dual-core or better recommended.
  • 2 GB of RAM; 4 GB of RAM recommended. (2.5 GB minimum if running on a virtual machine)
  • Hard disk space: up to 130 GB of available space, depending on features installed; typical installations require 20-50 GB of free space.
  • Hard disk speed: to improve performance, install Windows and Visual Studio on a solid state drive (SSD).
  • Video card that supports a minimum display resolution of 720p (1280 by 720); Visual Studio will work best at a resolution of WXGA (1366 by 768) or higher.
Install SSDT with Visual Studio 2019

SSDT for Visual Studio 2019

If Visual Studio 2019 is already installed, you can edit the list of workloads to include SSDT. If you don’t have Visual Studio 2019 installed, then you can download and install Visual Studio 2019 Community.
  • For SQL Database projects, select SQL Server Data Tools under Data storage and processing in the list of workloads.
Data storage and processing workload
SSDT for Visual Studio 2017

Install SSDT with Visual Studio 2017

To install SSDT during Visual Studio installation, select the Data storage and processing workload, and then select SQL Server Data Tools.

If Visual Studio is already installed, you can edit the list of workloads to include SSDT.

Data storage and processing workload

Install Analysis Services, Integration Services, and Reporting Services tools

To install Analysis Services, Integration Services, and Reporting Services project support, run the SSDT standalone installer.

The installer lists available Visual Studio instances to add SSDT tools. If Visual Studio isn't already installed, selecting Install a new SQL Server Data Tools instance installs SSDT with a minimal version of Visual Studio, but for the best experience, we recommend using SSDT with the latest version of Visual Studio.

Select AS, IS, RS

SSDT for VS 2017 (standalone installer):


Command-line tools

The tools below are the main command-line tools.

1. bcp - The bulk copy program utility (bcp) bulk copies data between an instance of Microsoft SQL Server and a data file in a user-specified format. The bcp utility can be used to import large numbers of new rows into SQL Server tables or to export data out of tables into data files. Except when used with the queryout option, the utility requires no knowledge of Transact-SQL. To import data into a table, you must either use a format file created for that table or understand the structure of the table and the types of data that are valid for its columns.

Following link to download:

Version Information:
Release number: 15.0
Build number: 15.0.1300.359
Release date: March 13, 2019
Platform: Windows, macOS, Linux
Command to check the present version: bcp /v

NOTE: The command-line tools are General Availability (GA), however they're being released with the installer package for SQL Server 2019 (15.x).

System Requirements
Windows 10, Windows 7, Windows 8, Windows 8.1, Windows Server 2008, Windows Server 2008 R2, Windows Server 2008 R2 SP1, Windows Server 2012, Windows Server 2012 R2, Windows Server 2016, Windows Server 2019.


2. sqlcmd - utility lets you enter Transact-SQL statements, system procedures, and script files at the command prompt.

Following link to download:

Version Information:
Release number: 15.0
Build number: 15.0.1300.359
Release date: March 13, 2019
Platform: Windows, macOS, Linux
Command to check the present version: sqlcmd -?

System Requirements
Windows 10 , Windows 7, Windows 8, Windows 8.1, Windows Server 2008 - 2019.
Labels:

Popular posts from this blog

What is SQL Server?

SQL Server SQL Server is a relational database management system (RDBMS) developed by Microsoft. SQL Server supports a wide variety of transaction processing, business intelligence and analytics applications in corporate IT environments. SQL Server supports ANSI SQL, which is the standard SQL (Structured Query Language) language. However, SQL Server comes with its own implementation of the SQL language, T-SQL. Why SQL Server? Microsoft SQL Server is a comprehensive database server and information platform offering a complete set of enterprise-ready technologies and tools that help people derive the most value from information at the lowest total-cost-of-ownership. Enjoy high levels of performance, availability, and security; employ more productive management and development tools; and deliver pervasive insight with self-service business intelligence (BI). A complete and integrated platform, Microsoft SQL Server brings it all together to get more value out of existing IT skills and asse
Read more

Download SQL Server Management Studio (SSMS)

Summary:  In this post, you will learn &  able to download  SSMS. About  SQL Server Management Studio ( SSMS ):  SSMS is Free!! SQL Server Management Studio (SSMS) is an integrated environment for managing any SQL infrastructure, from SQL Server to Azure SQL Database. SSMS provides tools to configure, monitor, and administer instances of SQL Server and databases. Use SSMS to deploy, monitor, and upgrade the data-tier components used by your applications, and build queries and scripts. Use SSMS to query, design and manage your databases and data warehouses, wherever they are - on your local computer, or in the cloud.   SSMS -  Prerequisites for Installation: SSMS supports the following 64-bit platforms when used with the latest available service pack: Supported Operating Systems: Windows 10 (64-bit) version 1607 (10.0.14393) or later Windows 8.1 (64-bit) Windows Server 2019 (64-bit) Windows Server 2016 (64-bit) Windows Server 2012 R2 (64-bit) Windows Server 2012 (64-bit) Windows Ser
Read more

Mastering Common Table Expression or CTE in SQL Server

WITH common_table_expression (Transact-SQL) Summary:  From this post you will learn about Common Table Expression or   CTE  in SQL Server using the with Clause.  About  CTE  Statement:  Specifies a temporary named result set, known as a common table expression (CTE). This is derived from a simple query and defined within the execution scope of a single SELECT , INSERT , UPDATE , DELETE or MERGE statement. A common table expression can include references to itself. This is referred to as a recursive common table expression.  Syntax: [ WITH <common_table_expression> [ ,...n ] ]   <common_table_expression>::=       expression_name [ ( column_name [ ,...n ] ) ]       AS       ( CTE_query_definition )   Arguments expression_name Is a valid identifier for the common table expression. expression_name must be different from the name of any other common table expression defined in the same WITH <common_table_expression> clause, but expression_name can be the same as the name
Read more