Dev Consultant Julien Oudot demonstrates how to automate the testing of a data layer in ASP.NET Core WEB API with Cosmos DB.
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.
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,
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.
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.
This post is provided by Senior App Dev Manager, Chris Tjoumas who provides an overview of Always Encrypted with SQL Server 2016.
In this post, I want to focus on the Always Encrypted security feature of SQL Server 2016 SP1,
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 languages customers prefer,
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, Senior Application Development Manager, Patrick King shares a SSRS tip to help control report item order when it differs from what you may see in VS designer.
I recently worked with a customer developing a SQL Server Reporting Services (SSRS) report that was rendering in a different order than what appeared in the designer in Visual Studio 2013.
Senior Application Development Manager, Deepak Malik, explains the Query caching behavior, performance implications, and extensibility provided in the latest release of Entity Framework
Caching entities or query results has been a recommended practice for application development to improve an application’s performance especially in data centric applications.