SQLServer-QA.net - Knowledge Sharing Network (SSQA.net) : links

SQL Server Data Services - what's new, basics and dig deeper

SSQA.net — Fri, 20 Jun 2008 07:27:00 GMT

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...(read more)

SQL Server 2008 Spatial data - geography & geometry, all in one

SSQA.net — Thu, 20 Mar 2008 08:32:00 GMT

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...(read more)

Various blog links for sharepoint and office products

SSQA.net — Wed, 19 Mar 2008 12:32:00 GMT

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...(read more)

SQL Server Database Mirroring and Sharepoint server - gotchas and problem solutions

SSQA.net — Tue, 18 Mar 2008 11:23:00 GMT

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...(read more)

New versions new website - I am specific to SQL Server

SSQA.net — Fri, 29 Feb 2008 13:14:00 GMT

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...(read more)

What is Business Intelligence? How to obtain complete tools suite to test?

SSQA.net — Fri, 08 Feb 2008 18:11:00 GMT

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...(read more)

SQL Server indexing - when to reorganize or rebuild?

SSQA.net — Mon, 21 Jan 2008 10:30:00 GMT

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...(read more)

Transactional Replication Snapshot Issues - useful resources to resolve

SSQA.net — Wed, 16 Jan 2008 07:08:00 GMT

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...(read more)

SQL Server 2008 - links to newbie users and relevant whitepapers

SSQA.net — Sun, 14 Oct 2007 19:15:00 GMT

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...(read more)