Archive

Posts Tagged ‘SQL’

#Azure November newsletter

November 30, 2016 Leave a comment

Once again I’m amazed of the pace that Microsoft releases new innovative and great service in Azure! Just love it! 🙂

Free e-book: Enterprise Cloud Strategy

What if you were able to achieve both efficiency and innovation in your business domains and applications across your entire portfolio? What if you could take advantage of the cloud and all its resources and features? With a good road map and strategy, you can. Download the free e-book, Enterprise Cloud Strategy, and find ways to build your own road map to success.

Download the free e-book

Advancing our ambition to democratize artificial intelligence

Microsoft recently announced a new partnership with OpenAI, a nonprofit AI research organization co-founded by Elon Musk, Sam Altman, Greg Brockman and Ilya Sutskever. Together we hope to make significant contributions to advance the field of AI, and make it more accessible to every developer and every organization. Read more about the partnership and why OpenAI chose Azure as the primary cloud platform from Harry Shum, Microsoft Executive Vice President of AI and Research and Sam Altman, co-founder, OpenAI (and be sure to watch the video about why they chose Azure). Also, visit the Azure Blog for more information.

Connect(); // 2016: Keynotes and technical sessions available on demand

Missed the Microsoft Connect(); developer event? Catch up on all the news and keynotes or dive right into any of the technical sessions on Visual Studio, .NET, Xamarin, DevOps, Azure, Data with Intelligent Apps, UWP, developing for Office and more! Browse the on-demand content.

G-Series instances now available for Azure Cloud Services

G-Series instances are available in Azure Cloud Services in all regions where G-Series instances for Azure Virtual Machines are currently offered. They feature the latest Intel Xeon processor E5 v3 family and provide unparalleled computational performance, substantial memory, and robust local solid-state drive (SSD) storage.

VMware backup now available in Azure Backup

VMware backup in Azure Backup helps protect virtual machines running on the VMware platform, on-premises or in the cloud. If you run backups on-premises, this new capability helps you meet requirements for operational recovery. If you back up your information to the cloud, you can meet long-term compliance rules and have an offsite copy of your data. For more information, visit the Operations Management Suite | Protection & Recovery webpage.

In-Memory OLTP for Azure SQL Database generally available

You can use In-Memory OLTP, a feature of Azure SQL Database, to achieve incredible performance gains (up to 30 times) for transaction processing and data ingestion in Premium databases, with no or minimal changes to the application. Memory-optimized tables, memory-optimized table types, and natively compiled T-SQL modules are now available in all Premium databases, including databases in Premium elastic pools. For more information, read the Microsoft Azure SQL Database provides unparalleled performance with In-Memory technologies blog post.

Azure SQL Database Long-Term Retention in public preview

For applications with compliance or operational requirements to retain data, Azure SQL Database now offers Long-Term Retention (LTR). With just a few clicks, you can easily enable your databases to create weekly backups stored in your own Azure Backup vault and extend the retention period built into SQL Database from 35 days to up to 10 years. The backups in the vault are restorable and are automatically deleted after your configured retention period. For more information, visit the Azure Blog.

Azure Content Delivery Network adds new features for better performance, real-time management, and mobile users

Azure Content Delivery Network is a multi-CDN platform that offers massively scalable, secure delivery of content with accelerated performance. New capabilities include the ability to set up real-time alerts about delivery anomalies, such as bandwidth and cache status, and a mobile rules engine where you can customize rules and features targeted to mobile devices, such as device model and operating system. Visit the Azure Blog for more information.

Azure Active Directory Domain Services generally available

Azure Active Directory Domain Services offers scalable, high-performance, managed services such as domain join, LDAP, Kerberos, Windows Integrated Authentication, and Group Policy support. With the click of a button, administrators can enable managed domain services for Linux and Windows virtual machines and directory-aware applications deployed in Azure infrastructure services. By maintaining compatibility with Windows Server Active Directory, Azure Active Directory Domain Services gives you an easy way to migrate traditional on-premises applications to the cloud.

Azure HDInsight introduces advanced security capabilities in public preview

