Data collector and policy-based management: part 2

  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 >

SQL 2016 – Improve Performance with the Query Store feature: Part 1

  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 >

Data collector and policy-based management: part 1

  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 >

SQL On The Edge #5 – custom visualizations in PowerBi

  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 >

Delayed durability and impact on mirroring

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 >

Implementing fuzzy search in SQL server – part 2: Levenshtein distance

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 >

Implementing Fuzzy search in SQL server

  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 >

SQL server row level security

  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 >

Running SQL server jobs against an Azure SQL database

  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 >

SQL On The Edge #4 – SQL 2016 Stretch Database

  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 >
Page 10 of 23« First Page...89101112...20...Last Page »