(Pinal Dave) If you have learned about the new features of SQL Server 2019, you might already know about this feature called “memory-optimized tempdb metadata”.

(Daniel Janik) Let’s talk about what XLOCK is supposed to do. XLOCK is a table hint that can be applied to a query to place an exclusive lock on the resources that the query accesses.

(Ron L’Esteve) The recent hype of AI in the tech industry is digitally disrupting organizational goals while empowering the way we approach business and pleasure in our daily lives.

(Itzik Ben-Gan) This article is the third installment in a series on NULL complexities. In Part 1 I covered the meaning of the NULL marker and how it behaves in comparisons.

(Pinal Dave) When I searched for this topic, I was getting blogs where they were talking about additional logging for the job step in SQL Server Agent jobs. In this blog, I would share my learning about logging about SQL Server Agent itself.

(Thomas LaRock) At SQL Server Live last November, I demonstrated enabling SQL Audit for Azure SQL Database. During the class discussion I explained you must use Powershell to modify SQL Audit for Azure SQL Database. So, that’s my post today, showing you how it is done.

(Semjon Terehhov) What Power BI queries do to an underlying SQL Server data warehouse can be both complicated and confusing to understand. I am writing this tip to help DBAs and developers get the most out of their resources and avoid service degradation over time by providing an indexing strategy f

(Pinal Dave) Recently, I was reached out by one of the my financial technology clients based out of the USA who has just launched their services in India. Their system worked fine in most of the area but the challenge was to display the Indian currency sign.

(Carlos Robles) Developers often need new SQL Server instances with production data to start or continue working on their projects. Having shared SQL Server database environments often leads to resource contention and confusion.

(Kenneth Fisher) If you read the title to this post and your first thought was That’s not SQL is it? then you had the same first thought I did when I saw it.