SQL Server 2005 SP2 Re-release and post fixes

Bob Ward from PSS has a wonderful blog article that explains the details about the re-release of SQL Server 2005 SP2 and fixes posted later. This is a must read for anyone deploying SQL Server 2005 SP2 to understand the various hotfixes, GDRs and procedures. Please visit his link for more details. SQL Server 2005…

1

New MSDN Books Online search functionality

Check out the new Books Online search functionality online. The link below provides  a scoped search of Books Online that returns a more precise and targeted result set. You can use it to search Books Online content quickly. http://search.live.com/macros/sql_server_user_education/booksonline Please direct your feedback to SQLServerUE@hotmail.com. — Umachandar

1

SQL Server 2005 Performance Dashboard Reports

The SQL Server 2005 Performance Dashboard Reports are Reporting Services report files designed to be used with the Custom Reports feature introduced in the SQL Server 2005 SP2 release of SQL Server Management Studio. The reports allow a database administrator to quickly identify whether there is a current bottleneck on their system, and if a…

1

SQL Server Performance Engineering Team Blog

I would like to announce the blog from my team – SQL Server Performance Engineering. Feel free to visit our blog at http://blogs.msdn.com/sqlperf for your performance related questions and needs. Use the email link in the home page to share your feedback on performance and topics of interest. — Umachandar Jayachandran

1

SQL Server 2005 SP2 has been released…

SQL Server 2005 Service Pack 2 has been released. You can find more information from the service pack 2 page. This service pack extends the functionality of SQL Server in many ways. The What’s New document highlights the major changes in the Database Engine, Analysis Services, Integration Services and others. The service pack also has…

1

Database Applications Profile Survey in http://connect.microsoft.com/sqlserver

My team (Data & SQL Storage Performance Team) is conducting a survey on http://connect.microsoft.com/sqlserver to better understand SQL Server workloads. The connect link below will take you directly to the survey:   https://connect.microsoft.com/SQLServer/Survey/Survey.aspx?SurveyID=2226   Please consider providing your workload characteristics and hardware configuration to help us better understand the workloads that run on SQL Server….

1

SQL Server 2005 SP2 December CTP is available for download

SQL Server 2005 Service Pack 2 December CTP is available now for download. You can download it from: http://www.microsoft.com/downloads/details.aspx?FamilyID=d2da6579-d49c-4b25-8f8a-79d14145500d&DisplayLang=en Note that the December CTP has been published to the same location as the November CTP so if you come from the SQL Server 2005 CTP Home Page and get to December CTP don’t be confused….

1

Download SQL Server 2005 SP2 CTP

SQL Server 2005 Service Pack 2 (SP2) CTP has been released. You can provide feedback on the CTP release via http://connect.microsoft.com/sqlserver. The link for the various downloads is: http://www.microsoft.com/sql/ctp.mspx SQL Server 2005 SP2 CTP contains some new features in the database engine (vardecimal data types, object_name function enhancement, logon triggers, Common Criteria Compliance, sys.dm_exec_text_query_plan DMV,…

1

Top 5 relational data warehouse performance improvements you would like to see in next version of SQL Server

Hello Everyone, We are currently looking at top performance issues for various workloads and how we can improve those in next version of SQL Server. We are collecting feedback from various customer sources. I would like to extend an invitation to readers here for feedback on top 5 relational data warehouse performance improvements you would like to…

13

Top 5 OLTP performance improvements you would like to see in the next version of SQL Server

Hello Everyone, We are currently looking at top performance issues for various workloads and how we can improve those in next version of SQL Server. We are collecting feedback from various customer sources. I would like to extend an invitation to readers here for feedback on top 5 OLTP performance improvements you would like to…

31