Browse by Tags

SQL Server Upgrade - don't forget the Collation issues?
29 May 08 09:08 AM | ssqa.net | with no comments

Whenever any user (forum or usergroup) asks me about Upgrade gotchas and FAQs I will refer this SQLUpgrade-blurb post that I have made from my experience. Further I would like to enhance the topic of upgrade and things you need to watch about Collation...

Filed under: sql server, 2005, setup, collation, 2000, upgrade, settings, reference

End of Mainstream support for SQL Server 2000 & 2005 (SP1) today, then how about SP2?
08 April 08 06:04 AM | ssqa.net | with no comments

The subject say it all, as of today the mainstream support for SQL Server 2000 (SP4) and SQL Server 2005 (SP1) will be ended. That means for SQL Server 2005 service pack 1 there will not be any support and that can be obtained with a Custom Support agreement...

Filed under: sql server, 2005, microsoft, product, mainstream, support, extended, 2000, lifecycle

SQL Server 2008 Express features and variation from previous version
28 March 08 09:26 AM | ssqa.net | with no comments

Flood of questions fromthe users during a recent usergroup meeting. What will the specification for the SQL Server 2008 Express version be? What will be the differences between it and the 2005 version, not with MSDE? How about SQL Agent attachment to...

Filed under: sql server, 2008, 2005, licensing, features, sqlexpress, express, limitation, ram

SQL Server 2005 Enterprise Edition - make data available while creating indexes on large tables!
25 February 08 07:53 AM | ssqa.net | with no comments

Though it is not a best practice to perform a CREATE INDEX on large tables during the online hours where you have number of users accessing the metadata of SQL Server database. Within SQL Server 2005 Enterprise Edition you can perform ONLINE indexes operation...

Filed under: sql server, 2005, server, performance, best practices, index, clustered, online, production

SQL Server 2005 Index Optimization Best Practices
19 February 08 07:04 AM | ssqa.net | 3 comment(s)

Do you have a maintenance window to perform database reindexing? Have you ever performed full set of re-organize and re-index process on a bigger database? Do you know there are best practices to deploy in this regard? On large database systems, with...

Filed under: sql server, ssqa, 2005, performance, best practices, reorganize, optimization, database, statistics, blogs, index, dbreindex, reindex

SQL Server 2008 Reporting Services - tutorials how-to?
12 February 08 09:56 PM | ssqa.net | 1 comment(s)

Tutorials and free e-learning resources have become very useful within the Microsoft community recenlty, I have been looking for similar kind of information for Reporting Services and in particular to report building (GUI enhancement) as compared to SQL...

Filed under: sql server, elearning, 2008, 2005, report builder, reporting services, tutorial, fields

Certification path for SQL Server 2008, whats your choice?
12 February 08 11:50 AM | ssqa.net | 1 comment(s)

Are you ready for your SQL Server 2008 Certification? As SQL Server 2008 is still in CTP process Microsoft learning has already announced the process in getting certification in this new version. Not only with Learning opportunities Microsoft Press also...

Filed under: sql server, elearning, course, ssqa, 2008, 2005, certification, whats new, sql