SqlServer-QA.net

What Makes a DBA is a real Database Administrator Indeed? This looks like a small question but it requires a big answer to complete the definition of what makes a real DBA! Another question arises for the DBAs that how many servers/databases you manage? Not only that many forget that there are 2 different types of DBAs, Development & ...

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

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

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

This is first time Microsoft has divided the conference into 2 sections, Developer & IT-PRO.  Why Attend Tech-ed? IT Pros, you'll gain new solutions and new ideas for being more productive from sessions, product assessments, and interaction with experts and peers. Gain real-world learning from the Microsoft IT support ...

DBAs look after an organization's most important asset – its data – and yet their contribution to an organization is all too often misunderstood. Now it's time for DBAs to finally get the recognition they deserve with some new community awards, sponsored by Red Gate. If you're the kind of DBA who makes a real difference to your organization, or ...

I'm not going to shoot any questions to Microsoft about RTM release for SQL Server 2008, as it was made it clear from The Data Platform Insider blog post as:   Extract: ''Over the coming months, customers and partners can look forward to significant product milestones for SQL Server.  Microsoft is excited to deliver a feature ...