Featured
Author : Denny Lee Contributors / Reviewers : Richard Tkachuk, Akshai Mirchandani, Robert Zare, Thomas Kejser, Gang Xiao, Cristian Petculescu Introduction From the early days of Microsoft® SQL Server® Analysis Services, one of the query performance optimization ... More
Top 10 Lists: Review our summary list of best practices, recommendations, and common issues.
-
1,796 Views
Comments
Author: Burzin Patel Contributor: Kun Cheng Reviewers: Sanjay Mishra, Denny Lee, Mike Ruthruff, Sharon Bjeletich, Mark Souza, Peter Carlin, Hermann Daeubler...
-
2,174 Views
Comments
Author: Joseph Sack Technical Reviewer: Burzin Patel, Juergen Thomas, Lindsey Allen, Justin Erickson SQL Server 2008 failover clustering introduces several...
-
10,317 Views
Comments
Authors: Thomas Kejser, Denny Lee Contributors: Runying Mao Technical Reviewers: Burzin Patel, Kevin Cox, Peter Carlin, Mark Souza, Richard Tkachuk, Len...
-
11,179 Views
Comments
Contributors : Stuart Ozer, with Prem Mehra and Kevin Cox Technical Reviewers : Lubor Kollar, Thomas Kejser, Denny Lee, Jimmy May, Michael Redman, Sanjay...
-
10,001 Views
Comments
Proper configuration of IO subsystems is critical to the optimal performance and operation of SQL Server systems. Below are some of the most common best...
-
12,044 Views
Comments
OLTP work loads are characterized by high volumes of similar small transactions. It is important to keep these characteristics in mind as we examine the...
View All Articles>
SQLCAT Blog Mirror: Review our tips and tricks from enterprise customer lessons learned; mirrored from our SQLCAT Blog at http://blogs.msdn.com/sqlcat.
-
436 Views
Comments
Posted by: SQL Server Customer Advisory Team
- 12-07-2008
For the ultimate guide to upgrading to SQL Server 2008, please refer to the SQL Server 2008 Upgrade Technical Reference Guide . A successful upgrade to SQL Server 2008 should be smooth and trouble-free. To achieve that smooth transition, you must devote...
-
488 Views
Comments
Posted by: SQL Server Customer Advisory Team
- 11-14-2008
Thomas Kejser and I made some significant updates to the SQL Server Analysis Services Performance Guide for SQL Server 2008 - it's available here . Our hope is to keep it alive and make updates as necessary. So if there is something you'd like...
-
1,050 Views
Comments
Posted by: SQL Server Customer Advisory Team
- 11-05-2008
This blog is a result of lessons learned while working with the new Integrated Full Text Search in SQL Server 2008. It is not intended to be an in-depth tutorial on how to implement it. Instead, it will concentrate on best practices. The basics of how...
-
448 Views
Comments
Posted by: SQL Server Customer Advisory Team
- 10-29-2008
Recently, Wanda He from SQLCAT ISV team worked with Oracle Siebel group completed a new 12,000 concurrent users Siebel CRM 8.0 benchmark on SQL Server 2008 ( http://www.microsoft.com/isv/oracle/ ). The benchmark demonstrated that the combination of Microsoft...
-
562 Views
Comments
Posted by: SQL Server Customer Advisory Team
- 10-22-2008
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...
-
504 Views
Comments
Posted by: SQL Server Customer Advisory Team
- 10-16-2008
Check out the new look and feel of the sqlcat.com ! Now you have easy access and views of our Top 10 Lists, Technical Notes, Whitepapers, and Toolbox. As well, now our blogs our mirrored to sqlcat.com for easy access to all SQLCAT tips, best practices...
View All Articles>
Technical Notes: Deep level technical short papers on specific SQL Server topics
-
1,249 Views
Comments
Author: Mike Ruthruff Technical Reviewers: Benjamin Wright-Jones, Peter Byrne, Kun Cheng, Burzin Patel, Sanjay Mishra, Mark Souza, Michael Thomassy, Lubor...
-
1,313 Views
Comments
Author : Denny Lee Contributors / Reviewers : Richard Tkachuk, Akshai Mirchandani, Robert Zare, Thomas Kejser, Gang Xiao, Cristian Petculescu Introduction...
-
3,814 Views
Comments
Building and Deploying Large Scale SQL Server Reporting Services Environments Technical Note Series Authors: Denny Lee, Lukasz Pawlowski Contributors:...
-
5,217 Views
Comments
- Posted by: admin
- 09-25-2008
Authors: Denny Lee, Thomas Kejser, Matt Neerincx Contributors / Reviewers: Peter Carlin, Brandon Berg, Eric Jacobsen, Burzin Patel Background Our initial...
-
3,644 Views
Comments
Author: Michael Thomassy Technical Reviewers: Sanjay Mishra, Burzin Patel, Stuart Ozer A Deployment Method: Copying Databases When dealing with many large...
-
3,601 Views
Comments
Author: Nicholas Dritsas Contributers: Hae Jin Park Technical Reviewers: Denny Lee, Burzin Patel Case A large online gaming company tested a number of...
View All Articles>
Whitepapers: Deep level technical whitepapers on specific SQL Server best practices.
-
652 Views
Comments
SQL Server Best Practices Article Published: November 2008 Writer: Steffen Krause Contributors: Sanjay Mishra, Gopal Ashok, Greg Yvkoff, Rui Wang Technical...
-
863 Views
Comments
Published : November 2008 Writer: Michael Redman Technical Reviewers: Sanjay Mishra, Juergen Thomas, Jimmy May, Burzin Patel, Glenn Berry (SQL Server MVP...
-
827 Views
Comments
Published : November 2008 Writers : JC Cannon, Denny Lee Contributors / Reviewers : Andy Roberts, Ayad Shammout, Dan Jones, Craig Gick, Jack Richins, Raul...
-
6,596 Views
Comments
Published : October 2008 Writers : Lindsey Allen, Mike Ruthruff, Prem Mehra Reviewers : Cindy Gross, Burzin Patel, Denny Lee, Michael Thomassy, Sanjay...
-
1,175 Views
Comments
Published : August 2008 Writer : Sharon Bjeletich Reviewer : Thomas Kejser More and more business applications are architected as business frameworks,...
-
2,546 Views
Comments
Published : August 2008 Writers : Gopal Ashok (Microsoft Corporation), Paul S. Randal (SQLskills.com) Reviewers : Hilary Cotter (Relevant Noise), Prem...
View All Articles>
|
sql, server, best practices, whitepapers, analysis services, data mining, olap, datawarehouse, datawarehousing, availability, clustering, capacity, collation, data types, data warehouse, database, design, index, mirroring, optimization, partitions, performance, precision, processing, querying, scalability, security, reporting services, integration services
|
|