Welcome to SqlServer-QA.net Sign in | Join | Help

SQL Server 2008 (SSQA.net)

Trusted, Productive and Intelligent enterprise data platform.

Browse by Tags

All Tags » sql server » enhancement   (RSS)
SQL Server Data Encryption and Backup - any guidelines to follow?
When it comes to the data encryption within SQL Server 2008 you would think about Transparent data encryption (TDE) which is a new encryption feature. It sounds good that this is a high level security feature you can deploy to secure the data, and a catch Read More...
SQL Server 2008 - TSQL behavioural changes and enhancements
As usual the new release of SQL Server version 2008 had few changes from 2000 to 2005 and as usual this control-of-flow sequence should occur in order to take advantage of performance with transaction/rollback advantages. Such direction of flow should Read More...
SQL Server 2008 - enhanced feature in database mirroing "log compression"
Database Mirroring - new feature from SQL Server 2005 within High Availability ranch, a software based solution for database availability. Very important for the DBAs to keep up the database recovery model to FULL at all the times to achieve the High Read More...
Database Mirroring enhancements in SQL Server 2008
So far from the CTP release of SQL Server 2008 there has been few enhancements to the Database Mirroring, few of them I would like to list from what has been stated in BOL: Log Performance Enhancements Compression of stream data for which at least a 12.5 Read More...
Replication security information you need to know with SQL Server 2008
I was able to install SQL 2008 July CTP as a Virtual Image, tried to test few replication tasks to know what has been changed since last versions. At this time I would like to use the replication scripts from SQL 2000 version to see what it takes, nothing Read More...