Browse by Tags

SQL Server 2008 Spatial data - geography & geometry, all in one
20 March 08 11:24 AM | ssqa.net | with no comments

Geography & Geometry has much significance in day to day life, within that as a data now you can manage within your Database using SQL Server 2008 new data type - spatial, this represents information about the physical location and shape of geometric...

Filed under: blog, sql server, ssqa, 2008, data, new feature, spatial

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 Lockdown - Step by Step procedure
13 February 08 11:06 AM | ssqa.net | with no comments

Cross posting from other blog - http://sqlserver-qa.net/blogs/perftune/archive/2008/02/13/3502.aspx fyi. Hope you don't want to do it!

Filed under: blog, sql server, ssqa, security, best practices, lock down, availability

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