Bias, the Serial Killer of Diversity

Today we have a guest editorial from Kellyn Pot'Vin that tackles the tough topic of diversity.

Dynamically Query a 100 Million Row Table-Efficiently

This article describes methods of creating dynamic queries without the use of dynamic SQL to efficiently access large tables.

Automatically Creating UML Database Diagrams for SQL Server

SQL Server database developers seem reluctant to use diagrams when documenting their databases. It is probably because it has, in the past, been difficult to automatically draw precisely what you want, other than a vast Entity-relationship diagram. However, you can do it without buying any third-party tool, just using some existing Java-based open-source tools; and can even automate it entirely, using SQL and PowerShell. Phil Factor shows how.

Diagnosing parallelism-related latching

Diagnosing and resolving parallelism-related latching and blocking in SQL Server using DMV’s, the activity monitor, procedure execution plans, and index tuning.

Should I Stay or Go?

Today we have a guest editorial from Andy Warren that looks at the decision to leave a job. Or not.

A tour through tool improvements in SQL Server 2016

Ayo Olubeko talks through the improvements being made to SQL Server tooling in 2016.

Byte Me: Forget It

Implementing Azure SQL Database Elastic Database Jobs

Sometimes it's good to re-think how to write a query; set operations can provide performance benefits over 'straight SQL'. In this article, David Fitzjarrell takes a look at one such example in action.

The Clustered Index is not the Primary Key

As the title says, the clustered index doesn't have to the primary key and vice versa.

Inside-SQL Conference: SQL Server Deep Dives in London

14th June, Londo, UK - Inside-SQL conference offers deep dives on a range of SQL Server topics, with tracks focusing on DBAs, Developers and BI.

Use the discount code "Redgate" for £40 off the price of a ticket.