A note on Window 10 Operating System

It is somewhat confusing when it comes to operating system for Windows 10.

If you go by this link on msdn, you will see that Windows 10 oprating systems version number is 10 and for Windows 8.1 version 6.3. Here is a partial screen shot:

OS_Version

When you look at settings of your Computer on Windows 10 you would see this:

OS_Version2

You get Windows 10 as the Operating System when you use Windows Command or PowerShell command gwmi win32_operatingsystem.

Recently I installed SQL Server 2014 (x64) Developer Edition on Windows 10 (the same lap top).
I queried for the version of SQL Server 2014 using the query:

Select @@version

To my great surprise, I got the below response (Operating system highlighted):

Microsoft SQL Server 2014 - 12.0.2269.0 (X64)
 Jun 10 2015 03:35:45
 Copyright (c) Microsoft Corporation
 Developer Edition (64-bit) on Windows NT 6.3 <X64> (Build 10586: ) (Hypervisor)

The Operating System for Windows System is still reported as Windows NT 6.3 <x64> (Build 10586). This means the SQL Server is assuming to be running on a Windows 8.1 Computer OS.

Searching PowerShell scripts with Script Browser - A good productivity tool

If you install Script Browser from here, searching for PowerShell scripts, several thousands of them from TechNet Script Center becomes a lot easier. You do not have to Google or Bing. What is more it opens up within the scripting environment. You can mark the script you want as favorite and download them. All though Windows 10 is not in the supported OS list, it still works.

Bundled with it you can also try the pilot version of Script Analyzer

Version Details:

PowerShellScriptBrowser00

If you install and still do not find it in the ISE do the following:

1. Start Windows PowerShell with the "Run as administrator" option.
2. Run this command:
Set-ExecutionPolicy -ExecutionPolicy RemoteSigned
You can refer to about_Execution_Policies

When installed you should be able to see the Script Browser in your Windows PowerShell ISE as shown:

You search TechNet resources as shown here (search key NuGet and language PowerShell):

Get yourself PowerShell 5.0 February 2015 Preview

PowerShell 5.0 February preview is available to download from here:
http://www.microsoft.com/en-us/download/details.aspx?id=45883

 February 2015 includes the following:

• Updates to Windows PowerShell,
• Windows PowerShell Desired State Configuration (DSC)
• Windows PowerShell ISE

Plus new CMDLETS

• OneGet
• PowerShellGet
• Network Switch

Supported OSs:

• Windows Server 2012 R2
• Windows 8.1 Pro
• Windows 8.1 Enterprise
• Windows Server 2012

February 2015 preview updates the November 2014 preview with a few more new features detailed
here (only two of them stable):

• Develop DSC resources with classes in Windows PowerShell - Stable
• Remove DSC documents delivered to a system - Stable
• Support for inheritance with classes in Windows PowerShell - Experimental
• DSC resource script debugging - Experimental
• Support for new RefreshMode - Experimental
• Partial configurations support mixed RefreshModes - Experimental
• PSScriptAnalyzer: static code analysis of  Windows PowerShell artifacts - Experimental

Details to appear on my other blog:
http://hodentekMSSS.blogspot.com