by Chris Kempster – While Windows 2000’s encrypted file system option provides needed security, how does it affect SQL Server’s performance?
Other News
Administrators Fight Back Against Slammer
By George V. Hulme – The impact of the Slammer worm subsided Monday as companies scrambled to patch systems and block the worm’s ability to spread. Slammer is being touted as the worst attack on the Internet since the summer of 2001, when a worm called Code Red attacked hundreds of thousands of syst
Counting the Costs
By Itzik Ben-Gan – You can use date and time manipulations for calculating call costs across different rate periods as long as you stick to the basics.
Leaving the History Behind with Oracle’s Fine Grained Access Control
Marin Komadina explains how to export tables from a user schema–without having to export the history tables as well.
Use SYS_CONTEXT to Obtain Session Information
by Ahbaid Gaffoor – Use the SYS_CONTEXT call to extract session infomation for your application.Here’s a sample script which I use frequently to obtain a session’s information when connected in SQL*Plus:
XML/Web Services 100 Interview Questions – Part 2 of 5
Preparing for an interview? Or just want to refresh your XML skills? Here are 100 questions on XML and related technologies. The Part I in this series presented 20 questions to assess the basic concepts. Now, the Part II focuses on XML implementation questions specific to Microsoft platform.
Web Services and Security
By sridevi krishnan – A key benefit of the emerging web services architecture is the ability to deliver integrated, interoperable software solutions using web-based standards. Ensuring the security of web services through a comprehensive security model is critical, both for organizations and their c
Working XML: Creating a project
Work continues on the integration of Eclipse — IBM’s open-source project to build an extensible Integrated Development Environment (IDE) for Java developers — and Benoît Marchal’s simple content-management solution known as XM. In this installment, Benoît adds a wizard to initialize a new project.
SQL Server Worm Slows Internet Traffic To A Crawl
By Mitch Wagner – A new worm attacking Microsoft SQL Server 2000 systems slowed Internet traffic to a crawl early Saturday.Security companies are warning about the worm, named W32/SQL Slammer or Sapphire, which uses a buffer overflow in SQL Server to take over the system and send out a flood
mssqlXpress version 0.99 released
mssqlXpress is the latest full-featured integrated development environment (IDE) for MS SQL. mssqlXpress enables you to develop your databases using one powerful application. If you are an MS SQL developer, your life could be a lot easier from now on! The Problem MS SQL develope
