(Maria Colgan) Oracle Autonomous Database automates the lifecycle management of a database, everything from provisioning, scaling, backups and patching, but what it doesn’t do yet is fully tune your application.

(Aakash Patel) Occasionally a SQL Server encounters a performance problem which can’t be addressed by just optimizing problematic code or tweaking some server level settings. In those situations, we must take a holistic approach for identifying the resource bottleneck.

(Daniel Janik) Recently I ran into an error when trying to copy a small database bacpac into an Azure Managed Instance. It’s said that SSMS is able to do this task. Let’s see it in action.

(Itzik Ben-Gan) This article is the first in a series about the fundamentals of table expressions in T-SQL.

(Pinal Dave) One of my clients contacted me and asked me the reason for this message? And my first reaction was, did you keep the database in very cold weather?

(Rick Dobson) Collecting stock symbol data over multiple years can allow you do to time series analysis on stock prices. In this tip we look at how to download stock prices for all stocks over a set period of time and load the data into SQL Server for analysis.

(Chris Webb) Back in 2018, when I wrote a detailed post on how to create nested display folders for measures in Power BI, I mentioned that unlike in Analysis Services it was not possible to make a Power BI measure appear in two or more folders simultaneously.

(Pinal Dave) The other day, I had a very interesting conversation with one of my clients about Scheduler_ID With a Large Number in dm_os_schedulers while working with the Comprehensive Database Performance Health Check.

(Hannes du Preez) The following command shrinks the size of the data and log files in a database.

(Grant Fritchey) One reason a lot of people don’t like Extended Events is because the output is in XML. Let’s face it, XML is a pain in the bottom.