(Linchi Shea) The best documentation on the I/O behavior of SQL Server checkpoints is found in SQL Server 2000 I/O Basics by Bob Dorr. In particular, you should read the following carefully:
Other News
You cannot rebuild system databases if you run the Setup command from a location that is not the original installation location of SQL Server 2005
When you run the Setup command from a location that is not the location from which you originally installed an instance of Microsoft SQL Server 2005, you cannot rebuild system databases.
Chapter 5: Administering SQL Server 2005 Integration Services
(Ross Mistry, Chris Amaris, Alec Minty and Rand Morimoto) SQL Server 2005 Integration Services (SSIS) replaces the SQL Server 2000 Data Transformation Services (DTS). SSIS provides for the following data services: –Extraction –Transformation –Loading
What’s new in SQL Server 2008
(Steven Warren) SQL Server 2008 will be released in 1st quarter of 2008. We may be also looking at the release of Windows Server 2008 and Visual Studio. If you are interested in SQL Server 2008, you can download the latest CTP today.Here is a list of some of the new features available (excerpts from
Webcast Today – Troubleshooting and SQL Server 2005
The Weekly SQL Server Show – Watch Now This show is an interview with Kim Tripp and Paul Randal. We got together at DevConnections in Las Vegas and talked about everything from the famous board game to SQL Server 2008. > Watch Here Many Things Can Impact Query Performance Once you work through your systems, reviewing calls, reviewing indexes, checking […]
Database Platform Choices – The Results
Just Posted: SelectViews 86 This show is an interview with Kim Tripp and Paul Randal. We got together at DevConnections in Las Vegas and talked about everything from the famous board game to SQL Server 2008. > Watch Here Converting Mainframe Data to SQL Server? Do you need expert conversion of complex EBCDIC (mainframe) data into ready-to-import ASCII files? Greenview’s […]
IBM DB2 Content Manager security model essentials
(Naga Praveena Palasamudram, Suma C. Shastry and Aruna Dadi) IBM DB2 Content Manager (CM) provides a flexible way of defining the security for your Enterprise Content Management (ECM) system. Depending on your business needs, you can design the security for your ECM system to be lenient or strict. C
New Administrative Views in DB2 9.5
(Chris Eaton) I’m just back from IDUG in Athens where I attended many great sessions and found lots of new material for my blog. I have already written many blog postings on the new administrative views in DB2 9 (search my blog for SYSIBMADM). So let’s start off with some new administrative views th
Converting Schematron to XML Schemas
(Rick Jelliffe) Noah Mendelsohn on XML-DEV got me thinking again about the obvious dual of the recent blogs here: how to convert Schematron into XSD. Putting aside the natural question of why we might want to do this, here’s my stab at an answer.
XAML: Rethink How You Code UIs
(Kathleen Dollard) Developers at Microsoft have been busy revolutionizing how we program of late. Nowhere are these changes more evident today than when creating user interfaces (UIs), where, instead of CodeDOM generation of untouchable files, you’ll program with the intrinsically declarative model