(Dino Esposito) To write effective .NET data-driven applications, a deep understanding of the ADO.NET object model is essential. In version 2.0 of the .NET Framework, the set of classes that form the ADO.NET object model are nearly identical to those in version 1.1, but Microsoft has introduced a fe

(Andrew Karasev) Our and Microsoft Business Solutions’ goal here is to educate the database administrator, programmer, and software developer to enable them Microsoft Great Plains support for their companies. In our opinion self support is the goal of Microsoft to facilitate implementation of its pr

(William Pearson) In this article, we will examine the enhancement of queries using CROSSJOIN() where calculated members are, indeed, to be returned. We will begin with a simple, but intensive, CROSSJOIN() scenario, reviewing how CROSSJOIN() performance can become an issue where larger sized data se

(Herts Chen) To figure out which partition designs work best to reduce the number of sequential scans for Listing 2 and Listing 3 in the main article, I created six cubes, structured identically but with different partition designs. The idea is to partition along the Time and Occupant_Severity dimen

Learn about all of the ways to connect natively to Microsoft SQL Server 2005 from your smart client application. This webcast looks at ODBC, OLE-DB, and SNAC, and highlights what has changed for SQL Server 2005 in terms of native data access technologies.

(Bipin Joshi) ASP.NET DataGrid web control can be bound quickly with any database table like SQL server. For most of the data types all you need to do is to add a bound column and set its datafield property to the column name from the table. However, displaying image data type i.e. binary data i

Lock escalation is the process of converting many fine-grained locks (such as row or page locks) into table locks. Microsoft SQL Server dynamically determines when to perform lock escalation. When making this decision, SQL Server takes into account the number of locks that are held on a particular s

(Serdar Yegulalp) SQL administrators typically set up a nightly or weekly maintenance plan for their databases. The details of a maintenance plan will vary depending on what’s needed for a particular database, but it usually consists of making a backup, checking the database and its indexes for inte

(Don Schlichting) SQL Express 2005 is a new, FREE, Microsoft SQL Server lightweight edition. This new edition is the upgrade to Microsoft’s SQL Server 2000 Desktop Edition (MSDE). Targeted to developers of “simple” applications, it includes a fully functional SQL Server database engine and a Query A

(Don Franke) This article discusses a pretty simple combination of C#, Javascript, an IFRAME, and SQL Server Reporting Services to create a one-click web page for viewing all the reports for your web application.