In this post I would like to demonstrate with a hands-on example that is not always possible to restore a database to any Edition of SQL Server.We assume of course that the version of SQL Server remains the same. In my machine I have various instances
Διαβάστε περισσότερα
In this post I would like to talk about a common issue that confuses SQL Server DBAs and developers.RecentlyI had to deploy an ASP.Net web site from the development server to the live production server.The database server on the deployment server was
Διαβάστε περισσότερα
In this post I would like to about a new feature in SQL Server 2008, namely Policy-Based Management.With this new feature DBAs can enforce policies to an instance of SQL Server or many instances of SQL Server they are responsible for. Most DBAs have to
Διαβάστε περισσότερα