(Thomas LaRock) A short time ago a colleague asked me where he could find a “Databases 101” guide for the non-technical professional. As it turns out, the internet is littered with information, and mis-information, regarding data and databases.

(Pinal Dave) During Comprehensive Database Performance Health Check, one of the DBas asked what is the most optimal value for Max Worker Threads. The question was indeed asked when my customer looked at the value of Max Worker Threads in the Processor sections of the Server Property, they were reall

(Jack Vamvas) Question: I’m logged onto a SQL Server 2016 instance using Windows Authentication and executing SELECT CURRENT_USER. Although I have sysadmin rights – the result always returns dbo.

(Lingxi Li) We are happy to announce that we have released a new version of SSIS Azure Feature Pack with a brand-new Azure Data Lake Analytics Task and enhanced Azure SQL DW Upload Task.

(Eli Leiba) How can we create a simple and dynamic SQL Server T-SQL script that will accept a string in of the form of ‘X1 Y1, X2 Y2, X3Y3,………,Xn Yn’ which is a textual representation of a two dimensional polygon. The x,y points are the values of the polygon from first to last where the first value

(Kenneth Fisher) When I think of the public role I often think of the guest database principal (user) at the same time. They aren’t really the same though. For one thing while you can’t remove either one, you can disable the guest and in fact for user databases this is recommended.

(Itzik Ben-Gan) This article is the fourth in a series about optimization thresholds. The series covers grouping and aggregating data, explaining the different algorithms that SQL Server can use, and the costing model that helps it choose between the algorithms.

(Pinal Dave) Question: How to DELETE Multiple Table Together Via SQL Server Management Studio (SSMS)?

(Denny Cherry) Setting up Transparent Data Encryption, or Backup Encryption, or basically anything else where you need to restore a certificate to another SQL Server instance can get tricky as soon as you run the instances under different service accounts.

(Pedro Lopes) If you follow this blog, you know that in the last couple years, we have been adding more information to showplan, to make it a one-stop-shop for all your query performance troubleshooting insights. You can see more about those showplan enhancements here.