If you are managing a SQL Server you will sooner or later need to schedule some maintenance tasks, like backing up your databases. The easy way to do this is use the SQL Server 2008 Maintenance Plan wizard (SSMPW). Here are some FAQs about SSMPW: ...

A migration to a newer version of SQL Server is usually a very critical process. Everyone is anxious if their old application will work as expected in the new version of SQL Server. Well you won't need to plunge into the deep sea and hope for the...

A matter that constantly comes up when discussing with customers is the size and history of the error log of SQL Server. The first question concerns the size of the ERROLOG file. If a lot of operations take place that log information to the errorlog...

Often I get questions from customers about SQL Server 2008 Express (what is it, what features does it have, e.t.c.) and so I decided to dedicate a blog post to summarize its usage and capabilities. Ø What is SQL Server 2008 Express? SQL Server...

Happy new year, this is my first blog post for 2010 :) My first blog post of 2010 will be about the following scenario: - You want to configure the local security policies of a Windows 2000 or Windows 2003 server. - You open the console secpol...