Upgrading Replication from SQL Server 2000 32-Bit to SQL Server 2008 64-Bit without re-initialization

In this article we summarized the experiences we gathered during the planning and upgrade of a customer's project. The customer is one of the largest retail shops in its area. Their architecture is made up of a main server, which is located at headquarters and hosts several hundred publications containing over a thousand articles. Regional stores are located all over the country acting as subscribers for the publications hosted on the main server. Based on the business needs and infrastructure limitations the customer set the following goals for the project:

Dude, Your Fly is Open

by Tim Mitchell

SQLServerCentral.com

Editorial

A guest editorial from Tim Mitchell today talks about the way you handle problems. Other people's problems. A professional way of pointing out mistakes is the best policy.

Managing Analysis Services Deployment - Part 4

by Shahfaisal Muhammed

SQLServerCentral.com

Analysis Services (SSAS)

Part 4 of this series, Shahfaisal Muhammed brings another method of deploying your SSAS projects to a new server: the synchronize database method. The rest of the series covers other methods.

Data Type Precedence and Implicit Conversions

by Seth Phelabaum

SQLServerCentral.com

Blogs

In my last post, I noted that one of the biggest differences between ISNULL and COALESCE was the fact that...

SQL Server Impersonation

by Additional Articles

Database Journal

Security

SQL Server impersonation, or context switching, is a means to allow the executing user to assume the permissions of a given user or login until the context is set back, set to yet another user, or the session is ended. Deanna Dicken shows you two mechanisms for accomplishing this task and walks through some examples.

Data Dashboards

by Steve Jones

SQLServerCentral.com

Editorial

Google recently unveiled a dashboard to allow users to manage the data that Google stores about them. Including removing search data! Steve Jones comments on the possibility of implementing this for other companies.

Expand Your Brand

by Press Release

SQLServerCentral.com

Events

There are a number of events coming up in 2010 that need speakers to share their knowledge of SQL Server with others. Check out this list and consider submitting something.

Microsoft SQL Server 2008 Analysis Services Consolidation Best Practices

by Additional Articles

SQLCAT

Analysis Services (SSAS)

This technical note describes the consolidation options, considerations, and best practices for Microsoft® SQL Server® 2008 Analysis Services that the SQL CAT team has derived from working with Analysis Services customers. In this technical note, we also discuss an Analysis Services load balancer solution that one of our internal customers uses to load balance queries from Microsoft Excel® and SQL Server Reporting Services clients across multiple query servers to increase query performance and provide availability.