Azure HDInsight has several new key security capabilities. It integrates with Azure Active Directory and Azure Active Directory Domain Services for enterprise-grade authentication and identity management. HDInsight also integrates with Apache Ranger for a central policy and management portal where administrators can maintain fine-grained control policies over Hadoop data access, components, and services. Data processed by HDInsight is stored in Azure Data Lake Store or Azure Storage. Both offer server-side encryption to secure data at rest.

Azure Data Factory adds more connectors and achieves higher speeds

Azure Data Factory allows you to bring data from a rich variety of locations into Azure for advanced analytics and predictive modeling. We recently added support for FTP/S, Amazon S3, Amazon Redshift, and Parquet file format. Load speeds have also been greatly enhanced: you can now load into Azure SQL Data Warehouse at 1.2 GBps and load into Azure Data Lake Store and Azure Blob Storage at over 1.0 GBps.

Azure Analysis Services in public preview

Built on the proven analytics engine in Microsoft SQL Server Analysis Services, Azure Analysis Services delivers enterprise-grade Business Intelligence semantic modeling capabilities with the scale, flexibility, and management benefits of the cloud. For more information, visit the Azure Blog.

Continue reading here!
//Richard

Microsoft announcing SQL Server on Linux – #SQL, #Microsoft, #DB, #PaaS

This is sooo cool and further shows how Microsoft has changed over the past years!

SQL-Loves-Linux

It’s been an incredible year for the data business at Microsoft and an incredible year for data across the industry. This Thursday at our Data Driven event in New York, we will kick off a wave of launch activities for SQL Server 2016 with general availability later this year. This is the most significant release of SQL Server that we have ever done, and brings with it some fantastic new capabilities. SQL Server 2016 delivers:

  • Groundbreaking security encryption capabilities that enable data to always be encrypted at rest, in motion and in-memory to deliver maximum security protection
  • In-memory database support for every workload with performance increases up to 30-100x
  • Incredible Data Warehousing performance with the #1, #2 and #3 TPC-H 10 Terabyte benchmarks for non-clustered performance, and as of March 7, the #1 SAP SD Two-Tier performance benchmark on Windows1
  • Business Intelligence for every employee on every device – including new mobile BI support for iOS, Android and Windows Phone devices
  • Advanced analytics using our new R support that enables customers to do real-time predictive analytics on both operational and analytic data
  • Unique cloud capabilities that enable customers to deploy hybrid architectures that partition data workloads across on-premises and cloud based systems to save costs and increase agility

These improvements, and many more, are all built into SQL Server and bring you not just a new database but a complete platform for data management, business analytics and intelligent apps – one that can be used in a consistent way across both on-premises and the cloud. In fact, over the last year we’ve been using the SQL Server 2016 code-base to run in production more than 1.4 million SQL Databases in the cloud using our Azure SQL Database as a Service offering, and this real-world experience has made SQL Server 2016 an incredibly robust and battle-hardened data platform.

Gartner recently named Microsoft as leading the industry in their Magic Quadrant for Operational Database Management Systems in both execution and vision. We’re also a leader in Gartner’s Magic Quadrant for Data Warehouse and Data Management Solutions for Analytics, and Magic Quadrant for Business Intelligence and Analytics Platforms, as well as leading in vision in the Magic Quadrant for Advanced Analytics Platforms.

Gartner MQs

Extending SQL Server to Also Now Run on Linux

Today I’m excited to announce our plans to bring SQL Server to Linux as well. This will enable SQL Server to deliver a consistent data platform across Windows Server and Linux, as well as on-premises and cloud. We are bringing the core relational database capabilities to preview today, and are targeting availability in mid-2017. Read more…

Microsoft Ignite 2015 summary – #MSIgnite, #EnvokeIT, #Azure, #Office365, #OneDrive, #EMM, #PaaS, #IaaS

Hi all,

We at EnvokeIT participated and collaborated at Microsoft Ignite 2015 in Chicago. And it was one of the most intense events I’ve visited in years with a lot of happening in the business and Microsoft really showed that they are the leading innovator in many areas!

