SQL Tutorials & Articles
-
Java in a Python body
by Sing LiSing Li explores the advantages of Jython, a Python implementation created in Java.
-
New C# 3.0 Language Features
by Scott GuthrieLearn about some of the new features in C# 3.0 including automatic properties, collection initializers, extension methods, lambda expressions and anonymous types.
-
Dynamic Search Conditions in T-SQL
by Erland SommarskogA very common requirement in an information system is to have a function (or several functions) where the users are able to search the data by selecting freely among many possible criterias. In this text I will look at various techniques to solve this problem.
-
SQL Trusted Connections with ASP.NET
by Barry DorransHard coding passwords into your application or your web site is a bad thing. Barry looks at how we can use trusted connections to provide the authentication we need, without the need for these potential security hazards.
-
Microsoft Indexing Service and ASP.NET
by Barry DorransMicrosoft Indexing Service is a service that provides a means of quickly searching for files on the machine. Barry investigates how we can use the indexing service to expose full-text searching in ASP.NET.
-
Using SQL Server for ASP.NET session state
by Barry DorransLearn how you can use an alternative session storage method, using SQL Server - very useful if you're running sites across multiple servers, or need session state to persist across application restarts.
-
Effective Controls for Attaining Continuous Application Security Throughout the Web Application Development Life Cycle
by Caleb SimaImproving your Web application development process is one of the best ways to avoid security vulnerabilities and nasty surprises during security assessments. Learn about the points in the software development life cycle where additional security awareness and training is needed to ensure that your organization remains successful and secure.
-
Web Application Vulnerability Assessment Essentials
by Caleb SimaIt is important for a business to understand the fundamentals of running a vulnerability assessment in order to determine how one will be run and what can be expected from the results. A web application security scanner can automate the process, but a quality assessment may still require actual human eyes to catch specific issues. Learn more about the whys and hows of vulnerability assessments.
-
Top 10 Application Security Vulnerabilities in Web.config Files - Part One
by Bryan SullivanIn part one of this two part article, you will learn about five of the top ten “worst offenders” of misconfigurations of application security that can cause overall problems for ASP.NET Web-based applications. Learn more about how to secure the Web.config files of an ASP.NET application.
-
Developing for Office 2007
by Matt NicholsonThe forthcoming 2007 Microsoft Office System offers many new opportunities for software developers. Matt Nicholson looks at the new user interface and the Open XML file format, finds out what's happened to VSTO, and explores the possibilities opened up by SharePoint Server 2007 and Groove 2007.
-
Testing for Security in the Age of Ajax Programming
by Bryan SullivanAjax programming, which allows a web page to refresh a small portion of its data from a web server, is an exciting technology that has recently been introduced. However, this type of programming can also leave applications open to SQL injection and similar attacks. Learn more about Ajax programming and what it means in terms of security.
-
SharePoint, Document Library and SQL Server
by S.S. AhmedThis tutorial shows how you can capture a document in SharePoint's document library, retrieve information from its properties and store in in SQL Server. It will teach you how to use Event Handler Toolkit.
-
Using WMI From Managed Code
by Andriy KlyuchevskyyWindows Management Instrumentation (WMI) is Microsoft's implementation of Web-Based Enterprise Management (WBEM) and the Common Information Model (CIM). Although WMI is COM-based, Andriy Klyuchevskyy shows you how you can access it from C# and VB.NET through System.Management, thanks to COM Inter-Op.
-
Creating Applications for Handheld Devices Using eMbedded Visual Basic
by Rob BickelA no nonsense tutorial designed to give Visual Basic developers an insight into developing VB applications for handheld devices such as PDAs.
-
High-Performance .NET Application Development & Architecture
by Dimitrios MarkatosThis article demonstrates the art of creating and architecting high-performance and scalable .NET applications, covering all stages, from planning to development and their perspective best practices.
-
Locking the Door behind You: Hacker Protection for Your Web Applications
by Caleb SimaYour Web applications can be the most important and most vulnerable entry point into your organization, and, as such, ensuring adequate hacker protection in your Web applications can be critical. This article discusses some of the issues.
-
New features for web developers in ASP.NET 2.0
by Alex HomerASP.NET 2.0 brings enhanced performance and many new features that make the web developer's life easier. Alex Homer takes you through what's new.
-
DataGrid/GridView Paging and Sorting Using A DataReader
by Dimitrios MarkatosThis article will demonstrate two ways one could implement the DataReader to bind a DataGrid, that includes caching, paging and persistent bi-directional sorting, all without the use of a DataAdapter/DataSet at all, and includes ASP.NET 2.0 GridView version!
-
Selecting, Confirming & Deleting Multiple Checkbox Items In A DataGrid/GridView - Part 2: Maintaining CheckBox State Acr
by Dimitrios MarkatosIn this article, we will examine how to create a fully functional DataGrid and GridView in .NET 2.0 with all the features you'd find set up on Hotmail, Yahoo, and AOL Mail, and further demonstrate how you can multi-select items across pages and batch delete them all.
-
Generate Thumbnail Images from PDF Documents in .NET
by Jonathan HodgsonThis article presents VB.NET code to create thumbnail images from a directory of Adobe Acrobat PDF documents using the .NET Framework.