I will be back

I could not post any thing on this blog for some time now. I will be back soon.

SQL Server Tip: Search within Stored Procedures, Functions and Views

Often during development and maintenance of applications, the biggest issue for the developer is searching dependent objects in SQL server. These are generally the stored procedures, views and functions. The SQL server stores these procedures, views and functions in Tables. We just have to search the right tables for results.

Searching Stored Procedures, user defined Functions and Views

The below T-SQL query is used for searching stored procedures and function for a specific keyword.

SELECT Tsu.name AS schemaname, Tso.name AS routinename, Tsc.[text] AS routine, Tso.xtype AS routinetype
FROM sys.sysobjects AS Tso INNER JOIN sys.syscomments AS Tsc ON Tso.id = Tsc.id 
INNER JOIN sys.sysusers AS Tsu ON Tso.uid = Tsu.uid
WHERE     (Tso.xtype = 'P' OR Tso.xtype = 'v' OR Tso.xtype = 'FN') AND (Tsc.text LIKE '%Search Keyword%')
ORDER BY routinetype, routinename

View TechieRao.com on your Mobile

Store the http://www.TechieRao.com on your browser. Just fire up the QR code reader on your smart phone and point the camera to the 2D barcode on the left side.

Basics of failover mechanism for critical software systems

For many years the systems are being designed to be immune to the failures. This means that when a system or a sub-system fails still the system/subsystem must be able to function to the maximum extent. The best example for this is Auto pilot and manual piloting of the Aircraft. Generally the modern Aircrafts fly in auto pilot mode over long distances in a pre designated path using onboard mission computers. When the auto pilot system malfunctions it will warn the pilots and switches over to manual mode. This will allow the aircraft to fly safely and land in nearest airfield in spite of the failure of a critical system.

Introduction to TPL part 2 - Task

We have understood the background of the Task parallel library in the previous post. Now we need to concentrate on the building blocks of the library namely Task, Task scheduler, Blocking collection and the PLINQ.

Each of the TPL block has description of the features and example(s) associated with it. In this article I would like to discuss about the “Task” in this post.

Task

Coming right from the world of System.Threading.Thread a task looks little different. A TPL Task is nothing but a well wrapped Thread and having good infrastructure. TPL is still wrapped around the same namespace. TPL Task can be found in the namespace Syste.Threading.Tasks. TPL task has same ability to of a Thread object and been extended.

The below code shows how a thread and a TPL task can be used in typical scenarios

Introduction to TPL Part 1

For many years we have seen the Processor clock frequency going up. Well there is vertical limit. All of a sudden we are seeing processors having multiple cores. Well, what is a multicore processor? We can approximately say that multiple processors with in one processor.  These internal processors are called Cores.  Each of these cores can execute two threads (hardware threads) at a time (based on architecture). Here we must not assume that these hardware threads are executing by switching. But these are getting executed in parallel in real time.