I hope that you enjoy my report and that it gives you a condensed overview of what happened and please contact us at EnvokeIT if you want assistance within any area below! And thank you Microsoft for such a great event and also all you bloggers out there that I’ve linked to in this material.

I must say that this event was positive and a bit scary at the same time. Microsoft is for sure pushing as visionairies and innovators in a lot of areas, and I think that competitors will have a hard time competing in the coming years.

These are the areas where A LOT have been released already and where Microsoft according to my oppinion will increase its market share significantly:

  • Cloud and Mobile services, and with this I don’t mean IaaS service for just running a VM in their public Azure cloud or building a hybrid cloud with connectivity to on-premise datacenters. They are delivering so many capabilities now as PaaS and SaaS services. Just look at the sections below, it’s everything from Enterprise Mobillity Management (EMM), Business Intelligence, Database, Storage, Web Apps/services, Service Availability services (DR, Monitoring/Reporting, Backup etc.), Development, Source Control, Visual Studio Online etc. It’s amazing!!
  • Open Source/Linux support – It’s so cool how much Microsoft have shifted to become an adopter to support more open source technologies and way of thinking than just a couple of years ago! Just have a look at all the Linux support they have in Azure, the Linux support they now have in System Center, Docker support to deliver more DevOps capabilities and all the other services in Azure. It’s amazing and so fun! So now both Microsoft have opened their eyes and realized that they can’t ignore this anymore just like Citrix has with their addition of XenDesktop for Linux with SuSE and RedHat support!

The first day kicked off and was a bombarding of product announcements aimed at helping IT pros secure and manage the new Universal Windows Platform.

CEO Satya Nadella presided over a three-hour keynote, which focused on how Microsoft’s new wave of software and cloud services will enable IT and business transformations that are in line with the ways people now work. Nadella talked up Microsoft’s focus on “productivity and platforms” and how it’s tied with the shift to cloud and mobility. He also highlighted the need for better automation of systems and processes, and better management of the vast amounts of data originating from new sources such as sensors and other Internet-of-Things-type nodes.

As mentioned there where a lot of updates and below I’ve tried to gather these and I hope it gives you a good insight on the infromation we received and also guidance on how you can get more information about the topics.

Included below are links to detailed overviews of each of the demos (from Microsoft blog post) – including information about how to use them, where to learn more, and what you’ll need to get started.

The following picture is a sketch of the keynote and is also quite good at summarizing the message of Mobile and Cloud first!

 

vNiklas also created a great powershell script that automates the downloading of all MS Ignite content with PowerShell and Bits from Channel 9 that you can find here!

Enterprise Mobility Management (EMM) – MDM, MAM, MCSM/MIM etc…

Microsoft’s next chapter in Enterprise Mobility, great blog post on where Microsoft is going etc. http://blogs.technet.com/b/enterprisemobility/archive/2015/05/04/ignite-microsofts-next-chapter- in-enterprise-mobility.aspx …

Windows 10 Continuum – this is cool, think about docking your smartphone to your external screen, keyboard and mouse! That’s try mobility of youre device, this looks really cool and something that I’d like to try out once released!

Have a look at the feature demo at Ignite in the video below.

What’s New and Upcoming with Microsoft Intune and System Center Configuration Manager | Microsoft Ignite 2015

This session outlines the latest enhancements in enterprise mobility management using Microsoft Intune and System Center Configuration Manager. See the newest Microsoft Intune improvements for managing mobile productivity without compromising compliance, and learn about the futures of Microsoft Intune and Configuration Manager, including new Windows 10 management scenarios.

Microsoft Intune and Configuration Manager, including new Windows 10 management scenarios.

https://channel9.msdn.com/Events/Ignite/2015/BRK3861/player

In the CloudEnterprise Mobility Management table of content:

Office 2016 public preview available!

Over the last 12 months, we’ve transformed Office from a suite of desktop applications to a complete, cross-platform, cross-device solution for getting work done. We’ve expanded the Office footprint to iPad and Android tablets. We’ve upgraded Office experiences on the Mac, the iPhone and on the web. We’ve even added new apps to the Office family with Sway and Office Lens. All designed to keep your work moving, everywhere. But that doesn’t mean we’ve forgotten where we came from. While you’ve seen us focus on tuning Office for different platforms over the last year, make no mistake, Office on Windows desktop is central to our strategy.

