SqlServer-QA.net

Here is the monthly security update that I receive from Microsoft that I would like to share, this is more important to put this into practice to secure your Server environment.  This security update resolves a privately reported vulnerability in the Server service. The vulnerability could allow remote code execution if ...

I have no doubt in stating that Virtualization has become hot topic in the industry now a days, that is leading to consolidate your Database platform using available technologies. The main interest in getting this up is that virtualization can lower overall IT costs which is the priority for any Enterprise, but at the same time one ...

Fais Your list of steps are simple and clear to follow and I hope you have tested them already. If not for a simulation make sure to go through on a virtual server (non0clustered) to give you more in hand experience. This is required to get a feel of how you are going to manage the upgarde tasks, as it may not be as easy it said, and I would like ...

Linked Server errors, such as between SQL Server 2000 and 2005 versions are quite common in DBA-day life. When it goes wrong I would always refer (myself) and others to review HowDoI-PreventLinkedServerIssues resource from ASPFAQ site. Also the usual practice of checking of whether its a security issue to allow the logins, if so then goto ...

ITS Party time!!! Well I'm joking, its not a real-party time in the sense of food & drinks, its party time for Database world. Year 2008 entered already that kicks Microsoft gearing up for worldwide events, important ones. Release of Visual Studio 2008, Windows Server 2008 and SQL Server 2008!!! This brings most of the users in IT to ...

Virtual labs - in simple words its simple to use where a pre-installed environment is setup to try out /test SQL Server installation for your databses upgrade, that has full-featured labs. Not only this you have an option to download manual with a 90-minute block for each module if you are not sure enough. All you have to do is sign-up (free) on ...

SQL Server User Education blog on MSDN has this update about SQL Server 2000 BOL Update - Don't forget to update your local version copy with this latest release. You can download the updated SQL Server 2000 Books Online from the Microsoft Download Center. .