Tag: sql server

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 >

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

This Log Buffer edition works it way through some of the coolest blog posts from Oracle, SQL Server and MySQL of the past week.

Read More >

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

This Log Buffer Edition covers some blog posts of Oracle, SQL Server and MySQL from this past week.

Read More >

SQL Server Fast Food

  An environment where you have a high number of databases on one server, or many, can be time consuming to something as simple as adding a user account. You have the option of using the GUI with SQL Server Management…

Read More >

Issues with Plan Cache Reuse & Row Goal Optimization

  I am presenting here on behalf of my colleague  Fabiano Amorim (he is busy resolving other exciting performance issues…  :-D ) . Fabiano had an interesting case with one of our customers that is very common in SQL Server. The…

Read More >