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 […]

 

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 […]

 

Pave the shortcuts!

Here is a real life example of a great concept: great unpaved shortcuts in their glory.

Pave the shortcuts!

The reality is that if there is a well-stomped shortcut somewhere, then it should definitely be paved. After all, it is well-stomped because many have taken it. And if many have taken a shortcut, this means

Continue reading […] Pave the shortcuts! […]