In March we introduced an IT Pro and Developer Preview for the 2016 release of our Office desktop apps on Windows, and now—as a next step—we’re ready to take feedback from a broader audience. Today we’re expanding the Office 2016 Preview, making it available to Office users everywhere in preparation for general availability in Fall 2015.

Office 2016 previewers will get an early look at the next release of Office on Windows desktop, but more importantly they’ll help to shape and improve the future of Office. Visit the Office 2016 Preview site to learn more about the Preview program and if it’s right for you.

New in Office 2016

Since March, we’ve shared some glimpses of what’s to come in Office 2016. Today, we’d like to give a more holistic view of what customers at home and work can expect in the next release. In Office 2016, we’re updating the Office suite for the modern workplace, with smart tools for individuals, teams, and businesses.

Read more…

Synergy 2015 – A condensed recap of everything you need to know – via @gkuruvilla, #Citrix, #CitrixSynergy

This is a great summary recap that George Kuruvill has done of Citrix Synergy 2015! Great work and enjoy this blog post!

For those of you who were not able to attend Citrix Synergy this year & dont have the time to sit through the key note recordings, I decided to put together a condensed version of some of the key announcements. So here goes!

Citrix Workspace Cloud

  • Citrix hosted control plane that enables customers to deliver a comprehensive mobile workspace to end users.
  • Gives customers the flexibility to host workloads on premises, in public or private clouds.
  • Control plane also provides end to end monitoring of user connections.
  • Evergreen infrastructure since Citrix maintains all core infrastructure components.
  • Workspace Cloud Connector installed on premises on a Win 2k12 server that establishes SSL communication between control plane and customer environment. Used to talk to infrastructure components like Active Directory and hypervisors hosting workload

I wrote a blog on CWC and the value proposition a month back that you can find here.

SYN 217 –  Workspace Cloud – Technical Overview [Video]

 

Citrix Lifecycle Management

  • Comprehensive cloud based service that can be used to design, deploy and manage both Citrix and other enterprise applications.
  • Based on the ScaleXtreme technology.
  • Lifecycle Management enables customers/partners to deploy infrastructure not only on premises but also public/private clouds (resource locations)
  • Customers/Partners have the ability to create blueprints to automate infrastructure deployments end to end. Examples of blueprints include a XD deployment for instance where you could not only install all the XD infrastructure but also automate the installation of all supporting infrastructure like Active Directory, SQL etc.
  • Vendors have the ability to create blueprints as well that can then be consumed by customers and partners alike.
  • Customers/Partners also have the ability to incorporate scripts (new/existing) into the deployment.
  • Once a blueprint is developed, its added to a library. Any resource within the library can then be deployed to a resource location (on premises, public/private cloud)
  • Another key benefit of the Lifecycle Management technology is the ability to automate application upgrades.

XenApp/XenDesktop

  • Xenapp 6.5 maintenance extended till end of 2017, EOL extended till 06/2018. Details here
  • New Feature Pack for XA 6.5 (enhance storage performance, Lync support enhancements, UPM enhancements, Director “Help Desk” troubleshooting”, Storefront 3.0, Receiver.next)
  • XenApp/XenDesktop 7.6 FP2  (End of Q2)
    • New Receiver X1
    • Lync 2013 on Mac
    • Touch ID Support
    • HDX with Framehawk
    • Native Receiver for Linux
    • Linux Apps and Desktops (Redhat and SUSE support)
    • Desktop Player for Mac 2.0 (June)
    • Desktop Player for Windows (Tech Preview)

SYN 233 – Whats new in XenApp and XenDesktop [Video]

SYN 319 – Tech Update for XenApp and XenDesktop  [Video]

Read more…

#XenDesktop 7.1 on #Hyper-V Pilot Guide! – #Citrix

February 19, 2014 1 comment

This is a great PoC guide, some thing I would have done differently in detail but overall great work!

