MSMVPS.COM

The Ultimate Destination for Blogs by Current and Former Microsoft Most Valuable Professionals.

Browse by Tags

Blogs

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

Syndication

News

Blog Archive List

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

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

Published Tue, Dec 9 2008 3:45 by SqlServer-QA.net

Filed under: sql server, mvp, database, best practices, hardware, corrupted, dbcc checkdb, survival, code examples
Control the database version - an important task for DBA!

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

Published Tue, Dec 9 2008 1:37 by SqlServer-QA.net

Filed under: application, sql server, database, dba, documentation, best practices, stored procedure, beginner, versioncontrol, small
SQL Server 2008 Upgrade Technical Reference Guide

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

Published Fri, Dec 5 2008 2:44 by SqlServer-QA.net

Filed under: sql server, tools, database, download, upgrade, best practice, management studio, books online, document
Script to perform database backup, restore and optimization tasks without maintenance plans - SQL Server 2008

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

Published Mon, Sep 29 2008 2:15 by SqlServer-QA.net

Filed under: sql server, restore, database, dba, backups, task, new features, scripting
Commonly used SharePoint admin links - Tip of the day on Sharepoint from IDERA

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

Published Fri, Aug 29 2008 15:46 by SSQA.net

Filed under: database, sharepoint, idera, tips, toolset, admin
SQL Server 2005 - adhoc script to perform backup, restore and integrity checks/optimization jobs without Database Maintenance plans?

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

Published Tue, Apr 29 2008 5:14 by SSQA.net

Filed under: sql server, database, dba, blog, best practices, responsibilties, backups, strategy, size
SQL Server databases - checkpoint, cache and I/O request - what you need to know?

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

Published Tue, Apr 22 2008 13:51 by SSQA.net

Filed under: sql server, performance, msdn, backup, blogs, database, transaction log, cache, i/o, flush, monitoring, checkpointl
MOSS Tables - Usage Reporting

http://suguk.org/blogs/sharepointhack/archive/2008/03/17/9161.aspx...( read more ) Read More...

Published Wed, Mar 19 2008 2:00 by SSQA.net

Filed under: sql server, microsoft, database, sharepoint
SQL Server Database Mirroring and Sharepoint server - gotchas and problem solutions

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

Published Tue, Mar 18 2008 6:23 by SSQA.net

Filed under: sql server, high availability, technet, database, best practices, sharepoint, database mirroring, failover, links
Database Maintenance for Microsoft® SharePoint® Products and Technologies

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

Published Thu, Mar 13 2008 5:52 by SSQA.net

Filed under: microsoft, database, sharepoint, whitepaper
Object search within Management Studio of SQL Server 2008

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

Published Wed, Mar 12 2008 3:56 by SSQA.net

Filed under: sql server, database, 2008, management studio, object explorer, object search
SQL Server 2005 Partitioned Tables and Indexes - learning curve

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

Published Wed, Mar 12 2008 3:01 by SSQA.net

Filed under: sql server, performance, indexes, data, backup, bi, database, statistics, partition, monitoring, strategy, data warehouse
Relation between SQL Server 2005 and Volume Shadow Copy services?

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

Published Tue, Feb 19 2008 2:45 by SSQA.net

Filed under: sql server, backup, database, disk, best practices, vss, configuration, volume shadow, sqlwriter
SQL Server database upgrade - FAQs, How-to, Gotchas, links and blurb

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

Published Tue, Jan 22 2008 7:55 by SSQA.net

Filed under: sql server, database, upgrade, best practices, sa, clustering, database mail, data files, FAQ, gotchas, sqlmail
SQL Server Error 4616 - You cannot perform this operation for the restore database

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

Published Tue, Dec 11 2007 2:47 by SSQA.net

Filed under: sql server, database, error, error log, resource, attach, .mdf, 4616
List of modified Knowledge Base articles in SQL Server 2005 Enterprise X64 Edition

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

Published Fri, Nov 16 2007 17:14 by SSQA.net

Filed under: sql server, restore, database, kba, service pack2, x64, backups, modified
FIX: Error message when you run the DBCC CHECKTABLE statement or the DBCC CHECKDB statement in Microsoft SQL Server 2005: "Column '<ColumnName>' value is out of range for data type 'float'"

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

Published Fri, Oct 26 2007 14:40 by SSQA.net

Filed under: sql server, database, kba, datatype, column, dbcc checktable, float, dbcc checkdb
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"

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

Published Sun, Oct 21 2007 12:57 by SSQA.net

Filed under: sql server, database, error, kba, snapshot, service state, writer
Calculate size of an index for a new database?

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

Published Wed, Oct 17 2007 14:06 by SSQA.net

Filed under: sql server, indexes, database, dba, cache, best practices, tempdb, capacity, calculate
SQL Server DTS: Dynamically Change Source and Destination in Transform Data Task

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

Published Wed, Oct 10 2007 15:24 by SSQA.net

Filed under: sql server, ssis, database, dts, connections, dynamic

1 2 3 4 Next >

Questions? Contact Susan at Susan-at-msmvps.com. Each post's copyright held by the original author. All rights reserved. Blog site is an independent site not sponsored by Microsoft.
Our servers would like to thank www.ownwebnow.com and www.exchangedefender.com. We wouldn't be here without the generosity of Vlad Mazek and his companies.

Powered by Community Server (Commercial Edition), by Telligent Systems

zines:andrewbelon.com

Browse by Tags

Blogs

Syndication

Recent Posts

Tags

News

Archives

Blog Archive List

Blog Archive List

Blog Archive List

Blog Archive List

Blog Archive List

Blog Archive List

Blog Archive List

Blog Archive List

Blog Archive List

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

Control the database version - an important task for DBA!

SQL Server 2008 Upgrade Technical Reference Guide

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

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

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

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

MOSS Tables - Usage Reporting

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

Database Maintenance for Microsoft® SharePoint® Products and Technologies

Object search within Management Studio of SQL Server 2008

SQL Server 2005 Partitioned Tables and Indexes - learning curve

Relation between SQL Server 2005 and Volume Shadow Copy services?

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

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

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

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

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"

Calculate size of an index for a new database?

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