mountainss Cloud and Datacenter Management Blog

Microsoft Hybrid Cloud blogsite about Management


Leave a comment

#Microsoft SQL Server 2019 Preview Overview #SQL #SQL2019 #Linux #Containers #MSIgnite

Microsoft SQL Server 2019 Preview

What’s New in Microsoft SQL Server 2019 Preview

• Big Data Clusters
o Deploy a Big Data cluster with SQL and Spark Linux containers on Kubernetes
o Access your big data from HDFS
o Run Advanced analytics and machine learning with Spark
o Use Spark streaming to data to SQL data pools
o Use Azure Data Studio to run Query books that provide a notebook experience

• Database engine
o UTF-8 support
o Resumable online index create allows index create to resume after interruption
o Clustered columnstore online index build and rebuild
o Always Encrypted with secure enclaves
o Intelligent query processing
o Java language programmability extension
o SQL Graph features
o Database scoped configuration setting for online and resumable DDL operations
o Always On Availability Groups – secondary replica connection redirection
o Data discovery and classification – natively built into SQL Server
o Expanded support for persistent memory devices
o Support for columnstore statistics in DBCC CLONEDATABASE
o New options added to sp_estimate_data_compression_savings
o SQL Server Machine Learning Services failover clusters
o Lightweight query profiling infrastructure enabled by default
o New Polybase connectors
o New sys.dm_db_page_info system function returns page information

• SQL Server on Linux
o Replication support
o Support for the Microsoft Distributed Transaction Coordinator (MSDTC)
o Always On Availability Group on Docker containers with Kubernetes
o OpenLDAP support for third-party AD providers
o Machine Learning on Linux
o New container registry
o New RHEL-based container images
o Memory pressure notification

• Master Data Services
o Silverlight controls replaced

• Security
o Certificate management in SQL Server Configuration Manager

• Tools
o SQL Server Management Studio (SSMS) 18.0 (preview)
o Azure Data Studio

Introducing Microsoft SQL Server 2019 Big Data Clusters

SQL Server 2019 big data clusters make it easier for big data sets to be joined to the dimensional data typically stored in the enterprise relational database, enabling people and apps that use SQL Server to query big data more easily. The value of the big data greatly increases when it is not just in the hands of the data scientists and big data engineers but is also included in reports, dashboards, and applications. At the same time, the data scientists can continue to use big data ecosystem tools while also utilizing easy, real-time access to the high-value data in SQL Server because it is all part of one integrated, complete system.

Read the complete Awesome blogpost from Travis Wright about SQL Server 2019 Big Data Cluster here

Starting in SQL Server 2017 with support for Linux and containers, Microsoft has been on a journey of platform and operating system choice. With SQL Server 2019 preview, we are making it easier to adopt SQL Server in containers by enabling new HA scenarios and adding supported Red Hat Enterprise Linux container images. Today we are happy to announce the availability of SQL Server 2019 preview Linux-based container images on Microsoft Container Registry, Red Hat-Certified Container Images, and the SQL Server operator for Kubernetes, which makes it easy to deploy an Availability Group.

SQL Server 2019 preview containers now available

Microsoft Azure Data Studio

Azure Data Studio is a new cross-platform desktop environment for data professionals using the family of on-premises and cloud data platforms on Windows, MacOS, and Linux. Previously released under the preview name SQL Operations Studio, Azure Data Studio offers a modern editor experience with lightning fast IntelliSense, code snippets, source control integration, and an integrated terminal. It is engineered with the data platform user in mind, with built-in charting of query resultsets and customizable dashboards.

Read the Complete Blogpost About Microsoft Azure Data Studio for SQL Server here

SQL Server 2019: Celebrating 25 years of SQL Server Database Engine and the path forward

Awesome work Microsoft SQL Team and Congrats on your 25th Anniversary !

Advertisements


Leave a comment

Enhancing Microsoft #Security using Artificial Intelligence E-book #AI #Azure #MachineLearning

At the Center of intelligent security management is the concept of working smarter, not harder. However, this is a significant undertaking when you consider the ever-evolving landscape of threats and security challenges, combined with the myriad of devices, apps, and user scenarios. In this e-book, learn how you can intelligently detect, protect, and respond to threats by leveraging the strong integration between Microsoft security solutions and our partners.
Read the full e-book to learn how Microsoft is using artificial intelligence (AI) in security features like:

  • Windows Hello
  • Azure Active Directory
  • Azure Advanced Threat Protection
  • Windows Defender SmartScreen
  • Windows Defender Network Protection
  • Exchange Online Protection and more…

You can download Enhancing Microsoft Security using Artificial Intelligence E-book here


Leave a comment

Impressions of Microsoft #MSTechSummit in Amsterdam 2018 #MVPbuzz

Microsoft Tech Summit 2018 Amsterdam

It’s Really Awesome to Help Microsoft on the #MSTechSummit in Amsterdam for the community doing Q&A on the Microsoft Experts Center Booth and talking with customers on real scenarios about moving to the Microsoft Azure Cloud. Questions like What are the best practices, and what can I do with Microsoft Azure Stack in my own datacenter. Where can I get more information ? Solving problems for the customer by giving them directions where they can find the solution. Supporting customers with the On-Demand LABS and answering the questions they have, It’s just Great to be a Microsoft MVP Cloud and Datacenter Management and support the Community in this way on the Microsoft Tech Summit 2018 in Amsterdam 🙂

Here you see some impressions of the two days Event :

The Entrance in Amsterdam RAI on the Day before the Event

Getting registered as a Speaker on the Day before the MSTechSummit begins.

The Azure Keynote with Tad Brockway

Impressive Virtual Machine on Azure Cloud Services

Supporting the Community on the Experts Booth doing Q&A

And of course you can meet Great Microsoft employees from Redmond 🙂

On the Picture with Seth Juarez He Likes Machine Learning and AI
and of course working on CH9
 

And on the Picture with Jeff Woolsey from the Microsoft Server Team.
Install Project Honolulu for Remote Management 😉

And YES you can do Clustering on Microsoft Azure !
Have a look at Robert Smit his Blog Site

Meeting MVP mate from Austria Toni Pohl
He is developing cloud solutions with Office365 and Azure

The HUB

A full House for the Break-Out Session Azure Stack with Natalia Mackevicius

She is Director PM Azure Stack

Community Center and Experts Booth
Join the Microsoft Tech Community Today
#MVPbuzz

Microsoft LABS on Demand are Ready to Rock !

Thank you Microsoft and Community for this Awesome Event !
Microsoft Tech Summit 2018 Amsterdam


Leave a comment

#RedShirtAMS Wednesday 24th of May 2017 with @scottgu in Amsterdam #DevOps #Developers #Azure #AzureStack

 

Experience the newest technologies in Microsoft Azure by joining Scott Guthrie for sessions on how you can do more on the intelligent cloud. Scott will present a deep dive into Microsoft’s cloud services, advanced workloads and capabilities. He’ll do several demonstrations first-hand to show how these solutions can enable you to achieve more using the best of the Linux ecosystem and the best of the Windows ecosystem, together. Demos will include the latest in infrastructure – VM scale sets, managed disks, Hybridcloud, Azure Stack, enterprise mobility + security, Xamarin/mobile development, SQL, Data Lake, Cognitive Services, Machine Learning, AI, R, open source capabilities, Logic Apps, Power BI, Flow, developer tools and services, containers and more.

JOIN US

Wednesday 24th of May 2017, 09:15 AM – 16:00 PM, doors open at 08.45

Amsterdam RAI, Europaplein 2, 1078 GZ, Amsterdam

#RedShirtAMS
#MVPBuzz