(Manoj) The adoption of public cloud computing services shows no signs of slowing down — Gartner predicted that the global public cloud services market will grow 17.3 percent in 2019 alone.

(FonsecaSergio) There are multiple ways to achieve this and there are also some storage types you should be aware

(Rick Dobson) Please provide frameworks with SQL code for assessing if a set of data values conform to normal or uniform distributions. Build on prior guidelines given for assessing goodness of fit to an exponential distribution.

(Pinal Dave) Have you ever imagined how often SQL Server performance issues are actually caused by poor capacity planning? Sometimes a SQL Server database has insufficient storage performance, an instance is running out of memory, or the server level CPU is skyrocketing to an unhealthy level.

(Joe Gavin) You need to automate running some SQL, but the is you need to run it directly on an Express Edition of SQL Server that doesn’t have the SQL Server Agent we know and love. How can you automate tasks for SQL Server Express?

(Grant Fritchey) What happens in Query Store when the database itself is READ_ONLY?

(Itzik Ben-Gan) In Closest Match, Part 1, I covered a T-SQL challenge that was provided to me by Karen Ly, a Jr. Fixed Income Analyst at RBC.

(Tibor Karaszi) You might know that statistics can have a high impact on performance. As you add, remove and modify data, the statistics will be more and more outdated.

(Pinal Dave) Today’s blog post is actually a follow up of my earlier blog post SQL SERVER – Copy Data From SSMS Query Result to Excel.

(Jason Brimhall) One probably seldom thinks of the SQL Agent jobs scheduled on the SQL Server instance – unless they fail. What if the job failed because something was changed in the job? Maybe you knew about the change, maybe you didn’t.