Browse by Tags

SQL Server 2005 or 2008: SQL Native Client or MDAC - which is best one to use?

Published 16 June 8 3:53 AM | SSQA.net

SQL Native client or MDAC - which is best one to use? This was the question I was asked during my presence at DAT booth at the Tech-Ed ITPRO conference in Orlando. The sensible answer will be 'it depends'. Practically I have seen that there are...

Filed under: sql server, mdac, features, sqlnative, components, native client, editions

SQL Server 2008 - Replication and Filestream, are both supported together?

Published 26 May 8 4:1 AM | SSQA.net

Ok, replication concepts and technology has been continuing since the olden days (version 70) within SQL Server journey. To talk about new features within SQLServer 2008 comapring to the previous versions, FILESTREAM where much of data is created every...

Filed under: sql server, replication, BOL, features, support, filestream

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

10 Best Practices for Data Archiving - all platforms

Published 31 December 7 6:44 AM | SSQA.net

When you think about effective data management, archiving will also play important role to manage your data. In this regard Windows Magazine has included best practices for your data management. Data privacy and identity theft have a higher profile in...

Filed under: sql server, data, reporting, features, best practice, key, platform, database management, archive

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 Server 2008 - what would be cost for licensing as compared to SQL 2005 version?

Published 19 September 7 2:30 AM | SSQA.net

Since the release of SQL Server 2008 CTP most of the blogs are filled with 'whats new' feature within this release or going to create a highlight as compared to SQL 2005. The best of all those blogs I would recommend (thanks to) Bob Beauchemin...

Filed under: sql server, microsoft, features, install, licensing, finance

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

Swiss-knife features in SQL Server to help you

Published 25 May 7 8:11 AM | SSQA.net

Over the times managing RDBMS platform has evolved into a phase that all of the essential functionality that a Database Administrator needs to administer a multivendor or single-vendor database environment wrapped in an intuitive graphical interface....

Filed under: sql server, microsoft, ssis, ssas, ssms, features