(Sergey Gigoyan) Undoubtedly, having properly designed SQL Server database backup solutions is crucial for any company. Having discussed database Maintenance Plans in the previous two articles (here and here) from this series, in this article, we are going to explore how to implement database backu

(Chris Webb) Very occasionally you may find that a report that is slow to render – but still renders successfully – in Power BI Desktop shows the error “Visual has exceeded the available resources” for some visuals when published to the Power BI Service:

(Pinal Dave) If you search on the internet, you will find various combinations of missing services. One of the common situations is to have ALL SQL related services missing from SQL Server Configuration Manager.

(blobeater) Wouldn’t it be nice if we could access one main dashboard / report that pulls in information from many tools such as security centre, SQL advisor and cost management tools?

(Rick Dobson) I recently was tasked with tracking and monitoring views in the SQL Server databases that I administer. Among the attributes that I am required to track are code module name, defining T-SQL for a module, created and last modified dates, and last run datetime. Please demonstrate how t

(Pinal Dave) It has been a while since I have been working with SQL Server 2019 with my clients to help them with performance-related issues while working on Comprehensive Database Performance Health Check. Recently, I had a very interesting conversation with one of my clients about Cardinality Esti

(Eli Leiba) The PIVOT operator (or “cross-tab” operation) is a very handy tool in SQL Server, but its main limitation is that you often don’t know the values that you need to pivot on.

(Nisarg Upadhyay) In this article, I will explain the process of installing pre-requisites to deploy the SQL Server AlwaysOn availability group.

(Pinal Dave) Many times, I feel that I have so many blogs that I must have covered all common possible error related to the usage of SQL Server. But it looks like there are few easy ones which I missed.

(Grant Fritchey) I know, I know, I’m on #teamexevents so I think that Extended Events can do no wrong, but let’s address this thought that Profiler is easier.