Tech Guy on September 15th, 2009

I know it’s very tempting to write blank exception handlers, and to just ignore errors. But if you run into problems, and haven’t written any error messages, it becomes almost impossible to find out the cause of the error. Even the simplest exception handler can be of benefit. For example, put a try { .. [...]

Tags: , ,

Tech Guy on September 15th, 2009

If you’ve come from a C/C++ background, you may not find this quite as much a problem as those who have used other languages. In Java, arrays are zero-indexed, meaning that the first element’s index is actually 0. Confused? Let’s look at a quick example.

// Create an array of three strings

String[] strArray = new String[3];

// [...]

Tags: , ,

Tech Guy on September 15th, 2009

This is one of the most frequent errors that we all make. It’s so simple to do, and sometimes one can look at an uncapitalized variable or method and still not spot the problem. I myself have often been puzzled by these errors, because I recognize that the method or variable does exist, but don’t [...]

Tags: , ,

When writing multi-threaded applications, many programmers (myself included) often cut corners, and leave their applications and applets vulnerable to thread conflicts. When two or more threads access the same data concurrently, there exists the possibility (and Murphy’s law holding, the probability) that two threads will access or modify the same data at the same time. [...]

Tags: ,

Tech Guy on September 15th, 2009

Null pointers are one of the most common errors that Java programmers make. Compilers can’t check this one for you – it will only surface at runtime, and if you don’t discover it, your users certainly will.
When an attempt to access an object is made, and the reference to that object is null, a [...]

Tags: , ,

Tech Guy on September 8th, 2009

There may be situations where you need to delete all the tables in a database, or clean all rows in all the tables or truncate all the tables in database. If the database contains only few tables then it is not a problem, Otherwise it would be a major task to clean the database.
Luckily Microsoft [...]

Tags: , , ,

Key Benefits

The new API gives a fine grain control on the behavior of the runtime with regards to multithreading, memory allocation, assembly loading and more.
To take advantage of better Debugging and error checking.
The ASP.NET 2.0 compiler automatically compiles application code and dependent resources when a request is made to a resource on your [...]

Tags: , , ,

Tech Guy on September 8th, 2009

Overview of Consistency Errors
A DBCC CHECKDB statement may report consistency errors in your database when all the following conditions are true:

SQL Server loads data into a column that is a sql_variant data type.
The data originates in another column that is a sql_variant data type and at some point the data is sent on-the-wire [...]

Tags: , , ,

Tech Guy on September 8th, 2009

What are Builtin\Administrators?
SQL Server creates a default NT Group login called Builtin\Administrators during installations.This login facilitates the following

All local NT administrators on the server to have default sysadmin privileges 
Automatic access to system tables
Automatic access to user tables

How security is compromised?
SQL Server security is compromised as follows

Vulnerable to changes by [...]

Tags: , , ,

Tech Guy on September 8th, 2009

This article describes the resolution for the issue that is faced while processing the OLAP cube in SQL Analysis Services. While processing the dimension in the cube sometimes the dimension gets hanged or it throws the error “– 2147221411: Process operation failed”.
Problem Summary
When you try to process the shared dimension of a OLAP cube [...]

Tags: , , , ,