Browse by Tags
All Tags »
dba (RSS)
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...
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
Read More...
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...
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
Read More...
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,
Read More...
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
Read More...
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 by
Read More...
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
Read More...
See this VIdeo_blog by Linchi Shea in AskaSQLGuru website, very useful for the newbie DBAs.
Read More...
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
Read More...
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
Read More...
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
Read More...
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
Read More...
SSMS - save your passwords safely in dev. environment
Read More...
Well the prime criteria for DBAs is to upgrade from the previous versions to latest version and it is not an easy option or platform to perform so quickly without having a proper testing within their environment. As far as the SQL Server is concerned
Read More...