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 to their grief that SQL 2008 CTP6 is available to...
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 reduce the storage requirements for your data....
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 in SQLSkills for the extensive list & useful...
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 system table SP_RENAMEDB is replaced with...
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. May be it is a smaller system or mission-critical...