(Hadi Fadlallah) There are many operations that we may run while working with OLAP cubes such as cube and partitions processing, executing administrative tasks, performing analysis and more…

(Kenneth Fisher) The other day I saw a weird option for the UPDATE command in a stack overflow answer. Basically it looked like this:

(Pinal Dave) Earlier this week, I wrote a blog post about SQL SERVER – Top Reasons for Slow Performance. The blog post got extremely popular as it contained many real-world problems and suggestions. After the blog post was released, I received quite many emails and questions.

(Maria Colgan) I got a lot of follow-up questions on what Query Block names are and how to find them, after my recent post about using SQL Patches to influence execution plans.

(Ron L’Esteve) The need to process Big Data Real-Time streams is becoming an increasing need for many businesses. Customers in numerous industries are seeking to harness the power of real-time big data to unlock valuable insights.

(Thomas LaRock) I’ve written before about using sqlmap to perform sql injection testing against a website. It is also possible to use sqlmap to connect directly against a database.

(Pinal Dave) The journey of consulting is always a fun one with lots of learning. Recently during the Comprehensive Database Performance Health Check, I had a great conversation about how to disable Parameter Sniffing and DISABLE_PARAMETER_SNIFFING Query Hint.

(Grant Fritchey) The single most important thing to remember about Extended Events is that this functionality is not simply a replacement for Profiler/Trace, but a whole new tool with new functionality.

(Mircea Dragan) There are situations when we need the structure of a SQL Server database and database objects for further processing. For example, when we want to create a skeleton of the database in a different location (i.e. computer, SQL Server, etc.), or when we want to make sure that the databa

(Pinal Dave) SQL Server 2019 is indeed very well made software by Microsoft. Recently, I have a very interesting situation while working with SQL Server 2019, which I had not faced before about OPTION(FAST N). While busy with Comprehensive Database Performance Health Check, I did not have access to