Author : All posts by ilikesql

12

Jul

Azure sets new performance benchmarks with SQL Data Warehouse

As the amount of data grows exponentially, the pressure to quickly harness it for insights to share across the organization also increases rapidly. As Microsoft continues to evolve our analytics portfolio, we are committed to delivering a data warehouse solution that provides a fast, flexible, and secure analytics platform in the cloud.

Today we are excited to announce that Azure SQL Data Warehouse has set new performance benchmarks for cloud data warehousing by delivering at least 2x faster query performance compared to before. The key to this technical innovation is instant data movement, a capability that allows for extremely efficient movement between data warehouse compute nodes. At the heart of every distributed database system is the need to align two or more tables that are partitioned on a different key to produce a final or intermediate result set. Instant data movement in SQL Data Warehouse now accelerates this movement, resulting in faster query performance. You can learn more about how your query performance will improve from this blog.

Insights in minutes with Azure SQL Data Warehouse

We know that data makes every decision better, but decisions need to be timely to be competitive in the market. Fast decisions need

12

Jul

Announcing new offers and capabilities that make Azure the best place for all your apps, data, and infrastructure

Just a few months back, I wrote about how we are helping companies move to the cloud with a flexible hybrid approach and cost-effective path to Azure. To help our customers realize even greater savings and simplify the migration to Azure, I’m pleased to share some exciting updates to address these customer needs.

Migrate to Azure with free Windows Server and SQL Server 2008 Extended Security Updates

Windows Server and SQL Server 2008/2008 R2 were hugely popular when they launched nearly 10 years ago and have been deployed in millions of instances worldwide. Our customers continue to run many of their business applications on these servers. With the decade anniversary coming, both these versions are nearing end of support – with SQL Server 2008 end of support in July 2019 and Windows Server 2008 end of support in January 2020. We know many customers want to continue with these servers, and we are here to help ensure all our customers have great options.

Today, we are announcing that we will provide extended security updates for three years past the end of support dates for free when running in Azure. This means customers get the efficiency of running servers in Azure,

12

Jul

Consulting offers in Azure Marketplace arrive in Canada

At Microsoft, we take pride in the fact that we have the biggest and best partner ecosystem in Canada, and it is incredible to see the amazing work that occurs each and every day. Digital transformation for many organizations can be a big undertaking, which is why it is important to have various types of partners like Systems Integrators and Managed Service Providers who can help customers navigate everything from simple migrations to complex cloud deployments. Following the rapid growth and positive response of Consulting Services offers on AppSource, we delivered the capability to Azure Marketplace customers in the US in May. Today, we are excited to announce that they are now available in Canada.

These new listing options expand Azure Marketplace beyond ISVs and applications so that customers can find a wide range of consulting services, such as assessments, onsite workshops, proofs of concept, and implementations, each backed by a partner with deep Azure expertise (Microsoft Partner Gold and Silver Competency). The Gold and Silver Cloud Platform competency partners help customers modernize their infrastructure, migrate applications and data to the cloud, and build analytics solutions on data platforms in the cloud, signaling their ability to deliver quality solutions in

12

Jul

Azure IoT Central available for partners to manage and extend customer solutions

As more and more enterprises begin to see value from IoT and digital transformation, many businesses still need help building the necessary digital capabilities. That’s where our partners truly shine. Azure IoT Central brings the simplicity of SaaS for IoT so partners can focus on delivering the business value to their customers, no cloud expertise required. Today, at Inspire 2018, we are adding several features that provide an easy avenue to partner types across the IoT ecosystem to benefit from IoT.

Since entering public preview IoT Central has implemented a number of new features, capabilities, and usability improvements. Features made available today make it easy for partners to resell, manage and extend customer solutions.

Azure IoT Central now available in Azure CSP

Azure IoT Central now supports Azure CSP subscriptions. Leverage the power of CSP to add managed services and have end-to-end ownership of the customer lifecycle and relationship for Microsoft Azure. Partners are empowered to manage sales, own the billing relationship, provide technical and billing support and be the customers’ single point of contact. In addition, CSP provides a full set of tools including a self-service portal and accompanying APIs to easily provision, manage and provide billing for their

12

Jul

How Microsoft Azure Stack means transformation and opportunities for partners

We are a few days away from kicking-off Microsoft Inspire 2018 in Las Vegas, Nevada. It is an event I look forward to every year. This year however is a special year to celebrate the momentum we have with our partners for Microsoft Azure Stack. At Microsoft Inspire 2017, we had a couple of sessions for Azure Stack. They were both completely full, including the overflow rooms! I thought I would take this moment to reflect on our first year of launch and share a quick view on the opportunities ahead.

