Página 1 de 2 12 ÚltimoÚltimo
Resultados 1 a 10 de 11
  1. #1
    WHT-BR Top Member
    Data de Ingresso
    Dec 2010
    Posts
    18,556

    [EN] Announcing MS SQL Server on Linux public preview

    Tiffany Wissner
    November 16, 2016

    Today, we are excited to announce the public preview of the next release of SQL Server on Linux and Windows, which brings the power of SQL Server to both Windows – and for the first time ever – Linux. SQL Server enables developers and organizations to build intelligent applications with industry-leading performance and security technologies using their preferred language and environment. With the next release of SQL Server, you can develop applications with SQL Server on Linux, Windows, Docker, or macOS (via Docker) and then deploy to Linux, Windows, or Docker, on-premises or in the cloud.

    We have seen strong reception for the private preview to date with more than 50% of Fortune 500 companies applying for the private preview.

    Easy, Fast, and Efficient

    We have made it easier than ever to get started with SQL Server. You’ll find native Linux installations with familiar RPM and APT packages for Red Hat Enterprise Linux and Ubuntu Linux, and packages for SUSE Linux Enterprise Server will be coming soon as well. The Windows download is available on the Technet Eval Center. Finally, the public preview on Windows and Linux is also available on Azure Virtual Machines (coming soon) and as images available on Docker Hub, offering a quick and easy installation within minutes.

    SQL Server offers tremendous performance. In-Memory OLTP today delivers up to 100x faster reads and 30x faster writes. SQL Server also owns multiple top TPC-E performance benchmarks1 for transaction processing and top TPC-H performance benchmarks2 for data warehousing, as well as top performance benchmarks with leading business applications. We also recently showcased SQL Server running more than one million R predictions per second. With the next release of SQL Server, we are bringing these leading innovations to Linux. On top of this performance, SQL Server also provides incredible efficiency, and removes the need to architect the scale of your application.

    Tooling on Linux

    Today, we have released updated versions of our flagship SQL Server tools including SQL Server Management Studio (SSMS), Visual Studio SQL Server Data Tools (SSDT) and SQL Server PowerShell with support for the next release of SQL Server on Windows and Linux. We are also excited to announce the new SQL Server extension for Visual Studio Code that is available now on the Visual Studio Code marketplace. Developers can use the SQL Server extension for VS Code on macOS/Linux/Windows with SQL Server running anywhere (on-premises, on Linux and Windows, in any cloud, in virtual machines, Docker, SQL Server 2016 or the next release of SQL Server preview) and with Azure SQL Database and Azure SQL DW. Native command-line tools are also available for SQL Server on Linux.

    The new SQL Server Migration Assistant (SSMA) 7.1 release helps you quickly convert Oracle, MySQL, Sybase, and DB2 databases to SQL Server on both Linux and Windows. Download SSMA 7.1 today for Oracle, MySQL, Sybase, DB2, and Access.

    Other improvements in the next version of SQL Server

    The next release of SQL Server brings the power of SQL Server to Linux. In addition, this release includes in-memory, advanced analytics, columnstore, and SQL Server Integration Services (SSIS) enhancements. For more information on what is new with this release, see What’s New in SQL Server.

    Stay tuned for additional capabilities in future previews!

    Get started today

    Try the preview of the next release of SQL Server today! Get started with the preview of SQL Server on Linux, macOS (via Docker) and Windows with our developer tutorials that show you how to install and use SQL Server v.Next on macOS, Docker, Windows, RHEL and Ubuntu and quickly build an app in a programming language of your choice.



    Learn more

    Visit the Connect(); webpage to watch overview, security, high availability, and developer tools videos about SQL Server on Linux on-demand, watch the Microsoft Mechanics video to see how to get started in under one minute, and go to the next release of SQL Server webpage to get started with interactive SQL Server on Linux hands on labs for Linux administrators new to SQL Server and for existing SQL Server database administrators new to Linux, and read detailed documentation. Sign up to stay informed about new SQL Server on Linux developments.

    Stay tuned for additional SQL Server Blog posts in the coming weeks, including SQL Server high availability, security, connectors, and developer tools on Linux!

    1 http://www.tpc.org/tpce/results/tpce...%&currencyID=0

    2 http://www.tpc.org/tpch/results/tpch...ype=noncluster


    https://blogs.technet.microsoft.com/...of-sql-server/

  2. #2
    WHT-BR Top Member
    Data de Ingresso
    Dec 2010
    Posts
    18,556

    PR: Microsoft becomes Linux Foundation Platinum Member

    November 16, 2016

    The Linux Foundation, the nonprofit advancing professional open source management for mass collaboration, today announced that Microsoft has joined the organization at a Platinum member during Microsoft’s Connect(); developer event in New York.

    From cloud computing and networking to gaming, Microsoft has steadily increased its engagement in open source projects and communities. The company is currently a leading open source contributor on GitHub and earlier this year announced several milestones that indicate the scope of its commitment to open source development. The company released the open source .NET Core 1.0; partnered with Canonical to bring Ubuntu to Windows 10; worked with FreeBSD to release an image for Azure; and after acquiring Xamarin, Microsoft open sourced its software development kit. In addition, Microsoft works with companies like Red Hat, SUSE and others to support their solutions in its products.

    "As a cloud platform company we aim to help developers achieve more using the platforms and languages they know,” said Scott Guthrie, Executive Vice President, Microsoft Cloud and Enterprise Group. “The Linux Foundation is home not only to Linux, but many of the community’s most innovative open source projects. We are excited to join The Linux Foundation and partner with the community to help developers capitalize on the shift to intelligent cloud and mobile experiences.”

    Microsoft already contributes to several Linux Foundation projects, including Node.js Foundation, OpenDaylight, Open Container Initiative, R Consortium and Open API Initiative.

    John Gossman, Architect on the Microsoft Azure team, will join The Linux Foundation Board of Directors.

    “Microsoft has grown and matured in its use of and contributions to open source technology,” said Jim Zemlin, Executive Director of The Linux Foundation. “The company has become an enthusiastic supporter of Linux and of open source and a very active member of many important projects. Membership is an important step for Microsoft, but also for the open source community at large, which stands to benefit from the company’s expanding range of contributions.”

    To view a full roster of Linux Foundation members, please visit http://www.linuxfoundation.org/about/members.

    https://www.linuxfoundation.org/anno...ation-platinum

  3. #3
    WHT-BR Top Member
    Data de Ingresso
    Dec 2010
    Posts
    18,556

    SQL 2 x 0 5ms

    Estou usando VM ScaleWay para testar a instalação.

    1. A primeira tinha 4GB RAM mas o MS SQL não instala na Debian Wheezy.

    2. A segunda tinha 2GB RAM e Debian Jessie -> This machine must have at least 3.25 gigabytes of memory to install Microsoft(R) SQL Server(R)

    Tinha reduzido para 2GB porque VMs de 4GB está bem dificil de alocar, levando um tempão até conseguir criar.


  4. #4
    WHT-BR Top Member
    Data de Ingresso
    Dec 2010
    Posts
    18,556
    Tentei até as 19h alocar uma VM com 4GB RAM mas não teve jeito. Aloquei um "dedicado" de 8GB (VM de 8GB está sem estoque) e o MS SQL + Tools instalaram e rodaram OK no DEbian Jessie seguindo as receitas de bolo do Ubuntu 16.04 https://docs.microsoft.com/en-us/sql...x-setup-ubuntu
    Última edição por 5ms; 16-11-2016 às 19:41.

  5. #5
    WHT-BR Top Member
    Data de Ingresso
    Dec 2010
    Posts
    18,556

  6. #6
    WHT-BR Top Member
    Data de Ingresso
    Dec 2010
    Posts
    18,556

    off-topic

    Alguns comentários:

    1. A versão utilizada do Debian na ScaleWay foi "SID" (aka "unstable"). O pacote MS SQL requer bibliotecas mais atualizadas do que versões incluidas na versão estável do Debian, caracteristicamente e intencionalmente sempre bastante defasada de outras distribuições Linux. Como a versão do MS SQL é "preview" utilizar a versão instável do Debian não é problema, pois ambas não deveriam ser utilizados em produção, mas essa defasagem proposital do Debian vai pegar porque só é adequada para o marasmo Linux. O procedimento da MS para instalação é para as distribuições Ubuntu e Red Hat, ambas suportadas por empresas comerciais.

    2. É bom lembrar que ScaleWay é inadequada para rodar banco de dados porque o armazenamento local é volátil. Os conteúdos dos discos virtuais locais são (opcionalmente) copiados para armazenamento permanente quando o "bare metal" é suspenso (STOP) -- o mesmo com instâncias. Não sei se pode ser contornado utilizando SAN da Online.net porque a ScaleWay utiliza conta de usuário distinta e tem toda a questão de segurança da rede privada e coisa e tal. Além do mais, fazer um carnaval com SAN para suportar um processador fracote é dificil justificar, ainda mais com os preços baixos de servidores dedicados disponiveis por aí -- no minimo seria o caso de contratar a mariola equivalente da Online.net que custa barato e vem com 1 HDD 1TB.

    3. Um problema adicional de rodar banco de dados na ScaleWay é que o mecanismo de proteção via "log" utilizado em alguns SGBDs é prejudicado em caso de pane/danos. Por exemplo, no caso do MS SQL é possivel recuperar rapidamente e integralmente o banco de dados utilizando o último backup e o "log", sendo altamente recomendado que o "log" seja armazenado em dispositivo distinto do banco. Contudo, na ScaleWay, os volumes criados são voláteis e compartilham o mesmo hardware -- qualquer pobrema na rebimboca da parafuseta perde-se o banco e o log. Não bom.

    4. Por último, ontem "redescobri" uma deficiência injusticável na ScaleWay: permitir criar uma instância sem ter recurso disponivel para iniciá-la. Esse tipo de anomalia era comum nos desencapados C1 e persiste nos desencapados C2 e nas VMs. Certamente ter uma instância suspensa (com STOP) e não conseguir iniciá-la quando necessário é muito pior, mas ser cobrado por uma nova instância que não tem possibilidade de inicio imediato revela um sistema que opera praticamente sem reserva de capacidade e aparentemente sem controle automático do nivel de utilização. Sabe lá quando, caridosamente, a ScaleWay mudou o status para indisponivel, efetivamente impedindo criar novas instâncias, mas quem tinha criado antes (meu caso) ficou tentando alocar recursos sem haver disponibilidade, a mesma situação dos desafortunados que tentaram reiniciar VMs suspensas. Não bom.
    Última edição por 5ms; 17-11-2016 às 09:17.

  7. #7
    WHT-BR Top Member
    Data de Ingresso
    Dec 2010
    Posts
    18,556

    Microsoft: SQL Server for Linux is the real deal

    Now available in a public preview, SQL Server for Linux aims to be full-featured like the Windows edition and a robust, long-term choice for enterprises

    Serdar Yegulalp
    Nov 17, 2016

    Those who wondered what it would be like to run Microsoft SQL Server on Linux now have an answer. Microsoft has released the first public preview of the long-promised product.

    Microsoft also wants to make clear this isn’t a “SQL Server Lite” for those satisfied with a reduced feature set. Microsoft has a four-point plan to make this happen.

    First is through broad support for all major enterprise-grade Linux editions: Red Hat Enterprise Linux, Ubuntu Linux, and soon Suse Linux Enterprise Server. “Support” means behaving like other Linux applications on the distributions, not requiring a Microsoft-only methodology for installing or running the app. An introductory video depicts SQL Server installed on RHEL through the system’s yum package manager, and a white paper describes launching SQL Server’s services via systemd.

    Second, Microsoft promises the full set of SQL Server 2016’s features for Linux users—not only support for the T-SQL command set, but high-end items like in-memory OLTP, always-on encryption, and row-level security. It will be a first-class citizen on Linux, as SQL Server has been on Windows itself.

    Third is Linux support for the tooling around SQL Server—not SQL Server Management Studio alone, but also the Migration Assistant for relocating workloads to Linux systems and the sqlps PowerShell module. This last item is in line with a possibility introduced when PowerShell was initially open-sourced: Once ported to Linux, it would become part of the support structure for other big-name Microsoft applications as they, too, showed up on the OS. That’s now happening.

    By bringing SQL Server to Linux, Microsoft can compete more directly with Oracle, which has long provided its product on Linux. Oracle may be blunting the effects of the strategy by shifting customers toward a cloud-based service model, but any gains are likely to be hard-won.

    The other, immediate benefit is to provide Microsoft customers with more places to run SQL Server. Enterprises have historically run mixes of Linux and Windows systems, and SQL Server on Linux will let them shave the costs of running some infrastructure.

    Most of all, Microsoft is striving to prove a Microsoft shop can lose little, and preferably nothing, by making a switch—and a new shop eyeing SQL Server has fewer reasons to opt for a competing database that’s Linux-first.

    http://www.infoworld.com/article/314...real-deal.html

  8. #8
    WHT-BR Top Member
    Data de Ingresso
    Dec 2010
    Posts
    18,556

    Ubuntu

    Como não poderia deixar de ser no mundo da boca livre, a versão 16 vem com uma "inovação" que pode ser catastrófica: supostamente desde a versão 15 os reempacotadores do alheio trocaram eth0 por eno1. Deve existir uma razão importantissima, beneficios incalculáveis, um marco histórico da humanidade. Use eth0 e nem KVMoIP poderá salvá-lo da reinstalação.

  9. #9
    WHT-BR Top Member
    Data de Ingresso
    Dec 2010
    Posts
    18,556
    "eno1 is the onboard Ethernet (wired) adapter."

  10. #10
    WHT-BR Top Member
    Data de Ingresso
    Dec 2010
    Posts
    18,556

    10%

    Debian 8, sem aplicações.

    Código:
    Benchmark Run: Fri Nov 25 2016 19:10:35 - 19:31:16
    8 CPUs in system; running 1 parallel copy of tests
    
    Dhrystone 2 using register variables       13058792.8 lps   (10.0 s, 7 samples)
    Double-Precision Whetstone                     2166.6 MWIPS (10.0 s, 7 samples)
    Execl Throughput                               2101.4 lps   (30.0 s, 2 samples)
    Pipe Throughput                             1045743.3 lps   (10.0 s, 7 samples)
    Pipe-based Context Switching                  95965.0 lps   (10.0 s, 7 samples)
    Process Creation                               4146.6 lps   (30.0 s, 2 samples)
    Shell Scripts (1 concurrent)                   4716.0 lpm   (60.0 s, 2 samples)
    Shell Scripts (8 concurrent)                   2342.7 lpm   (60.0 s, 2 samples)
    System Call Overhead                        2052262.8 lps   (10.0 s, 7 samples)
    
    System Benchmarks Partial Index              BASELINE       RESULT    INDEX
    Dhrystone 2 using register variables         116700.0   13058792.8   1119.0
    Double-Precision Whetstone                       55.0       2166.6    393.9
    Execl Throughput                                 43.0       2101.4    488.7
    Pipe Throughput                               12440.0    1045743.3    840.6
    Pipe-based Context Switching                   4000.0      95965.0    239.9
    Process Creation                                126.0       4146.6    329.1
    Shell Scripts (1 concurrent)                     42.4       4716.0   1112.3
    Shell Scripts (8 concurrent)                      6.0       2342.7   3904.5
    System Call Overhead                          15000.0    2052262.8   1368.2
                                                                       ========
    System Benchmarks Index Score (Partial Only)                          760.4

    Código:
    Benchmark Run: Fri Nov 25 2016 19:31:16 - 19:51:57
    8 CPUs in system; running 8 parallel copies of tests
    
    Dhrystone 2 using register variables      104421499.2 lps   (10.0 s, 7 samples)
    Double-Precision Whetstone                    17325.9 MWIPS (10.0 s, 7 samples)
    Execl Throughput                              12320.0 lps   (29.9 s, 2 samples)
    Pipe Throughput                             8351937.6 lps   (10.0 s, 7 samples)
    Pipe-based Context Switching                1289572.2 lps   (10.0 s, 7 samples)
    Process Creation                              29084.1 lps   (30.0 s, 2 samples)
    Shell Scripts (1 concurrent)                  24060.7 lpm   (60.0 s, 2 samples)
    Shell Scripts (8 concurrent)                   3246.3 lpm   (60.1 s, 2 samples)
    System Call Overhead                        5952759.8 lps   (10.0 s, 7 samples)
    
    System Benchmarks Partial Index              BASELINE       RESULT    INDEX
    Dhrystone 2 using register variables         116700.0  104421499.2   8947.9
    Double-Precision Whetstone                       55.0      17325.9   3150.2
    Execl Throughput                                 43.0      12320.0   2865.1
    Pipe Throughput                               12440.0    8351937.6   6713.8
    Pipe-based Context Switching                   4000.0    1289572.2   3223.9
    Process Creation                                126.0      29084.1   2308.3
    Shell Scripts (1 concurrent)                     42.4      24060.7   5674.7
    Shell Scripts (8 concurrent)                      6.0       3246.3   5410.5
    System Call Overhead                          15000.0    5952759.8   3968.5
                                                                       ========
    System Benchmarks Index Score (Partial Only)                         4289.5

    Ubuntu 16, carga zero, aplicações: ipset, iptables, lighttpd, dnsmasq, dns auth, Microsoft sqlserver


    Código:
    Benchmark Run: Tue Dec 06 2016 15:13:35 - 15:34:23
    8 CPUs in system; running 1 parallel copy of tests
    
    Dhrystone 2 using register variables       12032014.8 lps   (10.0 s, 7 samples)
    Double-Precision Whetstone                     2093.6 MWIPS (10.0 s, 7 samples)
    Execl Throughput                               1697.0 lps   (29.9 s, 2 samples)
    Pipe Throughput                              917604.7 lps   (10.0 s, 7 samples)
    Pipe-based Context Switching                  55666.5 lps   (10.0 s, 7 samples)
    Process Creation                               4081.1 lps   (30.0 s, 2 samples)
    Shell Scripts (1 concurrent)                   4434.0 lpm   (60.0 s, 2 samples)
    Shell Scripts (8 concurrent)                   2119.3 lpm   (60.0 s, 2 samples)
    System Call Overhead                        1654190.8 lps   (10.0 s, 7 samples)
    
    System Benchmarks Partial Index              BASELINE       RESULT    INDEX
    Dhrystone 2 using register variables         116700.0   12032014.8   1031.0
    Double-Precision Whetstone                       55.0       2093.6    380.7
    Execl Throughput                                 43.0       1697.0    394.6
    Pipe Throughput                               12440.0     917604.7    737.6
    Pipe-based Context Switching                   4000.0      55666.5    139.2
    Process Creation                                126.0       4081.1    323.9
    Shell Scripts (1 concurrent)                     42.4       4434.0   1045.8
    Shell Scripts (8 concurrent)                      6.0       2119.3   3532.1
    System Call Overhead                          15000.0    1654190.8   1102.8
                                                                       ========
    System Benchmarks Index Score (Partial Only)                          650.9
    Código:
    Benchmark Run: Tue Dec 06 2016 15:34:23 - 15:55:12
    8 CPUs in system; running 8 parallel copies of tests
    
    Dhrystone 2 using register variables       93851392.5 lps   (10.0 s, 7 samples)
    Double-Precision Whetstone                    16740.2 MWIPS (10.0 s, 7 samples)
    Execl Throughput                              10339.3 lps   (29.9 s, 2 samples)
    Pipe Throughput                             7326582.8 lps   (10.0 s, 7 samples)
    Pipe-based Context Switching                 655031.8 lps   (10.0 s, 7 samples)
    Process Creation                              33126.5 lps   (30.0 s, 2 samples)
    Shell Scripts (1 concurrent)                  22856.6 lpm   (60.0 s, 2 samples)
    Shell Scripts (8 concurrent)                   2988.1 lpm   (60.1 s, 2 samples)
    System Call Overhead                        5768053.7 lps   (10.0 s, 7 samples)
    
    System Benchmarks Partial Index              BASELINE       RESULT    INDEX
    Dhrystone 2 using register variables         116700.0   93851392.5   8042.1
    Double-Precision Whetstone                       55.0      16740.2   3043.7
    Execl Throughput                                 43.0      10339.3   2404.5
    Pipe Throughput                               12440.0    7326582.8   5889.5
    Pipe-based Context Switching                   4000.0     655031.8   1637.6
    Process Creation                                126.0      33126.5   2629.1
    Shell Scripts (1 concurrent)                     42.4      22856.6   5390.7
    Shell Scripts (8 concurrent)                      6.0       2988.1   4980.2
    System Call Overhead                          15000.0    5768053.7   3845.4
                                                                       ========
    System Benchmarks Index Score (Partial Only)                         3770.6

Permissões de Postagem

  • Você não pode iniciar novos tópicos
  • Você não pode enviar respostas
  • Você não pode enviar anexos
  • Você não pode editar suas mensagens
  •