 WebProWorld Dev Forum |
Looking for good PHP resources
SO here my delema. My hosting company has gone php happy. But I am having problems find good PHP resources for scripts an tutorials.
ASP & ASP.Net Books
I am looking for just two books that teach me the baiscs of ASP and ASP.Net. And for ASP.Net, which is better C# or VB.Net to learn ASP.Net?
|
|
Recent Articles |
The Best Day Ever to Design a Database Structure
Have you ever been faced with the challenge of designing a new database structure? Do you have to redevelop an existing database? The truth is that creating or developing a database structure requires at least basic knowledge of SQL scripts.
SQL Injections
Since learning how to manipulate a database is usually the first thing programmers learn it makes sense that learning about SQL injections should also be one of the first things they learn. SQL Injections happen when a malicious user extends your SQL query
|
|
| 05.24.05
Error / Exception Handling in SQL Server
Many programming languages have a fairly consistent behavior when there is a run-time error / exception. Normally execution simply terminates in case of an error / exception, unless you have set up an error / exception handler that takes care of the error / exception, I would like to clear that an error is an act, assertion, or belief that unintentionally deviates from what is correct, right, or true while an exception is especially a case that does not confirm to a rule or generalization.
How SQL Server Behave when an Error Occur
In some languages error variable is set and you have to check this variable, while in T-SQL it is confusing, because depending on what error that occurs and in which context it occurs, SQL Server can take no less than four different actions. I first give an overview of these alternatives, followed by a more detailed discussion of which errors that cause which actions.
Read The Whole Article
The SQL Server 2005 Paradigm Shift
Skeptics who question Microsoft’s decision to integrate its .NET CLR with SQL Server 2005 tend to use the language of doomsayers such as Jeremiah or Cassandra to make their points. They believe in-process CLR is an insanely bad idea that could jeopardize the scalability and reliability of SQL Server.
It's easy to dismiss such talk, but it wouldn't hurt to get a sense for what these folks are up in arms about.
Read The Whole Article
Implementing Managed code in SQL Server 2005 using Visual Studio.NET 2005
The common language runtime (CLR) is the heart of the Microsoft .NET Framework and provides the execution environment for all .NET Framework code. Code that runs within the CLR is referred to as managed code. The CLR provides various functions and services required for program execution, including just-in-time (JIT) compilation, allocating and managing memory, enforcing type safety, exception handling, thread management, and security.
One of the benefits of managed code is type safety, or the assurance that code accesses types only in well-defined, permissible ways. Before managed code is executed, the CLR verifies that the code is safe. For example, the code is checked to ensure that no memory is read that has not previously been written. The CLR can also help ensure that code does not manipulate unmanaged memory.
Read The Whole Article
OpenBase, a better kind of SQL?
OpenBase International is a medium-sized enterprise with one core product: OpenBase SQL. Mac OS X users may have heard of OpenBase SQL if they use StickyBrain or Daylite. Those two applications rely on OpenBase SQL for storing their data.
When I prepared myself for this article, I went to see what Gartner Group thought of OpenBase. It turned out that the analyst doesn’t find anything at all from OpenBase. They don’t know the vendor. Yet OpenBase develops and delivers a full-scale SQL database with all the features you would only expect from vendors like Oracle and Sybase, or if you’re more into Open Source, from MySQL.
Read The Whole Article |
