This is a coder's book. It's intended to help developers build applications that make use of T-SQL. It's not about database administration or design. It's not about end-user or GUI application development. It's not even about server or database performance tuning. It's about developing the best T-SQL code possible, regardless of the application.
You'll have to judge for yourself whether these goals have been met, but my hope is that, regardless of the degree of success, the effort will at least be evident.

This book uses SQL Server's Northwind and pubs sample databases extensively. You'll nearly always be able to determine which database a particular example uses from the surrounding commentary or from the code itself. The pubs database is used more often than Northwind, so, when it's not otherwise specified or when in doubt, use pubs.

(more…)

This book was written for Visual Basic programmers by a Visual Basic programmer. In my description of how to work with Visual Basic .NET, I first build a foundation, providing background about the changes in computing and software development that make knowing about the MS .NET Framework of vital interest to programmers as well as a practical necessity. I cover the essentials of object-oriented programming in Visual Basic .NET and explain how to build your own classes and work with the .NET Framework classes, how to work with arrays and collections, and how to debug and handle errors in your programs. From our foundation, we climb to the next level. I cover the details of how to work with .NET assemblies, how to work with files and data streams, and how to monitor files over a network, including how to build a Windows service application that runs on a server.

In three full chapters I cover how programming for data access has changed with Visual Basic .NET and ADO.NET. Then we move to the world of Web services—programs and components designed to run on the Internet. In the last chapter, I bring together what's been covered throughout the earlier chapters. Along the way, you'll see plenty of useful and interesting sample code.

(more…)

Exploits. In most information technology circles these days,the term exploits has become synonymous with vulnerabilities or in some cases,buffer overflows. It is not only a scary word that can keep you up at night wondering if you purchased the best firewalls,configured your new host-based intrusion prevention system correctly,and have patched your entire environment,but can enter the security water-cooler discussions faster than McAfee’s new wicked anti-virus software or Symantec’s latest acquisition.

Exploits are proof that the computer science,or software programming,community still does not have an understanding (or,more importantly,firm knowledge) of how to design,create,and implement secure code.

(more…)

My previous book, You Can Do It!, was written for the complete newcomer to programming. I made no assumptions about the reader’s prior knowledge and skills other than that they were capable of using a M$ Windows–based machine at the general level of accessing the Internet. It should not matter to such people what language is used for their practical experience of programming. I chose C++ because I felt certain that it was well up to the task, as long as I used a carefully chosen subset and augmented the Standard Library with a library of my own design that would support writing programs that newcomers would find interesting. The priority of that book was learning sound programming.

(more…)

For many years now, Microsoft Access has allowed users all over the world to design and develop Windows-based database applications. Microsoft Office Access 2003 continues to be the world’s most popular database. This book is for people who have already mastered the use of Microsoft Access databases and now are ready for the next step —programming. Access 2003 Programming by Example with VBA, XML, and ASP takes non-programmers through the detailed steps of creating Access databases from scratch and then shows them how to retrieve and manage their data programmatically using various programming languages and techniques.

With this book at hand, users can quickly build the toolset required for developing their own database solutions. This book proves that, given the right approach, programming an Access database from scratch and controlling it via programming code can be as easy as designing and maintaining databases with Access built-in tools. Anyone interested in learning how to get started with VBA programming in Access will benefit from this book’s 303 hands-on examples and 11 step-by-step projects.

(more…)

Why do we care about database security?

If money could be said to exist anywhere in a network, it exists on a database server. When we say that modern economies are reliant on computers, what we really mean is that modern economies are reliant on database systems. Databases are behind the systems that affect almost every aspect of our lives — our bank accounts, medical records, pensions, employment records, phone records, tax records, car registration details, supermarket purchases, our children's school grades — almost every piece of information of significance in our lives is stored in a modern relational database management system. Since this volume covers seven of the most popular relational database systems, chances are that your personal information is currently being stored in the very systems that are the subject of this book.

