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.
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.
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 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.
Learn how to prevent the DACPAC from rebuilding all objects that once participated in transactional replication and have no changes in development.
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 ...
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...
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’s time ...
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. Let’...
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 work. Ma...
