(Jugal Shah) SQL Server performs a couple of internal steps before executing a query. The steps that interest us here are compilation and execution.
Author: SSWUG Research
Wonders of the OUTPUT Clause in SQL Server 2005
(Jagadish Chaterjee) This article mainly focuses on the new “output” clause introduced in Microsoft SQL Server 2005. In this article I shall also teach you about producing output for DML statements, which could not be done in any of the previous versions of SQL Server. I shall give examples of sever
Calling an Arbitrary Web Service
(Scott Golightly) Test Web Services quickly and more efficiently without having to write full-blown applications each time by using .NET reflection and the CodeDOM to dynamically generate a proxy to a Web Service.
Password cracking tools for SQL Server
(Kevin Beaver) If you’re performing a penetration test or higher-level security audit of your SQL Server systems, there’s one test you must not miss. It seems obvious, but many people overlook it: SQL Server password testing. Given the inherent weaknesses compared with more secure Windows authentica
Nested DataGrids Simplify Hierarchical Data Display
(Lee Richardson) Suppose you are asked to write an ASP.NET search page that performs a database search and displays the results—employee names, recent project assignments for each, and hours billed per week per assignment. Would you approach the task by dynamically constructing HTML tables in a code
Visual Studio 2005 Hands-On Tutorial – Part 2
(David Catherman) This is the second part in a series of hands-on tutorials that will take you through all the steps to build a complete application using the new SQL Server 2005 database and Visual Studio 2005 IDE tools.
Localization in ASP.NET 2.0
(Bilal Haidar) A few years ago we started hearing new terms in economics about globalization and integration of international markets. This made many large business companies begin thinking of how to attract markets from all over the world and not only from domestic markets. The first idea that mi
Transactions in the .NET 2.0 Framework
(Joe Duffy) Most meaningful software operations are composed of multiple independent steps. Although a single method call, for instance, is often viewed as a logically distinct unit, this is in the eye of the caller. A single method might just execute a single SQL UPDATE statement over 1000 database
Use Microsoft Access to interact with your DB2 data
(Kulvir Singh Bhogal) If you have Microsoft Access in use in your enterprise, here’s how to use it to easily access your IBM DB2 for Linux, UNIX, and Windows data. You’ll learn how to set it up for accessing DB2, and then see how to create forms and generate reports based on the underlying DB2 data
The Linux Letter: The Database Engines That Could
(Barry L. Kline) Hi. My name is Barry, and I’m a DBMS addict. You have to be if you’re in the IT field. As an i5 junkie, my DBMS of choice is DB2. I love its stability, its power, and its lack of a requirement for a full-time DBA to keep it running at peak efficiency. Unfortunately, DB2 on any […]