Tag: sql server

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 >

Log Buffer #450: A Carnival of the Vanities for DBAs

This Log Buffer Editions picks few blog posts from Oracle, SQL Server and MySQL.

Read More >

Log Buffer #449: A Carnival of the Vanities for DBAs

  This Log Buffer Edition covers some of the niftiest blog posts from Oracle, SQL Server and MySQL.

Read More >

Implementing Fuzzy Search in SQL Server – Part 1

  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 >

Log Buffer #448: A Carnival of the Vanities for DBAs

This Log Buffer is dedicated to the top quality news from the arena of Oracle, SQL Server and MySQL.

Read More >

Log Buffer #447: A Carnival of the Vanities for DBAs

  This Log Buffer Edition covers the weekly blog posts of Oracle, SQL Server and MySQL.

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 >

Log Buffer #446: A Carnival of the Vanities for DBAs

This Log Buffer Edition covers some more Oracle, SQL Server and MySQL blog posts from across the world.

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 >