(lukaseder) What’s a good natural key?

(Rajendra Gupta) In the continuation of our SQL FILESTREAM article series, we’ll be covering transaction log backups

(Pinal Dave) During my recent SQL Server Performance Tuning Practical Workshop, someone asked, how do they know what is the automatically configured max worker threads for their machine.

(Derek Colley) As a database developer or DBA with a growing interest in data science, you have been tasked with creating a process to enable your organization to make predictions about their data using machine learning methods.

(Lindsay Moore) The first step in learning how to avoid deadlocks in SQL Server databases is preparedness. Knowing about deadlocks — in particular, what causes them — is the key to preventing them and resolving those that do occur, according to SQL Server experts.

(Kenneth Fisher) This month our intrepid host for T-SQL Tuesday is Shane O’Neill (b/t). He’s asked us to talk about our cookies. No not the kind you eat (Double Stuff Oreos and Thin Mints are the best of course) or even the kind that web sites use to store information.

(Pinal Dave) After finishing my lab and testing, I went to my client and they showed me error while setting up cloud witness. They showed me a different error then earlier.

(Jason Brimhall) A powerful little expression in SQL Server is the CASE statement. The CASE statement has the ability to “transform” data per business rules to help better understand the data in a given query.

(Tim Radney) Azure SQL Database is Microsoft’s database-as-a-service offering that offers a tremendous amount of flexibility and security and, as part of Microsoft’s Platform-as-a-Service, gets to take advantage of additional features.

(Michael J. Swart) A couple weeks ago, I wrote about how to find lonely tables in Sql Server. This is a follow up to that post.