Can we audit the activity inside the SQL Server 2008 to capture SELECTs activity? For the first time I though CDC will be useful to DBAs in auditing the activity on the database, but its not entirely. It is equivalent to auditing functionalities and in short CDC is more poised towards the ETL for incrementatl data load and that uses an ...

Hot topic in the industry about the server consolidation and how you can take advantage by planning for SQL Server 2008 that is poised to release by next year. DOWNLOAD the document that consits the information on Server Consolidation DOWNLOAD the datasheet for Server Consolidation Finally WebCast on the Server Conslidation...(read more)

Within SQL 2008 I was looking for information on report building (GUI enhancement) as compared to SQL 2005 Reporting Services. I believe nothing much different by looking at the current CTP for SQL 2008, I expect a change when SQL 2008 RS is ready RTM. Meanwhile if you are willing to go through this refer to the Tutorials links as follows: ...

When L Wednesday, August 22, 2007 4:00 PM Eastern | 3 PM Central | 2 PM Mountain | 1 PM Pacific Hosted by: Microsoft, Edgewood Solutions & Idera Overview of Microsoft SQL Server 2008, code name ''Katmai'', the next generation of SQL Server. ''Katmai'' provides an enterprise data platform for your mission-critical applications, while providing ...

I was able to install SQL 2008 July CTP as a Virtual Image, tried to test few replication tasks to know what has been changed since last versions. At this time I would like to use the replication scripts from SQL 2000 version to see what it takes, nothing much I believe compared from 2005 to 2008. While going this replication security process gone ...

SQL Server Compact Edition is best used with handheld devices such as PDAs to get update on the sales & marketing information within your SALES department that is spread across the globe. As in the name it is compact database ideal for embedding in mobile and desktop applications. SQL Server Compact 3.5 gives developers a common programming ...

As this is the 2nd instalment of public CTP of SQL Server 2008 we will be expecting more information on 'whats new' and 'whats not (deprecated)'. For me (majority of you too) having handful information with DMVs is essential, in this regad we have 5 new DMVs available with this CTP, here they are: sys.dm_os_memory_brokers This DMV is helpful to ...

By now you are aware that July 2007 CTP for SQL Server 2008 is available to download, if you are not ready to test this installation even you can take a tour by referring to the BOL for July CTP. Exclusive Link to download BOL only. As you can see above that if you have installed Katmai books online this instalment of BOL will be installed as a ...

So July2007Ctp is available now and you need to learn more details about this release, then look at the calendar of events (online & webcasts) that are lined up by Microsoft SQL Server Developmetn Team. The first event is scheduled to host on 13th August 2007, register for July CTP Public Web Chat and don't forget to Add to Calendar Further ...

Here it is, next installment of SQL 2008 CTP which is July CTP of SQL Server 2008 is now available for download on the SQL Connect site (you need to have a passport login to download). There are few enhancements to the Reporting services, introduction of new date & time data types including the performance data colleciton. The ones I like are ...