http://www.sqlservercentral.com/Articles tagged Programming posted on SQLServerCentral.comen-us360sjones@sqlservercentral.com (Steve Jones)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. http://www.sqlservercentral.com/articles/Security/freeencryption/1980/2008/04/25http://www.sqlservercentral.com/articles/Security/freeencryption/1980/A different way for file handling through SQL Server.http://www.sqlservercentral.com/articles/Programming/62487/2008/04/22http://www.sqlservercentral.com/articles/Programming/62487/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. http://www.sqlservercentral.com/articles/Administering/usingvbscripttoautomatetasks/1171/2008/03/07http://www.sqlservercentral.com/articles/Administering/usingvbscripttoautomatetasks/1171/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.http://www.sqlservercentral.com/articles/SQL+Server+2005+Compact+Edition/61677/2008/01/23http://www.sqlservercentral.com/articles/SQL+Server+2005+Compact+Edition/61677/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.http://www.sqlservercentral.com/redirect/articles/61837/2008/01/18http://www.sqlservercentral.com/redirect/articles/61837/This article will quickly dive head first right into XML. http://www.sqlservercentral.com/articles/Basics/20010422115709/78/2008/01/04http://www.sqlservercentral.com/articles/Basics/20010422115709/78/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. http://www.sqlservercentral.com/articles/Miscellaneous/2748/2007/12/05http://www.sqlservercentral.com/articles/Miscellaneous/2748/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).http://www.sqlservercentral.com/redirect/articles/61557/2007/12/05http://www.sqlservercentral.com/redirect/articles/61557/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.http://www.sqlservercentral.com/redirect/articles/61559/2007/11/26http://www.sqlservercentral.com/redirect/articles/61559/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.http://www.sqlservercentral.com/redirect/articles/61427/2007/11/23http://www.sqlservercentral.com/redirect/articles/61427/This handy control gives you everything you need to control how users input usernames, passwords, select servers, and choose connection types. http://www.sqlservercentral.com/redirect/articles/61418/2007/11/20http://www.sqlservercentral.com/redirect/articles/61418/This article looks at fuzzy testing and how to build a provider for your own use.http://www.sqlservercentral.com/redirect/articles/61426/2007/11/16http://www.sqlservercentral.com/redirect/articles/61426/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. http://www.sqlservercentral.com/articles/.Net/workingwithsqlparameterinnet/2311/2007/11/09http://www.sqlservercentral.com/articles/.Net/workingwithsqlparameterinnet/2311/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.http://www.sqlservercentral.com/redirect/articles/61414/2007/11/02http://www.sqlservercentral.com/redirect/articles/61414/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. http://www.sqlservercentral.com/articles/Access/linkingaccesstosqlserver/2176/2007/11/02http://www.sqlservercentral.com/articles/Access/linkingaccesstosqlserver/2176/This article shows how to retrieve both remote and local XML data and display it in a data Web control.http://www.sqlservercentral.com/redirect/articles/3170/2007/09/10http://www.sqlservercentral.com/redirect/articles/3170/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. http://www.sqlservercentral.com/redirect/articles/3188/2007/09/06http://www.sqlservercentral.com/redirect/articles/3188/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.http://www.sqlservercentral.com/redirect/articles/3169/2007/09/03http://www.sqlservercentral.com/redirect/articles/3169/Not every application needs a full-featured enterprise-scale database. In such cases, you can reduce costs and save resources by using a small-footprint database.http://www.sqlservercentral.com/redirect/articles/3198/2007/08/29http://www.sqlservercentral.com/redirect/articles/3198/This article shows how to use the SqlDataSource and AccessDataSource controls to query data from a relational database.http://www.sqlservercentral.com/redirect/articles/3168/2007/08/27http://www.sqlservercentral.com/redirect/articles/3168/You can easily build Wiki Web sites with ASP.NET and SQL Server and provide your teams with one of the most powerful ways of collaborating on the Web. http://www.sqlservercentral.com/redirect/articles/3187/2007/08/23http://www.sqlservercentral.com/redirect/articles/3187/This article explores the concepts and advantages of data source controls, and compares their usage in ASP.NET 2.0 to data access techniques in ASP.NET 1.x.http://www.sqlservercentral.com/redirect/articles/3167/2007/08/20http://www.sqlservercentral.com/redirect/articles/3167/LINQ may be getting the most attention in the forthcoming .NET 3.5, but there are also several new language features that add functionality and make life easier for the programmer. http://www.sqlservercentral.com/redirect/articles/3151/2007/08/09http://www.sqlservercentral.com/redirect/articles/3151/A web look up of a huge list of stock symbols from an MS SQL database.http://www.sqlservercentral.com/redirect/articles/3100/2007/07/30http://www.sqlservercentral.com/redirect/articles/3100/This column is less about the mechanics of a common language runtime (CLR) feature and more about how to efficiently use what you’ve got at your disposal.http://www.sqlservercentral.com/redirect/articles/3078/2007/07/27http://www.sqlservercentral.com/redirect/articles/3078/This article shows the reader how to construct a library of scalar and table valued functions for SQL Server 2005 to perform regular expression analysis.http://www.sqlservercentral.com/redirect/articles/3099/2007/07/25http://www.sqlservercentral.com/redirect/articles/3099/ADO.NET in the next release of Visual Studio® code-named "Orcas" features the new Entity Framework.http://www.sqlservercentral.com/redirect/articles/3075/2007/07/25http://www.sqlservercentral.com/redirect/articles/3075/Do you wish callers of your library could describe their types to you programmatically? Read a little about reflection in CLR Programming.http://www.sqlservercentral.com/redirect/articles/3077/2007/07/20http://www.sqlservercentral.com/redirect/articles/3077/This article describes how to provide full text search using Microsoft Indexing Service in .NET applications.http://www.sqlservercentral.com/redirect/articles/3098/2007/07/20http://www.sqlservercentral.com/redirect/articles/3098/In this article, I'll show you how to create a generic scheduler that runs on a Windows Service. The scheduler will be able to accept pluggable actions that we can develop later implementing a custom interface. Backgroundhttp://www.sqlservercentral.com/redirect/articles/3097/2007/07/17http://www.sqlservercentral.com/redirect/articles/3097/