(Jack Vamvas) I’m getting various questions about the Spectre and Meltdown impact on SQL Server. I’ll start listing the most popular questions and the response.

(Pedro Lopes) As I mentioned on yesterday’s post, with the recent release of SQL Server 2017 CU3, we released yet more showplan enhancements: you can see other posts related to showplan enhancements here.

(Pinal Dave) While preparing for a demo session for my client, I was playing with SQL Server backups on my lab server. I encountered an error which I am going to blog here. Here is the error about backup or restore history details.

(Jorg Klein) Many of my blog posts are focused on Azure cost reduction as this is essential to keep in mind when designing cloud solutions. Azure is a very cost-effective platform when it’s used in the right way, meaning you always have to consider the fact Azure is elastic and make sure your soluti

(Kenneth Fisher) Did you know SQL Server has a thing called a synonym? It’s not something you see used very often even though it’s been around for >10 years (SQL 2005). In fact, I’d be willing to bet that a good chunk of the people reading this have never (or just recently) heard of them.

(Pinal Dave) One of my customers recently reached out to me to help them out with a strange error which they were facing related to Add FileGroup. After carefully looking at the issues, we figured out that real issue was much deeper and very different.

(John Miner) The process of classifying a company into an industry segment has been around since the 1950’s. Wikipedia has listed several popular taxonomies that are in current use.

(Erin Stellato) How much time do you spend troubleshooting performance issues as a Database Administrator or Developer? Have you ever tracked it? As the average total percentage of your day, it may not look like a lot of time, but when the issue is serious, you can spend hours tracking it down and w

(ScottEpperly) Working with transactions in Azure SQL Data Warehouse (ADW) and the Analytics Platform System (APS, aka PDW) is a bit different than one would expect.

(Pinal Dave) Recently I have received a very interesting question in an email. The user wanted to know how will trigger behave when there are nested triggers. In an email, he described a scenario where trigger called another trigger. I really liked the question and immediately answered in the email