Windows way to Digital Learning……

sql-on-linux

Now Microsoft SQL Server supports on Linux platforms.

I have tested on Redhat, CentOS and Oracle Linux.

Here we will see step by step guide to install SQL server on Linux.

Supported platforms

Platform

Supported version(s)

Get

Red Hat Enterprise Linux

7.3

Get RHEL 7.3

SUSE Linux Enterprise Server

v12 SP2

Get SLES v12 SP2

Ubuntu

16.04 and 16.10

Get Ubuntu 16.04

Docker Engine

1.8+

Get Docker

Prerequisites

  • You need at least 3.25 GB of memory to run SQL Server on Linux.

 

Install SQL Server

  • Login to root user using putty.

su - root

  • We will download and install SQL server repositories by using following commands.

# curl https://packages.microsoft.com/config/rhel/7/mssql-server.repo
> /etc/yum.repos.d/mssql-server.repo

# curl https://packages.microsoft.com/config/rhel/7/prod.repo
> /etc/yum.repos.d/msprod.repo

 

sql-on-linux_curl

  • Verify .repo files under /etc/yum.repos.d/ directory

sql-on-linux_repos

  • To install SQL Server and MSSQL Tools package, run the following commands
# yum install -y mssql-server mssql-tools

sql-on-linux_1

sql-on-linux_2

sql-on-linux_3

  • Run the configuration script to accept license terms and set SA password
# cd /opt/mssql/bin/
# sudo ./mssql-config setup

 

sql-on-linux_4

  • To verify the mssql-server service is running
# systemctl status mssql-server

sql-on-linux_5

  • To open tcp-1433 port on system firewall in order to allow external clients to communicate with the database server.
# firewall-cmd --add-port=1433/tcp --permanent
# firewall-cmd --reload

 

sql-on-linux_6

  • Testing SQL Server
# cd /opt/mssql-tool/bin/
# ./sqlcmd -S srv01 -U SA

 

 

Upgrade SQL Server

  • To upgrade the mssql-server package on Linux, execute the following command
# yum update mssql-server

Uninstall SQL Server

  • To uninstall or remove the mssql-server package on Linux, execute the following command

# yum remove mssql-server  
(Remove or delete mssql-server package)

# rm -rf /var/opt/mssql/
(Remove or delete database files)

Windows Backup Error: Detailed error: ERROR – A Volume Shadow Copy Service operation error has occurred: (0x800423F0)

vss_error1

Resolution:

In an elevated open powershell: vssadmin list writers

vss_error2

Writer name: ‘FSCVSSWriter’

Writer Id: {68124191-7787-401a-8afa-12d9d7ccc6ee}

Writer Instance Id: {2865b83a-ebb5-4431-8164-a90ff79c59ca}

State: [7] Failed

Last error: Inconsistent shadow copy

Execute Services.msc (To open services windows) and disable or restart Microsoft Forefront Server Protection VSS.

vss_0x800423f0

Restart windows backup, now backup should complete.

How to check the Volume Shadow Copy Service (VSS) provider/writer status.

To check the VSS provider/writer status.
1. Open a command window. Click Start > Run and type CMD, and then click OK.
2. At the command prompt, type vssadmin list providers, and then press ENTER.
3. Confirm that the list shows Microsoft VSS providers listed as:

  • Microsoft Software Shadow Copy provider 1.0
4. Type vssadmin list writers at the command prompt, and then press ENTER.
5. Confirm that all the VSS writers are showing:
  • State: [1] Stable
  • No error

 Microsoft Free E-Books 

Introducing Windows Server 2016

  • Introducing Windows Server 2016
    John McCabe

  • Data Science with Microsoft SQL Server 2016
    Buck Woody, Danielle Dean, Debraj GuhaThakurta, Gagan Bansal, Matt Conners, Wee-Hyong Tok

  • Microsoft Azure Essentials: Fundamentals of Azure, Second Edition
    Michael S. Collier and Robin E. Shahan

  • Configuring Microsoft SharePoint Hybrid Capabilities
    Jeremy Taylor, Neil Hodgkinson, and Manas Biswas

  • Windows 10 IT Pro Essentials Support Secrets
    Ed Bott

  • Introducing Microsoft Power BI
    Alberto Ferrari and Marco Russo

Introducing Microsoft SQL Server 2016: Mission-Critical Applications, Deeper Insights, Hyperscale Cloud, Preview 2

  • Introducing Microsoft SQL Server 2016: Mission-Critical Applications, Deeper Insights, Hyperscale Cloud
    Stacia Varga, Denny Cherry, and Joseph D’Antoni

  • Microsoft Platform and Tools for Mobile App Development
    Cesar de la Torre and Simon Calvert

  • Microsoft Azure Essentials Migrating SQL Server Databases to Azure
    Carl Rabeler

  • Planning and Preparing for Microsoft SharePoint Hybrid
    Jeremy Taylor

  • Windows 10 IT Pro Essentials: Top 10 Tools
    Ed Bott

  • Creating Mobile Apps with Xamarin.Forms
    Charles Petzold

  • Deploying Windows 10: Automating deployment by using System Center Configuration Manager
    Andre Della Monica, Russ Rimmerman, Alessandro Cesarini, and Victor Silveira

  • Introducing Windows 10 for IT Professionals, Technical Overview
    Ed Bott

Free E-Book: Microsoft Press : Enterprise Cloud Strategy

  • Enterprise Cloud Strategy
    Barry Briggs and Eduardo Kassner

Courtesy: Microsoft Press
Find more training eBooks & books at The Microsoft Press Store.

Windows 10 Free Upgrade Available in 190 Countries Today

Microsoft offered as a free upgrade to genuine Windows 7, Windows 8.1 and Windows Phone 8.1 customers.

How to prepare your PC for Windows 10 ?

Windows 10 Upgrade Notification

Windows 10 Upgrade Notification

Windows 10 minimum system hardware requirements:

  • RAM: 1GB for 32-bit / 2GB for 64-bit
  • Storage: 16GB for 32-bit / 20GB for 64-bit
  • CPU: 1GHz or faster
  • Graphics: DirectX 9 capable video card

Most important thing to check is windows updates.

Download Link Here.

Note: 

Make sure first you backup your personal data on OneDrive or locally on your external hard drive.

Windows 10

Windows 10

KB2990170 – MPIO Identifies Different Disks As The Same Disk

 

Symptoms

The code in Microsoft Windows that converts a hexadecimal device ID to an ASCII string may drop the most significant nibble in each byte if the byte is less than 0×10. (The most significant nibble is 0.) This causes different disks to be identified as the same disk by Multipath I/O (MPIO). At the very least, this may cause problems in mounting affected disks. And architecturally, this could cause data corruption.

Resolution

When you apply this hotfix, the conversion algorithm is fixed. Disks that were masked by this issue before you installed the hotfix may be raw disks that still have to be partitioned and formatted for use. After you apply this hotfix, check in Disk Management or Diskpart for previously hidden disks.

A supported hotfix is available from Microsoft Support.

Exchange 2013 SP1 Architecture Poster

Ex2013SP1Architecture

Zoom the poster on Zoomit by Rhoderick Milne.

You can also directly download the Exchange 2013 SP1 poster from the Microsoft Download Center.

Tag Cloud