Azure SQL Database Managed Instance (Azure SQL DB MI) is a fully managed SQL Server Database Engine Instance hosted in Azure cloud. This is the most compatible PaaS option for migrating on-premises SQL Server databases to the cloud (PaaS is good if you want to use capabilities like automatic patching and version updates, automated backups, … Continue reading What “near 100% compatibility” of Azure SQL DB Managed Instance actually means?
Tag: SQL Server
Business Intelligence Solutions Decision Tree
In this article we will cover most important Business Intelligence components based on Microsoft Data Platform. One week ago there were announcements on Power BI Premium and Power BI Report Server which will require some clarification, so I decided to create another decision tree describing available Microsoft analytical modeling and visualization tools, and covering Power … Continue reading Business Intelligence Solutions Decision Tree
Data Science with Microsoft R Hands-on Labs
In this post I will provide list of most important publically available Data Science with Microsoft R Hands-on Labs which we use in MTC New York for Microsoft R workshops. To start doing labs provided below it’s a good idea to have a general level of predictive and classification Statistics, and a basic understanding of … Continue reading Data Science with Microsoft R Hands-on Labs
Materials from Mission Critical Performance Workshop
Today in MTC New York I provided workshop “Always On: Mission Critical Performance” dedicated to some new features of SQL Server 2016. (And this time SQL Server AlwaysOn technology actually was covered, but it was only fraction of the whole content 😉 ). Here you can find presentation decks from this workshop: SQL Server 2016 Evolution SQL Server 2016 Performance (Here I … Continue reading Materials from Mission Critical Performance Workshop
Machine Learning @ 1 million predictions per second and more
Watch recordings of keynote and session previews of Microsoft Machine Learning & Data Science Summit 2016 on the latest Big Data, Machine Learning, Artificial Intelligence, and Open Source techniques and technologies. Some take-aways from the keynote: Combination of in-memory technologies and in-database analytics with R at scale using SQL Server 2016 can make 1 million fraud predictions … Continue reading Machine Learning @ 1 million predictions per second and more
Machine Learning Solutions Decision Tree
New version is available: Artificial Intelligence Decision Tree Machine learning is a technique of data science that helps computers learn from existing data in order to forecast future behaviors, outcomes, and trends. Currently there are lot of products which can be used for this on-premises or in the cloud, based on single node or multiple nodes, … Continue reading Machine Learning Solutions Decision Tree
Business Excellence 