Friday, January 17, 2020

PowerShell cmdlets version that works with (compatible) SQL Server 2019

PowerShell is in continuous development mode. New challenges require updating of software to accommodate the changes. This is the nature of such things. PowerShell cmdlets also follow this natural course and we have many versions.

I had an older version, and when I tried to launch contextually from SSMS v 8.4, I got this response:

In order to get the version you want, you may access this link:

SQL Server with PowerShell

Here is a list from the above site:

Scripting Options in SQL Server Management Studio v 18.4

The Scripting options can be accessed from Tools: Options in the SQL Server Management Studio v18.4.

In the Options window drill-down on SQL Server Object Explorer | Scripting as shown.

 Expand the node, General scripting options to display the following:

 Expand the node, Object scripting options to display the following:

 Expand the node, Table and view options to display the following:

 Expand the node, Version options to display the following:

In each version of SSMS, the Options window is slightly different or arranged differently.

Wednesday, January 15, 2020

Get head start in Basic SQL at PCATT

A new session is going to start soon. Sign-up here.

Microsoft SQL Azure Database: SQL Server in Microsoft Cloud
Windows PowerShell for SQL Server

My sincere thanks and best wishes to my students in the previous meets of this course.

Monday, January 13, 2020

What is XEvent Profiler in SQL Server Management Studio (SSMS) 2019?

XEvent Profier's role in SSMS is for troubleshooting SQL Server Issues such as slow running queries, identify long-running queries, monitor SQL statements, etc. From Version SQL Server 7.0, SQL Profiler was used, but it was not easy to use due to the lack of a GUI.

SQL Profiler was replaced by XEvent Profiler which is easy to use and presents a quick view of Extended Events.
XEvents is a feature of SSMS and not SQL Server and it was available in SSMS V17.3.

It is also available in SSMS V18.4 which is the latest version of SSMS as of now. You can find in the Object Explorer (bottom-most node)  of SSMS as shown here.

Wednesday, January 23, 2019

SQL Server 2017 Performance Benchmarks

TPC is an acronym for Transaction Processing Corporation, a non-profit organization to define transaction processing benchmarks and providing objective, verifiable performance data to the industry.

Here is the scope of TPC from its website (

"The term transaction is often applied to a wide variety of business and computer functions. Looked at as a computer function, a transaction could refer to a set of operations including disk read/writes, operating system calls, or some form of data transfer from one subsystem to another.
While TPC benchmarks certainly involve the measurement and evaluation of computer functions and operations, the TPC regards a transaction as it is commonly understood in the business world: a commercial exchange of goods, services, or money. A typical transaction, as defined by the TPC, would include the updating to a database system for such things as inventory control (goods), airline reservations (services), or banking (money).
In these environments, a number of customers or service representatives input and manage their transactions via a terminal or desktop computer connected to a database. Typically, the TPC produces benchmarks that measure transaction processing (TP) and database (DB) performance in terms of how many transactions a given system and database can perform per unit of time, e.g., transactions per second or transactions per minute"

Here is what SQL Server 2017 performance looks like.

Monday, December 31, 2018

Happy New Year 2019

Wishing you all a Happy New Year 2019.

Thank you for reading my blog. See you in 2019

Thursday, November 15, 2018

Get the November update of PowerBI Desktop

You can easily download PowerBI Desktop from Microsoft Store and launch it within minutes.

If you never had PowerBI, you may need to fill up this form.

 You have two options.
 This comes up first but you can ignore it. It has lots of good information and links to videos if you are new.

Here is the working screen of the app.

 You can get the version number from here using About.

This is the November version.

New feature list from Microsoft Site:

Here is a video summarizing features:

PowerShell cmdlets version that works with (compatible) SQL Server 2019

PowerShell is in continuous development mode. New challenges require updating of software to accommodate the changes. This is the nature of...