Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Content with tag Programming Rss

   Items 1 to 20 of 353    Older >>
 

Generate C# class code for table

For any supplied table, my proc, usp_TableToClass, generates class code in C#, including fields, properties, getters and setters.  Read more...
By Cade Bryant 2013/12/24 | Source: SQLServerCentral.com | Category: development
Rating: |  Discuss |   Briefcase | 8,977 reads

Extended Procs

By Dave 2013/10/01 | Category: development
Rating: (not yet rated) |  Discuss |   Briefcase | 2,159 reads

Soundex - Experiments with SQL CLR

Using test driven development to turbocharge Soundex  Read more...
By David Poole 2013/09/12 | Source: SQLServerCentral.com | Category: programming
Rating: |  Discuss |   Briefcase | 4,883 reads

Generate C# class code for table

For any supplied table, my proc, usp_TableToClass, generates class code in C#, including fields, properties, getters and setters.  Read more...
By Cade Bryant 2013/12/24 | Source: SQLServerCentral.com | Category: development
Rating: |  Discuss |   Briefcase | 8,977 reads

Starting to Program

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...
By Steve Jones 2012/07/06 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 273 reads

Conversion of a plain English problem into T-SQL

An example of how a mathematical problem was converted into T-SQL by evolving a script in iterations.  Read more...
By Rob McNicol 2011/10/03 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 4,864 reads

Generate C# class code for table

For any supplied table, my proc, usp_TableToClass, generates class code in C#, including fields, properties, getters and setters.  Read more...
By Cade Bryant 2013/12/24 | Source: SQLServerCentral.com | Category: development
Rating: |  Discuss |   Briefcase | 8,977 reads

Surely It Should Just Work?

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...
By Phil Factor 2009/11/16 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 111 reads

Role Membership

By Britt Cluff 2009/10/22 | Category: security
Rating: (not yet rated) |  Discuss |   Briefcase | 3,048 reads

Python for the SQL Server DBA

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...
By Additional Articles 2009/09/18 | Source: SimpleTalk | Category: programming
Rating:  Rate this |   Briefcase | 4,462 reads

Data Types

By Britt Cluff 2009/09/02 | Category: programming
Rating: (not yet rated) |  Discuss |   Briefcase | 4,221 reads

Writing Dynamic Stored Procedure

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...
By Sunil Chandurkar 2009/06/01 | Source: SQLServerCentral.com | Category: programming
Rating: |  Discuss |   Briefcase | 19,230 reads

SQL Server 2008 Developer Training Kit

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...
By Additional Articles 2009/05/28 | Source: Microsoft MSDN | Category: programming
Rating:  Rate this |   Briefcase | 4,470 reads

.NET Basics for the Database Developer: Take the Plunge

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...
By Additional Articles 2009/04/15 | Source: DevX | Category: .net
Rating:  Rate this |   Briefcase | 5,896 reads

Adobe AIR: Running SQL Commands Against a Local Database

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...
By Additional Articles 2009/01/16 | Source: DevX | Category: adobe air
Rating:  Rate this |   Briefcase | 3,282 reads

Accessing SQL Server Databases with PHP

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...
By Additional Articles 2008/09/05 | Source: TechNet Blogs | Category: programming
Rating: (not yet rated)  Rate this |   Briefcase | 3,693 reads

Uncommon Table Expressions

This article describes an alternate use of CTEs for functional data processing.  Read more...
By Peter Kierstead 2008/08/11 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 9,294 reads

Microsoft Jet 4.0 Sorting APIs: DBCompareStringW and DBLCMapStringW

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...
By Additional Articles 2008/07/11 | Source: TechNet Blogs | Category: jet
Rating: (not yet rated)  Rate this |   Briefcase | 2,784 reads

T-SQL Data Processing

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...
By Peter Kierstead 2008/06/23 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 7,916 reads

Free Encryption

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...
By Michael Coles 2008/04/25 (first published: 2005/07/21) | Source: SQLServerCentral.com | Category: security
Rating: |  Discuss |   Briefcase | 75,249 reads
   Items 1 to 20 of 353    Older >>
 
Tags
miscellaneous (152)    
.net (72)    
sql server 7 (69)    
t-sql (60)    
ado (44)    
visual basic 6 (43)    
administration (32)    
sql-dmo (28)    
strategies (26)    
access (20)    
stored procedures (19)    
database design (16)    
configuring (15)    
performance tuning (15)    
asp (13)    
security (11)    
basics (9)    
dts (8)    
xml (8)    
advanced querying (7)    
career (6)    
replication (6)    
backup / restore (5)    
data warehousing (5)    
sql server 2005 (5)    
certifications (4)    
development (4)    
indexing (4)    
naming standards (4)    
reviews (4)    
sql server 6.5 (4)    
system development life cycle (4)    
upgrading (4)    
analysis services (ssas) (3)    
best and worst practices (3)    
book reviews (3)    
disaster recovery (dr) (3)    
monitoring (3)    
sql puzzles (3)    
worst practices (3)    
advanced (2)    
availability (2)    
editorial (2)    
news (2)    
olap server (2)    
other (2)    
rants (2)    
adobe air (1)    
c# (1)    
c++ (1)    
common table expression (cte) (1)    
distributed queries (1)    
english query (1)    
friday poll (1)    
installation (1)    
jet (1)    
php (1)    
product reviews (1)    
python (1)    
semaphore (1)    
sharepoint (1)    
smo (1)    
sql clr (1)    
sql server (1)    
sql server 2008 (1)    
sql server compact edition (ssce) (1)    
sqlclr (1)    
state of the business (1)    
synonyms (1)    
test driven development (1)    
testing (1)    
updategrams (1)    
vsts (1)