Planning decisions are critical for a successful firewall implementation. Missing some of the most important points when designing a firewall implementation can jeopardize our information integrity and the overall network security.
SQL Server Parallel Execution Plans
Microsoft SQL Server introduced parallel query processing capability in version 7.0. The purpose of parallel query execution is to complete a query involving a large amount of data more quickly than possible with a single thread on computers with more than one processor.
Client versus Server Side Functionality in E-Commerce, Storefront Applications
E-Commerce, E-Business, Internet Shopping, On-line Storefronts, Digital Storefronts, Electronic Shopping, Internet Commerce, Web Commerce, B2B, B2C, etc. are all terms used by marketing to grab a “mind share”. They all refer to buying and selling over the Internet.
Which Web Server Is “Winning”
A November 2003 survey published by the UK-based Internet services company Netcraft made the claim that the Apache Web server “has a significant percentage gain” over its chief rival, Microsoft’s Internet Information Services (IIS), and now controls over two-thirds of the global Web server market. Only days later, Port80 Software released a survey stating that “Microsoft IIS maintains dominance of the corporate Web server market” with 53.8 percent of the market. With two seemingly similar surveys drawing contradictory conclusions, clearly the question of whose software powers the majority of the Web server market demands a deeper examination.
How to Interact with SQL Server’s Data and Procedure Cache
As you have worked with SQL Server, you probably have run across the terms data cache and procedure cache, and may have wondered what exactly a cache was. SQL Server is configured to use a physical pool of memory on the server, and it will allocate the majority of this memory pool to hold data pages that have been read, along with the compiled execution plans for all previously-run Transact-SQL statements. It is this dynamic pool of memory that is being referred to by the data cache and procedure cache. Before SQL Server 7.0, the data cache and procedure cache were two separate pools of memory and could be controlled separately. In SQL Server 7.0 and SQL Server 2000, one pool of memory is used both for data and execution plans.
Introduction to IIS 6.0 on Windows Server 2003 – Part 2
Welcome to the second installment of Internet Information Services 6.0 on Windows Server 2003. I have decided to write this series of articles aimed at Internet Information Services 6 on Windows Server 2003 as both a refresher for the IT professional that is familiar with designing, deploying and administering IIS 4 and 5 as well as allowing some of the newcomers to IIS services regardless of version to get their feet wet so to speak.
Introduction to IIS 6.0 on Windows Server 2003
Welcome to the first installment of Internet Information Services 6.0 on Windows Server 2003. I have decided to write this series of articles aimed at Internet Information Services 6.0 on Windows Server 2003 as both a refresher for the IT professional that is familiar with designing and administrating IIS 4 and 5 as well as allowing some of the newcomers to the service to get their feet wet so to speak.
How to Search for Date and Time Values Using Microsoft SQL Server 2000
Suppose you’re writing a query to find all the invoices that were written on January 6, 2003. You know from the control totals that 122 invoices were written that day. But when you run this query:
SQL Server Upgrade Recommendations and Best Practices
As the DBA in your organization, you are central to the success of the SQL Server environment. In the case of a system upgrade, you need to act as a driver’ for an upgrade project to ensure success based on your technical expertise and role in the organization. Over this multi-part series, these articles will outline proven and recommended best practices for the upgrade process. This process is detailed from both technical and logistical perspectives which are both critical to the success of the project.
SQL Server Upgrade Recommendations and Best Practices – Part 2
The first article of the series, Part 1 – Upgrade Overview and Project Planning, detailed the business justification for upgrades to SQL Server 2000 related to TCO (Total Cost of Ownership), automation capabilities and new features from both the Business and DBA perspectives. The next portion of the article outlined a detailed process to break down the SQL Server 2000 project as well as the applicable Upgrade project phases using high level steps. Both sets of information were in simple terms for DBAs new to the Upgrade process, well experienced DBAs needing a refresher or for technical managers interested in the level of effort and overall planning for a SQL Server 2000 Upgrade.