(Kenneth Fisher) When it comes to migrating applications to Azure, there are a number of paths available.

(Edwin Sarmiento) Our company has started evaluating Containers to modernize our SQL Server databases. I have deployed SQL Server 2017 RTM on Linux for our development environments and would like to get it updated. How do I update my SQL Server 2017 on Linux containers?

(Pinal Dave) Recently one of my oldest clients of Comprehensive Database Performance Health Check asked me a very interesting question about a table variable and SELECT INTO. The question was it is possible to do SELECT INTO a Table Variable in T-SQL?

(Ron L’Esteve) The process of moving data from an on-premises SQL Server to Azure Data Lake Storage has become an ever increasing and vital need for many businesses. Customers with numerous on-premises SQL servers along with hundreds of databases within these servers are interested in leveraging Azu

(Erin Stellato) A performance tuning engagement can end up taking many turns as you work through it – it all depends on what is showing up as the problem and what the data tells you.

(Pinal Dave) One of the very popular questions I receive is how to import data from Excel in SQL Server. Let us learn about that in this blog post and we will use SQL Server Management Studio for this exercise.

(blobeater) The full message when connecting to your Azure SQL Database is: Reason: An instance-specific error occurred while establishing a connection to SQL Server.

(Emil Drkusic) You can create several user-defined objects in a database. One of these is definitely user-defined functions. When used as intended, they are a very powerful tool in databases. In today’s article, we’ll see how to create, change and remove them from the database, as well as how to use

(John Miner) I hope you noticed the similarity of the article’s title to a famous novel named “The tale of two cities” by Charles Dickens. This novel is Dicken’s best-known work of historical fiction, with over 200 million copies sold and is regularly cited as the best-selling novel of all time. I

(Chris Webb) Back in December when I wrote a series of posts on testing the performance of Power BI reports in the browser, I mentioned that it was important to test in the browser because some aspects of the performance of a report may be different there compared to in Power BI Desktop.