Quick & dirty php serilaization

 class MYENC {
  private $STRESC = [ '"' => """, "'" => "'", '&' => "&", '>' => ">", '<' => "<", ];
  function STRENC($s) { 
   if (is_null($s)) return "N";
   $opc = 'P'; $rv = [];
   foreach (str_split($s) as $c) {
    $n = ord($c);
    if ($n <= 0x20 || $n > 126 || $n == ord('\\')) array_push($rv, sprintf(strtoupper("&#%x;"), $n));
    elseif (array_key_exists($c, $this->STRESC))  array_push($rv, $this->STRESC[$c]); 
    else array_push($rv, $c);
   }
   return join('',$rv);
  }
  function STRDEC($s) {
   if (is_null($s)) return $s;
   preg_match_all("/[&][^;]*;/", $s, $m, PREG_OFFSET_CAPTURE); 
   if (count($m) <= 0) return $s;
   $p = $m[0];
   if (count($p) <= 0) return $s;
   $ESC = array_flip($this->STRESC);
   for ($i = count($p)-1; $i >= 0; $i--) {
    $rep = ''; $x = $p[$i];
    if (array_key_exists($x[0], $ESC)) $rep = $ESC[$x[0]];
    else if (preg_match("/^[&][#]([0-9A-F]+);/i", $x[0], $h) > 0) $rep = chr(hexdec($h[1]));
    $s = substr_replace($s, $rep, $x[1], strlen($x[0]));
   }
   return $s;
  }
  private $CONTROL = [ "N" => [ 'arg' => 0, 'func' => '_N'],
              "A" => [ 'opc' => 'A', 'arg' => 0, 'func' => '_A'],
              "C" => [ 'opc' => 'C', 'arg' => 0, 'func' => '_C'],
              "P" => [ 'opc' => 'P', 'arg' => 1, 'func' => '_P'],
              "=" => [ 'opc' => '=', 'arg' => 0, 'func' => '_EQ'],
              "#" => [ 'opc' => '#', 'arg' => 0, 'func' => '_HASH'],
              "i" => [ 'opc' => 'i', 'arg' => 0, 'func' => '_INT'],
              "b" => [ 'opc' => 'b', 'arg' => 0, 'func' => '_BOOL'],
              "f" => [ 'opc' => 'f', 'arg' => 0, 'func' => '_FLOAT'],
  ];
  function __construct() { }
  private function    _N(&$S,$v) { array_push($S, NULL); }
  private function    _A(&$S,$v) { array_push($S, []); }
  private function    _C(&$S,$v) { array_push($S, new stdClass); }
  private function    _P(&$S,$v) { array_push($S, $v); }
  private function   _EQ(&$S,$v) { $v = array_pop($S); $f = array_pop($S); $C = array_pop($S); $C->$f = $v; array_push($S, $C); }
  private function _HASH(&$S,$v) { $v = array_pop($S); $f = array_pop($S); $A = array_pop($S); $A[$f] = $v; array_push($S, $A); }
  private function  _INT(&$S,$v) { $v = array_pop($S); array_push($S, intVal($v)); }
  private function _BOOL(&$S,$v) { $v = array_pop($S); array_push($S, !!intVal($v)); }
  private function _FLOAT(&$S,$v) { $v = array_pop($S); if ($v == 'NAN') $v = NAN; elseif ($v == 'INF') $v = INF; else $v = floatVal($v); array_push($S, $v); }
  private function NEXTOPC($P, $_off, &$opr, &$v) {
   $opr = NULL; $v = NULL;
   $idx = $_off;
   $CTL = $this->CONTROL;
   if ($idx < 0 || $idx >= strlen($P)) return 0;
   $op = $P[$idx];
   $idx++;
   if (!array_key_exists($op, $CTL)) return 0;
   $opr = $CTL[$op];
   if ($opr['arg'] == 0) return $idx - $_off;
   if (preg_match("/([0-9]+)[.]/", $P, $m, PREG_OFFSET_CAPTURE, $idx) <= 0) return 0;
   $k = $m[1];
   $idx += strlen($k[0]) + 1;
   $len = intVal($k[0]);
   if ($idx+$len > strlen($P)) return 0;
   $v = substr($P, $idx, $len);
   $idx += $len;
   return $idx - $_off;
  }
  function DECODE($P) {
   $STACK = []; $off = 0;
   for (;;) {
    $i = $this->NEXTOPC($P, $off, $opr, $v);
    if ($i <= 0) break;
    $off += $i;
    $func = $opr['func'];
    $this->$func($STACK, $v);
    #print "OPC " . $opr['opc'] . "\$i=${i} \$off=${off}\n";
   }
   return array_pop($STACK);
  }
  private function EMIT(&$K, ... $s) { $K .= join('', $s); }
  private function EMITS(&$K, ... $params) {
   foreach ($params as $s) {
    if (is_null($s)) { $this->EMIT($K, "N"); return; }
    $post = '';
    if (is_float($s)) {
     $post = 'f';
     if (is_nan($s)) $s = 'NAN'; elseif (is_infinite($s)) $s = 'INF'; else $s = sprintf("%.17e", $s);
    }
    elseif (is_int($s)) $post = 'i';
    elseif (is_bool($s)) $post = 'b';

    $this->EMIT($K, "P", strlen($s), ".", $s, $post);
   }
  }
  private function ENC(&$K, $X) {
   if (is_array($X)) {
    $this->EMIT($K, "A");
    foreach ($X as $k => $v) {
     if (is_array($v)) { $this->EMITS($K, $k); $this->ENC($K, $v); continue; }
     if (is_object($v)) { $this->EMITS($K, $k); $this->ENC($K, $v); continue; }
     $this->EMITS($K, $k, $v);
     $this->EMIT($K, "#");
    }
    return;
   }
   if (is_object($X)) {
    $this->EMIT($K, "C");
    foreach (get_object_vars ($X) as $k => $v) {
     if (is_array($v)) { $this->EMITS($K, $k); $this->ENC($K, $v); continue; }
     if (is_object($v)) { $this->EMITS($K, $k); $this->ENC($K, $v); continue; }
     $this->EMITS($K, $k, $v);
     $this->EMIT($K, "=");
    }
    return;
   }
   $this->EMITS($K,$X);
  }
  function ENCODE($X) { $K = ''; $this->ENC($K, $X); return $K; }
 }

http://onlinephpfunctions.com/

http://onlinephpfunctions.com/

Virtual Entities

https://docs.microsoft.com/en-us/dynamics365/customer-engagement/developer/virtual-entities/custom-ve-data-providers

https://docs.microsoft.com/en-us/dynamics365/customer-engagement/developer/virtual-entities/sample-generic-ve-plugin

Download tools from NuGet

12/06/2017

• 2 minutes to read
• Contributors
   

Applies to Dynamics 365 (online), version 9.x

You can download tools used in development from NuGet using the powershell script found below. These tools include:

Tool	NuGet Package
Code generation tool CrmSvcUtil.exe	Microsoft.CrmSdk.CoreTools
Configuration Migration tool DataMigrationUtility.exe	Microsoft.CrmSdk.XrmTooling.ConfigurationMigration.Wpf
Package Deployer PackageDeployer.exe	Microsoft.CrmSdk.XrmTooling.PackageDeployment.WPF
Plug-in Registration Tool PluginRegistration.exe	Microsoft.CrmSdk.XrmTooling.PluginRegistrationTool
SolutionPackager tool SolutionPackager.exe	Microsoft.CrmSdk.CoreTools

Download tools using PowerShell

1. In your Windows Start menu, type Windows Powershell and open it.
2. Navigate to the folder you want to install the tools to. For example if you want to install them in a devtools folder on your D drive, type cd D:\devtools.
3. Copy and paste the following PowerShell script into the PowerShell window and press Enter.
   PowerShell

   $sourceNugetExe = "https://dist.nuget.org/win-x86-commandline/latest/nuget.exe"
   $targetNugetExe = ".\nuget.exe"
   Remove-Item .\Tools -Force -Recurse -ErrorAction Ignore
   Invoke-WebRequest $sourceNugetExe -OutFile $targetNugetExe
   Set-Alias nuget $targetNugetExe -Scope Global -Verbose
   
   ##
   ##Download Plugin Registration Tool
   ##
   ./nuget install Microsoft.CrmSdk.XrmTooling.PluginRegistrationTool -O .\Tools
   md .\Tools\PluginRegistration
   $prtFolder = Get-ChildItem ./Tools | Where-Object {$_.Name -match 'Microsoft.CrmSdk.XrmTooling.PluginRegistrationTool.'}
   move .\Tools\$prtFolder\tools\*.* .\Tools\PluginRegistration
   Remove-Item .\Tools\$prtFolder -Force -Recurse
   
   ##
   ##Download CoreTools
   ##
   ./nuget install  Microsoft.CrmSdk.CoreTools -O .\Tools
   md .\Tools\CoreTools
   $coreToolsFolder = Get-ChildItem ./Tools | Where-Object {$_.Name -match 'Microsoft.CrmSdk.CoreTools.'}
   move .\Tools\$coreToolsFolder\content\bin\coretools\*.* .\Tools\CoreTools
   Remove-Item .\Tools\$coreToolsFolder -Force -Recurse
   
   ##
   ##Download Configuration Migration
   ##
   ./nuget install  Microsoft.CrmSdk.XrmTooling.ConfigurationMigration.Wpf -O .\Tools
   md .\Tools\ConfigurationMigration
   $configMigFolder = Get-ChildItem ./Tools | Where-Object {$_.Name -match 'Microsoft.CrmSdk.XrmTooling.ConfigurationMigration.Wpf.'}
   move .\Tools\$configMigFolder\tools\*.* .\Tools\ConfigurationMigration
   Remove-Item .\Tools\$configMigFolder -Force -Recurse
   
   ##
   ##Download Package Deployer 
   ##
   ./nuget install  Microsoft.CrmSdk.XrmTooling.PackageDeployment.WPF -O .\Tools
   md .\Tools\PackageDeployment
   $pdFolder = Get-ChildItem ./Tools | Where-Object {$_.Name -match 'Microsoft.CrmSdk.XrmTooling.PackageDeployment.Wpf.'}
   move .\Tools\$pdFolder\tools\*.* .\Tools\PackageDeployment
   Remove-Item .\Tools\$pdFolder -Force -Recurse
   
   ##
   ##Remove NuGet.exe
   ##
   Remove-Item nuget.exe    
   

4. You will find the tools in the following folders:

• [Your folder]\Tools\ConfigurationMigration
• [Your folder]\Tools\CoreTools
• [Your folder]\Tools\PackageDeployment
• [Your folder]\Tools\PluginRegistration

To get the latest version of these tools, repeat these steps.

Revert git change

git stash save --keep-index
git stash drop

---

Accounts

Customers

---

Html Diamond - HTML code

<!DOCTYPE html>
<!-- https://www.sitepoint.com/community/t/diamond-with-text-centered/35376/3 -->
<html lang="en">
<head>
<meta charset="UTF-8">
<meta name="description" content="">
<meta name="keywords" content="">
<meta name="robots" content="">
<meta name="viewport" content="width=device-width, initial-scale=1, maximum-scale=1" />


<!--css-->
<link rel="stylesheet" href="css/master.css" />
<style type="text/css">
    * {
        padding: 0;
        font: 16px Helvetica, sans-serif;
    }

    .diamond {
        margin: 50px;
        width: 100px;
        height: 100px;
        background: red;
        transform: rotate(45deg);
        -ms-transform: rotate(45deg);
        -webkit-transform: rotate(45deg);
        border-radius:15px;
    }

    .diamond-inner {
        margin: 50px;
        color: #fff;
        font-weight: bold;
        font-size: 1.2em;
        line-height: 1.4em;
        text-align: center;
        transform: rotate(-45deg);
        -ms-transform: rotate(-45deg);
        -webkit-transform: rotate(-45deg);
        width:100px;
        height: 100px;
        display: table-cell;
        vertical-align: middle;
        text-align: center;
        border-radius:15px;
    }

</style>

<!--[if lt IE 9]>
         <script src="//html5shiv.googlecode.com/svn/trunk/html5.js"></script>
    <![endif]-->

<title>Title of the document</title>
</head>
<body>
    <div class="diamond">
        <div class="diamond-inner"> Business Starter </div>
    </div>
</body>
</html>

Connect to SQL Server with Windows Authentication in a different domain - Database Administrators Stack Exchange

Connect to SQL Server with Windows Authentication in a different domain - Database Administrators Stack Exchange:

runas /netonly /user:domain\username "C:\path_to\ssms.exe""

Enable/Disable Network interface via command line - Microsoft Community

Enable/Disable Network interface via command line - Microsoft Community:
"netsh interface set interface name="Local Area Connection" admin=disabled"

'via Blog this'
Get NIC list and index number:

wmic nic get name, index

Enable NIC with index number: (eg: 7)
wmic path win32_networkadapter where index=7 call enable

Disable NIC with index number: (eg: 7)
wmic path win32_networkadapter where index=7 call disable

netsh interface set interface name="Local Area Connection" admin=disabled

External Authentication Services with ASP.NET Web API (C#) | The ASP.NET Site

External Authentication Services with ASP.NET Web API (C#) | The ASP.NET Site:

'via Blog this'

Yacc/Lex Tools v0.2

http://ecianciotta-en.abriom.com/2013/08/yacclex-tools-v02.html

Generate Bitmap containing Centered Text

using System;

using System.Collections.Generic;

using System.Linq;

using System.Text;

using System.Threading.Tasks;

namespace ConsoleApplication14

{

    class Program

    {

        static void Main(string[] args)

        {

            string txt = "HELLO";

            System.Drawing.Bitmap bmp = new System.Drawing.Bitmap(131, 50);

            System.Drawing.Graphics g = System.Drawing.Graphics.FromImage(bmp);

            g.Clear(System.Drawing.Color.DarkGreen);

            System.Drawing.Font f = new System.Drawing.Font("Courier", 25, System.Drawing.FontStyle.Bold);

            System.Drawing.SizeF szf = new System.Drawing.SizeF();

            szf = g.MeasureString(txt, f);

            int xoff = (int)((bmp.Width - szf.Width) / 2);

            g.DrawString(txt, f, System.Drawing.Brushes.Red, new System.Drawing.Rectangle(/*x*/xoff, /*y*/0, bmp.Width, bmp.Height));

            bmp.Save("c:/temp/xxx.bmp");

        }

    }

}

C# Formax XML

     // Load the XmlDocument with the XML.
     document.LoadXml(fp.FetchXml);

     writer.Formatting = System.Xml.Formatting.Indented;

     // Write the XML into a formatting XmlTextWriter
     document.WriteContentTo(writer);
     writer.Flush();
     mStream.Flush();

     // Have to rewind the MemoryStream in order to read
     // its contents.
     mStream.Position = 0;

     // Read MemoryStream contents into a StreamReader.
     System.IO.StreamReader sReader = new System.IO.StreamReader(mStream);

     // Extract the text from the StreamReader.
     String FormattedXML = sReader.ReadToEnd();

     string[] Result = FormattedXML.Replace("\r", "").Split(new char[] { '\n'});
     foreach (string s in Result)
        Consolw.WriteLine("{0}", s);

Serialize CRM Object

namespace ConsoleApplication6
{
    class Program
    {
        static void Main(string[] args)
        {
            Microsoft.Xrm.Sdk.Entity E = new Microsoft.Xrm.Sdk.Entity("entity");
            System.Runtime.Serialization.DataContractSerializer Sz =
                new System.Runtime.Serialization.DataContractSerializer(typeof(Microsoft.Xrm.Sdk.Entity));
            StringBuilder sb = new StringBuilder();
            System.IO.MemoryStream ms = new System.IO.MemoryStream();
            Sz.WriteObject(ms, E);
            string str = Encoding.ASCII.GetString(ms.ToArray());
        }
    }
}

JavaScript - Change URI port

var foo = document.createElement("a");
//foo.href = "http://www.example.com:8080/demo/";
foo.href = document.location.href;
foo.port = 8000;
document.location.href = foo.location.href ;

//var newURL = foo.href;
//console.log(newURL); // output: http://www.example.com:8000/demo/

Operator Precedence Parsing

'via Blog this'

Sample: Use duplicate detection when creating and updating records

Sample: Use duplicate detection when creating and updating records: "reate.Parameters.Add"

'via Blog this'

JavaScript - CRM format

function pad(num, size) {
    var s = num + "";
    while (s.length < size) s = "0" + s;
    return s;
}
function formatDateForCRM(date) {
 var delta = (date.getHours() * 60 + date.getMinutes()) - (date.getUTCHours() * 60 + date.getUTCMinutes());
 var deltaS = "+";
 if (delta < 0) { deltaS = "-"; delta = 0 - delta; }
 var deltaM = (delta % 60);
 var deltaH = (delta - deltaM) / 60;
 var DateFilter = "datetime\'";
 DateFilter += pad(date.getUTCFullYear(), 4) + "-";
 DateFilter += pad(date.getUTCMonth() + 1, 2) + "-";
 DateFilter += pad(date.getUTCDate(), 2);
 DateFilter += "T";
 DateFilter += pad(date.getUTCHours(), 2) + ":";
 DateFilter += pad(date.getUTCMinutes(), 2) + ":";
 DateFilter += pad(date.getUTCSeconds(), 2);
 DateFilter += deltaS + pad(deltaH, 2) + ":" + pad(deltaM, 2);
 return DateFilter;
}

var X = new Date();
var S = formatDateForCRM(X);
print(S);

Disable Phone Number Detection in Internet Explorer 11

Disable Phone Number Detection in Internet Explorer 11:

'via Blog this'

Microsoft Support Lifecycle

https://support.microsoft.com/en-us/lifecycle/search/default.aspx?sort=PN&alpha=sql%20server&Filter=FilterNO

Products Released	Lifecycle Start Date	Mainstream Support End Date	Extended Support End Date	Service Pack Support End Date	Notes
Microsoft SQL Server 2000 64-bit Edition	11/30/2000	4/8/2008	4/9/2013	7/11/2002
Microsoft SQL Server 2000 Desktop Engine	11/30/2000	4/8/2008	4/9/2013
Microsoft SQL Server 2000 Desktop Engine Release A	1/29/2003	4/8/2008	4/9/2013
Microsoft SQL Server 2000 Developer Edition	11/30/2000	4/8/2008	4/9/2013	7/11/2002
Microsoft SQL Server 2000 Enterprise Edition	11/30/2000	4/8/2008	4/9/2013	7/11/2002
Microsoft SQL Server 2000 Reporting Services Service Pack 1	9/22/2004	Not Applicable	Not Applicable	7/11/2006
Microsoft SQL Server 2000 Reporting Services Service Pack 2	4/22/2005	Review Note	Review Note		Support ends 12 months after the next service pack releases or at the end of the product's support lifecycle, whichever comes first. For more information, please see the service pack policy athttp://support.microsoft.com/lifecycle/#ServicePackSupport.
Microsoft SQL Server 2000 Service Pack 1	6/12/2001	Not Applicable	Not Applicable	2/28/2002
Microsoft SQL Server 2000 Service Pack 2	11/30/2001	Not Applicable	Not Applicable	4/7/2003
Microsoft SQL Server 2000 Service Pack 3a	1/7/2003	Not Applicable	Not Applicable	7/10/2007
Microsoft SQL Server 2000 Service Pack 4	5/6/2005	Review Note	Review Note		Support ends 12 months after the next service pack releases or at the end of the product's support lifecycle, whichever comes first. For more information, please see the service pack policy athttp://support.microsoft.com/lifecycle/#ServicePackSupport.
Microsoft SQL Server 2000 Standard Edition	11/30/2000	4/8/2008	4/9/2013	7/11/2002
Microsoft SQL Server 2000 Windows CE Edition 2.0	12/16/2002	1/8/2008	1/8/2013
Microsoft SQL Server 2000 Workgroup Edition	6/1/2005	4/8/2008	4/9/2013
Microsoft SQL Server 2005 Compact Edition	2/19/2007	4/12/2011	4/12/2016	7/10/2007
Microsoft SQL Server 2005 Developer Edition	1/14/2006	4/12/2011	4/12/2016	7/10/2007
Microsoft SQL Server 2005 Enterprise Edition	1/14/2006	4/12/2011	4/12/2016	7/10/2007
Microsoft SQL Server 2005 Enterprise Edition for Itanium-based Systems	1/14/2006	4/12/2011	4/12/2016	7/10/2007
Microsoft SQL Server 2005 Enterprise X64 Edition	1/14/2006	4/12/2011	4/12/2016	7/10/2007
Microsoft SQL Server 2005 Express Edition	6/1/2006	4/12/2011	4/12/2016	7/10/2007
Microsoft SQL Server 2005 Express Edition with Advanced Services	7/16/2006	4/12/2011	4/12/2016	7/10/2007
Microsoft SQL Server 2005 for Embedded Systems	1/14/2006	4/12/2011	4/12/2016	7/10/2007
Microsoft SQL Server 2005 Service Pack 1	4/18/2006	Not Applicable	Not Applicable	4/8/2008
Microsoft SQL Server 2005 Service Pack 2	2/19/2007	Not Applicable	Not Applicable	1/12/2010
Microsoft SQL Server 2005 Service Pack 3	12/15/2008	Not Applicable	Not Applicable	1/10/2012
Microsoft SQL Server 2005 Service Pack 4	12/13/2010	Review Note	Review Note		Support ends 12 months after the next service pack releases or at the end of the product's support lifecycle, whichever comes first. For more information, please see the service pack policy athttp://support.microsoft.com/lifecycle/#ServicePackSupport.
Microsoft SQL Server 2005 Standard Edition	1/14/2006	4/12/2011	4/12/2016	7/10/2007
Microsoft SQL Server 2005 Standard Edition for Itanium-based Systems	1/14/2006	4/12/2011	4/12/2016	7/10/2007
Microsoft SQL Server 2005 Standard X64 Edition	1/14/2006	4/12/2011	4/12/2016	7/10/2007
Microsoft SQL Server 2005 Workgroup Edition	1/14/2006	4/12/2011	4/12/2016	7/10/2007
Microsoft SQL Server 2008 Developer	11/6/2008	7/8/2014	7/9/2019	4/13/2010
Microsoft SQL Server 2008 Enterprise	11/7/2008	7/8/2014	7/9/2019	4/13/2010
Microsoft SQL Server 2008 Express	11/11/2008	7/8/2014	7/9/2019	4/13/2010
Microsoft SQL Server 2008 Express with Advanced Services	11/22/2008	7/8/2014	7/9/2019	4/13/2010
Microsoft SQL Server 2008 R2 Datacenter	7/20/2010	7/8/2014	7/9/2019	7/10/2012
Microsoft SQL Server 2008 R2 Developer	7/20/2010	7/8/2014	7/9/2019	7/10/2012
Microsoft SQL Server 2008 R2 Enterprise	7/20/2010	7/8/2014	7/9/2019	7/10/2012
Microsoft SQL Server 2008 R2 Express	7/20/2010	7/8/2014	7/9/2019	7/10/2012
Microsoft SQL Server 2008 R2 Express with Advanced Services	7/20/2010	7/8/2014	7/9/2019	7/10/2012
Microsoft SQL Server 2008 R2 for Embedded Systems	7/20/2010	7/8/2014	7/9/2019	7/10/2012
Microsoft SQL Server 2008 R2 Parallel Data Warehouse	11/9/2010	7/8/2014	7/9/2019		Hardware products will receive 5 years of support following Microsoft’s end of sales date for the Major Product version. Minor Product releases follow the Support Lifecycle of their respective Major Product versions.
Microsoft SQL Server 2008 R2 Service Pack 1	7/12/2011	Not Applicable	Not Applicable	10/8/2013
Microsoft SQL Server 2008 R2 Service Pack 2	7/26/2012	Not Applicable	Not Applicable	10/13/2015
Microsoft SQL Server 2008 R2 Service Pack 3	9/26/2014	Review Note	Review Note		Support ends 12 months after the next service pack releases or at the end of the product's support lifecycle, whichever comes first. For more information, please see the service pack policy athttp://support.microsoft.com/lifecycle/#ServicePackSupport.
Microsoft SQL Server 2008 R2 Standard	7/20/2010	7/8/2014	7/9/2019	7/10/2012
Microsoft SQL Server 2008 R2 Standard Edition for Small Business	7/20/2010	7/8/2014	7/9/2019	7/10/2012
Microsoft SQL Server 2008 R2 Web	7/20/2010	7/8/2014	7/9/2019	7/10/2012
Microsoft SQL Server 2008 R2 Workgroup	7/20/2010	7/8/2014	7/9/2019	7/10/2012
Microsoft SQL Server 2008 Service Pack 1	3/31/2009	Not Applicable	Not Applicable	10/11/2011
Microsoft SQL Server 2008 Service Pack 2	9/24/2010	Not Applicable	Not Applicable	10/9/2012
Microsoft SQL Server 2008 Service Pack 3	10/6/2011	Not Applicable	Not Applicable	10/13/2015
Microsoft SQL Server 2008 Service Pack 4	9/30/2014	Review Note	Review Note		Support ends 12 months after the next service pack releases or at the end of the product's support lifecycle, whichever comes first. For more information, please see the service pack policy athttp://support.microsoft.com/lifecycle/#ServicePackSupport.
Microsoft SQL Server 2008 Standard	11/6/2008	7/8/2014	7/9/2019	4/13/2010
Microsoft SQL Server 2008 Standard Edition for Small Business	11/6/2008	7/8/2014	7/9/2019	4/13/2010
Microsoft SQL Server 2008 Web	11/6/2008	7/8/2014	7/9/2019	4/13/2010
Microsoft SQL Server 2008 Workgroup	11/6/2008	7/8/2014	7/9/2019	4/13/2010
Microsoft SQL Server 2012 Business Intelligence	5/20/2012	7/11/2017	7/12/2022	1/14/2014
Microsoft SQL Server 2012 Developer	5/20/2012	7/11/2017	7/12/2022	1/14/2014
Microsoft SQL Server 2012 Enterprise	5/20/2012	7/11/2017	7/12/2022	1/14/2014
Microsoft SQL Server 2012 Express	5/20/2012	7/11/2017	7/12/2022	1/14/2014
Microsoft SQL Server 2012 for Embedded Systems	5/20/2012	7/11/2017	7/12/2022	1/14/2014
Microsoft SQL Server 2012 Parallel Data Warehouse	7/12/2013	10/9/2018	Review Note		SQL 2012 PDW appliance hardware and the server software configured and running on the appliance hardware shall receive five years of support from General Availability of SQL Server Parallel Data Warehouse 2012.
Microsoft SQL Server 2012 Service Pack 1	11/7/2012	Not Applicable	Not Applicable	7/14/2015
Microsoft SQL Server 2012 Service Pack 2	6/10/2014	Review Note	Review Note		Support ends 12 months after the next service pack releases or at the end of the product's support lifecycle, whichever comes first. For more information, please see the service pack policy athttp://support.microsoft.com/lifecycle/#ServicePackSupport.
Microsoft SQL Server 2012 Standard	5/20/2012	7/11/2017	7/12/2022	1/14/2014	Support ends 12 months after the next service pack releases or at the end of the product's support lifecycle, whichever comes first. For more information, please see the service pack policy athttp://support.microsoft.com/lifecycle/#ServicePackSupport.
Microsoft SQL Server 2012 Web	5/20/2012	7/11/2017	7/12/2022	1/14/2014
Microsoft SQL Server 2014 Business Intelligence	6/5/2014	7/9/2019	7/9/2024	7/12/2016
Microsoft SQL Server 2014 Developer	6/5/2014	7/9/2019	7/9/2024	7/12/2016
Microsoft SQL Server 2014 Enterprise	6/5/2014	7/9/2019	7/9/2024	7/12/2016
Microsoft SQL Server 2014 Enterprise Core	6/5/2014	7/9/2019	7/9/2024	7/12/2016
Microsoft SQL Server 2014 Express	6/5/2014	7/9/2019	7/9/2024	7/12/2016
Microsoft SQL Server 2014 Service Pack 1	4/14/2015	Review Note	Review Note		Support ends 12 months after the next service pack releases or at the end of the product's support lifecycle, whichever comes first. For more information, please see the service pack policy athttp://support.microsoft.com/lifecycle/#ServicePackSupport.
Microsoft SQL Server 2014 Standard	6/5/2014	7/9/2019	7/9/2024	7/12/2016
Microsoft SQL Server 2014 Web	6/5/2014	7/9/2019	7/9/2024	7/12/2016
Microsoft SQL Server 4.2 for OS/2	Not Available	7/1/1999	Not Applicable
Microsoft SQL Server 6.0 Standard Edition	Not Available	3/31/1999	Not Applicable
Microsoft SQL Server 6.5 Enterprise Edition	3/1/1998	3/31/2004	Not Applicable
Microsoft SQL Server 6.5 Service Pack 1	12/31/1998	Not Applicable	Not Applicable	1/1/2002
Microsoft SQL Server 6.5 Service Pack 2	9/15/2000	Not Applicable	Not Applicable
Microsoft SQL Server 6.5 Service Pack 3	1/15/2000	Not Applicable	Not Applicable
Microsoft SQL Server 6.5 Service Pack 4	Not Available	Not Applicable	Not Applicable	3/24/1999
Microsoft SQL Server 6.5 Service Pack 5a	12/24/1998	Not Applicable	Not Applicable	3/31/2004
Microsoft SQL Server 6.5 Standard Edition	6/30/1996	1/1/2002	Not Applicable
Microsoft SQL Server 7.0 Enterprise Edition	3/1/1999	12/31/2005	1/11/2011
Microsoft SQL Server 7.0 Service Pack 1	5/25/1999	Not Applicable	Not Applicable	3/31/2004
Microsoft SQL Server 7.0 Service Pack 2	3/20/2000	Not Applicable	Not Applicable
Microsoft SQL Server 7.0 Service Pack 3	Not Available	Not Applicable	Not Applicable	7/26/2002
Microsoft SQL Server 7.0 Service Pack 4	4/26/2002	Review Note	Review Note		Support ends 12 months after the next service pack releases or at the end of the product's support lifecycle, whichever comes first. For more information, please see the service pack policy athttp://support.microsoft.com/lifecycle/#ServicePackSupport.
Microsoft SQL Server 7.0 Standard Edition	3/1/1999	12/31/2005	1/11/2011
Microsoft SQL Server Compact 3.5	2/19/2008	4/9/2013	4/10/2018	10/13/2009
Microsoft SQL Server Compact 3.5 Service Pack 1 for Windows Mobile	8/11/2008	Not Applicable	Not Applicable	7/12/2011
Microsoft SQL Server Compact 3.5 Service Pack 2	6/29/2010	Review Note	Review Note		Support ends 12 months after the next service pack releases or at the end of the product's support lifecycle, whichever comes first. For more information, please see the service pack policy athttp://support.microsoft.com/lifecycle/#ServicePackSupport.
Microsoft SQL Server Compact 4.0	4/13/2011	7/12/2016	7/13/2021
Microsoft SQL Server Notification Services 2.0 Enterprise Edition	11/26/2002	1/8/2008	1/8/2013
Microsoft SQL Server Notification Services 2.0 Standard Edition	11/26/2002	1/8/2008	1/8/2013
SQL Server 2012 Enterprise Core	5/20/2012	7/11/2017	7/12/2022