You’ve heard of XenDesktop 7.1, experienced a demo and worked through the Reviewer’s Guide. Now where do you turn when you’re ready for a PoC, pilot and preparations for a full-scale rollout?

Here on the Citrix Readiness and Enablement Team, we’re always looking for ways to empower our customers to be successful on their projects. To this end, we’ve taken one of our most popular hands-on lab guides used to train hundreds of internal and external students and reworked it for consumption by the masses. The XenDesktop 7.1 on Hyper-V Pilot Guide can be download fromhttps://citrix.sharefile.com/d/scaa256260df4ab3b. In this guide we cover the following topics with step-by-step instructions and screenshots:

– Configuring System Center Virtual Machine Manager and Installing the Agent
– Setting Up SQL Server Mirroring for a XenDesktop site
– Setting up the XenDesktop Site
– Joining a Controller to an Existing Site
– Configuring StoreFront and Installing Certificates
– Configuring NetScaler for StoreFront Load Balancing
– Installing the VDA Software on Desktop and Server VMs
– Creating Catalogs of Machine for Desktops and Servers
– Creating Delivery Groups for Desktops and Servers
– Delivering Installed and App-V Applications
– Provisioning Services Configuration and Optimizations
– Using the XenDesktop Setup Wizard
– Setting up Remote Access with NetScaler and StoreFront
– Internal and External Connectivity Scenarios
– Load Evaluator Policies
– Monitoring with Director
– Exploring Configuration Logging
– Exploring Delegated Administration
– Working with PowerShell

And much more!

Take a look through the document and let us know your thoughts…

IMPORTANT: This guide is designed to be used as a reference for building PoC and/or pilot environments. Production environments should always be…

Continue reading here!

//Richard

#XenDesktop 7.1 Service Template Tech Preview for System Center 2012 Virtual Machine Manager – #SCVMM

November 5, 2013 Leave a comment

This is interesting! Really good and can’t wait to try it out!

Introduction

Let’s face it, installing distributed, enterprise-class virtual desktop and server based computing infrastructure is time consuming and complex.  The infrastructure consists of many components that are installed on individual servers and then configured to work together.  Traditionally this has largely been a manual, error prone process.

The Citrix XenDesktop 7.1 Service Template for System Center 2012 Virtual Machine Manager (SCVMM) leverages the rich automation capabilities available in Microsoft’s private cloud offering to significantly streamline and simplify the installation experience.  The XenDesktop 7.1 Service Template enables rapid deployment of virtual app and desktop infrastructure on Microsoft System Center 2012 private clouds.  This Tech Preview is available now and includes the latest 7.1 version of XenDesktop that supports Windows Server 2012 R2 and System Center 2012 R2 Virtual Machine Manager.

Key Benefits:

  • Rapid Deployment – A fully configured XenDesktop 7.1 deployment that adheres to Citrix best practices is automatically installed in about an hour; a manual installation can take a day or more.
  • Reduction of human errors and the unwanted consequences – IT administrators answer 9 questions about the XenDesktop deployment, including the VM Network to use, the domain to join, the SQL server used to host the database, the SCVMM server to host the desktops, and the administrative service accounts to connect to each of these resources.  Once this information is entered, the Service Template automation installs the XenDesktop infrastructure the same way, every time, ensuring consistency and correctness.
  • Reduction in cost of IT Operations – XenDesktop infrastructure consistently configured with automation is less costly to support because the configuration adheres to best practice standards.
  • Free highly skilled and knowledgeable staff from repeatable and mundane tasks – A Citrix administrator’s time is better spent focused on ensuring that users get access to the applications they need, rather than lengthy production installation tasks.
  • Simplified Eval to Retail Conversion – Windows Server 2012 and later, as well as XenDesktop 7.1, support conversion of evaluation product keys to retail keys.  This means that a successful POC deployment of the XenDesktop 7.1 Service Template is easily converted to a fully supported and properly configured production deployment.
  • Easy Scale-Out for greater capacity – SCVMM Service Templates support a scale-out model to increase user capacity.  For example, as user demand increases additional XenDesktop Controllers and StoreFront servers are easily added with a few clicks and are automatically joined to the XenDesktop site.

