Administrating SQL Server Reporting Services - Planning, Documenting and Troubleshooting

I just had another article published at simple-talk.com: “Administrating SQL Server Reporting Services – Planning, Documenting and Troubleshooting“.

The article is a deep dive into the configuration, security and performance of SSRS and is closely related to the SSRS Performance Dashboard which I recently developed.

 

Feel free to explore the article and to take a look at

Continue reading […] Administrating SQL Server Reporting Services – Planning, Documenting and Troubleshooting […]

 

How to query currently running SQL Server Agent jobs

Today I went on a quest to discover a way to list all currently running SQL Server Agent jobs. As every other quest, this one also started with Google-ing.

Within 2 minutes I found this great post by Brent Ozar on SQLServerPedia. Why is this post so great? It is so great because Brent figured

Continue reading […] How to query currently running SQL Server Agent jobs […]

 

SQL Server parallelism on server level and MAXDOP

Recently, at a SQL Server conference, the parallelism topic was brought up. One of the participants in the conversation expressed opinion that once the parallelism for the SQL Server instance is disabled, there is no way a query will be executed in parallel.

At the time I just expressed my doubt and my hope that this

Continue reading […] SQL Server parallelism on server level and MAXDOP […]