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...

Filed under: sql server, webcast, learning, links, data services, ssds

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...

Filed under: sql server, indexes, 2008, labs, data capture, spatial, data type, links, new features, geometry, geography

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...

Filed under: sql server, microsoft, blogs, sharepoint, resources, links

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...

Filed under: sql server, high availability, technet, database, best practices, sharepoint, database mirroring, failover, links

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...

Filed under: sql server, microsoft, version, new, learning, website, links, launch

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...

Filed under: sql server, management, microsoft, bi, data mining, labs, development, testing, business intelligence, links, operation guide

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...

Filed under: sql server, indexes, msdn, blogs, rebuild, schema, best practice, schedule, links, performance monitoring, reorganize

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...

Filed under: sql server, microsoft, security, replication, merge, transactional, tips, setup, links

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...

Filed under: sql server, microsoft, 2008, ctp, whitepaper, books online, links