Prerequisites Before we begin, ensure that you have the following: An Azure Subscription: If you don’t have one, you can create a free account. An Azure SQL Database: Set up a database in Azure and note down your server name (like yourserver.database.windows.net), database name, and the credentials (username and password) used for accessing the database. SQL Server Management Studio (SSMS):…

AZ-300 | Azure SQL Data Warehouse

SQL Data Warehouse lets you easily scale, pause, and resume your data warehouse. The architecture of SQL Data Warehouse separates storage and compute, allowing you to scale them independently.

Distributed Tables

SQL Data Warehouse divides your data into 60 databases. Each individual database is called a distribution. After you’ve loaded data into each table, SQL Data Warehouse has to know…

Have been under a social media embargo, until today, but now that the Microsoft Ignite 2017 keynote has taken place, I am able to proudly say that the solution our team has been working on for some time was part of the Keynote addresses.

During the second keynote lead by Scott Guthrie, Danielle Dean a Data Scientist Lead @Microsoft discussed at a high level, one of the solutions we are developing at Jabil, which involves advanced image recognition of circuit board issues. The keynote focused in on the context of the solutions data science portion and introduced the new Azure Machine Learning Workbench to the packed audience.

Tomorrow morning there is a session – “Using big data, the cloud, and AI to enable intelligence at scale” (Tuesday, September 26, from 9:00 AM to 10:15 AM, in Hyatt Regency Windermere X)… during which we will be going into a bit more detail, and the guys at Microsoft will be expanding on the new AI and Big Data machine learning capabilities (session details via this link).

#gallery-0-5 { margin: auto; } #gallery-0-5 .gallery-item { float: left; margin-top: 10px; text-align: center; width: 50%; } #gallery-0-5 img { border: 2px solid #cfcfcf; } #gallery-0-5 .gallery-caption { margin-left: 0; } /* see gallery_shortcode() in wp-includes/media.php */

Azure SQL Data Warehouse: Troubleshoot with the Resource Health check

New update for Azure SQL Data Warehouse…

Reduce troubleshooting time with the upgraded Resource Health check for SQL Data Warehouse.

This upgrade considers the health status of all components of the SQL Data Warehouse architecture, which includes each SQL database distribution and the SQL Data Warehouse engine on each compute node. Login and heartbeat signals of each component are emitted at…

5 Announcements from PASS Summit 2016

The annual Professional Association for SQL Server (PASS) conference was held recently, and Microsoft has disclosed some of the important announcements from that event.

Public Preview of Azure Analysis Services – Azure Analysis Services enables developers and BI professionals to create BI Semantic Models.

SQL Server 2016 DW Fast Track Reference Architecture, 145TB – The Data Warehouse Fast Track…

Meet the latest Microsoft tools and tech to help you build a cloud culture

Enterprises demand cloud-speed innovation, and Microsoft’s Cloud Platform team keeps delivering as this week saw with a wave of new releases across the product portfolio. The C+E News Bytes blog helpfully rounds up the latest and greatest tools to help companies embrace the cloud-first era, including a preview of Azure SQL Data Warehouse, Azure Active Directory Connect, Azure Application…

Need more storage space for your data? Azure SQL Data Warehouse opens its doors

We’re all up to our eyeballs in data. Where’s an enterprise to turn for relief…

Read More

Azure SQL Data Warehouse

Have you seen the Azure SQL Data Warehouse announced by Microsoft during the recent Ignite conference? Azure SQL Data Warehouse is announced as a combination of enterprise-grade SQL Server augmented with the massively parallel processing architecture of the Analytics Platform System, which allows the SQL Data Warehouse service to scale across very large datasets. It integrates with existing Azure…