Tag: sql server

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 >

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

  The show goes on. This Log Buffer Edition picks some blogs which are discussing new and old features of Oracle, SQL Server and MySQL.

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 >

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 >