Administrating SQL Server Reporting Services - Planning, Documenting and Troubleshooting

RIL_button( “http://sqlconcept.com/2011/11/22/administrating-sql-server-reporting-services-planning-documenting-and-troubleshooting/”, “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

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

November 22nd, 2011 | Tags: , , , , , , , , , , , , , | Category: SSRS, T-SQL | Comments are closed
Work on itWell, now...OKGoodGood job! (3 votes, average: 5.00 out of 5)

If you gave a rating less than the maximum, you must leave a comment with suggestions on how to improve the post. :)

Loading ... Loading ...

 

SQL Server parallelism on server level and MAXDOP

RIL_button( “http://sqlconcept.com/2011/06/18/sql-server-parallelism-on-server-level-and-maxdop/”, “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

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

June 18th, 2011 | Tags: , , , , | Category: CPU, Performance audit, Ramblings | 2 comments - (Comments are closed)
Work on itWell, now...OKGoodGood job! (2 votes, average: 5.00 out of 5)

If you gave a rating less than the maximum, you must leave a comment with suggestions on how to improve the post. :)

Loading ... Loading ...

 

Pave the shortcuts!

RIL_button( “http://sqlconcept.com/2011/05/14/pave-the-shortcuts/”, “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

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

May 14th, 2011 | Tags: , , , , , | Category: Disaster recovery, Some thoughts, SQL Server Wishlist | Comments are closed
Work on itWell, now...OKGoodGood job! (1 votes, average: 5.00 out of 5)

If you gave a rating less than the maximum, you must leave a comment with suggestions on how to improve the post. :)

Loading ... Loading ...