Expect to answer 60 multiple choice questions within 120 minutes. To pass the exam, you need to answer at least 42 questions correctly (70%). Specifically, the exam tests you about the following categories of information.
Community
In-line functions in SQL Server 2000
By Mark Oldfield – One of the most under appreciated new features of SQL Server 2000 is the usage of functions. It is definitely worthwhile creating a “tool-kit” of commonly used functions to use in each new project. So next time you are hard-coding a common task, take a bit longer and write a funct
Microsoft’s Road Map Shows New Windows File System
Microsoft execs confirmed that the Longhorn version of the Windows client and server–due several years from now–will use as its file system database technology slated for inclusion in the next version of SQL Server, code-named Yukon. The upcoming version of SQL Server will store documents, E-mail,
Microsoft Access Developer’s Guide to SQL Server
Book by Mary Chipman and Andy Baron – If you are faced with the task of moving your Access databases to SQL Server, or even if you not, but you want to get more performance and scalability out of Access, then the book Microsoft Access Developer’s Guide to SQL Server is for you.
Oracle Announces New Oracle9i Developer Release For Jaguar
by Bryan Chaffin – Apple got a big boost in the enterprise market as Oracle released a new developer release for Oracle9i, its enterprise level database solution. The new release is designed to work with Mac OS X Server, and Oracle is pushing Xserve as the preferred hardware.
Locking down Microsoft SQL Server
By Jonathan Lurie and Timothy Stockstill – Rewriting applications because of database security gaps is costly and time consuming. One of the easiest ways to avoid rewrites is to make security a priority during the initial database design and to enforce security at each tier. We’ll discuss som
Get status information for trace flag(s) currently turned on
by taruna paaladugu – The command DBCC TRACESTATUS can be used to get the status information for trace flag(s) currently turned on. Here is the syntax:
Top Online Discussion Forums
By Michael Otey – Although it’s the birthplace of spam, the Internet has many redeeming qualities. Sometimes when you’re stumped by a SQL Server problem, you can use the Internet to find information and solutions. Not all advice is good advice, but the Web provides a way for you to post questions an
Web Services in Hand
By Darryl K. Taft – Palm Inc.’s Palm Solutions Group has teamed with BEA Systems Inc. to announce a long-term strategic relationship to deliver Web services to Palm-based handheld devices.Palm will develop tools and a device-side software suite for simplifying development and deployment of m
DataPower Delivers Accelerator For XML, Web Services Traffic
By Richard Karpinski – DataPower Technology said it has delivered a network device to speed the performance of XML-based Web services. The DataPower XA35 XML Accelerator can be deployed either alongside application servers — which store and deliver Web services — or downstream in the networ