June 2007 - Posts
SQL Server 2008 brought new feature that is Declarative Management Framework (DMgF, we cannot name it as DMF as it stands Dynamic Management Functions from SQL 2005). This is a policy based system to manage a SQL Server instance, using SSMS you can create
Read More...
Every trade has got high-risk profession, IT has no exclusion and due to the considerable risks involved from hackers, spammers, security-threats, floods etc. During a course of action the risk-averse can lead to the increased performance & scalability
Read More...
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
Read More...
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 applied
Read More...
This session provides an overview of the next release of Microsoft SQL Server that is currently under development. We cover the core value proposition, major themes and scenarios, and some specific improvements. We also discuss the new development processes
Read More...
There are few discussions flying around that Transact SQL will cease to work as LINQ is round the corner and also interesting discussion about impact on C# here. As LINQ is more kind of development language as Microsoft promoting for develpers, IMHO it
Read More...
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
Read More...
One of our Developer asked me this question that they are unable to find complete informaiton about the compatibility between SQL 2000, 2005 and 2008 versions. The answer is yes, its obvious and don't worry this is a temporary feature as the current CTP
Read More...
Few out there are still not comfortable to install or test the SQL 2008 (Katmai) CTP as SQL 2005 is still 'fairly' new in the field and users are getting eventually hands-on experience. So in order to get to know more on the documentation 'only' for SQL
Read More...
As you are aware SQL Server 2008 CTP is available for download and the heat is on to catch up what it will be different with SQL 2008 as compared to current evolution of SQL 2005. SQL Development Team in Microsoft proudly announces that SQL 2008 is built
Read More...
The new feature in SQL 2008 that is Declarative Management has a bug and it seems to be inoperable. Dan Jones from MSFT has suggested the fix is to launch a command line and run the following command: C:\Program Files\Microsoft Visual Studio 8\SDK\v2.0\Bin\sn.exe
Read More...
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
Read More...
First of all I would like to remind the users to install the SQL 2008 CTP on their Virtual Server environment rather than mixing with current test or development (physical) environment. Once the SQL 2008 CTPs are more stable and if you are planning to
Read More...
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)
Read More...
Its official now, SQL Server 2008 Community Technology Preview (CTP) aka beta available to download and as usual the codename for this release has been Katmai. CrossPost on SQL 2008 in this site.
Read More...