Showing results for Data - Developer Support

Nov 14, 2018
Post comments count0
Post likes count0

Synchronizing Azure Cosmos DB Collections for Blazing Fast Queries

Developer Support
Developer Support

While Cosmos DB offloads many of the hard NoSQL scaling problems, shaping your data and choosing a logical partition key are left to you. The partition key choice is arguably the most important decision you’ll need to make – it cannot be changed and must be determined upon creation of a collection.

TeamAzureCosmosDB
Nov 8, 2018
Post comments count0
Post likes count0

Azure Cosmos DB Pricing Overview

Developer Support
Developer Support

My customers have spent some time working with Azure Cosmos DB and had questions around pricing. I thought I would share a bit of what I have learned when it comes to pricing for Cosmos DB for this BLOG article.

TeamAzureCosmosDB
Sep 27, 2018
Post comments count0
Post likes count0

Cosmos DB Emulators can also run in the Cloud

Developer Support
Developer Support

Dev Consultant Julien Oudot demonstrates how to automate the testing of a data layer in ASP.NET Core WEB API with Cosmos DB.

Team.NET CoreCosmosDB
Jun 21, 2018
Post comments count0
Post likes count0

SQL Server Objects as Software Artifacts

Developer Support
Developer Support

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

TeamSQLSSDT
Mar 27, 2018
Post comments count0
Post likes count0

Audit SQL Server stop, start, restart

Developer Support
Developer Support

In this article, Application Development Manager Steve Keeler outlines an approach for determining the domain identity of a user who has initiated a stop, start, or restart request on SQL Server services. Although SQL Server contains server and database auditing functionality as part of the product, this cannot be used to determine the identity of ...

TeamALMTFS
Mar 3, 2018
Post comments count1
Post likes count0

Using JOIN with MAX to write efficient queries

Developer Support
Developer Support

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

TeamSQL
Feb 12, 2018
Post comments count0
Post likes count0

PolyBase – How SQL Server does Big data!

Developer Support
Developer Support

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

TeamSQL ServerSQL
Oct 18, 2017
Post comments count0
Post likes count0

SQL Server 2016 Express SP1 – Always Encrypted

Developer Support
Developer Support

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

TeamSQL
Aug 9, 2017
Post comments count0
Post likes count0

mySQL, POSTgreSQL DBs as a Service

Developer Support
Developer Support

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

TeamAzureSQL
Jul 1, 2017
Post comments count0
Post likes count0

An overview of SSDT

Developer Support
Developer Support

This post is provided by Senior App Dev Manager, Fadi Andari who provides some history around Data Tools and a practical walk-through of SSDT.I am the first to admit that the SQL Server/Visual Studio relation has been very confusing for the past few years especially when it comes to Data Tools and Source Control. In this post, I will focus on the t...

TeamSSDT