Skip to main content
Microsoft
Developer Support
Developer Support
  • Home
  • DevBlogs
    • Visual Studio
    • Visual Studio Code
    • Visual Studio for Mac
    • DevOps
    • Developer support
    • CSE Developer
    • Azure SDK
    • IoT
    • Command Line
    • Perf and Diagnostics
    • Dr. International
    • Notification Hubs
    • Math in Office
    • DirectX
    • PIX
    • SurfaceDuo
    • Startups
    • Sustainable Engineering
    • C++
    • Java
    • Java Blog in Chinese
    • JavaScript
    • PowerShell Community
    • PowerShell Team
    • Python
    • Q#
    • TypeScript
    • Visual Basic
    • Visual C#
    • Visual F#
    • .NET
    • ASP.NET
    • NuGet
    • Xamarin
    • #ifdef Windows
    • Apps for Windows
    • Azure Depth Platform
    • Azure Government
    • Bing Dev Center
    • Microsoft Edge Dev
    • Microsoft Azure
    • Office 365 Development
    • Old New Thing
    • Windows MIDI and Music dev
    • Windows Search Platform
    • Azure Cosmos DB
    • Azure Data Studio
    • Azure SQL
    • OData
    • Revolutions R
    • SQL Server Data Tools

    Developer Support

    Services for Microsoft Premier and Unified Support Customers

    SQL Archives | Developer Support

    Azure SQL MI Replication – New Possibilities for Hybrid Environments
    Azure SQL MI Replication – New Possibilities for Hybrid Environments
    Premier Developer Premier Developer April 15, 2019 Apr 15, 2019 04/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.

    Comments are closed.0AzureAzure SQL
    SQL Server Objects as Software Artifacts
    SQL Server Objects as Software Artifacts
    Premier Developer Premier Developer June 21, 2018 Jun 21, 2018 06/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 ...

    Comments are closed.0SQLSSDT
    Using JOIN with MAX to write efficient queries
    Using JOIN with MAX to write efficient queries
    Premier Developer Premier Developer March 3, 2018 Mar 3, 2018 03/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 ...

    1SQLTeam
    PolyBase – How SQL Server does Big data!
    PolyBase – How SQL Server does Big data!
    Premier Developer Premier Developer February 12, 2018 Feb 12, 2018 02/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 ...

    Comments are closed.0PolyBaseSQL
    SQL Server 2016 Express SP1 – Always Encrypted
    SQL Server 2016 Express SP1 – Always Encrypted
    Premier Developer Premier Developer October 18, 2017 Oct 18, 2017 10/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 ...

    Comments are closed.0SQLTeam
    mySQL, POSTgreSQL DBs as a Service
    mySQL, POSTgreSQL DBs as a Service
    Premier Developer Premier Developer August 9, 2017 Aug 9, 2017 08/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 ...

    Comments are closed.0AzuremySQL
    Factoring impact of SQL Secure Login Certificate Key Length on SQL Performance
    Factoring impact of SQL Secure Login Certificate Key Length on SQL Performance
    Premier Developer Premier Developer March 7, 2017 Mar 7, 2017 03/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. ...

    Comments are closed.0CertificatesSQL
    Random SQL Workload Generator
    Random SQL Workload Generator
    Avatar Monu Bambroo May 26, 2016 May 26, 2016 05/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 ...

    Comments are closed.0SQLTeam
    Microsoft Cloud: Migrating Workloads and Security Planning
    Microsoft Cloud: Migrating Workloads and Security Planning
    Premier Developer Premier Developer June 4, 2015 Jun 4, 2015 06/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 ...

    Comments are closed.0AdvisoryAzure
    Relevant Links

    About Us

    Microsoft Unified Support

    Contact Us

    Case Studies

    Join our Team


    Content issues or broken links?  Please leave a comment or send us a note!

    Top Bloggers
    Premier Developer

    Premier Developer

    Archive
  • March 2021
  • February 2021
  • January 2021
  • December 2020
  • November 2020
  • October 2020
  • September 2020
  • August 2020
  • July 2020
  • June 2020
  • May 2020
  • April 2020
  • March 2020
  • February 2020
  • January 2020
  • December 2019
  • November 2019
  • October 2019
  • September 2019
  • August 2019
  • July 2019
  • June 2019
  • May 2019
  • April 2019
  • March 2019
  • February 2019
  • January 2019
  • December 2018
  • November 2018
  • October 2018
  • September 2018
  • August 2018
  • July 2018
  • June 2018
  • May 2018
  • April 2018
  • March 2018
  • February 2018
  • January 2018
  • December 2017
  • November 2017
  • October 2017
  • September 2017
  • August 2017
  • July 2017
  • June 2017
  • May 2017
  • April 2017
  • March 2017
  • February 2017
  • January 2017
  • December 2016
  • November 2016
  • October 2016
  • September 2016
  • August 2016
  • July 2016
  • June 2016
  • May 2016
  • April 2016
  • March 2016
  • February 2016
  • January 2016
  • December 2015
  • November 2015
  • October 2015
  • September 2015
  • August 2015
  • July 2015
  • June 2015
  • May 2015
  • April 2015
  • March 2015
  • February 2015
  • January 2015
  • December 2014
  • November 2014
  • October 2014
  • September 2014
  • May 2014
  • March 2014
  • May 2013
  • January 2013
  • December 2012
  • June 2012
  • August 2011
  • February 2010
  • October 2008
  • September 2008
  • August 2008
  • April 2008
  • February 2008
  • January 2008
  • December 2007
  • November 2007
  • October 2007
  • September 2007
  • August 2007
  • July 2007
  • June 2007
  • Stay informed

    Login
    Code Block
    What's new
    • Surface Duo
    • Surface Laptop Go
    • Surface Pro X
    • Surface Go 2
    • Surface Book 3
    • Microsoft 365
    • Windows 10 apps
    • HoloLens 2
    Microsoft Store
    • Account profile
    • Download Center
    • Microsoft Store support
    • Returns
    • Order tracking
    • Virtual workshops and training
    • Microsoft Store Promise
    • Financing
    Education
    • Microsoft in education
    • Office for students
    • Office 365 for schools
    • Deals for students & parents
    • Microsoft Azure in education
    Enterprise
    • Azure
    • AppSource
    • Automotive
    • Government
    • Healthcare
    • Manufacturing
    • Financial services
    • Retail
    Developer
    • Microsoft Visual Studio
    • Windows Dev Center
    • Developer Center
    • Microsoft developer program
    • Channel 9
    • Microsoft 365 Dev Center
    • Microsoft 365 Developer Program
    • Microsoft Garage
    Company
    • Careers
    • About Microsoft
    • Company news
    • Privacy at Microsoft
    • Investors
    • Diversity and inclusion
    • Accessibility
    • Security
    English (United States)
    • Sitemap
    • Contact Microsoft
    • Privacy
    • Manage cookies
    • Terms of use
    • Trademarks
    • Safety & eco
    • About our ads
    • © Microsoft 2021