(blobeater) Ok, so Azure SQL doesn’t really have its own error log based somewhere on a machine within \MSSQLLog directory but the closest thing you will get is a system catalog view called sys.event_log which is very useful.

(Pinal Dave) While working on SQL Server Comprehensive Database Performance Health Check, with a client who uses many different SQL and NoSQL databases. During the consultation engagement, we ended up a very interesting query which actually runs faster on MongoDB and slows on SQL Server.

(Jason Brimhall) Some time ago, I wrote an article for SQL Server 2008 to help determine the use of the server since SQL Server 2008 was reaching End Of Life.

(John Miner) The development life cycle of an Extract, Translate and Load (ETL) process encompasses many phases. The Business Intelligence developer gathers the requirements from the business line and designs a package to transfer the data from point A to point B adhering to the time window that wa

(Pinal Dave) Today’s blog post is inspired by my earlier blog post SQL SERVER – Measure CPU Pressure – Detect CPU Pressure. I was recently asked during one of the consulting engagement Comprehensive Database Performance Health Check how do I actually measure the CPU for the entire server.

(Greg Robidoux) Have you ever wondered where SQL Server Management Studio (SSMS) gets its information from and how you can retrieve the same data without using SSMS? Well it’s not a big secret. Most of the information that is displayed in the GUI is based on information gathered from queries, but w

(Jack Vamvas) Question: What is the performance impact of enabling Transparent Data Encryption (TDE) on SQL Server database query performance? How can I measure the performance impact ?

(Pinal Dave) The reason, I love my job is that my audience. Every single day I work with new clients on the project Comprehensive Database Performance Health Check, I also discover new aspects of SQL Server. One of DBA recently asked is there any way to capture the execution plan for the canceled qu

(Greg Gonzalez) SQL Server has always provided the ability to capture live queries on an ad hoc basis in an easily-consumable rowset format – first with legacy SQL Server Profiler, later via Extended Events in SSMS.

(Gauri Mahajan) We introduced Azure Databricks, how it is created and some of its important components in my previous article here. We will look at how we can work with Azure Blob Storage in Azure Databricks in this article.