(more…)

This project-based guide from Adobe will teach readers all they need to know to create engaging interactive content with Flash CS3. Using step-by-step instructions with projects that build on the knowledge learned in each lesson, readers will learn the key elements of the Flash interface, including panels, timelines, and frames. From there, readers will learn how to work with vector and bitmap graphics; create and edit symbols; modify text and add interactivity with ActionScript 3.0; and incorporate animation, music, and sound to their projects. They'll also learn how to prepare and export their finished projects for Web and broadcast. Of course, readers will also learn how to take advantage of the new features of Flash CS3–the streamlined user interface, native support for Photoshop and Illustrator files, revamped drawing tools, new video encoding features, code editing enhancements, and much more.

(more…)

Ajax and REST Recipes: A Problem-Solution Approach will serve all of your Ajax needs, by providing adaptable solutions for common tasks you'll want to implement on web sites using the next generation of Ajax and REST techniques. As a JavaScript developer, your time is precious, so you'll want to solve problems that present themselves in your work as quickly as possible. You can pick up the code provided in this book, adapt it, or plug it straight into your own applications.

The book mainly focuses on illustrating and explaining how to build applications that use JavaScript, Ajax, and REST Web Services, along with some user interface issues. Specifically, the following topics are covered: implementing JavaScript unit tests; explaining the intent of Dynamic Languages, Web Services and SOA; defining and implementing contracts using REST; understanding why JavaScript Functions have state; implementing JavaScript "Generics", which are a mixture between real Generics and a replacement algorithm; using code blocks; using functions to make decisions; understanding the difference of JavaScript code that behaves like a value type or a reference type; implementing proxies, delegates, mixins, and overloaded functions; implementing a complete Ajax and Web Service architecture; defining a Web Service using REST; handling large or slow or real-time data sets; implementing shopping cart type architectures; and solving the back button problem using Ajax.

(more…)

Today's richest market is the New Customer Majority: middle-aged and older adults who make up the biggest percentage of the buying public. Never before have adults 40 years and older been in the majority. Understanding this population and persuasively selling to it require a new kind of marketing research arsenal.

In Ageless Marketing, authors David Wolfe and Robert Snyder document the results of a groundbreaking research project on the aging boomer generation, detailing the core values, buying behaviors, and emotional factors that distinguish the New Customer Majority. As more companies seek sales from multiple age groups, ""ageless marketing"" becomes critical to financial performance. Companies that master its subtleties have realized amazing profits. New Balance, for example, saw an annual rate of 25 percent or more with its ageless marketing themes, even when the athletic shoe industry had shown no growth since 1997.

(more…)

Want to calculate the probability that an event will happen? Be able to spot fake data? Prove beyond doubt whether one thing causes another? Or learn to be a better gambler? You can do that and much more with 75 practical and fun hacks packed into Statistics Hacks. These cool tips, tricks, and mind-boggling solutions from the world of statistics, measurement, and research methods will not only amaze and entertain you, but will give you an advantage in several real-world situations-including business.

This book is ideal for anyone who likes puzzles, brainteasers, games, gambling, magic tricks, and those who want to apply math and science to everyday circumstances. Several hacks in the first chapter alone-such as the "central limit theorem,", which allows you to know everything by knowing just a little-serve as sound approaches for marketing and other business objectives. Using the tools of inferential statistics, you can understand the way probability works, discover relationships, predict events with uncanny accuracy, and even make a little money with a well-placed wager here and there.

(more…)

Mastering the development of Microsoft .NET Framework applications in C# is less about knowing the C# language and more about knowing how to use the functionality of the .NET Framework class library most effectively. Visual C# 2005 Recipesexplores the breadth of the .NET Framework class library and provides specific solutions to common and interesting programming problems. Each solution (or recipe) is presented in asuccinct problem/solution format and most are accompanied by working code samples.

