In my previous post we talked about the architecture of Policy-Based Management. In this post we will create and run a policy against some SQL Server Instances. Creating a Policy In SQL Server 2014 you are allowed to create a…
Read More >After playing with this great new feature for some time and speaking about it during a SQL Saturday in Montreal, I can say that I am very excited about Query Store in SQL 2016! Performance tuning is our bread and butter…
Read More >This article will address the main techniques for the efficient management of multiple instances in a SQL Server database 2014 using the Tools Data Collector and Policy-Based Management. In addition, it will be demonstrated in a practical way how…
Read More >Have you ever used Microsoft’s PowerBi service? If you have, have you used it within the last year? The reason I ask is that the current PowerBi service is so radically different from the initial release that pretty much only…
Read More >Objective To Test the delayed durability feature with mirroring in high performance and high safety mode. The idea is to confirm what the performance improvement is of the transaction and if it has any benefit in high latency networks. …
Read More >The Levenshtein Distance, as discussed in my last post, is a way to measure how far two strings are located from each other. There are several T-SQL implementations of this functionality, as well as many compiled versions. In addition, the…
Read More >Fuzzy Search in SQL Server is not done very well. This post will cover how to implement Fuzzy Search capabilities using several approaches. What is it? Fuzzy Search is the process to locate records that are relevant to…
Read More >Row Level Security (RLS) has been implemented in SQL Server 2016 for both on-premise and v12 of Azure instances. The problem this solves is: a company with multiple applications accessing sensitive data in one or more tables. How do…
Read More >I recently had a client ask how to run SQL Server jobs against an Azure SQL Database, and because SQL DB doesn’t have an SQL Agent like most other versions of SQL Server, it isn’t always obvious how to…
Read More >As the Microsoft SQL Server team continues to build very interesting integrations between the full SQL Server box product we all know and the Azure cloud platform. Stretch database is another integration that will be included as part of SQL…
Read More >