(James Crowley) As a developer, I find that an incredible amount of my time is spent dealing with databases in some form or another – be it displaying, manipulating or analyzing data; creating client or server applications. The advent of the .NET Framework has brought with it some major changes, and

(Frank Gutierrez) This is a step-by-step example of an unmanaged call, i.e. from a DTS Active X script, to a .NET assembly, using a SQL Server scheduled Job as the caller’s context. Almost any class in .NET can be exposed to a COM client simply by exporting the information for its assembly and regis

(Andrew Novick) The second theme of 2005 for the Coding-in-SQL newsletter is T-SQL Coding Style. That is, how T-SQL statements and comments are presented.

(Mahesh) A new feature in SQL Server 2005 is the introduction of a new virtual table (rather a ResultSet) called Common Table Expressions (CTE). CTE stores temporarily the results set during the execution of a SELECT, INSERT, UPDATE or DELETE statement. The advantage of using CTE is the ability to w

(Muthusamy Anantha Kumar) SQL Server database administrators often deploy object changes, such as table, procedure, trigger etc., on the production system. Usually when they do, they check for dependencies, just to make sure that those changes are not going to break the system.

(emadns) Initializing or establishing a connection is a common pattern in many areas of Windows programming. If you want to start drawing on a window, you need first to obtain a device context by calling GetDC or CreateDC, and when you are done, you close it by calling ReleaseDC or DeleteDC. If

(Stefan Prodan) If you made an application that is using an SQL database that needs to be located on the client server, VS.NET Setup Project doesn’t help too much. You could go for InstallShield or another product that will make things easy, but the costs will get higher. So, while searching for a f

(Muthusamy Anantha Kumar) This article demonstrates the CPU Utilization of any SQL Server box by taking advantage of WMI and VBScript in order to find under utilized Servers. It is important to know which Servers use more CPU and during what period of time, to help the SQL Server database administra

(Jeremy Kadlec) SQL Server delivers a number of functions for small to large organizations with needs ranging from internally developed applications to third-party off-the-shelf software. With all systems, data collection, entry and analysis at some level is required to meet organizational needs.

(Michael Otey) The new development features found in SQL Server 2005 are the accumulation of many man-years worth of effort both by the SQL Server development team as well as by the .NET Framework development team. The most significant of these new development features is the integration of the