Visual C# 2005 Recipes is not intended to teach you how to program, nor to teach you C#. However, if you have even the most rudimentary experience programming applications built on the .NET Framework using C#, you will find this book to be an invaluable resource. Ideally, when you are facing aproblem, this book will contain arecipe that provides the solution, or at least it will point you in the right direction. Even if you just want to broaden your knowledge of the .NET Framework class library, Visual C# 2005 Recipesis the perfect resource to assist you.

(more…)

To bring you up to speed with Visual Basic 2005, this practical book offers nearly 50 hands-on projects. Each one explores a new feature of the language, with emphasis on changes that can increase productivity, simplify programming tasks, and help you add new functionality to your applications. You get the goods straight from the masters in an informal, code-intensive style. Part of our new Developer's Notebook series.

When MS introduced the Visual Basic .NET programming language, as part of its move to the .NET Framework two years ago, many developers willingly made the switch. Millions of others, however, continued to stick with Visual Basic 6. They weren't ready for such a radical change, which included an object-oriented environment similar to Java. They liked the old Visual Basic just fine. In an effort to win over those diehard VB6 developers, the company has included a new version of VB.NET in its upcoming next generation release of the Visual Studio .NET development platform. Visual Basic 2005 comes with innovative language constructs, new compiler features, dramatically enhanced productivity and an improved debugging experience. The language's new version is now available in beta release, and MS is encouraging developers to give it a test drive. Visual Basic 2005: A Developer's Notebook provides the ideal test track.

(more…)

ClickOnce, a new technology in Visual Studio 2005, lets you quickly and easily deploy your Windows apps via web servers, file servers, or even CDs. But while ClickOnce delivers web-style deployment of your application, that's only part of the story. Once you've installed an application using ClickOnce, it can automatically check for new updates to the application, which saves time in application maintenance and upgrades. And on the security front, a ClickOnce application runs within a secure sandbox and you configure it using the Code Access Security model.

(more…)

This book provides a complete application- and example-oriented introduction to the database system MySQL. No previous knowledge of SQL or database design is assumed.

MySQL is on the verge of repeating in the database market the success achieved by Linux in the operating system sector. In combination with PHP or Perl, MySQL is increasingly used as the database system for web sites. (A favorite combination is Linux + Apache + MySQL + Perl or PHP. Such systems are called “LAMP systems” for short.) MySQL is not just for small web sites; it is used by large firms with huge amounts of data, such as Yahoo!, Slashdot, and NASA.

(more…)

Since its creation, Visual Basic (VB) has steadily grown into the world’s most popular programming language. But popularity doesn’t always mean respect, and for years the development community has been split between those who think Visual Basic is a revolutionary way to solve just about any programming problem and those who think VB should be sent to the bargain bin to make room for a return to “serious” C++ or Java coding. As a result, Visual Basic programmers have a reputation for being a slightly paranoid bunch.

Recently, Visual Basic has been through the greatest change of its life. It’s morphed into a modern, object-oriented language that’s built on MS’s .NET Framework—the same plumbing that powers such heavyweights as C#. Although most VB developers believe that the .NET Framework will eventually replace old-style Visual Basic 6, a surprising number haven’t made the jump yet. Some don’t trust the new technology (and the never-ending name changes). Others are too busy with real work to think about making a move. And a few are scared off by the radical new model and inevitable migration headaches.

(more…)

Identity and Access Management are rapidly gaining importance as key areas of practice in the IT industry, and directory services provide the fundamental building blocks that enable them. For enterprise developers struggling to build directory-enabled .NET applications, The .NET Developer's Guide to Directory Services Programming will come as a welcome aid.

Microsoft MVPs Joe Kaplan and Ryan Dunn have written a practical introduction to programming directory services, using both versions 1.1 and 2.0 of the .NET Framework. The extensive examples in the book are in C#; a companion Web site includes both C# and Visual Basic source code and examples.

(more…)