The XenDesktop Service Templates were developed and tested with the support of our friends and partners at Dell, who, in support of the release of XenDesktop 7.1 and the Service Template technical preview, are expected to launch new and innovative solutions that include these and other automation capabilities this quarter.  These solutions are based on the Dell DVS Enterprise for Citrix XenDesktop solutions.

Simplification of Distributed Deployments

The XenDesktop 7.1 in-box installation wizard is a fantastic user experience that automatically installs all the required prerequisites and XenDesktop components in under 30 minutes.  The result is a fully installed XenDesktop deployment, all on a single server, that is excellent for POCs and product evaluations.  The installation and configuration challenges occur when you want to install XenDesktop in production, with enterprise-class scalability, distributed across multiple servers.

Manual Installation Steps

XenDesktop 7 manual installation steps

Read more…

How To: #XenMobile #MDM 8.5 Deployment Part 1 and 2: Installation – via @AdamInTheCloud

September 8, 2013 1 comment

Wow, it’s like Adam read my mind, I’m doing the same kind of blog post series but for a XenMobile MAM deployment! Will post part 2 of the MAM series later tonight (once it’s done, waiting on some StoreFront issues to solve and I’m getting there!)

But in the meantime have a look at this great series by Adam! Great job Adam!!!

How To: XenMobile MDM 8.5 Deployment Part 1: Installation

n late 2012 Citrix announced they had purchased a 7-year-old startup company called Zenprise that was a hot player in the mobile device security market. Up until that time, Citrix was positioning for that sector with its CloudGateway Enterprise product and focusing mostly on apps and data management..not really the device. Zenprise helped them flesh out their offering, which is now known as “XenMobile”. Although it’s gone through a few iterations it has finally reached a final “form” if you will of three editions: MDM, App, and Enterprise.

The purpose of this article series will be to walk through the installation and basic setup of the MDM (Mobile Device Management) Edition which focuses almost exclusively on managing the device, and not necessarily so much the data or apps. Although it is capable of application pushes and the like… a feature comparison can be found on Citrix’ website HERE. I encourage you to view that. One major difference to note is MDM does not sandbox apps/data, but App Edition does, and Enterprise Edition can.

In researching this product for some internal training we are currently going through it became pretty apparent there is very little information out there on it, and if there is its unfortunately outdated because the product has been rapidly evolving over the first half of the year. In this series of blog articles I will go over how to deploy a single instance of XenMobile 8.5 MDM on an internal network, configure basic policies and rules, and apply them to your devices.

If you would like to read the other parts in this article series please go to:

This, unfortunately is the most boring part of MDM which is the install…but I would be remiss by not going over it for some of you that “have to see” it. So lets get to it so we can get on to the more exciting stuff!

First: Pre-req’s. All of this is straight from eDocs, I’m not reinventing the wheel here.

  • MDM 8.5 needs to go on a 2008 R2 or 2012 server.
  • Setup an active directory service account and make it a local admin on the MDM server
  • Disable IPv6 (not via registry, just uncheck the box)
  • UAC disabled
  • Firewall disabled (this is my preference..I disable server firewalls but you’re welcome to do as you wish)
  • Your service account needs permissions creator/owner/read/write on your SQL server. I will not be using PostgreSQL.
  • SQL 2005/2008/R2/2012 in your environment (Reference Architecture recommends SQL for production deployments, not PostgreSQL. See HERE)
  • Java SE 7 Update 11 (dk-7u4-windows-x64.exe) installed on the server
  • Java Cryptography Extension (JCE) USJP 7 on the serverExternal DNS record such as mobile.mydomain.com
    • To install the Java Cryptography Extension
      • Install Java SE 7u11
      • Open the JCE zip file and copy local_policy.jar and US_export_policy.jar to your computer desktop.
      • Navigate to the folder /java/jdk1.7.0_x/jre/lib/security and copy the files from Step 2 to this folder.
  • Obtain an Apple….

Continue reading part 1 here and part 2 here!

//Richard

%d bloggers like this: