Tuesday, December 20, 2005

Pass presentation SQL Server

Presentation by Bill Graziano,SQL Server MVP on 2005 pass community summit. I think this presentation is precise and go to the point of what you need. With the additional knowlege you got it can be used as a guide to database programming and administration. Worth viewing it. To view it click Pass presentation

Monday, December 19, 2005

SQL Server 2005 & SQLDMO

I have recently uninstalled SQL Server 2005 and got the following error while trying to run enterprise manager for SQL Server 2000. I was trying to find out why SQL Server 2005 will affect the installation of SQLDMO.dll file.

The error I was getting was :
SQLDMO has not been registered; please re-run SQL Server setup and contact system administrator.

The way to solve this issue is to register the dll rather than re-running SQL Server 2000 setup. First check that sqldmo.dll exists in binn dirctory of your SQL Server installation then run regsvr32 sqldmo.dll from command line.

Wednesday, December 14, 2005

SQL Server 2005 Roadshow

Have you missed the launch of SQL Server 2005 roadshow ? To register and attend SQL Server 2005 roadshow during first quarter of 2006 , go to Sql Server Europe

Friday, December 09, 2005

Database mirroring

When Microsoft first comes up with this idea, I was delighted with the concept of database mirroring. I thought it will provide bulletproof solution with minimal cost for setting up redundancy solution for small and medium size business who are the one struggling to make ends meet. But, when they have decided to disable on the release of SQL Server 2005, I was gutted. By default, database mirroring is disabled in the new release but you can still be able to enable using trace flag 1400 as a start up parameter. Microsoft does recommend not using database mirroring in production environment. It might be a case that Microsoft is not ready to release this feature, I do understand their thinking. If they are not confident then it is the right direction.

You can read data mirroring overview, SQL Server 2005 Editions that supports mirroing and various technical aspects of this technology by going to SQL Server 2005 Database mirroring

Thursday, December 08, 2005

SQL Server 2005 Books Online

SQL Server 2005 Books Online is out and can be downloaded now. Download Books online

SQL Server 2005 Samples

SQL Server 2005 Samples and Sample Databases (December 2005) is out and you can down load from SQL Server samples (Dec 2005)

Wednesday, December 07, 2005

SQL Server 2005 for DBAs

Last time I mentioned about features of SQL Server 2005. That is a good start to get an idea of what SQL Server 2005's new features are. Today, I am going to point you to An Overview of SQL Server 2005 for the Database Administrator. You can find this on microsoft web site or click An Overview of SQL Server 2005 DBAs

Monday, December 05, 2005

Log shipping

Have come accross many times people asking about how perform log shipping. If you are running Enterprise edition, log shipping can be done through EM. The problem is always where to start. Content posted on www.sql-server-performance.com web site is best place to start. To view details SQL Server Log shipping

Friday, December 02, 2005

SQL Server 2005(After Launch)

I have compiled some of the sites that give you a comprehensive review of how SQL Server 2005 is received. The following links will help you explore different views from different angle.
- SQL Server 2005 News & Reviews
- Microsoft unwraps flagship database SQL Server 2005
- Database Wars: The Next
- Microsoft, SAP Team Up Against Oracle
- SQL Server 2005 piles it on
- SQL Server 2005 May Tempt Many to Jump Platform
- SQL Server 2005: I Said Be Cautious, Not Petrified

Are just few of the one which catched my eye. Please send me any one you know off and will add to the list.

Thursday, December 01, 2005

SQL 2005 Feature Pack

Feature Pack for Microsoft SQL Server 2005 is out in November. The standalone packges includes:
- Latest versions of redistributable components for SQL Server 2005
- Latest versions of add-on providers for SQL Server 2005
- Latest versions of backward compatibility components for SQL Server 2005
To see detailed explanation and download click SQL 2005 Feature Pack

Sysprocess to Isolate Performance

Nice article by Terry Troisi on sql-server-performance.com on how to use sysprocess table in master database to isolate perfomance issues. To veiw more details click Sysprocess to Isolate Performance issues part-1