November 2017 Roundup

November 2017 SQL Roundup

I recently had the opportunity to be the keynote presenter at the QUT Doctoral Consortium for the School of Information Systems. I had the privileged to hear about the amazing research the students had undertaken to solve complex computer science problems. The common theme throughout the research projects was despite the limitless compute power of the cloud, they still faced challenges with articulating these findings to stakeholders.

WARDY IT Solutions has seen this same challenge with Community Care organisations. We’ve developed a Data Analytics as a Service (DAaaS) solution called Care Insights to deliver prescriptive insights and easily disseminate analytics to all stakeholders involved in community care. You can find out more about this innovative solution here.

Scroll down to read my top picks for November.

How the Virtual DBA Service saved my marriage

Our Virtual DBA customers are a very happy lot! We were delighted with the response to the customer satisfaction survey and the overwhelmingly positive feedback. Although we’re confident in our ability to add value to the business, we were surprised to hear just how many people had experienced a positive impact outside of work. Read what our customers had to say in our latest post.

Oracle vs SQL Server: What Oracle’s pricing changes mean for your cloud decisions

All organisations are somewhere along their journey to the cloud. Whether you’re in the planning stages, in the process of transitioning or have completed the journey, you’ll still need to be making ongoing decisions about what’s best for your total data environment. Oracle’s latest pricing changes may lead you to think twice about your cloud decisions. If you’re running Oracle databases, don’t miss this post.

Three years in a row – Microsoft is a leader in the ODBMS Magic Quadrant

Gartner has positioned Microsoft in the Leaders Quadrant in the 2017 Magic Quadrant for Operational Database Management Systems again this year. This is the third year that Microsoft has been positioned farthest in completeness of vision and ability to execute in the operational database management systems market. Read more about it here.

Final service pack release for SQL Server 2012

SQL Server 2012 Service Pack 4 is now available for download. This upgrade is available to all customers with existing SQL Server 2012 deployments and contains a roll-up of released hotfixes as well as more than twenty improvements centered around performance, scalability, and diagnostics based on the feedback from customers and SQL community. Download it here.

Tutorial: Migrate your SQL Server database to Azure SQL Database

Moving your SQL Server database to Azure SQL Database is as simple as creating an empty SQL database in Azure and then using the Data Migration Assistant (DMA) to import the database into Azure. This tutorial explains how to:

  • Create an empty Azure SQL database in the Azure portal (using a new or existing Azure SQL Database server)
  • Create a server-level firewall in the Azure portal (if not previously created)
  • Use the Data Migration Assistant (DMA) to import your SQL Server database into the empty Azure SQL database
  • Use SQL Server Management Studio (SSMS) to change database properties.

View the tutorial here.

Ad-hoc query support in Azure Data Lake Tools for Visual Studio

Developers using Azure Data Lake Tools for Visual Studio can now create single U-SQL scripts without first creating a solution or project. Simply create a temporary U-SQL query without any parent project and solution. Find out more.

Azure SQL Data Warehouse Workload Patterns and Anti-Patterns

Thinking of using Azure SQL Data Warehouse? In this post, Microsoft detail a list of scenarios where Azure SQL Data Warehouse is not a suitable solution. Read on to get clarity on some of the concepts around RDBMS usage related to OLTP and OLAP workload, Symmetric Multiprocessing (SMP) and Massively Parallel Processing (MPP), workload patterns and anti-patterns, focusing on Azure SQL Data Warehouse.

Single Sign-On Support when connecting to data sources from the Power BI Service

With the latest On-Premise Gateway Data Release, it is now possible to use Single Sign-On when connecting to certain data sources using DirectQuery mode from Power BI. With Single Sign-On configured, queries execute under the identity of the user interacting with Power BI so each user sees precisely the data for which they have permissions in the underlying data source – no more shared data caching across different users. Find out more about Single Sign-On support here.