Security! This is the word comes in mind of every concerned person when it come...
This post will show you how to change the collation settings in MS SQL Server for specific database...
In this post I will show you how you can resolve collation conflict error...
In this book I have tried to cover every single piece of information that might requires for installing and configuring SQL Server HA option like Clustering, Replication, Log Shipping and Database Mirroring...
Generally, we create views and stored procedures (proc here after) ...
SQL Server 2008 November CTP is available for download, click here to grab your copy of SQL Server 2008
Since some times their is a discussion on what's new in SQL Server 2008, when the reference material will be available!! Here is an answer to this, Microsoft has introduce a course at its E-Learning, the course aims to educate IT Professional who has prior experience working with SQL Server. Microsoft has made learning SQL Server 2008 easy by offering e-learning course, the course is devided into three category:
more details on this course is available here, all you need to have is a Windows Live Account https://www.microsoftelearning.com/eLearning/offerDetail.aspx?offerPriceId=139087
