24 Hours of SQL Server 2008: Manage Your Unstructured Data with SQL Server 2008

Hi friends, unfortunatly I forget to attened this webcast but some how I manage to download the presentation file for the same. You can download the presentation file by clicking the link given below


24 hrs of SQL 2008 Manage your unstructured data with SQL Server 2008.pdf

24 Hour of SQL Server 2008: Reach Your Data with SQL Server 2008

Hi friends I have attened another session of 24 Hour of SQL Server 2008. In these session presenter discuss about how you can easily maniputlate data in your application with the new features of SQL Server 2008.

Following are the topics discussed in this session

1. Using Service Broker
2. Creating Data Service
3. Consuming Data Service

In this session we learnt about:

a. The tools available to application developers to access data flexibly in SQL Server 2008.
b. How Service Broker solves many of the problems faced when working with distributed data enviornments.
c. ADO.NET Data Services provide a powerful yet simple alternative to SOAP based web access.

You can download the presentation file by clicking link given below

24 hrs of SQL 2008 Reach your data with SQL 2008.pdf

SQL Server 2005 Best Practice Collection

I found a great stuff on SQL Server 2005 on one of the blog. Following are the topics covered in this collection

1. XML Best Practices for Microsoft SQL Server 2005
2. Performance Optimizations for the XML Data Type in SQL Server 2005
3. SQL Server 2005 Security Best Practices - Operational and Administrative Tasks
4. SQL Server 2005 Full-Text Queries on Large Catalogs: Lessons Learned
5. Scale-Out Querying with Analysis Services
6. SQL Server 2005 Analysis Services Processing Best Practices
7. Predeployment I/O Best Practices
8. Partial Database Availability
9. Comparing Tables Organized with Clustered Indexes versus Heaps
10. SQL Server 2005 Deployment Guidance for Web Hosting Environments
11. Resolving Common Connectivity Issues in SQL Server 2005 Analysis Services Connectivity Scenarios
12. Implementing Application Failover with Database Mirroring
13. OLAP Design Best Practices for Analysis Services 2005
14. DBCC SHOWCONTIG Improvements and Comparison between SQL Server 2000 and SQL Server 2005
15. TEMPDB Capacity Planning and Concurrency Considerations for Index Create and Rebuild
16. Loading Bulk Data into a Partitioned Table
17. Database Mirroring Best Practices and Performance Considerations
18. SQL Server 2005 Performance Tuning using Waits and Queues
19. Analysis Services 2005 Performance Guide
20. SAP with Microsoft SQL Server 2005: Best Practices for High Availability, Performance, and Scalability
21. Microsoft SQL Server 2005 Tuning Tips for PeopleSoft 8.x
22. Troubleshooting Performance Problems in SQL Server 2005

Also, check out some of features available in SQL Server 2005 Best Practices ToolBox:
Scripts and Tools for Performance Tuning and Troubleshooting SQL Server 2005

1. Buffer Cache
2. CPU and Optimization
3. Indexes and Indexing
4. Input Input/Output
5. Performance
6. Query Plan Re-Use
7. Retrieving SQL Text and XML Plans
8. SQLOS: Schedulers, Runnable Queue, Waiter List
9. Tempdb
10. Transactions and Locking
11. Wait Statistics
12. SQL Server 2005 Best Practices Analyzer
13. DMV Stats

Read More