Browse by Tags

SQL Server Data Services - what's new, basics and dig deeper
Published 20 June 8 2:27 AM | SSQA.net
In continuation to my post about best learnings in Tech-Ed conference on SQL Server Data Services (SSDS), I'm kind of more interested to know about this new 'cloud based' data management solution for the Data Platform. So the first question...
SQL Server 2008 Spatial data - geography & geometry, all in one
Published 20 March 8 3:32 AM | SSQA.net
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...
Various blog links for sharepoint and office products
Published 19 March 8 7:32 AM | SSQA.net
Though I'm an expert within SQL Server arena, sometimes I find it bit difficult when the sharepoint database are involved with an added flavour of performance issues within this farm. So in this regard recently I have been searching through the web...
SQL Server Database Mirroring and Sharepoint server - gotchas and problem solutions
Published 18 March 8 6:23 AM | SSQA.net
You may be aware that Database Mirroring is an important High Availability [HA] option available within SQL Server 2005 version. Having this HA option within your Sharepoint farm where the databases are associated to failover, then you must note few issues...
New versions new website - I am specific to SQL Server
Published 29 February 8 7:14 AM | SSQA.net
You all might know this SQL-HomePage would take you to the SQL Server webpages on Microsoft and now with recent launch 2008 wave another new site created specific to SQL Server 2008, which is SQL-Server-2008 . Nothing major difference here as the first...
What is Business Intelligence? How to obtain complete tools suite to test?
Published 8 February 8 12:11 PM | SSQA.net
Business Intelligence (BI) - is the new term from Microsoft for all Data Warehousing & Data Mining requirement since the SQL Server 2005 version is released. Say many organization face challenges with the Data Explode, this BI offers management and...
SQL Server indexing - when to reorganize or rebuild?
Published 21 January 8 4:30 AM | SSQA.net
Re-organizing or rebuilding index would help the SQL optimizer to reduce the fragmentation for a better performance. In this case few users might have doubt that when to rebuild or reorganize (SQL Server 2005)? IN the series of Performance blog posts...
Transactional Replication Snapshot Issues - useful resources to resolve
Published 16 January 8 1:8 AM | SSQA.net
When you have problems with SQL Server replication where the transactional replication is common case in setting up, eventually you will have problems when the data is growing up and any sudden changes in the ETL will also have affect on replication process...
SQL Server 2008 - links to newbie users and relevant whitepapers
Published 14 October 7 2:15 PM | SSQA.net
During a conference one of the newbie user asked me for the links and whitepapers about SQL Server 2008, as it was bit hard to find relevant information from Books online for SQL Server 2008 (CTP). So here they are from the links I can accumulate: SQL...