(Irina Medvinskaya) An important function of any program is the ability to work with a file system and manipulate files and directories. In this tip, we examine how to work with a file system using VB.NET. We show you a handy way to perform necessary functions with examples that utilize the existing
Author: SSWUG Research
Configure RAID for maximum SQL Server I/O throughput
(Greg Robidoux) The name of the game is I/O throughput. Running backup and restore sessions is one of the most I/O intensive activities you will perform on your SQL Server. That’s because when you run a backup and/or restore you are reading the entire contents of the database and then writing the en
Techniques for Indexing Low-Selectivity Columns in SQL Server
(Aldrich Merrill) Most of us have probably faced this situation at one time or another: there’s a deceptively simple query in your system that’s performing poorly: SELECT col1, col2, col3 FROM aLargeTable WHERE flag = 1
.NET Framework 3.0
(Somasegar) When speaking to developers about WinFX one question that repeatedly comes up is, “WinFX sounds great, but what happens to .NET?” .NET Framework has becomes the most successful developer platform in the world. Developers know and love .NET.
Working with Logical Datacenter Designer in Visual Studio 2005
(Satheesh Kumar) The logical datacenter diagram communicates important information to developers about the target environment into which their application systems will be deployed. The Logical datacenter Designer is used to create the logical representation of the logical datacenters. Logical Data
Mastering Enterprise BI: Working with Measure Groups
(William Pearson) The advent of MSSQL Server Analysis Services 2005 witnessed the introduction of many new concepts within a dramatically more sophisticated design environment. Measure Groups represent one of myriad enhancements that we encounter early in exploring and implementing Analysis Services
Introducing SimpleXML in PHP 5
(Alejandro Gervasio) In the first article of a three-part series, you will learn the basics of using the “simplexml” extension that comes with PHP 5. This library is primarily focused on parsing simple XML files, and can save you a lot of work.
Threading Proof of Concept Code Snippet Using .NET 2.0
(Steve Schofield) This code sample shows how to start multiple threads to enhance performance. I was looking for a way to increase performance of a console application that records information to a database. The code sample listed below has a couple of techniques. The first starts many threads and
Setting limits to slave numbers in MySQL 5.0
(Mike Hillyer) How many slaves can be set with MySQL 5.0? We plan to set a configuration with a single master on many boxes serving as slaves, but we have to know tha maximum number of slaves that can be set to avoiding troubles on the master side. (R)
The Underground PHP and Oracle Manual
(Christopher Jones and Alison Holloway) This book shows how to use the PHP scripting language with the Oracle database. It covers installation of both Oracle and PHP, and shows how to use them together efficiently. (pdf)