28

Apr

SQL Server community-driven enhancements in SQL Server 2017
SQL Server community-driven enhancements in SQL Server 2017

This post was authored by the SQL Server Tiger Team

Although SQL Server 2016 runs faster, SQL Server 2017 promises to run even faster and empower customers to run smarter with intelligent database features like the ability to run advanced analytics using Python in a parallelized and highly scalable way, the ability to store and analyze graph data, adaptive query processing, and resumable online indexing allowing customers to deploy it on the platform of their choice (Windows or Linux). SQL Server is one of the most popular DBMS among the SQL community and is a preferred choice of RDBMS among customers and ISVs owing to its strong community support. In SQL Server 2017 CTP 2.0, we have released several customer delighters and community-driven enhancements based on the learnings and feedback from customers and the community from in-market releases of SQL Server.

Smart differential backup – A new column modified_extent_page_count is introduced in sys.dm_db_file_space_usage to track differential changes in each database file of the database. The new column modified_extent_page_count will allow DBAs, the SQL community and backup ISVs to build smart backup solutions, which perform differential backup only if percentage changed pages in the database are below a threshold (say 70

28

Apr

Power BI Pride 2017: share your pride with the world!
Power BI Pride 2017: share your pride with the world!

Source: https://powerbi.microsoft.com/en-us/blog/power-bi-pride-2017-share-your-pride-with-the-world/           It’s about pride – the pride you have as a Power BI customer, partner, or employee. It’s about pride in your work, and in the work of your fellow business intelligence experts. Last READ MORE

27

Apr

Tech Tip Thursday: Guy in a Cube’s favorite Power BI feature?

Source: https://powerbi.microsoft.com/en-us/blog/tech-tip-thursday-guy-in-a-cube-s-favorite-power-bi-feature/           Microsoft’s Guy in a Cube has been providing tips and tricks for Power BI and Business Intelligence on his YouTube channel since 2014. Occasionally on Thursdays we highlight a different helpful video from READ MORE

27

Apr

HDInsight tools for IntelliJ & Eclipse April Updates
HDInsight tools for IntelliJ & Eclipse April Updates

Source: https://blogs.msdn.microsoft.com/azuredatalake/2017/04/27/hdinsight-tools-for-intellij-eclipse-april-updates/     We are pleased to announce the April updates of HDInsight Tools for IntelliJ & Eclipse. This is a quality milestone and we focus primarily on refactoring the components and fixing bugs. We also added Azure Data READ MORE

26

Apr

Azure Data Lake U-SQL April 25 2017 Updates: Introducing Packages, UNPIVOT INCLUDE NULLS, fast file set preview flag, R extension returns dataframes, exporting your cluster database with sample data to your local run and more!

Source: https://blogs.msdn.microsoft.com/azuredatalake/2017/04/27/azure-data-lake-u-sql-april-25-2017-updates-introducing-packages-unpivot-include-nulls-fast-file-set-preview-flag-r-extension-returns-dataframes-exporting-your-cluster-database-with-sample-data-t/   We have concluded the rollout of our April 2017 refresh to all the regions today. Here are the April 2017 Updates for Azure Data Lake U-SQL and Developer Tooling! The main items are the release of the READ MORE

26

Apr

Programmatically find SQL Server TCP ports
Programmatically find SQL Server TCP ports

Source: https://blogs.msdn.microsoft.com/sql_server_team/programmatically-find-sql-server-tcp-ports/   There are many instances in SQL Server management where one person would like to find all the TCP ports that SQL Server is binding to. Finding all the TCP ports that SQL Server is listening on might READ MORE

26

Apr

SQL Server Community driven Enhancements in SQL Server 2017
SQL Server Community driven Enhancements in SQL Server 2017

Source: https://blogs.msdn.microsoft.com/sql_server_team/sql-server-community-driven-enhancements-in-sql-server-2017/   While SQL Server 2016 runs faster, SQL Server 2017 promises to run faster and empower customers to run smarter with intelligent database features like the ability to run advanced analytics using Python in a parallelized and highly READ MORE

26

Apr

Power BI Mobile apps feature summary – April 2017
Power BI Mobile apps feature summary – April 2017

Source: https://powerbi.microsoft.com/en-us/blog/power-bi-mobile-apps-feature-summary-march-april-2017/           We are happy to share with you all of the recent features and improvements that we’ve released for the Power BI Mobile apps. This month we mainly focused on improving the quality of READ MORE

25

Apr

Certificate-based authentication for Azure SQL DB using Azure Active Directory with recent Azure RM PowerShell version

Source: https://blogs.msdn.microsoft.com/sqlsecurity/2017/04/25/certificate-based-authentication-for-azure-sql-db-using-azure-active-directory-with-recent-azure-rm-powershell-version/   This is a new version of the previous blog on Token-based authentication (see https://blogs.msdn.microsoft.com/sqlsecurity/2016/02/09/token-based-authentication-support-for-azure-sql-db-using-azure-ad-auth/ ) updated to accommodate recent Azure RM PowerShell version. The certificate-based authentication allows to use a local certificate that can be registered with READ MORE

25

Apr

Exposing Hive!
Exposing Hive!

Source: https://blogs.msdn.microsoft.com/azuredatalake/2017/04/25/exposing-hive/   I sat down with Justin Scott (Application Development Manager at Microsoft working with our top customers) to talk about Apache Hive and where it’s heading. You can listen to channel 9 podcast now