Additional Articles

Service Pack 2 Uninstall Not Possible for SQL Server 2005

by Additional Articles

MSSQLTips.com

SQL Server 2005

You probably already know that SQL Server 2005 SP2 has been released. This is a good thing if you are in need of one of the changes that are included in this service pack. In a previous tip, SQL Server 2005 - Service Pack 2, we took a look at what was to be included in this second service pack for SQL Server 2005. The question that you often face is should I install this service pack. One thing to note before you install SP2 is that there is no way to uninstall it once it is installed.

2009-07-14

2,824 reads

Top five tips for SQL Server developers

by Additional Articles

SQLServerCentral

T-SQL

Check out these handy database development best practices, with tips on dealing with batch updates, stored procedures and more.

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

(7)

You rated this post out of 5. Change rating

2009-07-14

7,765 reads

Database Mirroring in SQL Server 2008

by Additional Articles

SQLServerCentral

Database Mirroring

Learn the basics of the Database mirroring in SQL Server 2008. Mak provides a step-by-step on how to create database mirroring. Subsequent installments will discuss how to add data on the principal server and how data is mirrored to the mirrored server.

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

(2)

You rated this post out of 5. Change rating

2009-07-13

3,451 reads

Transfer Logins Task and Transfer Database Task in SSIS

by Additional Articles

SQLServerCentral

Integration Services (SSIS)

The Transfer Logins and Transfer Database tasks can be used in combination to easily and efficient migrate databases and users across different SQL Servers.

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

(2)

You rated this post out of 5. Change rating

2009-07-13

2,220 reads

How To Enable User-Defined Hierarchies in SQL Server Analysis Services (SSAS)

by Additional Articles

MSSQLTips.com

Analysis Services (SSAS)

I have a requirement to provide users with the capability to define their own reporting hierarchies for sales data. For instance they had a report which broke down sales by the four regional VPs then by office. Later they created regions, assigned VPs to each region, then assigned offices to each VP. Now they want to be able to create a number of other scenarios and choose which one when they run a report. Can you provide some suggestions on how to do this?

2009-07-10

3,043 reads

Partitioned Table and Index Strategies Using SQL Server 2008

by Additional Articles

SQLServerCentral

Partitioned Tables

The Microsoft SQL Server 2008 database software provides table partitioning to make such operations more manageable.

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

You rated this post out of 5. Change rating

2009-07-10

3,009 reads

Create a Web-Based CRUD Automation Framework with Python

by Additional Articles

SQLServerCentral

Python

Implement a CRUD automation framework that handles insert and simple queries, an easy way to talk to a database without needing to write any database-access code.

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

(1)

You rated this post out of 5. Change rating

2009-07-09

1,967 reads

Automating Performance Monitor Statistics Collection for SQL Server and Windows

by Additional Articles

MSSQLTips.com

Performance Monitoring

You have about 100 SQL Servers installed in your production environment. You have performance problems on few of the servers, but they happen during the time when you are not watching the servers. So, how can you automate performance statistics collection on all the servers around the clock so we have the statistics for 24/7/365.

2009-07-08

3,919 reads