SqlServer-QA.net

PERFMON and Resource Governor - two great tools in hand for a DBA to monitor/resolve the performance problems, agreee! Back in olden days you may remember about SQLDiag and PSSDiag, the utility used as a general purpose diagnostics collection utility that can be run as a console application or as a service. Both of these Diag tools are helpful to ...

In continuation to SQL Server - Precision Performance techniques using RML Utilities and SQL Server troubleshooting tools PSSDiag, SQLDiag, SQLNexus, RML Utilities and ReadTrace: which one to choose? posts here it will be a wonderful news for DBAs to hear that Microsoft Development team developed an update for the RML Utilities which now ...

Hi, I have installed SQL Server 2005 MSDE. I am trying to take SQL Server 2005 database backup from Dos prompt but I am getting the following error: [Microsoft][ODBC SQL Server Driver][SQL Server]Cannot open backup device 'C:\test.bak'. Operating system error 3(Error not found). [Microsoft][ODBC SQL Server Driver][SQL Server] BACKUP DATABASE ...

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 to handle these important tasks in hand with the scripts and not to leave to the GUI or API ...

Here is another meeting scheduled for Scottish Area SQL Server USergroup after the long (summer) holidays, don't miss the event if you want to know:  What’s new for a DBA in SQL Server 2008? There are many great new features in SQL Server 2008. In this presentation Martin will demonstrate some of his favourite features that will be of ...

Here it comes again, second one in this year one of the biggest UK based SQL Server conference - SQLBits III aka cubed. It is free to attend and what you will get is: 20 hours of top content from the world of SQL Server presented by the top speakers in the UK SQL Server Community. You will also have the chance of meeting and networking with like ...

Actually need to give in installer.

Hi, I want to reduce the size of backup file(.bak). For this I have shrink the log files. But this reduced the size from 486MB to 485MB. Can someone tell me how to reduce the backup file size further?  Thanks in advance...Nishant Shende       

I'm sure that by now you are aware about the list of new features within SQL Server 2008 and recently I have had couple of emails from newbie DBA/users in SQL Server asking about any reference they can get on these new features, with a video. In this regard Microsoft learning has provided right to the point of subject references as ...

Thank you so much for all the responses to the DBA Blunders post! As I mentioned, however, that question was asked on behalf of a friend of mine. Now I have a question of my own. I am currently training a group of new junior DBAs. One of them has already started assisting with some client operations, but is still closely supervised. For those ...