By Chris J. GavilanesRead moreTweetShareWith more than 50 years of experience, CTO and co-founder of the consultancy CTO, Chris J Gavilianes, now at Microsoft Research, says SQL Server has become the backbone of modern computing.
“I don’t think anyone could have predicted it was that simple,” says Gavilandanes, who joined Microsoft in 2013 and is the author of SQL Server Management Studio (SSMS).
“We have a very big database system that has a lot of features, but it doesn’t have a great UI.
We didn’t understand how to set up this big system to interact with a database.
I think we just went in with a little naive optimism and hoped for the best.”
With the recent release of the SQL Server 2017 software update, Microsoft has added features such as the ability to import CSV and XML files from SQL Server into C# and Visual Basic.
Gavilandias’ own research, however, has shown that the toolset is not sufficient to create an effective database.
As a result, the team has developed an advanced SQL Server management toolkit.
Its purpose is to provide developers with an easy way to create databases and manage SQL Server instances.
This is in contrast to the traditional SQL Server tools like the DBMS Toolkit, which focuses on providing a more intuitive, graphical experience to developers.
For this reason, Gavillais has created an extension to SSMS called SQL Server Enterprise Edition, which offers developers a toolkit for creating database instances.SSMS allows users to set the schema, which is used to define the data in the database.
The toolkit provides a number of options to define schema options, such as column names, fields, and tables.
However, the real power comes when users can create SQL Server database instances, such that the database instances are able to run on top of each other, and to query the database from any application.
A database instance can be created by opening an SSMS window and choosing the database to be created.
When an instance is created, the windows icon is placed in the upper right corner of the window.
Once the window is open, users can then choose the type of database to use, which will then be determined by the type-of-database option.
The following window will be shown to the right of the instances type of Database.
Click the icon next to the DB name, and you will see a window that looks like this.
Now, to use a database instance, the user has to select the database type from the list of available databases.
If the database instance is not listed, click the Edit button and choose a database type.
Alternatively, users may click on the icon of the database, select a database name, type of table, or a name for the table.
Next, the instance will be created, and the window will show that an instance exists, with a text box that reads, “You can now use the database.”
This text box tells the database owner how to access the database using the SQL PowerShell cmdlets.
In this example, the owner of the instance is running SQL Server as an administrator.
You can then perform any of the functions provided by the database such as create, update, delete, and query.
All of the queries are made from within the SQL cmdlets, such is the case for queries to the table called User, which was created by using the New-Table cmdlet.
Finally, if you want to remove a query from the database or set a default query, the administrator can right-click on the instance and select Delete.
Users can also delete the instance from the server by selecting the Delete button, and then selecting Delete from the context menu.
Lastly, users will be able to create tables, add fields, create indexes, and insert data into the database without having to write SQL scripts.
These functions are also accessible from within SSMS.
SSMS is an extension of the SSMS Framework, which has been in place since the release of SQL 2008, allowing developers to create SQL server instances in SQL Server and add them to SQL Server databases.
SSMS provides additional features that enable SQL Server administrators to add database instances to existing SQL Server environments and to create and manage database instances on Azure SQL Database.SSM is now available on Azure, SQL Server, and SQL Azure.
Microsoft is planning to launch a preview version of SSMS on Azure in the first half of 2019, which can be used to test the functionality and to gather feedback on the toolkit before it is released as an Azure-only offering.
On the other hand, there is a separate preview version on Azure that has been made available for SQL Server 2016.
To learn more about SSMS, see the following links: