SQLServerCentral.com Articles tagged Programming

Starting to Program

Fri, 06 Jul 2012 06:00:00 UT

This Friday Steve Jones asks what resources might help the new DBA learn to program better. Pick the language of your choice and let us know what resources have worked well for you.

Get alerts within 15 seconds of SQL Server issues
SQL Monitor checks performance data every 15 seconds, so you can fix issues before your users even notice them. Start monitoring with a free trial.

Conversion of a plain English problem into T-SQL

Mon, 03 Oct 2011 06:00:00 UT

An example of how a mathematical problem was converted into T-SQL by evolving a script in iterations.

Surely It Should Just Work?

Mon, 16 Nov 2009 07:00:00 UT

Does a programmer need to know how his code gets executed? Arguably, developers should focus on database structures rather than a particular implementation, and Phil tries to convince us that good programming is not just knowing everything about your programming environment.

Python for the SQL Server DBA

Fri, 18 Sep 2009 06:00:00 UT

Python is increasingly used by DBAs as a general-purpose scripting language, despite the pressure to adopt Microsoft's PowerShell. They find it easy to learn, powerful, and reasonably intuitive. Here Timothy Wiseman, a working DBA, explains the attraction of Python and gives a general introduction to the language, suitable for anyone who has been wondering whether to give it a try.

Writing Dynamic Stored Procedure

Mon, 01 Jun 2009 06:00:00 UT

In this article I have shown a way of writing queries in which WHERE clause of the query is executed dynamically depending on values of input parameters.

SQL Server 2008 Developer Training Kit

Thu, 28 May 2009 06:00:00 UT

The SQL Server 2008 Developer Training Kit will help you understand how to build web applications which deeply exploit the rich data types, programming models and new development paradigms in SQL Server 2008.

.NET Basics for the Database Developer: Take the Plunge

Wed, 15 Apr 2009 06:00:00 UT

This short introduction to .NET shows Access and SQL Server developers how to use a development tool to create connections to data and a user interface to manipulate that data.

Adobe AIR: Running SQL Commands Against a Local Database

Fri, 16 Jan 2009 07:00:00 UT

Once you've established a connection between an Adobe AIR application and a local database, you can run SQL commands (CREATE TABLE, INSERT, DELETE, SELECT, etc.) using the flash.data.SQLStatement class. Find out how.

Accessing SQL Server Databases with PHP

Fri, 05 Sep 2008 06:00:00 UT

This paper discusses how to use several of these features by closely examining parts of the Example Application in the SQL Server 2005 Driver for PHP product documentation in MSDN. This paper assumes that the reader is familiar with programming in PHP, that the reader has a computer that meets the System Requirements listed for using the driver, and that the AdventureWorks example database is installed from CodePlex.

Uncommon Table Expressions

Mon, 11 Aug 2008 06:00:00 UT

This article describes an alternate use of CTEs for functional data processing.

Microsoft Jet 4.0 Sorting APIs: DBCompareStringW and DBLCMapStringW

Fri, 11 Jul 2008 06:00:00 UT

The Microsoft Jet 4.0 relational database engine utilizes character sorting tables when creating and querying field indexes made up of character data. Two Microsoft Windows APIs are generally utilized for this functionality:

T-SQL Data Processing

Mon, 23 Jun 2008 06:00:00 UT

This article from new author Peter Kierstead shows us how to implement your own "fuzzy" dedup/merge logic without resorting to RBAR in T-SQL.

Free Encryption

Fri, 25 Apr 2008 06:00:00 UT

Free SQL Server 2000 Encryption for your data!!! Author Michael Coles has put together a tolljit and some XPs that you can use to encrypt your data with the Blowfish algorithm. It is hard to write good applications that encrpyt data and manage the keys and security. This will give you a great headstart on protecting your data.

File Handling A Different Way

Tue, 22 Apr 2008 06:00:00 UT

A different way for file handling through SQL Server.

Using VBScript to Automate Tasks

Fri, 07 Mar 2008 07:00:00 UT

This article discusses why VBScript should be one of the tools you use to manage your server. Sample scripts show how to remove files over x days old and how to FTP files.

SQLCE Workshop IV - Integration with Visual Studio 2005

Wed, 23 Jan 2008 07:00:00 UT

Continuing on with his series on SQL Server 2005 Compact Edition, regular author Jacob Sebastian takes a look at how Visual Studio fits into your SQL CE project.

Accessing Data from a Mobile Application

Fri, 18 Jan 2008 07:00:00 UT

Data access is an important aspect of developing applications with the Microsoft® .NET Compact Framework for Windows Mobile® devices. By using the existing architecture to send and receive data between your mobile application and your application server, you can pass data with either DataSets, custom objects, or scalar values.

XML IN 20 MINUTES!

Fri, 04 Jan 2008 07:00:00 UT

This article will quickly dive head first right into XML.

Introduction to Bitmasking in SQL Server 2005

Wed, 05 Dec 2007 07:00:00 UT

The use of bitmasking is usually limited to decoding values in the system views, but it can be useful in other places when you want to save space. New author Lee Everest brings us an introduction to bitmasking and its use in SQL Server 2005.

File Management with Scripting Object

Wed, 05 Dec 2007 07:00:00 UT

Once you get familiar with the File Scripting Object (FSO), managing files in Access is not so bad--getting started is the painful part. To help you along, this month's download includes sample code for both Access (early bound) and VB Script (late bound).

SQL Server Connection Strings

Mon, 26 Nov 2007 07:00:00 UT

Some common and not so common connection strings for the .NET SqlConnection object. The article includes .NET sample code and some tricks to increase the supportability of your application.

Events in SharePoint 2007

Fri, 23 Nov 2007 07:00:00 UT

Windows® SharePoint® Services (WSS) 3.0 offers developers many significant improvements for building custom business solutions based on SharePoint sites. One of the biggest developer-focused enhancements has to do with a new infrastructure for handling server-side events.

.NET Building Blocks: Build a Configurable Database Credential Selector

Tue, 20 Nov 2007 07:00:00 UT

This handy control gives you everything you need to control how users input usernames, passwords, select servers, and choose connection types.

Create a Custom Test Interface Provider for Team Sytem

Fri, 16 Nov 2007 07:00:00 UT

This article looks at fuzzy testing and how to build a provider for your own use.

Working With SqlParameter in .NET

Fri, 09 Nov 2007 07:00:00 UT

Interacting with SQL Server from .NET is a radical change from the old OLEDB/ODBC method. Raj Vasant brings us some easy ways to work with parameters passed in with the ADO SQLCommand.

A Brief History of Programming, Part 1

Fri, 02 Nov 2007 06:00:00 UT

In part 1 of his series on the history of programming, David Chisnall takes a look at some of the developments of the last few decades that have created the current crop of languages and discusses where they came from.

Linking Access to SQL Server

Fri, 02 Nov 2007 06:00:00 UT

For quick and dirty work, sometimes Access is the best way to work with SQL Server. Andy Warren brings a basic tutorial on how you can link Access to your SQL Server tables to easily and quickly manipulate data.

ASP.NET 2.0: Retrieving XML Data with XmlDataSource Control

Mon, 10 Sep 2007 06:00:00 UT

This article shows how to retrieve both remote and local XML data and display it in a data Web control.

Browser Style Form Navigation

Thu, 06 Sep 2007 06:00:00 UT

This article series features a demo app affectionately named Something Not Entirely Unlike Access, which employs a variety of methods to obfuscate the "Accessian" features.

Accessing and Updating Data in ASP.NET 2.0: Filtering Database Data wi

Mon, 03 Sep 2007 06:00:00 UT

Learn how to retrieve just a subset of database data based on hard-coded values and values from the querystring, other Web controls on the page, session variables, and so on.