Browse Blog Posts by Tags

All Tags » SQL Server » dba (RSS)

MVP WordPress Blogs

Browse Blog Posts by Tags

Showing related tags and posts for the Blogs application. See all tags in the site

How to be an Exceptional DBA - free ebook.

A new year gift to the SQL Server users!! As the title states every DBA wants to be exceptional within their environment . Within your demanding role there are more things that needs importance in continuing the fire-fighting techniques to keep up the...

Posted to SQLServer-QA.net - Knowledge Sharing Network (SSQA.net) by on Wed, Jan 2 2008
Filed under: Filed under: sql server, databases, red-gate, dba, download, ssp, sql-server-performance, ebook, beginners in sql serever
SQL Server: How do I identify the queries that are worth tuning?

Have you ever asked this question about how do I identify the queries that worth tuning? The simple answer it is neither easy or hard to obtain such information if you have managed your SQL Server by deploying industry best practices (wherever possible...

Posted to SQLServer-QA.net - Knowledge Sharing Network (SSQA.net) by on Fri, Nov 16 2007
Filed under: Filed under: sql server, performance, management, microsoft, blogs, technet, dmv, dba, best practice, slow query
How to find whether backup is performed using SQL native methods or third party tools?

Interesting question: how can we know the difference between a native backup and backup taken by third party tool? Say you have started newly in a enterprise wide platform and your task is to find out what methods of BACKUP and RESTORE are followed to...

Posted to SQLServer-QA.net - Knowledge Sharing Network (SSQA.net) by on Tue, Oct 23 2007
Filed under: Filed under: sql server, restore, high availability, backup, dba, best practices, third party
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...

Posted to SQLServer-QA.net - Knowledge Sharing Network (SSQA.net) by on Wed, Oct 17 2007
Filed under: Filed under: sql server, indexes, database, dba, cache, best practices, tempdb, capacity, calculate
Solid Quality Mentors - Don't miss our SQL Server DBA Bootcamp in Dallas, TX

Don't miss our SQL Server DBA Bootcamp in Dallas, TX November 12-16, 2007 Register Now for this SQL Server DBA Bootcamp taught by Randy Dyess 5-Day Bootcamp only $3,200! Course Information: This course will give you a broad look at the enhancements...

Posted to SQLServer-QA.net - Knowledge Sharing Network (SSQA.net) by on Wed, Oct 17 2007
Filed under: Filed under: sql server, microsoft, dba, event, conference, web seminar, mentor, solid quality, bootcamp, sqm
Cluster resource 'SQL Server (<SQL Server instance name>)' in Resource Group '<Cluster group name>' failed.

A common mistake by DBAs for missing to check whether all the functionality of tools are working when a SQL Server Cluster environment is setup, though you may not catch hold of few issues with basic failover/failback testing initially but when the application...

Posted to SQLServer-QA.net - Knowledge Sharing Network (SSQA.net) by on Wed, Oct 10 2007
Filed under: Filed under: sql server, dba, sqlagent, best practices, cluster, error log, online, failure, active/passive
Disk Space Requirements for Index DDL Operations

Are you watching your disk space during the indexes operations where these database objects are stored? Recently I was stumped on a database that is only 5GB had reindexing process failure due to 10% of disk free space was available. For your information...

Posted to SQLServer-QA.net - Knowledge Sharing Network (SSQA.net) by on Fri, Sep 28 2007
Filed under: Filed under: sql server, performance, indexes, dba, optimization, disk space, best practice, hardware, disks, sorting, reindexing
How to read Database transaction log in SQL Server?

Another frequently asked questions in the forums and newsgroups, I have seen similar ones recently. I believe most of the newbie users ask this question and even more as interview based questions. So here is the catch in order to accomplish the task,...

Posted to SQLServer-QA.net - Knowledge Sharing Network (SSQA.net) by on Thu, Sep 27 2007
Filed under: Filed under: sql server, ssms, tools, transaction log, dba, read, access, audit, log file, third party, resolution
Failed to claim unused space with SP_SPACEUSED?

Recently I have been stumped by not cliaming unused space correctly even though after delete handful of rows on a table. You may be aware using SP_SPACEUSED will get you details such as : Column name Data type Description database_name nvarchar(128) Name...

Posted to SQLServer-QA.net - Knowledge Sharing Network (SSQA.net) by on Fri, Aug 31 2007
Filed under: Filed under: sql server, database, dbcc, dba, space, table, transact sql, data type, delete
How many DBAs you need to manage show in multi-server environment?

This sounds like a joke that "How many DBAs you need to change a light bulb?". I have come across this less technical question from SSP forum asking for recommended practices. They wanted to have information that How many servers should be managed...

Posted to SQLServer-QA.net - Knowledge Sharing Network (SSQA.net) by on Thu, Aug 30 2007
Filed under: Filed under: sql server, server, services, dba, edition, multiple
Resource for new SQL Server DBA and beginners in SQL Server

" Give me some good resource that I can refer as new dba or beginner or new learner " this is the question asked by beginners and new learners in various forums I participate, thus I decide to post a blog referring the same, they are: Here are...

Posted to SQL Server Citation - SQL Server Blog by Hemantgiri S. Goswami by on Mon, Aug 20 2007
Filed under: Filed under: sql server, best practices, dba, sql server administration, resources, self taught dba, sql turorial
Dedicated Administrator Console (DAC) - saved an important day for a DBA

Until recently I have just used Dedicated Administrator Console (DAC) to connect just to test whether the connection will be successful. You may be aware that only administrator will be able to access a running instance of SQL Server Database Engine to...

Posted to SQLServer-QA.net - Knowledge Sharing Network (SSQA.net) by on Sat, Aug 4 2007
Filed under: Filed under: sql server, performance, management, analysis, blocking, dba, dac, sac, investigation
SQL Server 2005 Performance Dashboard Reports - making most out of it!

Another set of reports you can generate using SQL Server 2005 Performance Dashboard Reports, this is mainly useful to monitor and resolve performance problems on your SQL Server 2005 database server using the Management Studio client. The reports allow...

Posted to SQLServer-QA.net - Knowledge Sharing Network (SSQA.net) by on Tue, Jun 26 2007
Filed under: Filed under: dashboard, sql server, performance, databases, dba, reporting
Database Administrator roles & responsibilities - difference in opinion

I have been asked about Database Administrator roles and responsibilities many times and also seen in forums/newsgroups. In a nutshell DBA is responsible for all sorts of database within the organisation. This might vary for the management of Enterprise...

Posted to SQLServer-QA.net - Knowledge Sharing Network (SSQA.net) by on Sun, Jun 17 2007
Filed under: Filed under: sql server, technet, dba, roles, responsibilties, technical, HR
SQL 2008 CTP is here, but what is going to happen for SQL 2000 version

Already I have been getting questions asking about what will be support for SQL 2000 version as the SQL 2008 is in CTP phase at the moment which is expected to release during next year. As it look at the moment the support (official) ends by April 2008...

Posted to SQLServer-QA.net - Knowledge Sharing Network (SSQA.net) by on Thu, Jun 7 2007
Filed under: Filed under: sql server, dba, support, lifecycle
Free DBA tool: SQL Log Rescue

A log analysis and recovery tool is an essential part of a DBA's toolkit. For monitoring SQL Server 2000 database transactions, recovering dropped tables, undoing rogue queries, and more, download Red Gate's free SQL Log Rescue tool. MoreHere...

Posted to SQLServer-QA.net - Knowledge Sharing Network (SSQA.net) by on Fri, Jun 1 2007
Filed under: Filed under: sql server, red-gate, dba
How to find list of DMVs & DMFs?

As most of blogs in this section travels through usage of Dynamic Management Views (DMV) & Dynamic Management Functions (DMF) I have had an email asking What is DMV & DMF and how to find list of them from a SQL Server instance. The internal mechanism...

Posted to SQLServer-QA.net - Knowledge Sharing Network (SSQA.net) by on Thu, May 31 2007
Filed under: Filed under: sql server, performance, management, microsoft, dmv, dba, dmf
CLR or TSQL - hard to decide for me in SQL 2005

Honestly I have had such decision time to choose whether to go to CLR (Common Language Runtime) or TSQL (Transact-SQL) to design on one aspect of component design at our place. Obviously TSQL was first choice as I have been experienced mostly, but don't...

Posted to SQLServer-QA.net - Knowledge Sharing Network (SSQA.net) by on Sat, May 12 2007
Filed under: Filed under: sql server, microsoft, dba, developer, catalogs, programming, clr
Database consistency checks and transaction log is filing up, help?

Yet anothe forums related question I would like to blog, as I have seen in my experience on newsgroups. There will be always a question asking about why Transaction log is filling up and blocking is ocurred when a DBREINDEX & CHECKDB processes are...

Posted to SQLServer-QA.net - Knowledge Sharing Network (SSQA.net) by on Wed, May 9 2007
Filed under: Filed under: sql server, performance, transaction log, dbcc, trace, search, concurrency, dba
ELSASOFT giving out SQLSPEC for FREE to MVP

Read More...

Posted to SQL Server Citation - SQL Server Blog by Hemantgiri S. Goswami by on Wed, May 2 2007
Filed under: Filed under: sql server, MVP, dba, document, contributors, sqlspec, ace, sql server community, oracle, elsasoft, mct

Page 6 of 6 (120 items) « First ... < Previous 2 3 4 5 6

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

Theme based on the Paperclip Blog Theme included in Community Server.
Enhanced to a Site-Wide Theme by Interscape Technologies.