Visual Basic for Applications (VBA) is a programming language built into Microsoft Office applications. As you improve your skills in any application from the Office System, you will eventually realize that although Microsoft Office applications offer a large number of tools, they do not offer everything you need to perform your daily chores. Such chores may include creating a corporate custom-format, a custom function that calculates commission payments, and so on.
Thus, VBA works as a gap-filler; in other words, its main purpose is to ensure that you can do whatever you need to do in your job.
In this article by Robert Martin, author of Excel Programming with VBA Starter,you will get to know a bit about VBA, its basic features, what you can do with it, and how you can put it to work with a view to facilitating your daily work, by automating common tasks.Read Visual Basic for Applications (VBA) in full
ETL (Extract Transform Load) is the most resource consuming part of data warehouse development and maintenance. An ETL tool, particularly one that is GUI-based, can leverage the productivity and quality of ETL development and maintenance.
WebSphere DataStage from IBM is an ETL tool. In DataStage you build and execute ETL jobs visually on its GUI clients. This article by Djoni Darmawikarta shows how to build and execute an ETL job with DataStage. Specifically, we’ll build a job that loads a Customer Dimension table from an input sequential file (implementing an SCD1, Slowly Changing Dimension Type1; a well-known technique from Dimensional Data Warehouse methodology).Read Visual ETL Development With IBM DataStage in full
MySQL Workbench is a visual database design tool recently released by MySQL AB. The tool is specifically for designing MySQL database.
MySQL Workbench has many functions and features; this article by Djoni Darmawikarta shows some of them by way of an example. We’ll build a physical data model for an order system where an order can be a sale order or a purchase order, and then, forward-engineer our model into an MySQL database.Read Visual MySQL Database Design in MySQL Workbench in full
In this article by Alexandru Serban, let's take a more realistic software development scenario. What I am going to build is a room-reservation system for the newly launched Orbital Hotel. As you well know, this is the very first space building, after the International Space Station, used for tourism, allowing people to enjoy a view of our blue planet and stars from their private rooms. OK, OK, the Orbital Hotel doesn't yet exist, but when it does, it must have a room reservation system anyway. Who knows, it might be this one.Read Visual SourceSafe:Creating a Service-Oriented Application in full
measured by testing the product based on the requirement, using different testing tools and techniques. Even though we test the product with different tools, the real judgement of the product comes from the testing that simulates the real life situation, for example, by simulating the actual number of users, by simulating the load and simulating the actual production environment, and then by measuring the product. Microsoft Visual Studio 2008 provides not only the development environment and code maintenance for application but also different testing features such as Unit test, Load test, Web test, Coded tests, and Ordering tests list.
This article by Subashni.S and N Satheesh Kumar, will give us an understanding of the tools in Visual Studio and an overview of the different types of testing supported by Visual Studio.Read Visual Studio 2008 Test Types in full
Software testing is one of the most important phases of the Software Development Life Cycle (SDLC). The delivery of the end product is based on better design, better coding, better testing, and meeting the requirements. The quality of the product is measured by testing the product based on functional and non-functional requirements with the help of testing tools and techniques. The tools are useful in simulating a real life situation and the user load. For example, testing a web application with more than 1000 user load is a very time consuming and tedious task if we do it manually. But the performance testing tool that comes along with Visual Studio 2010 can simulate this scenario and test it in a very short period of time. Visual Studio 2010 provides additional tools for testing all type of applications and scenarios such as Unit testing, Load Testing, Web testing, Ordered testing, and generic testing.
This article by Satheesh Kumar N and Subashni S, authors of Software Testing using Visual Studio Team System 2010, provides a high level overview on all the testing tools and techniques supported by Visual Studio 2010. This article covers the following topics:
- Testing as part of the software development life cycle
- Types of Testing
- Test Management in Visual Studio 2010
- Testing Tools in Visual Studio 2010
This article written by Manoj R Patil, the author of the book Pentaho for Big Data Analytics, provides a basic understanding of visualizations and examples to analyze the patterns using various charts based on Hive data.Read Visualization of Big Data in full
In this article written by Hector Cuesta, the author of Practical Data Analysis, you will learn how to create a social graph visualization of your Facebook Friends with d3.js.Read Visualizing my Social Graph with d3.js in full
In this article, we explore how Celtx lets us use sketching, storyboarding, and Adding media files. Besides, even if we are just writing a script, visualization techniques can make that a lot easier as well. Knowing where we are going is wonderful in helping us get there, eh? By the end of this article, we'll be well familiar with why and how to use these visualization features in Celtx.
In this article by Ralph Roberts, author of Celtx: Open Source Screenwriting Beginner's Guide, we will learn the following:
- Sketching: Sketches let us diagram camera, light, character and prop placement, and the other items that we need to visually plan the setup of a scene for filming.
- Storyboarding: Celtx helps us build storyboards using external clipart or photos and included icons to give a visual representation of our script. We can do storyboards before writing a script, or afterwards, to help turn the script into a film or video.
- Add media files: Media files (photos, graphics, videos) may be attached to any of the thirty-six production categories, including wardrobe, props, and locations.
This article by Lauren Malhoit, author of the book VMware vCenter Operations Manager Essentials, provides a quick overview of how vCenter Operations (vC Ops from here on) is able to learn our environment and gives us many benefits for both troubleshooting and capacity planning.
In this article, we'll cover:
- What is vCenter Operations Manager (vC Ops)?
- Benefits of troubleshooting with vC Ops
- Benefits of capacity planning with vC Ops
- Feature comparison of different versions
- What is vCenter Operations Manager Suite?
- Licensing versions
- Using vC Ops with other solutions
In this article by Jason Langone and Andre Leibovici, the authors of VMware View 5 Desktop Virtualization Solutions, we will learn about virtualization. Virtualization, the technology of abstracting the operating systems from the underlying physical server components, has become a cornerstone of the data center architecture. Virtualization allows organizations to run not just one operating system per physical server in the data center, but tens, dozens, or even hundreds, on a single physical server. The benefits of virtualization are many, including a reduction in hardware, power, and cooling costs. In addition, virtualization allows for new techniques of distribution and resilience to be applied, such as VMware Distributed Resource Scheduler (DRS) and VMware High Availability (HA).Read VMware View 5 Desktop Virtualization in full
Interactive Voice Response (IVR)-enabled telephony platforms are the pivot elements of the telephony industry. You must be familiar with several IVR telephony platform—your cellular provider's top-up system, your bank's call distribution system, or your Internet service provider's technical support line—IVR systems are everywhere. As you may already know, IVR systems can be a hell to use, but as Winston Churchill said, you just have to keep on going to get to your destination.
In this article by Nir Simionovich, we will learn about the human dynamics of IVR systems, the implementation and the deployment of an IVR environment to your AsteriskNOW PBX system.Read Voice Menus and IVR in AsteriskNOW in full
In this article by Robin de Jongh, author of SketchUp 7.1 for Architectural Visualization: Beginner's Guide, we will cover:
- What to include in your animation
- How to create a simple walkthrough in SketchUp
In this article created by Jan Haller, Henrik Vogelius Hansson, and Artur Moreira, authors of SFML Game Development, we are going to populate the game world, and implement the core part of the game; the actual gameplay with enemies, weapons, battles, and goodies. We are going to cover the following topics:
Enemy aircraft controlled by a simple artificial intelligence
Projectiles such as a machine gun or missiles
Pickups that improve the player's equipment
Collision detection and response between entities in the scene graph
The world's update cycle and automatic removal of entities
In this article created by Jan Haller, Henrik Vogelius Hansson, and Artur Moreira, the authors of SFML Game Development, we are going to populate the game world, and implement the core part of the game; the actual gameplay with enemies, weapons, battles, and goodies. We are going to cover the following topics:
- Enemy aircraft controlled by a simple artificial intelligence
- Projectiles such as a machine gun or missiles
- Pickups that improve the player's equipment
- Collision detection and response between entities in the scene graph
- The world's update cycle and automatic removal of entities
In order to solve problems that arise in concurrently running threads in applications, we need new debugging techniques suitable for the new parallelism environments that occur in Visual C#. In this article by Gastón C. Hillar, we will learn many tricks and debugging procedures that will help us find solutions to multithreaded application problems and have a better understanding of the execution of parallel threads. We will be performing the following exercises:
- Learn some tricks to prepare multithreaded code to simplify the debugging and troubleshooting processes
- Become skilled at watching and understanding the execution of multiple concurrent threads
In this article by Magnus Mischel we will take a look at the performance of ModSecurity and what impact, if any, it has on the speed of your server and web application. We will also look at the ways in which you can increase the performance of your server by tweaking your configuration and writing more efficient rules.Read Ways to improve performance of your server in ModSecurity 2.5 in full
WCF is the latest technology from Microsoft for building services. In this article by Mike Liu, we will explain what WCF is, and what it is composed of. We will also explain various .NET runtimes, .NET frameworks, Visual Studio versions, the relationships between them, and what is needed to develop or deploy WCF services. You will see some code snippets in this article that will help you to further understand WCF concepts, although they are not in a completed WCF project.
Let us discuss the following in detail:
- What WCF is
- Use of WCF for SOA
- WCF architecture
- Basic WCF concepts