Browse by Tags

SQL Server 2008 features - Relational & Data Warehouse Scalability list (new)

Published 2 May 8 9:12 AM | SSQA.net

Scalability is an important aspect in every application, a common achievement within OLTP environment and still applicable to OLAP (Anlaysis Services) environment. In any if the application or a cube or mining model may be unavailable for querying because...

Filed under: sql server, performance, ssas, features, 2008, whitepaper, Analysis Services, scalability

SQL Server 2008 - What's new and what's coming up!

Published 17 March 8 3:11 AM | SSQA.net

You may be aware that MVP s have the advantage of getting to know about the product information before it is let to the user community, that is the main advantage (I feel) to make the most of MVP award experience, Microsoft keeps MVPs informed of award...

Filed under: sql server, blogs, mvp, download, features, 2008, ctp, whatsnew, product release

SQL Server 2008 - Activity Monitor a new key to DBA!

Published 11 March 8 3:14 AM | SSQA.net

Have you looked at the Activity Monitor screen within the Managment Studio? I feel this is somewhat surprise features included from February CTP (or was it there before?). This is more useful to the DBAs to have a look at resource activity and locking...

Filed under: sql server, blocking, dba, version, features, 2008, pages, locks, activity monitor

SQL Server 2008 Data Security - TDE: Transperent Data Encryption what you need to know

Published 5 March 8 2:5 AM | SSQA.net

What kind of security features you adopt to protect your data? Login security, permissions and unauthorised access to your data, there is more you can do with SQL Server 2008 new feature called TDE - Transperent Data Encryption that is provided automatically...

Filed under: sql server, security, features, 2008, data encryption, transperent, tde

What's new, rather removed features from SQL Server 2008 (CTP6)

Published 21 February 8 2:11 AM | SSQA.net

It has been a 'very busy' month sofar, in particular to Microsoft world and sub-domains of Windows Server, Virtual Server & SQL Server and you know why from here. Not a 'real' launch for SQL Server folks out there, but a concession...

Filed under: sql server, microsoft, download, features, 2008, ctp, deprecated, whatsnew, removed

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

New feature in SQL Server 2008 - compression how it works?

Published 3 October 7 9:42 AM | SSQA.net

Since the release of SQL Server 2008 (last 2 CTPs) users are anxiously awaiting for data compression feature, so how it is handled in this version and what it does, is it a good thing? Data compression enables you to store your data more effectively and...

Filed under: sql server, microsoft, team, features, 2008, development, data capture, compression, backups, FAQ

SQL 2008 Training Available : free e-learning

Published 10 July 7 2:57 AM | SSQA.net

Here is the link to attend a free e-learning on SQL Server 2008 eLearning78337 link. Title: Clinic 7045: What's New in SQL Server 2008 Course Type: Self-paced Course (at your ease) Available Offline: Yes Estimated Time of Completion: 2 Hours Language...

Filed under: sql server, katmai, features, 2008, environment, new, elearning

Up close and personal with SQL Server 2008 (Katmai)

Published 22 June 7 4:33 PM | SSQA.net

In this two-part podcast series, we take a close look at SQL Server 2008. Microsoft product manager Francois Ajenstat discusses the key features of the upcoming version of SQL Server, what Microsoft is doing to scale SQL Server 2008, plus progress being...

Filed under: sql server, podcast, katmai, features, 2008

SQL Server 2008 - Change Data Capture: new feature

Published 20 June 7 4:34 PM | SSQA.net

Let us talk briefly about the new feature that is introduced within SQL Server 2008 aka Katmai. Change Data Capture (CDC) is (similar to triggers: INSERTED & DELETED tables) the 'new boy in SQL Server town' that records the DML activities...

Filed under: sql server, katmai, features, 2008, new, cdc, data capture

LINQ vs TSQL - Where it is going?

Published 17 June 7 2:58 PM | SSQA.net

There are few discussions around that is TSQL will cease to work as LINQ and another point of impact on C# here. As LINQ is more kind of development language as Microsoft promoting for develpers, IMHO it is not a replacement for TSQL at all. There are...

Filed under: sql server, features, 2008, deprecated, linq

Store any type of data - SQL 2008

Published 16 June 7 6:11 PM | SSQA.net

As you may have or may not seen from the initial documentation of SQL Server 2008 (formerly Katmai) product overview that few changes with regard to the data transition for the relational and non-relations quite good changes are introduced such as: FileStream...

Filed under: sql server, katmai, version, features, 2008, new, connect

Deprecated features highlights in SQL "Katmai" 2008 release

Published 10 June 7 5:52 PM | SSQA.net

SQL 2008 books online confirms the deprecated features that are not supported with the release of RTM, those few lists are as follows: SP_DBCMPTLEVEL is replaced with ALTER DATABASE .. SET COMPATIBILITY_LEVEL SP_HELPDEVICES is replaced with sys.backup_devices...

Filed under: sql server, microsoft, features, 2008, deprecated, development