Browse by Tags

SQL Server 2008 - TSQL behavioural changes and enhancements

Published 31 March 8 2:0 PM | SSQA.net

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...

Filed under: sql server, performance, transaction, article, 2008, tsql, enhancement, begin

SQL Server 2008 BI enahncements - what you want is what you get!

Published 25 February 8 2:49 PM | SSQA.net

So far the SQL Server 2008 Analysis Services new features were included until October CTP, top features that Microsoft would like to include within RTM version: New Aggregation designer - to browse and modify aggregation designs that are now shown grouped...

Filed under: sql server, performance, ssis, bi, ssrs, 2008, new, reporting services, enhancement, samples, business intelligence, integration services

SQL Server 2008 - enhanced feature in database mirroing "log compression"

Published 15 October 7 4:11 AM | SSQA.net

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...

Filed under: sql server, transaction log, log, features, 2008, database mirroring, compression, enhancement

Database Mirroring enhancements in SQL Server 2008

Published 4 October 7 9:9 AM | SSQA.net

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...

Filed under: sql server, release, 2008, ctp, database mirroring, enhancement, capture

Replication security information you need to know with SQL Server 2008

Published 15 August 7 6:0 AM | SSQA.net

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...

Filed under: sql server, security, replication, 2008, environment, 2000, 2005, enhancement