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

Error message 14420 and error message 14421 that occur when you use log shipping in SQL Server

Tue, 21 Apr 2009 07:02:00 GMT

If you are using SQL Server Log Shipping then above error message number will be familiar. One of the following error messages may be logged in the SQL Server error log: Error message 14420 Error: 14420, Severity: 16, State: 1 The log shipping destination...(read more)

SQL Server 2008 Service Pack 1 CTP

Sun, 08 Mar 2009 15:33:00 GMT

Its over half-year that SQL Server 2008 has been RTM'd and now it is time to test the CTP (Community Technology Preview) aka beta version of Service Pack 1 for this version. Absolutely right, for those of you waiting to try SQL Server 2008 until SP1...(read more)

SQL Server Execution Context and Security - more on Policy Based Management principal ##MS_PolicySigningCertificate##)

Mon, 23 Feb 2009 07:53:00 GMT

In continuation to this SQL Server 2008 - Policy Based Management - usage of ##MS_PolicyEventProcessingLogin## under Security, Logins in Management Studio post in the past there is more to talk about Executing Context and Security policy within SQL Server...(read more)

Database diagram issues after SQL Server upgrade

Wed, 18 Feb 2009 07:50:00 GMT

Have you planned your databases upgrade from SQL Server 2000 version to 2005 or 2008? Have you tested the above upgrade plan? How many times you have been involved in the number of databases upgrade within your platform? Many questions to answer when...(read more)

My session at SQLBits IV - Upgrading To SQL Server 2005 & 2008: Notes & Best Practices

Mon, 09 Feb 2009 08:53:00 GMT

Thanks to the members/users who voted for my session in relate to the SQLBits IV conference submissions . Thanks very much for submitting a session for SQLBits IV, 28 th March 2009 in Manchester, I am very pleased to tell you that your session “ Upgrading...(read more)

Reminder: Live Webcast TODAY! 10 Tips for Performance Monitoring - IDERA

Wed, 04 Feb 2009 09:01:00 GMT

Tired of phone calls from end users complaining about slow SQL Server performance? Tune into this two-part webcast to learn practical tips for proactively monitoring and managing SQL Server performance. In this live series, Greg Robidoux with Edgewood...(read more)

Two DBAs walk in to a room of Developers...

Tue, 03 Feb 2009 10:11:00 GMT

... rest is history! An unique event is planned by Scottish Developers network on Tuesday, April 14, 2009 from 6:30 PM - 8:30 PM (GMT) in Glasgow, Scotland. . Did you hear the one about the two DBAs that walked into a room full of developers? If you want...(read more)

Developer Day Scotland - get ready for 2009 event on 2nd May at Glasgow Caledonian University.

Mon, 02 Feb 2009 10:04:00 GMT

Developer Day Scotland (DDS) is a community event, run by community for community, which is based upon the highly successful Developer! Developer! Developer! (DDD) community conference events. Not to mention that they are very popular among SQL Server...(read more)

SQL Server - Service Broker and Messaging, take care of MSDB sizes

Mon, 02 Feb 2009 07:27:00 GMT

You may notice that from SQL Server 2005 version onwards MSDB system database has got more importance than any other system database, I believe. It is a fact that if any problem ocurrs on the system databases such as MODEL or TEMPDB or MSDB the SQL Server...(read more)

Control the database version - an important task for DBA!

SqlServer-QA.net — Tue, 09 Dec 2008 07:37:00 GMT

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...(read more)

What Makes a DBA is a real Database Administrator Indeed?

SqlServer-QA.net — Wed, 03 Dec 2008 07:41:00 GMT

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...(read more)

SQL Server - PERFMON counters and Resource Governor - what you can do in a performance issue situation?

SqlServer-QA.net — Mon, 17 Nov 2008 07:41:00 GMT

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...(read more)

RML Utilities (READTRACE/OSTRESS) now supports SQL Server 2008

SqlServer-QA.net — Thu, 13 Nov 2008 08:00:00 GMT

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...(read more)

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

SqlServer-QA.net — Mon, 29 Sep 2008 07:15:00 GMT

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...(read more)

What's new for a DBA in SQL Server 2008 - Scottish Area SQL Server User Group

SqlServer-QA.net — Fri, 19 Sep 2008 08:28:00 GMT

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...(read more)

SQLBits (III) Cubed - Mark your diary September 13 2008

SSQA.net — Fri, 01 Aug 2008 12:25:00 GMT

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...(read more)

SQL Server 2008 new features highlights - a short video samples

SSQA.net — Wed, 25 Jun 2008 18:06:00 GMT

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...(read more)

Tech-ed North America - what I'm doing there?

SSQA.net — Thu, 29 May 2008 21:18:00 GMT

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...(read more)

Red-gate news: New SQL Server DBA Awards - the search for the Exceptional DBA of 2008 begins

SSQA.net — Wed, 28 May 2008 10:56:00 GMT

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...(read more)

SQL Server 2008 features and getting through CTP, RC, RTM. Are we there yet?

SSQA.net — Wed, 14 May 2008 08:23:00 GMT

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...(read more)