SqlServer-QA.net

SQL Data Services (SDS), formerly known as SQL Server Data Services (SSDS), are highly scalable, on-demand data storage and query processing utility services. Built on robust SQL Server technologies and Windows Server, SDS provides highly available, secure, standards based web services that are easy to program and provision. On Monday 10/27/2008, ...

This was the big question posed by the users when a migration project is initiated at one of client's place.   SQL_Server_Migration_Assistant is a must tool to asses the issues when you have a mammoth task of data migration between SQL Server and other data sources such as Oracle & SYBASE. You may not know that not all Oracle ...

Introducing Idera's Point admin toolset BETA:10 Tools To Simplify SharePoint Management Idera is pleased to announce our new SharePoint management tool, the Point admin toolset(TM), is now in BETA and ready for download! If you're faced with SharePoint sprawl, out-of-control backups and compliance issues, Get Control! today using Point admin ...

You may be aware about using Third party tools to compare the data between 2 tables. Using SQL Server 2005 you need not entirely dependant on such requirement, TABLEDIFF utility is the new addition to the SQL Server. This utility enables you to compare the table contents by giving consistent information such as whether data is same, are they ...

One of the best learning during Tech-Ed week was to know about SQL Server Data Services which might be suitable for the web-based platforms, type of what we have and 2 interesting features for me were 'Business ready SLA & Application Agility' To know further about SSDS I recommend: Introduction about SSDS - ...

No doubt that the blog subject will be a most wanted requirement on their databases, that is most responsible for a SQL Server database then arguably the most critical task that you absolutely MUST get right is your database backup procedures.  Where the backup sequence comes the database RECOVERY model comes as another important ...

Configuration of server such as disk and memory is an important factor for SQL Server Performance, there is all about questions within newsgroups and forums that how do I setup the disk layout for a SQL Server database (say, 2005 version).  Not only this there will be more questions asked related to general guidelines or any other setup ...

Managing SharePoint is about more than just backup, recovery, administration, or migration. An effective SharePoint strategy means being proactive, scrutinizing the entire platform (including SQL Server), and reducing your vulnerability. This white paper offers best practices to help you understand the role and importance of SharePoint in your ...

When do you need data partitioning? The data you see in relational database may need such a strategy if the volume is huge, for instance the data to store event-log information having the schema such as:  [Id]  INT (make this primary key clustered), [Unit_Id]  UNIQUEIDENTIFIER, [EventType_Id]   ...

Replication plays important role within the data-driven events in an Enterprise, vital to the sales-work force type of management. DBAs will always havea primary focus in providing protection for the data assets stored in SQL Server. Protection that covers the security and data recoverability is also equally important, during this process ...