Developer Support

Advocacy and Innovation

Azure SQL TDE failures – Activity log Alerts to rescue

May 22, 2020 May 22, 2020 05/22/20

Developer Support

The SQL Server connection to the Key Vault can be lost for various reasons of either the SQL Server (updates, backups etc..) or the Key Vault (Key expired, disabled etc.) Luckily Azure provides detailed logging and alerting through Azure Monitor Logs and Alerts.

In-Memory OLTP Best Practices – Part 2

May 6, 2020 May 6, 2020 05/6/20

Developer Support

This is a continuation of our first blog post where we shared our best practices and thoughts around the following key decisions you will make when deploying the In-Memory OLTP solution.

A How-To Guide For pssdiag and SQL Nexus: Creating a pssdiag Package

April 24, 2020 Apr 24, 2020 04/24/20

Developer Support

In this post, Sr. Consultant Kendal Van Dyke explores pssdiag and SQL Nexus, free tools from Microsoft that help you capture and analyze SQL Server performance data.

In-Memory OLTP Best Practices – Part 1

March 11, 2020 Mar 11, 2020 03/11/20

Developer Support

In this multi-part series, App Dev Manager Jon Guerin and Premier Consultant Daniel Taylor (@dbabulldog) lays out some best practices around setting up and using In-Memory OLTP.

DACPAC always changes previously replicated tables on the target

December 29, 2019 Dec 29, 2019 12/29/19

Developer Support

Learn how to prevent the DACPAC from rebuilding all objects that once participated in transactional replication and have no changes in development.

Audit SQL Server stop, start, restart

March 27, 2018 Mar 27, 2018 03/27/18

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

PolyBase – How SQL Server does Big data!

February 12, 2018 Feb 12, 2018 02/12/18

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

Microsoft’s Geospatial Capabilities

January 30, 2018 Jan 30, 2018 01/30/18

Pam Lahoud

In a recent article published on LinkedIn, Premier Developer consultant Ron Vincent highlights some of Microsoft’s geospatial capabilities, both past and present.Microsoft has for some time now had some level of geospatial capabilities but since Azure has come along there has been many developments on this front. In this article, I think it...

The High Availability Conversation Part 1: Introduction

February 3, 2017 Feb 3, 2017 02/3/17

Monu Bambroo

In this post, Senior Consultant, Bradley Ball discusses High Availability for SQL Server. In this latest blog post PSfD Consultant Bradley Ball begins the High Availability Conversation based off of a question on Twitter. He answers the questions what do the Three Bears have to do with HA planning and the business users and IT management...

SQL Server 2016: It Just Runs Faster

October 20, 2016 Oct 20, 2016 10/20/16

Developer Support

Does the marketing live up to the hype? Senior ADM, Paul King shares some perspective from the field. Upgrading between major versions of a product can sometimes be a painful and time consuming task. Development organizations often have to spend time going over depreciated feature lists to make sure that their applications will still ...

Developer Support

SQL Server - Developer Support