SqlServer-QA.net

19th September 2007:After a 18 hour journey from my place to Denver I was able to settle down by last night and jetlag adds more weight to the tiredness. I'm back in Colorado Convention Center @ 07:00 hours to register at the SQLPASS 2007 summit and I can see a little bit downtrend in the number of attendees as compared to the previous 2006 ...

During the conference of Worldwide Partner Conference 2007 Microsoft announced the official launch date 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 that Windows Server® 2008, ...

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 ...

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 2000 tools and object model. By using SQL 2008 ...

As you have seen since SQL Server 2005 release the sample databases are not included and as I mentioned in SampleDBs blog you have to download from the SQL Server Samples Web site. Also SQL 2008 BOL will no longer include the databases & applications, all you have to refer the samples website to download, these will include only SQL ...

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. This is more useful or power ...

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 the software installation too, in this regard ...

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 SQL Server. Part 1: Outlining SQL Server ...

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 format. Further the column ...

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 transactional consistency, as of now ...