During the conference of Worldwide Partner Conference 2007 Microsoft announced the official date of release for SQL Server 2008 which is in CTP3 at the moment. This conference is aligned to deliver best practices for software-plus-services delivery models. Kevin Turner, chief operating officer announced...
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: English This is designed to learn about new and...
They (MS) said DTS will be wiped out after SQL Server 2005 and will not be supported, more and more SSIS is promoted to use. But within SQL Server "Katmai" DTS is included with a provision of management, run-time, and design-time support for DTS packages that were created by using the SQL Server...
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 policies to manage entities on that SQL instance...
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 of the systems. Take it similar approach on...
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 made regarding upgrades to the latest version of...
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 to the database objects with an easy relational...
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 data to store/allow large binary data with...
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 for SQL 2008 release documentation aka BOL...
Few out there are still not comfortable to install or test the SQL 2008 (Katmai) as SQL 2005 is still new in the field and users are getting eventually hands-on experience. So in order to get hands on for the documentation 'only' for SQL 2008 (katmai) then you can download the documentation files...