A year ago, we announced the general availability of Azure Stack, with the vision that Azure Stack is an extension of Azure and enables a truly consistent hybrid cloud platform. Including the ability to decide where applications and workloads should run whether it be cloud, on-premises datacenters, or at the edge. In fact since launch, we have seen some amazing scenarios where customers are using Azure Stack in remote, often disconnected, environments to deliver value to businesses and communities. And, our partners have been instrumental in unlocking such new possibilities for customers.

For example iMOKO, New Zealand’s digital health charity, decided to use Azure Stack to make their

12

Jul

Announcing new options for SQL Server 2008 and Windows Server 2008 End of Support

It’s incredible how much and how rapidly technology evolves. Microsoft’s server technology is no exception. We entered the 2008 release cycle with a shift from 32-bit to 64-bit computing, the early days of server virtualization and advanced analytics. Fast forward a decade, and we find ourselves in a full-blown era of hybrid cloud computing with exciting innovation in data, artificial intelligence, and more.

I want to thank our customers for choosing SQL Server and Windows Server to run their business and trusting Microsoft to be their technology partner. I would also like to make sure we support our customers in getting ready for the future and taking maximum advantage of today’s technologies. End of support is quickly approaching for these popular 2008 releases:

Extended Support for SQL Server 2008 and 2008 R2 will end on July 9, 2019. Extended Support for Windows Server 2008 and 2008 R2 will end on January 14, 2020.

End of support means the end of regular security updates. With cyberattacks becoming more sophisticated and frequent, running apps and data on unsupported versions can create significant security and compliance risks. The 2008 family of products was great for its time, but we highly recommend upgrading to

12

Jul

Announcing Azure Expert MSPs
Announcing Azure Expert MSPs

I am really excited that today, Gavriella Schuster, Corporate Vice President of One Commercial Partner, announced the Azure Expert Managed Service Provider program and unveiled our very first set of Azure Expert MSPs! These expert partners have proven real world proficiency and skills, for datacenter lift-and-shift, born-in-cloud new applications, and everything in-between. This new program will make it incredibly easy for you to discover and engage highly-capable MSPs in your region for your cloud projects and migrations. 

I consistently hear from customers that what matters most when selecting a managed service partner is demonstration of real-world experience, whether the partner is assessing, migrating, building, deploying, optimizing or efficiently managing business solutions on Azure. When you have the right partner by your side, I am confident you will be able to deliver your desired business outcomes and keep pace with all of the innovation that the cloud enables.

Azure Expert MSPs complete a rigorous audit by an independent third party, and also provide multiple customer references of Azure managed services projects delivered over the last 12 months. Furthermore, to retain the badge, these expert partners need to continue to meet pre-requisites annually and complete a progress audit every year. As

12

Jul

Power BI expands self-service prep for big data,unifies modern and enterprise BI

https://powerbi.microsoft.com/en-us/blog/power-bi-expands-self-service-prep-for-big-data-unifies-modern-and-enterprise-bi/Source: https://powerbi.microsoft.com/en-us/blog/power-bi-expands-self-service-prep-for-big-data-unifies-modern-and-enterprise-bi/           New capabilities for advanced data prep, enterprise-scale modeling and reporting.

11

Jul

Kafka 1.0 on HDInsight lights up real time analytics scenarios

Data engineers love Kafka on HDInsight as a high-throughput, low-latency ingestion platform in their real time data pipeline. They already leverage Kafka features such as message compression, configurable retention policy, and log compaction. With the release of Apache Kafka 1.0 on HDInsight, customers now get key features that make it easy to implement the most demanding scenarios. Here is a quick introduction:

Idempotent producers so that you don’t have to deduplicate

Consider a cellular billing system, in which the producer writes the amount of data consumed by users to a Kafka topic called data-consumption-events. If the broker or the connection fails, the producer will not get an acknowledgment of a message write and will retry that message. This will lead to duplicate writes to the system, causing users to be overbilled.

In critical scenarios like above, data engineers had to write and maintain custom deduplication logic, such as hashing and saving message ids. However, with idempotent producers turned on, Kafka handles that logic for you. Records include unique producer ids and the sequence number of the message. Kafka brokers will only accept a message from a producer if the sequence number is exactly one more than the committed sequence number

10

Jul

7/12 Webinar: Text Analysis in Power BI with Cognitive services with Leila Etaati

https://powerbi.microsoft.com/en-us/blog/7-12-webinar-text-analysis-in-power-bi-with-cognitive-services-with-leila-etaati/Source: https://powerbi.microsoft.com/en-us/blog/7-12-webinar-text-analysis-in-power-bi-with-cognitive-services-with-leila-etaati/           Get a sneak peak of the Business Application Sumit content with a preview of one of the sessions Leila will be doing at the Business Applications Summit!