New article on “Policy Based Management” is posted in our main website. Check the article from the link given below.
This article discusses the new feature named Policy Based Management in SQL Server 2008. Policy Based Management is an extensive management configuration that can be used to manage servers, databases and objects. Policy Based framework provides a way to define policies that apply to servers, databases and objects. With Policy based Management framework, you can enforce consistent policies across all servers.
Policy Based Management - SQL Server 2008
VN:F [1.0.8_357]
Rating: 0.0/5 (0 votes cast)
SQL Server 2008
Administration, SQL Server 2008
New article on Moving mirrored database is posted in our main website. This article describes how to move the database files of a mirrored database to a new location without any downtime. You can check the article from the link below.
How to Move mirrored database files
VN:F [1.0.8_357]
Rating: 0.0/5 (0 votes cast)
General
Administration, Database Mirroring
New article on SQL Server 2005 Best Practices posted in main website, you can read the article from the link below.
SQL Server 2005 Best Practices
VN:F [1.0.8_357]
Rating: 0.0/5 (0 votes cast)
General
Administration, SQL Server 2005
SQL Server 2005 SP3 released today after the release of SP3 beta a couple of weeks ago. You can download SP3 from the link below.
DOWNLOAD SQL SERVER 2005 SP3
Above download link is applicable to below products.
* SQL Server 2005 Enterprise
* SQL Server 2005 Enterprise Evaluation
* SQL Server 2005 Developer
* SQL Server 2005 Standard
* SQL Server 2005 Workgroup
For Express edition check the link http://go.microsoft.com/fwlink/?LinkId=64064 for SP3.
For a list of new features and improvements that are included in SQL Server 2005 SP3, review the What’s New document.
Once the server is patched with SP3, SQL Server version will be changed to 9.00.4035. You can use the below query to check it.
SELECT SERVERPROPERTY('ProductLevel')
SELECT SERVERPROPERTY('ProductVersion')
VN:F [1.0.8_357]
Rating: 0.0/5 (0 votes cast)
SQL Server 2005
Administration, Service Pack, SQL Installation
Couple of days back I saw a question on MSDN forums where a user is not getting any warnings when using isql (commandline utility) and he is getting warnings when using isqlw (query analyzer GUI) for the same query. I’m just writing this article because many of them face this problem when they do batch processing data’s through isql.
Example:
Consider you are having a table with column char(3) and if you insert a value which has 4 characters then sql client utility should throw a error. When you connect SQL Server using query analyzer, then Ansi_warnings are on by default and you will receive this error & the transaction will not happen. However if you connect SQL server using isql command line utility then you won’t get this error, instead it will truncate the last character and insert it into the table. Lets check it out! Read more…
VN:F [1.0.8_357]
Rating: 0.0/5 (0 votes cast)
General
Administration, SQL Server