(Kenneth Fisher) Always be learning right? So when I saw this I had to go HU?! That’s new. What’s going on here?

(Jason Brimhall) When SQL Server 2005 was released, a nifty little feature was included called synonyms. Despite being around since SQL Server 2005, I think this feature is often under-utilized or, more importantly, it is implemented in a very bad way.

(Marcin Policht) Transitioning to the Platform-as-a-Service model typically implies relinquishing certain degree of control over your computing environment.

(Diogo Souza) Most of the times that we need to optimize a SQL Server query, a lot of questions and uncertainties come to our minds, just like if we could use any tool that would help with this type of improvement not only regarding the performance itself, but also in structural terms like with inde

(blobeater) I wrote a guest article for an IT consultancy on Azure SQL Database, more specifically DTUs and vCore options. At a high level I discuss what both options are, the differences and what you should select.

(Jack Vamvas) Question: I’m getting the The transaction log for database is full due to LOG BACKUP Error 9002 Severity 17 State 2 error message .

(Pinal Dave) Azure is gaining popularity and I am getting clients who want to create Always On availability group as their high availability solution in Azure Virtual machine.

(Chris Webb) The order of the columns in a table in a Power BI dataset doesn’t matter all that much, especially because the Fields pane in Power BI Desktop ignores the original column order and lists the columns in a table in alphabetical order.

(Rajendra Gupta) In this article, we will explore SQL Server Profiler in Azure Data Studio in detail including download and installation, execution plans, coding T-SQL and more.

(Kenneth Fisher) Microsoft does a lot of things to try to help us not shoot ourselves in the foot. This little error is one of them. It’s an annoying error, and almost everyone turns it off automatically, so what is it and why is it there?