For any supplied table, my proc, usp_TableToClass, generates class code in C#, including fields, properties, getters and setters.  Read more...

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.  Read more...

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

For any supplied table, my proc, usp_TableToClass, generates class code in C#, including fields, properties, getters and setters.  Read more...

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.  Read more...

Read more...

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.  Read more...

Read more...

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.  Read more...

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.  Read more...

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.  Read more...

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.  Read more...

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.  Read more...

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

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:  Read more...

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.  Read more...

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.   Read more...

A different way for file handling through SQL Server.  Read more...

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.   Read more...

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.  Read more...