Check out my Technet webcast on Building SQL Server Reporting Services 2008 Large-Scale Solutions. In this webcast, you learn about successful configuration and architecture principles to maximize the scalability of your enterprise Microsoft SQL Server 2008 Reporting Services (SSRS) environment. Join us as we provide you details, based on real customer scenarios, on how to make the most of your SSRS 2008 environment. Have fun!
Month: October 2008
Technet Webcast: Building SQL Server Reporting Services 2008 Large-Scale Solutions
Check out my Technet webcast on Building SQL Server Reporting Services 2008 Large-Scale Solutions. In this webcast, you learn about successful configuration and architecture principles to maximize the scalability of your enterprise Microsoft SQL Server 2008 Reporting Services (SSRS) environment. Join us as we provide you details, based on real customer scenarios, on how to make the most of your SSRS 2008 environment. Have fun!
Reporting Services Scale-Out Deployment Best Practices
Check out the the third of five technical note as part of the Building and Deploying Large Scale SQL Server Reporting Services Environments Technical Note Series: Reporting Services Scale-Out Deployment Best Practices This technical note reviews the SSRS Scale-Out Architecture Report Catalog sizing The benefits of File System snapshots for SSRS 2005 Why File System snapshots may not help for SSRS 2008 Using Cache Execution Load Balancing your Network Isolate your workloads Report Data Performance Considerations Enjoy!
Reporting Services Scale-Out Deployment Best Practices
Check out the the third of five technical note as part of the Building and Deploying Large Scale SQL Server Reporting Services Environments Technical Note Series: Reporting Services Scale-Out Deployment Best Practices This technical note reviews the SSRS Scale-Out Architecture Report Catalog sizing The benefits of File System snapshots for SSRS 2005 Why File System snapshots may not help for SSRS 2008 Using Cache Execution Load Balancing your Network Isolate your workloads Report Data Performance Considerations Enjoy!
SQL System View Query for table, index, index type and compression
As you start playing with the features of SQL Server 2008, you realized that you will want to view your table, what indexes you applied on to it, the type of index (heap, clustered, nonclustered, etc.) as well as some key features of tihe index including uniqueness, fill factor, rows, and what type of data_compression is applied to the index. Here’s a quick query to do exactly this. select o.[name] as TableName, –i.object_id, i.[name] as IndexName, i.type_desc as IndexType, i.Is_Unique, i.fill_factor, i.[allow_row_locks], i.[allow_page_locks], p.[rows], p.data_compression_descfrom sys.objects (nolock) o left outer join sys.indexes (nolock) i on i.object_id = o.object_id left outer join sys.partitions (nolock) p on p.object_id = i.object_idwhere o.type…
SQL System View Query for table, index, index type and compression
As you start playing with the features of SQL Server 2008, you realized that you will want to view your table, what indexes you applied on to it, the type of index (heap, clustered, nonclustered, etc.) as well as some key features of tihe index including uniqueness, fill factor, rows, and what type of data_compression is applied to the index. Here’s a quick query to do exactly this. select o.[name] as TableName, –i.object_id, i.[name] as IndexName, i.type_desc as IndexType, i.Is_Unique, i.fill_factor, i.[allow_row_locks], i.[allow_page_locks], p.[rows], p.data_compression_descfrom sys.objects (nolock) o left outer join sys.indexes (nolock) i on i.object_id = o.object_id left outer join sys.partitions (nolock) p on p.object_id = i.object_idwhere o.type…
Presentation: SQL Server Reporting Services: IT Best Practices
This is Lukasz Pawlowski and my presentation at the Microsoft Business Intelligence Conference 2008 (October 2008) on SQL Server Reporting Services: IT Best Practices.
Presentation: SQL Server Integration Services Best Practices
This is Thomas Kejser and my presentation at the Microsoft Business Intelligence Conference 2008 (October 2008) on SQL Server Integration Services Best Practices.
Denny Lee 