Resources   No resource found

• EJB QUERY LANGUAGE (EJB QL)May 30, 2025. EJB QL is a query language used to query enterprise beans and their relationships, supporting string and arithmetic functions, with syntax defined using Backus-Naur Form (BNF) for structured query creation.
• Introduction To CDC (Change Data Capture) Of SQL Server - Part OneFeb 18, 2016. In this article, we will look into a SQL Server feature named CDC.
• SchemaBinding In SQL ServerSep 06, 2015. This article describes what is SchemaBinding and its advantages in SQL SERVER.
• Important Queries in SQLJun 07, 2015. In this article we learn some interesting and useful SQL queries.
• A Lap Around SQL JoinsMar 22, 2015. In this article you will learn about the joins in SQL.
• Basic Terminology of SQL ServerMar 17, 2015. In this article we learn SQL from the basics. Here I describe all the basic terminology of SQL.
• Debug Mode in SQL ServerFeb 24, 2015. In this article we will learn how to work with the debug Mode in SQL Server.
• Joins in SQL ServerFeb 19, 2015. In this article you will learn different types of Joins in SQL Server.
• How to Show Group Rows Using Group By in SQL ServerFeb 18, 2015. In this article we will see how to group rows using Group By and we will also see the difference between the Where and Having clauses.
• Rename Column Name in SQL ServerFeb 18, 2015. In this article we will see how to rename a column name without dropping a table.
• Entity Framework 6.0 SQL Logging: Changing the Content and FormattingJan 07, 2015. This article explains how to change the formatting of the output in Entity Framework 6.0.
• Create and Schedule a Job in SQL Server 2008Nov 05, 2014. This article explains how to create a new SQL Server job, how to schedule a job and how to set an alert for a job.
• The Undocumented Sp_MSforeachdb Procedure in SQL ServerMay 27, 2014. This article explains the undocumented sp_MSforeachdb procedure in SQL server.
• Create Table Box In QlikViewMay 14, 2014. This article describes how to create a simple Table Box in a QlikView application.
• SQL Server ProfilerSep 25, 2013. In this article we are describing SQL Server Profiler Terminology and Architecture.
• Case Statement in SQL Server 2012Dec 21, 2012. In this article I described the Case Statement in SQL Server.
• Concept of Exists Condition in SQL ServerMay 22, 2012. This article shows how to use the EXISTS condition in SQL Server. The EXISTS condition is used to check if the row exists or not in the table. EXISTS queries are very inefficient since the sub-query is re-run for every row in the outer query's table.
• How to Configure SQL Server 2005 Network ConnectivityMar 18, 2012. Here I am demonstrating how to simply configure networking connectivity in SQL Server 2005.
• How to Use RDLC Local Report in ASP.Net to Download in Doc PDF and Excel FormatAug 13, 2014. This article demonstrates how to use a RDLC local report to get various downloadable file formats of reports, such as a Word or Excel document or a PDF.
• The GOF "Chain of Responsibility" Design PatternJan 18, 2007. The Chain of Responsibility pattern is used to pass responsibility for handling a call to another class. This article gives a basic overview of the pattern.
• Intellisense: An Example of How to Make ItJul 01, 2002. Auto completing is one way to offer a productive and programmer friendly user interface to programmers and Intellisense feature of Visual Studio .NET is one of them.