(Cloud) Tip of the Day: Announcing VNet service endpoints general availability for MySQL and PostgreSQL

Today’s tip… We recently made Azure database services for MySQL and PostgreSQL generally available. These services offer the community versions of MySQL and PostgreSQL with built-in high availability, a 99.99 percent availability SLA, elastic scaling for performance, and industry-leading security and compliance on Azure. Since general availability, we have continued to bring new features and…


(Cloud) Tip of the Day: New Azure SQL DB Features

Today’s tip… Use read-only replicas to load balance read-only query workloads (preview) Read Scale-Out allows you to load balance Azure SQL Database read-only workloads using the capacity of read-only replicas. SQL Database: Long-term backup retention preview includes major updates More regional support – Long-term retention will be supported in all Azure regions and national clouds….


Tip of the Day: Free eBook Time Again

Today’s Tip… Your options include: Windows 10 Office 2016 and O365 PowerBI Azure System Center/Cloud SQL And a bunch more! Available here: “Largest FREE Microsoft eBook Giveaway! I’m Giving Away MILLIONS of FREE Microsoft eBooks again, including: Windows 10, Office 365, Office 2016, Power BI, Azure, Windows 8.1, Office 2013, SharePoint 2016, SharePoint 2013, Dynamics…


(SQL) Tip of the Day: Large row support

Today’s Tip… Support for large rows has been a frequent ask from our users. This update adds support for rows larger than 32K and data types over 8K. Large row support adds support for varchar(max), nvarchar(max) and varbinary(max). The addition of these data types makes it even easier to migrate to the cloud by allowing…


(SQL) Tip of the Day: Using Elastic Jobs for day to day tasks

Today’s Tip… Elastic Database Jobs are a great way to schedule actions in SQL Azure that can be run via TSQL. I have created a script that will help you create a scheduled job to automatically scale your database up and down on a schedule. You should be able to use this as a template…


(SQL) Tip of the Day: Azure Data Warehouse Supports Azure Active Directory Logins

Today’s Tip… As of May 31st now Azure Data Warehouse can utilize Azure Active Directory for logins. This uses contained database users in your ADW and allows your users to login via their AAD credentials. You can even add groups! You can see more information here: https://azure.microsoft.com/en-us/documentation/articles/sql-data-warehouse-get-started-connect-aad-authentication/


(SQL) Tip of the Day: SQL 2016 Released June 1st

Today’s Tip… SQL 2016 has been released as of June 1st! You can read all about it from the SQL Server Blog here: https://blogs.technet.microsoft.com/dataplatforminsider/2016/06/01/sql-server-2016-is-generally-available-today/ There are a number of new features in SQL 2016 including R language support, Stretch Database, and Query Store.


(SQL) Tip of the Day: Improving Azure DW Insert Performance

Today’s Tip… We have had a few cases recently with users concerned with their write performance on Azure DW. What we have found is that the backend distribution databases are designed for fast reading but can have some slower inserts. TempDB for Azure DW though uses very write efficient storage. What we have found is…


(SQL) Tip of the Day: Import AdventureWorks to SQL Azure

Today’s Tip… Steps to import AdventureWorks database to SQL Azure :- New portal has sample database to import but seems like it has only few tables. Steps to use the sample database from portal are here – https://blogs.msdn.microsoft.com/kaevans/2015/03/06/adventure-works-for-azure-sql-database/ currently outlined method is not working from the codeplex link. Below are the modifications done to make…