Wednesday, February 28, 2018

You have a new updated mssql-cli, the interactive command-line query tool for SQL Server

The public preview was announced in December last year. Now there is an update.

Read here.

You can download mssql-cli from here:


Using mssql-cli you get to do all this:

    T-SQL IntelliSense
    Syntax highlighting
    Pretty formatting for query results, including Vertical Format
    Multi-line edit mode
    Configuration file support

You can install mssql-cli if you have Python on your computer. For Windows you can install Python from here and make sure it is added to your PATH.

https://www.python.org/downloads/

Saturday, February 17, 2018

Get started with latest release of Microsoft SQL Operations Studio

Read my previous articles (9) on previous versions.

Download the February (latest) release of Microsoft SQL Operations Studio here.

There are couple of enhancements over the previous release. The following has been fixed or added:

Added Auto-Update Installation feature
Added Connection Dialog ‘Database’ Drop-down
Added functionality for new query tabs keeping active connection
Fixed bugs in SQL Editor and auto-completion


This is the version I have now.


When I update, my version is:


When I launched my previous release, I could access the latest. Clicking on this I could install the latest release.


Set up preparatory stage.


I did not see a drop-down of all databases. It did not find the databases. It just reverted to default in the drop-down.


However, it could keep two query windows open at the same time, maintaining two different connections.








Friday, February 2, 2018

Accessing POWER SHELL in Microsoft SQL Operations Studio


You can access the console in Microsoft SQL Operations Studio by clicking this option in the User Interface as shown.


PS_SQLOPS_0.png

This displays the terminal.



PS_SQLOPS_1.png

The following version of Power Shell is supported:


PS_SQLOPS_2.png



SQL Server 2017 Performance Benchmarks

TPC is an acronym for Transaction Processing Corporation , a non-profit organization to define transaction processing benchmarks and prov...