(Hadi Fadlallah) While building and deploying an SSAS OLAP cube, there are two processing orders that you can choose from when you create a process operation:

(Koen Verbeeck) I would like to know the number of rows affected by my SQL Server query. I know this is displayed as a message in SQL Server Management Studio, but I have to check the number of rows in an IF statement to verify if everything went alright. How can I do this in SQL Server?

(Haroon Ashraf) This is an introductory article about the Microsoft Report Builder tool which is used to build and manage paginated reports.

(Kenneth Fisher) I recently had someone tell me, and I’m paraphrasing a bit here:

(Pinal Dave) Has it ever happened to you that you have plenty of the CPU available event though there is a huge queue of Ruunable SPID? Just another day I worked on a consulting engagement Comprehensive Database Performance Health Check, and once we completed the task the server started to run amazi

(Chris Webb) Following on from my last two posts on Power Query performance, I thought I would write about another trick that can make a big difference to your query execution times.

(Eric Blinn) I need to know more about how SQL Server Agent Jobs and the supporting information stored in the MSDB database.

(Pinal Dave) Just yesterday, I received an email from a client who had hired me last year for Comprehensive Database Performance Health Check. While I worked with them last year, they were struggling with the performance of the server. We scientifically and strategically worked on their server and g

(Scott Murray) What are the topics I know now that wish I would have known when I started working with SQL Server Analysis Services, aka SSAS?

(blobeater) Do you execute DBCC CHECKDB on your Azure SQL Database? From past experience I know some people do, I would suggest not to bother.