Showing posts with label macOS. Show all posts
Showing posts with label macOS. Show all posts

Thursday, January 18, 2018

Microsoft SQL Operations Studio- January Public Preview is ready

You can downlaod it from here for all of the three platforms, Windows, macOS and Linux.
https://docs.microsoft.com/en-us/sql/sql-operations-studio/download

Before using review the following:

What is SQLOPS?
https://hodentekmsss.blogspot.com/2017/12/light-weight-database-management-and.html

Description of user interface:
https://hodentekmsss.blogspot.com/2017/12/sql-operations-studio-user-interface.html

Connecting to SQL Server 2016 using SQLOPS:
http://hodentekhelp.blogspot.com/2017/12/how-do-you-connect-to-sql-server-using.html

It is very easy to download and run immediately (Windows Installer and ZIP).

Using Installer:
Download and run the SQL Operations Studio (preview) installer for Windows.
Start the SQL Operations Studio (preview) app.
Link to click: https://go.microsoft.com/fwlink/?linkid=866480

Using the ZIP file:
Download SQL Operations Studio (preview) .zip for Windows.
Browse to the downloaded file and extract it.
Run \sqlops-windows\sqlops.exe
Link to click: https://go.microsoft.com/fwlink/?linkid=866479

Supported platforms:
Windows
Windows 10 (64-bit)
Windows 8.1 (64-bit)
Windows 8 (64-bit)
Windows 7 (SP1) (64-bit) - Requires KB2533623
Windows Server 2016
Windows Server 2012 R2 (64-bit)
Windows Server 2012 (64-bit)
Windows Server 2008 R2 (64-bit)
+
macOS
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

Uninstall:
Since it is preview, if you need to uninstall at a later date:
------------------------------------------
If you installed SQL Operations Studio (preview) using the Windows installer, then uninstall the same way you remove any Windows application.

If you installed SQL Operations Studio (preview) with a .zip or other archive, then simply delete the files.
-------------------------------------------
Enjoy!

Sunday, December 3, 2017

Download SQL Server 2017 Developer Edition and test drive


You may download SQL Server 2017 versions from here.

Download link:
https://www.microsoft.com/en-us/sql-server/sql-server-downloads

Three options are available as follows:

Trial (time limited enterprise edition)
Developer
SQL express

 DownlaodSQLServerDev2017_00


DownlaodSQLServerDev2017_01



DownlaodSQLServerDev2017_02



Microsoft describes this product as follows:
Industry-leading performance
Take advantage of breakthrough scalability, performance, and availability for mission-critical, intelligent applications and data warehouses.
Least vulnerable
Enhance security with encryption at rest and in motion. SQL Server is the least vulnerable database over the last 7 years in the NIST vulnerabilities database.
Real-time intelligence
Reason over any data and gain transformative insights for your business with real time analytics at up to 1M predictions/second.
End-to-end mobile BI
Transform data into actionable insights. Deliver insights on any device online or offline at one-fifth the cost of other self-service solutions.
Any application, anywhere
Build modern applications using any data, any language--on-premises and in the cloud, now on Windows, Linux, and Docker containers.

Languages
English, German, Spanish, Japanese, Italian, French, Russian, Chinese Simplified, Chinese Traditional, Portuguese Brazil, Korean
Editions

SQL Server 2017 | 64-bit ISO for Windows
SQL Server 2017 | 64-bit CAB for Windows
Other Distributions:
Windows Container Image on Docker Hub: https://hub.docker.com/r/microsoft/mssql-server-windows/
Linux: SQL Server 2017 on Linux and Windows page.

Tuesday, September 5, 2017

Go here to create apps that work with SQL Server

This is a very useful site that you should acquaint yourself with. You can create apps that work with SQL Server with all of the following:

C#
Java
NodeJS
PHP
Python

on

Windows
macOS
RHEL
UBUNTU
SLES (Suse...)



You need to start at this link:
https://www.microsoft.com/en-us/sql-server/developer-get-started/

Tuesday, July 25, 2017

Generate database object scripts with mulit-platform tool mssql-scripts

In your SSMS on your computer you can use the Generate Scripts drop-down
menu to create scripts for database objects as shown here for Northwind database on SQL Server 2016 SP1.


The above is for SQL Server on Windows Platform. However, mssql-scripts tool provide the same functionality as Generate Scripts wizard on SQL Servers on Linux and macOS. Of course mssql-scripts would work on Windows as well.

Using mssql-scripts based on Python you can generate T-SQL scripts for objects on SQL Servers, Azure SQL database and Azure SQL Data Warehouse. The generated script is saved to a .sql file or on Linux can be piped to standard Unix utilities (sed, awk and grep). The scripts can be checked into source control systems as well.

The source code for mssql-scripter is found here:
https://github.com/Microsoft/sql-xplat-cli

When Identity Security Becomes a Wall — Not a Shield

After a breach that forced a reset of my digital identity, I hit a roadblock I never anticipated: multi-factor authentication (2FA) locked m...