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

SQL Server Database Corruption - a nightmare for a DBA, what are your chances to survive?

SqlServer-QA.net — Tue, 09 Dec 2008 09:45:00 GMT

I bet the subjet line is not an easy one to take on for any DBA to think about the survival chances in case of database corrpution which causes without any indication. As a DBA have you ever wondered you can recover a corrupted database when you have...(read more)

Control the database version - an important task for DBA!

SqlServer-QA.net — Tue, 09 Dec 2008 07:37:00 GMT

Do you need to control the database version? How often you document the changes of a database? I find it very difficult and helpless whenever I go to solve a database problem, hearing about they have no clue about database and its properties, sounds familiar...(read more)

SQL Server 2008 Upgrade Technical Reference Guide

SqlServer-QA.net — Fri, 05 Dec 2008 08:44:00 GMT

What is the most required task when a DBA required to perform upgrade from previous versions? Complete understanding of the databases that are required to upgrade. Technical reference of upgrade path from previous version to the current one. Testing of...(read more)

Script to perform database backup, restore and optimization tasks without maintenance plans - SQL Server 2008

SqlServer-QA.net — Mon, 29 Sep 2008 07:15:00 GMT

In continuation to the SQL Server 2005 - adhoc script to perform backup, restore and integrity checks/optimization jobs without Database Maintenance plans? blog and scripts by Ola Hallengren, I presume they are very useful for the DBAs who are looking...(read more)

Commonly used SharePoint admin links - Tip of the day on Sharepoint from IDERA

SSQA.net — Fri, 29 Aug 2008 20:46:00 GMT

Refer a SharePoint Colleague! Forward To A Friend ___________________ Want to receive Idera's monthly newsletter? Sign-up here For a quick reference list of SharePoint URLs to commonly used administrative functions on a SharePoint site, visit the...(read more)

SQL Server 2005 - adhoc script to perform backup, restore and integrity checks/optimization jobs without Database Maintenance plans?

SSQA.net — Tue, 29 Apr 2008 10:14:00 GMT

As a DBA you might be aware that since SQL Server 2005 database maintenace plans have given flexibility in deploying the workflow of tasks required to make sure that your database is optimized, is regularly backed up, and is free of inconsistencies in...(read more)

SQL Server databases - checkpoint, cache and I/O request - what you need to know?

SSQA.net — Tue, 22 Apr 2008 18:51:00 GMT

Have you ever wondered about flushing databases? Well not quite possible to flush it straight away and not a best practice too on the live server, so what it is about and you need to know about transactions state when they occur. Say when the changes...(read more)

MOSS Tables - Usage Reporting

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

http://suguk.org/blogs/sharepointhack/archive/2008/03/17/9161.aspx...( read more ) Read More......(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)

Database Maintenance for Microsoft® SharePoint® Products and Technologies

SSQA.net — Thu, 13 Mar 2008 10:52:00 GMT

Here is a link for a white paper for database maintenence for Sharepoint Technologies http://go.microsoft.com/fwlink/?LinkId=111531&clcid=0x409...( read more ) Read More......(read more)

Object search within Management Studio of SQL Server 2008

SSQA.net — Wed, 12 Mar 2008 08:56:00 GMT

Good news for the Development DBAs to have a fature of searching for a particular object within the SQL database. The newest feature to SQL Server 2008 version will be 'object search'! Until now even for me I used to refer to ThisArticle to search...(read more)

SQL Server 2005 Partitioned Tables and Indexes - learning curve

SSQA.net — Wed, 12 Mar 2008 08:01:00 GMT

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

Relation between SQL Server 2005 and Volume Shadow Copy services?

SSQA.net — Tue, 19 Feb 2008 08:45:00 GMT

Until last month I was not aware about Volume Shadow Copy and what is the relation between that service & SQL Server services, so here I would like to give the information in this regard that will discuss SQL Server connection issues that you may...(read more)

SQL Server database upgrade - FAQs, How-to, Gotchas, links and blurb

SSQA.net — Tue, 22 Jan 2008 13:55:00 GMT

Upgrading a SQL Server database should be straight-forward, when you haven't got much of constraints on the application code. In this regard we have blogged previously such as UpgrageTags posts. Here in this post I would like to go with few FAQs that...(read more)

SQL Server Error 4616 - You cannot perform this operation for the restore database

SSQA.net — Tue, 11 Dec 2007 08:47:00 GMT

You may be aware default 4 SQL Server system databases master, model, msdb & tempdb are created automatically when the SQL Server is installed. Those databases files can be located under default directory assuming C:\Program Files\Microsoft SQL Server...(read more)

List of modified Knowledge Base articles in SQL Server 2005 Enterprise X64 Edition

SSQA.net — Fri, 16 Nov 2007 23:14:00 GMT

The following pages were recently modified, rather than posting each as a blog post I have included them here: Source: Knowledge Base Product: Microsoft SQL Server 2005 Enterprise X64 Edition Notification Contents: New and All Modifications FIX: A gradual...(read more)

FIX: Error message when you run the DBCC CHECKTABLE statement or the DBCC CHECKDB statement in Microsoft SQL Server 2005: "Column '' value is out of range for data type 'float'"

SSQA.net — Fri, 26 Oct 2007 19:40:00 GMT

The following pages were recently modified. Source: Knowledge Base Product: Microsoft SQL Server 2005 Enterprise Edition, SQL Server 2005 Standard Edition & SQLL Server 2005 Enterpris X64 Edition Notification Contents: New and Major Modifications...(read more)

Error message when you create a snapshot backup of many databases at the same time in SQL Server 2005: "ERROR Selected writer 'Microsoft Writer (Service State)' is in failed state"

SSQA.net — Sun, 21 Oct 2007 17:57:00 GMT

The following pages were recently modified. Source: Knowledge Base Product: Microsoft SQL Server 2005 Standard Edition & SQL Server 2005 Enterprise Edition Notification Contents: New and All Modifications Error message when you create a snapshot backup...(read more)

Calculate size of an index for a new database?

SSQA.net — Wed, 17 Oct 2007 19:06:00 GMT

How can you calculate size of an index in a database whenever a capacity planning exercise if performed? By default the size allocated for each user objects depends on the user application and on the amount of space that is created by the application...(read more)

SQL Server DTS: Dynamically Change Source and Destination in Transform Data Task

SSQA.net — Wed, 10 Oct 2007 20:24:00 GMT

I found this useful blog SQL Server DTS: Dynamically Change Source and Destination in Transform Data Task that I would like to share the users that are sub-merged with DTS tasks....( read more ) Read More......(read more)