SqlServer-QA.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 to their grief that SQL 2008 CTP6 is available to download and next question will be what's new. ...

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. SQL Server 2008 provides ...

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 blog information about SQL Server 2008 new ...

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 ALTER DATABASE .. MODIFY ...

Whenever the new release of a product comes out the first thing to know about what's new with this release, as the code name Katmai and now 'SQL Server 2008' which will be available for RTM in the year 2008. So the features within SQL 2008 (most interesting)  are the Declarative Management Framework, Resource Governor ...

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 system to maintain, there are various factors ...

I had a bit problem in opening few of my files on my desktop where I had Office 2003 installation, these files are created using Office 2007 on my laptop. Initially I was bemused to see every time I click on .docx file I had a message saying windows cannot open the file:  Hm, then I have realised that I need ''Microsoft Office ...

The next release of Visual Basic includes a set of features that can greatly improve a developer's productivity when building data-oriented applications. Get an overview of Visual Basic 9.0 in Visual Studio 2005 and see how the new language extensions introduce general-purpose query facilities that apply to all sources of data, be it relational, ...