(Baya Pavliashvili) Microsoft Analysis Services (MSAS) is a great tool for enabling business stakeholders to analyze data from various perspectives — and its growing popularity can be primarily attributed to its exceptional performance. (R)

(Tony Patton) Developers work hard to graciously handle exceptions so users don’t have to worry about the arcane system error messages. For this reason, exception handling is a standard part of every .NET application. The try/catch block allows you to catch exceptions and control application executi

(Douglas Reilly) Software developers constantly need to learn about new technologies, products and methodologies. Think about what sort of programming you were doing 5 or 10 years ago. If you have been developing software that long, you will, no doubt, be working on very different systems now than y

(Muthusamy Anantha Kumar) Automating the installation of SQL Server was made simple in SQL Server 2005. SQL Server 2005 can be installed using a GUI, an ini file or just run setup.exe with a bunch of parameters.

When ASP.NET v2.0, Visual Studio 2005, and Visual Web Developer were released to manufacturing, ORCS Web began supporting those technologies, making them immediately available to our clients. Visual Web Developer 2005 has a very cool feature that will allow you to dynamically create a SQL Server Ex

When you use the Analysis Services Parallel Process Utility to process a partition of Microsoft SQL Server 2000 Analysis Services, you receive the following error message: Run-time error ‘380’: Invalid property value

Under certain circumstances, the working set of the Microsoft SQL Server 2005 64-bit process may be paged out by Microsoft Windows. This behavior may cause a decrease in SQL Server 64-bit performance. Microsoft has found an issue that may cause the SQL Server 2005 64-bit working set to be trimmed.

(VGirish) When handling a project with hundreds of tables, it takes some time to understand the flows within the database. This is especially so if there is no document available. A possible scenario is legacy code up for maintenance or migration. After going through just a few tables, it becomes to

(Brett Burridge) We English people love to queue! So I was especially pleased when Microsoft included the Queue class within the .NET Framework. It’s just the thing for creating applications where items must be processed in an orderly fashion.

When you run a query in Microsoft SQL Server 2000, an access violation may occur. You experience this problem when the following conditions are true: • A table has a multicolumn index such as Table1(col1, col2). • The columns of the table do not accept the value NULL. • The query uses a predi