Ultra-Fast ASP.NET: Build Ultra-Fast and Ultra-Scalable web sites using ASP.NET and SQL Server

  • ISBN13: 9781430223832
  • Condition: NEW
  • Notes: Brand New from Publisher. No Remainder Mark.

Product Description
Ultra-Fast ASP.NET presents a practical approach to building fast and scalable web sites using ASP.NET and SQL Server. In addition to a wealth of tips, tricks and secrets, you’ll find advice and code examples for all tiers of your application, including the client, caching, IIS 7, ASP.NET, threads, session state, SQL Server, Analysis Services, infrastructure and operations. By applying the ultra-fast approach to your projects, you’ll squeeze every last ounce of … More >>

Ultra-Fast ASP.NET: Build Ultra-Fast and Ultra-Scalable web sites using ASP.NET and SQL Server

Querying Table Data Using Visual Basic Code in MS Access

In order to fully utilize the capabilities of MS Access, one must learn not only learn the Visual Basic (VB) programming language, but should also learn Standard Query Language (SQL). Once a grasp of these two languages have been obtained, MS Access users can begin to build faster and more efficient databases.

One tool that has proved itself very useful to me over the years is querying data from tables or queries using VB and SQL code. A brief introduction to this process is presented in this article. To best understand this process, an example is provided below along with an explanation of its parts.

'*********CODE***********

Dim rstTemp As Recordset

Dim strSQL As String

Dim routeNum As Integer

strSQL = "SELECT [Route], [Main Route PM], [Intersecting Route], [IntBeginPM], [IntEndPM] “

strSQL =  strSQL + “FROM Intersections_list WHERE (((CStr([Route])) = """ + cmbRouteQuery + """));"

Set rstTemp = CurrentDb.OpenRecordset(strSQL, dbOpenDynaset)

If (Not (rstTemp.EOF)) Then

rstTemp.MoveFirst

routeNum = rstTemp(0)

'************************

Continue reading “Querying Table Data Using Visual Basic Code in MS Access”

How Oracle 10g Works

Oracle 10g databaseAn Oracle database is a collection of data treated as a unit. The purpose of a database is to store and retrieve related information. A database server is the key to solving the problems of information management. In general, a server reliably manages a large amount of data in a multiuser environment so that many users can concurrently access the same data. All this is accomplished while delivering high performance. A database server also prevents unauthorized access and provides efficient solutions for failure recovery.

Oracle Database is the first database designed for enterprise grid computing, the most flexible and cost effective way to manage information and applications. Enterprise grid computing creates large pools of industry-standard, modular storage and servers. With this architecture, each new system can be rapidly provisioned from the pool of components. There is no need for peak workloads, because capacity can be easily added or reallocated from the resource pools as needed.

Continue reading “How Oracle 10g Works”

T-SQL: How do I find the greatest values in a column?

How can write a SELECT statement that finds the n greatest values in a column? From what i’ve read, the TOP statement only returns the first n rows, it doesn’t take any regard to the values. For example, if a have a column with ages, i want to be able to find the 5 oldest people.

Oracle Database 11g PL/SQL Programming

Product Description
Design Feature-Rich PL/SQL ApplicationsDeliver dynamic, client/server PL/SQL applications with expert guidance from an Oracle programming professional. With full coverage of the latest features and tools, Oracle Database 11g PL/SQL Programming lays out each topic alongside detailed explanations, cut-and-paste syntax examples, and real-world case studies. Access and modify database information, construct powerful PL/SQL statements, execute effective … More >>

Oracle Database 11g PL/SQL Programming

Microsoft SQL Server 2008 T-SQL Fundamentals

  • ISBN13: 9780735626010
  • Condition: NEW
  • Notes: Brand New from Publisher. No Remainder Mark.

Product Description
Master the foundations of T-SQL with the right balance of conceptual and practical content. Get hands-on guidance—including exercises and code samples—that show you how to develop code to query and modify data. You’ll gain a solid understanding of the T-SQL language and good programming practices, and learn to write more efficient and powerful queries. Discover how to: Apply T-SQL fundamentals, create tables, and define data integrity Understand logical query… More >>

Microsoft SQL Server 2008 T-SQL Fundamentals

Oracle executives cite modularity in Java’s future

OracleOracle executives cite modularity in Java’s future
InfoWorld – As Oracle has been prone to do for the past nine months, company officials Tuesday pledged a strong commitment to Java technology. They even offered glimpses of a modular future for the platform.

Read more on Computerworld

Oracle 11g Streams Implementer’s Guide

Product Description
Design, implement, and maintain a distributed environment with Oracle Streams Implement Oracle Streams to manage and coordinate the resources, information, and functions of a distributed system Get to grips with in-depth explanations of the components that make up Oracle Streams, and how they work together Learn design considerations that help identify and avoid Oracle Streams obstacles – before you get caught in them Covers implementation steps with explanati…

More >>

Oracle 11g Streams Implementer’s Guide

Oracle Announces Latest Release of Oracle(R) Berkeley DB

Oracle Announces Latest Release of Oracle(R) Berkeley DB
REDWOOD SHORES, CA–(Marketwire – 03/23/10) – Oracle (NASDAQ: ORCL – News ) News Facts Today, Oracle announced the latest release of Oracle Berkeley DB , the high-performance, small footprint open source embeddable database engine for mission-critical ‘edge’ applications. Oracle Berkeley DB 11g Release 2 introduces a new SQL API, based on SQLite, which is familiar to a large developer community …

Read more on Marketwire via Yahoo! Finance

Oracle Updates Embeddable Database Engine

Oracle Updates Embeddable Database Engine
CTIA Wireless — Oracle has announced the latest release of Oracle Berkeley DB, what it calls a high-performance, small-footprint, open-source embeddable database engine for mission-critical “edge” applications.

Read more on BillingWorld

Valid styles for converting datetime to string

I wrote this little table and procedure to help me remember what style 104 did, or how to get HH:MM AM/PM out of a DATETIME column. Basically, it populates a table with the valid style numbers, then loops through those, and produces the result (and the syntax for producing that result) for each style, given the current date and time.

It uses also a cursor. This is designed to be a helper function, not something you would use as part of a production environment, so I don’t think the performance implications should be a big concern.

Continue reading “Valid styles for converting datetime to string”

Use CAST (or CONVERT) to handle Null Date values in Microsoft SQL Server

In an SQL Server View, a problem is that the DateTime field has many Null values which is causing a problem with the parsing of the data in MSAccess.

How to I use CAST (or CONVERT) to handle Null Date values in my SQL Server view?

There is a way to use CAST or CONVERT similar to the nz type function in MSAccess to handle null date values but I can’t remember the syntax.

What is happening now is that I get a data mismatch in my MSAccess function when it hits a Null Date value. Can I somehow use the ISNULL or ISDate function? I believe I need to somehow return “” instead of Null.

Continue reading “Use CAST (or CONVERT) to handle Null Date values in Microsoft SQL Server”