PolyBase – How SQL Server does Big data!

In this post, Senior App Dev Manager Nayan Patel introduces SQL Server PolyBase and shares some insights from a recent engagement using the technology. I was recently involved in helping my customer complete a successful PoC around SQL Server 2016’s PolyBase feature.  They have invested a signification amount of budget and resources standing up their…


Filtered Indexes and Forced Parameterization: Can’t we all just get along?

We have a database here that stores information about Azure SQLDB health issues; it was chugging along fine for months, then earlier this week it started to struggle. You can see the large increase in steady-state CPU consumption: After asking around, we learned that forced parameterization had been enabled on this database around the time…


SQL Updates Newsletter – January 2018

Recent Releases and Announcements Cumulative Update #3 for SQL Server 2017 RTM https://blogs.msdn.microsoft.com/sqlreleaseservices/cumulative-update-3-for-sql-server-2017-rtm/ Cumulative Update #7 for SQL Server 2016 SP1 https://blogs.msdn.microsoft.com/sqlreleaseservices/cumulative-update-7-for-sql-server-2016-sp1/ Cumulative Update #10 for SQL Server 2014 SP2 https://blogs.msdn.microsoft.com/sqlreleaseservices/cumulative-update-10-for-sql-server-2014-sp2/ Power BI Desktop January Feature Summary https://powerbi.microsoft.com/en-us/blog/power-bi-desktop-january-2018-feature-summary/ Microsoft R Open 3.4.3 now available http://blog.revolutionanalytics.com/2018/01/microsoft-r-open-343-now-available.html The Future Computed: Artificial Intelligence and its role in society…


Microsoft’s Geospatial Capabilities

In a recent article published on LinkedIn, Premier Developer consultant Ron Vincent highlights some of Microsoft’s geospatial capabilities, both past and present. Microsoft has for some time now had some level of geospatial capabilities but since Azure has come along there has been many developments on this front. In this article, I think it’s time…


Kubernetes クラスタで SQL Server コンテナを動かしてみよう

Microsoft Japan Data Platform Tech Sales Team 森本 信次 Linux 版 SQL Server の Docker コンテナ対応によって 過去のブログ でもご紹介したように、高いポータビリティや柔軟性の恩恵を十分に得ることが出来るとお伝えしましたが、Docker コンテナの普及とともに、コンテナをクラスタ化した際の運用管理ツールの重要性も高まってきています。そこで今回 はコンテナの運用管理機能を提供する Kubernetes を Azure Container Service (AKS) の Managed Kubernetes クラスター環境で SQL Server を 以降 ステップバイステップで動かしてみたいと思います。 1. Azure Portal から Red Hat Enterprise 7.3 の仮想マシンを作成します。 今回 仮想マシンの OS として Red Hat Enterprise を使用していますが、SUSE などお好みの Linux を選択頂いても構いません。…


Managing SQL Server high availability and disaster recovery

In this sample chapter from Exam Ref 70-764 Administering a SQL Database Infrastructure, learn how to design appropriate high availability and disaster recovery solutions in SQL Server with special attention to installation, configuration, and administration processes.


SQL Server 2017 and Dynamics NAV

SQL Server 2017 was released in October last year with many new and interesting capabilities. For further information, please take a look at the product information at this location: https://docs.microsoft.com/en-us/sql/sql-server/what-s-new-in-sql-server-2017. Over the last few months, the Dynamics NAV team has been testing compatibility with this new version of SQL Server, and we are now proud…


Special offer: Save up to 60% on SQL Server 2017 learning resources

SQL Server 2017 gives you the power to build modern applications using the language of your choice, on-premises and in the cloud, on Windows, Linux, and Docker containers. In two new titles from Microsoft Press, explore the concepts and methodologies of managing SQL Server databases with hands-on practice to become a more experienced—and more efficient—database…


Preparing on-premises Active Directory for Azure AD Connect

Azure Active Directory Connect is Microsoft’s replacement for DirSync and Azure Active Directory Sync tools. In Skill 4.1 from Exam Ref 70-346 Managing Office 365 Identities and Requirements, 2nd Edition, explore how to prepare your on-premises Active Directory environment for synchronization of user accounts, group accounts, and more.


SAP on SQL Server: General Update – January 2018

SAP and Microsoft are continuously adding new features and functionalities to the SAP on SQL Server platform. The key objective of the SAP on Windows SQL port is to deliver the best performance and availability at the lowest TCO and simplest operation. This blog includes updates, fixes, enhancements and best practice recommendations collated over recent…