(Greg Larsen) Have you ever heard of the identity cache? If not, it is just a cache that stores the next 1000 available identity cached values for a table.

(Pinal Dave) I always blog about things which are new and updated but today we are going to write about something which is very old and it is near deprecated.

(blobeater) Before writing about pausing (and resuming) Azure SQL Data Warehouse (DW) it makes sense to discuss the architecture of this product.

(Kenneth Fisher) I was asked the other day why a customer was having performance issues on a table. A simple SELECT that only returns 1134 rows was taking over a minute!

(K. Brian Kelley) I have a SQL Server database for which I need to do a point-in-time restore. However, I’m unable to take a transaction log backup, as SQL Server gives me an error when I try to create a log backup.

(Pinal Dave) Today we will see a free online video which I did for DBA Fundamentals Virtual Chapters for PASS. The title of the video is 3 Performance Tuning Tricks you Always Wanted to Know.

(Alejandro Cobar) In previous tips of this series (tip 1, tip 2 and tip 3) I presented a couple of tools that can help you to perform the failover of databases under your care, along with the status of each of the databases.

(Chris Webb) One of the most popular blog posts I have written in recent years is this post on how the RelativePath and Query options for the Web.Contents() M function can be used to allow datasets that use web services as data sources to refresh successfully in the Power BI Service.

(Itzik Ben-Gan) This article is the second in a series about T-SQL bugs, pitfalls and best practices. This time I focus on classic bugs involving subqueries.

(Pinal Dave) Today I am starting a week-long series where I will be discussing various SQL Server Monitoring Tools. My primary aim is to help people with my consulting workshop Comprehensive Database Performance Health Check. While I help customers with their various SQL Server performance issues, I