SQL Archives | Premier Developer

Azure SQL MI Replication – New Possibilities for Hybrid Environments

Premier DeveloperApril 15, 2019Apr 15, 201904/15/19

As customers continue to have more applications deployed in Azure, it’s common that data from those on-premises applications has to be shared with the new cloud applications or vise-versa. A simple batched methodology may be suitable for table data that is rarely updated, but for data that changes frequently, this may introduce an unacceptably high latency and undermine any data concurrency, expected by the business users.

One of the limitations of SQL Azure database is that it can’t support a SQL agent, so replication, while possible from on-premises to the cloud, is not available in the opposite direction. One solution is the use of the relatively new Azure SQL Database Managed Instance, SQL MI, that allows replication from the cloud replicated back to an on-premises SQL database.

SQL Server Objects as Software Artifacts

Premier DeveloperJune 21, 2018Jun 21, 201806/21/18

This post is provided by Premier Field Engineer JJ Jacob who takes a look at the benefits of SQL Server Objects as software artifacts.A recent customer engagement revealed several pain-points. One of them is the issue of not being able to pinpoint the exact database schema the development team delivered to the production team. The issue ...

Using JOIN with MAX to write efficient queries

Premier DeveloperMarch 3, 2018Mar 3, 201803/3/18

In this post, Senior Application Development Manager, Alexei Govorine, demonstrates how to use SQL JOIN and MAX in a query.How to join two SQL tables and display the latest results.Recently a customer has asked me to help them with a query design. The question was how to join two tables and display the latest results from one of them in ...

PolyBase – How SQL Server does Big data!

Premier DeveloperFebruary 12, 2018Feb 12, 201802/12/18

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 ...

SQL Server 2016 Express SP1 – Always Encrypted

Premier DeveloperOctober 18, 2017Oct 18, 201710/18/17

This post is provided by Senior App Dev Manager, Chris Tjoumas who provides an overview of Always Encrypted with SQL Server 2016. Introduction In this post, I want to focus on the Always Encrypted security feature of SQL Server 2016 SP1, specifically with the Express edition. This post is motivated by a customer who was hoping to ...

mySQL, POSTgreSQL DBs as a Service

Premier DeveloperAugust 9, 2017Aug 9, 201708/9/17

This post is from App Dev Manager, Omer Amin who spotlights mySQL and POSTgreSQL, both announced at BUILD this year.If you missed the announcement at BUILD earlier this year, Azure Database for MySQL and Azure Database for PostgreSQL provide fully-managed MySQL and PostgreSQL database as-a-service for easy development and deployment using ...

Factoring impact of SQL Secure Login Certificate Key Length on SQL Performance

Premier DeveloperMarch 7, 2017Mar 7, 201703/7/17

In this post, Application Development Managers, Lou Sawyer and Everett Yang spotlight the performance impact of certificate key length for login operations with SQL Server. The effect of RSA Key Length on CPU utilization during decryption is well documented. With a larger key size, we expect higher CPU utilization during decryption. ...

Random SQL Workload Generator

Monu BambrooMay 26, 2016May 26, 201605/26/16

In a recent post from his blog, Premier Developer Consultant Bradley Ball gives us a step-by-step overview of how to use SQL Server Random Workload Generator Many developers develop their own T-SQL, many DBA’s have to maintain that SQL. If you are looking for a way to generate a workload against a SQL Server to practice performance ...

Microsoft Cloud: Migrating Workloads and Security Planning

Premier DeveloperJune 4, 2015Jun 4, 201506/4/15

In this blog post, Application Development Manager, Lalit Patel, shares examples of customers working with Premier to overcome migration concerns and build confidence while moving workloads to the cloud. Cloud Adoption is underway as more organizations look for opportunities to optimize spending and reduce the operational cost ...

Premier Developer