(Jason Brimhall) One of the beauties of using a tool such as Extended Events (XEvents) is the versatility and ease of use. XEvents can be used for so many things to help an aspiring DBA or Developer do their job better.

(Pinal Dave) I was recently helping my client to SQL recovery from a hardware failure. I have implemented a good backup strategy for them, and things were easy.

(Gauri Mahajan) Data exploration and aggregation are two significant aspects of data analysis while processing with transactional data stored in SQL Server with R for statistical inferences.

(Pinal Dave) This blog would be useful for those who are recovering from a disaster and are trying to rebuild system databases for SQL Server.

(Chris Webb) Recently I found I needed to remove all the HTML tags from some text in Power Query.

(Eric Blinn) I want to learn more about the SQL Server MSDB database and what it can offer me as a DBA.

(Grant Fritchey) In my last post I showed how you can create a volume with your container. I then showed a few things you can with a container using a volume. I want to explore volumes just a little bit more.

I found out that my employee is constantly going on interviews with other companies. Do I fire him?

(Grant Fritchey) A question that comes up on the forums all the time: Which query used the most CPU. You may see variations on, memory, I/O, or just resources in general.

(Gauri Mahajan) In this article we’ll review the SQL varchar data type including a basic definition and overview, differences from varchar(n), UTF-8 support, Collation, performance considerations and more.