In this text we will examine the basics of the relational database structure. We’ll define a relational database management system (RDBMS) and how one can be used to structure data relationally. While there are many other widely used powerful RDBMSs, in this book we’re going to focus on that of Microsoft’s latest incarnation – SQL Server 2008. We’ll examine the power of Microsoft’s implementation while keeping with the general ease of use seen with many other Microsoft products, how Wizards can be used to simplify almost all administration tasks, and finally we’ll examine the Command Line Interface (CLI) distributed with SQL Server 2008.. [More]

In this video tutorial we'll analyze Microsoft Virtual Earth, the new SQL Server 2008 GEOGRAPHY data type and ASP.NET AJAX. We'll build a database of longitude and latitude records for specific locations, we'll then use ASP.NET AJAX and the Virtual Earth service to exploit the locations found in the database.. [More]

In this tutorial we'll analyze Microsoft Virtual Earth, the new SQL Server 2008 GEOGRAPHY data type and ASP.NET AJAX. We'll build a database of longitude and latitude records for specific locations, we'll then use ASP.NET AJAX and the Virtual Earth service to exploit these locations found in the database.. [More]

In this tutorial we'll briefly examine and introduce the HIERARCHYID data type, which as you may, or may not know, is a new data type bundled with the upcoming SQL Server 2008.. [More]