Monthly Archives: April 2009

Again two free e-books from Microsoft!

Posted by on April 17, 2009 No comments

Hi again, here are two free books as present from Microsoft for the 25th anniversary of Microsoft Press.

9780735620704f Again two free e books from Microsoft!Windows Small Business Server 2008 Administrator’s Companion (24MB) by Charlie Russel and Sharon Crawford (27 chapters, 3 appendices, 712 pages)
Your comprehensive, one-volume guide to planning, setup, and administration. Get the critical information you need to build and run a Windows Small Business Server 2008–based network. This essential, single-volume reference details system capabilities and components—including Premium Edition features. Gain the real-world insights, workarounds, and troubleshooting tactics you need for on-the-job results.

9780735625419f Again two free e books from Microsoft!Microsoft Visual Basic 2008 Express Edition: Build a Program Now! (7.7MB) by Patrice Pelland (9 chapters, Glossary, 254 pages)
Make building new programming skills fun and fast with a quick-start, project-based approach!In this lively, eye-opening, hands-on book, all you need is a computer and the desire to learn how to program with Visual Basic 2008 Express Edition. Featuring a full edition of the software, this fun and highly visual guide walks you through a complete programming project—a desktop weather-reporting application—from start to finish. You’ll get an introduction to the Microsoft Visual Studio® development environment and learn how to put the lightweight, easy-to-use tools in Visual Basic Express Edition to work right away—creating, compiling, testing, and delivering your first ready-to-use program. You’ll get expert tips, coaching, and visual examples at each step of the way, along with pointers to additional learning resources.

Two interesting database related articles

Posted by on April 7, 2009 1 comment

logo header sql08 dg Two interesting database related articlesThe first one is about INSERT with SQL 2008 By Don Schlichting. Here is a short introduction.
This article will explore the various methods of using an INSERT statement with SQL Server 2008. After database Tables are created, a method to perform basic data manipulation tasks like inserting, modifying and deleting data is needed. Such data manipulation is accomplished through SQL Server’s own dialect of Structured Query Language (SQL) called Transact SQL or (T-SQL). TSQL Commands can be executed by typing them in directly to SQL Server, or graphically though the SQL Server Management Studio. The SQL Server Management Studio (SSMS) is an easy to use and intuitive graphical tool that lets you build and manage your database graphically. This article will explore the INSERT command of T-SQL’s Data Manipulation Language (DML).
To read the whole please follow the link above.

logo mysql sun a Two interesting database related articlesThe second one is about Five Query Optimizations in MySQL By Sean Hull. Again here is a short expert:
Query optimization is the often overlooked part of applications. Development schedules being what they are, getting the right results and getting the application working are the main priorities. So thoroughly testing, and benchmarking queries is often left as an afterthought.

With our short introduction to query optimization in MySQL, we hope to encourage at least some attention to these issues up front. We’ll also help you identify some of the more common optimizations you may run across.

Both are quite interesting read. Enjoy!