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

Content with tags Miscellaneous, Programming Rss

   Items 1 to 20 of 169    Older >>
 

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,256 reads

Using VBScript to Automate Tasks

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...
By Haidong Ji 2008/03/07 (first published: 2003/11/04) | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 100,314 reads

Introduction to Bitmasking in SQL Server 2005

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.   Read more...
By Lee Everest 2006/12/13 | Source: SQLServerCentral.com | Category: miscellaneous
Rating: |  Discuss |   Briefcase | 15,585 reads

Implementing Real-World Data Input Validation using Regular Expression

Francis Norton shows how to use regular expressions to fulfil some real world data validation requirements, demonstrating techniques ranging from simple number format checks, to complex string validation that requires use of regex's powerful "lookahead" feature.  Read more...
By Additional Articles 2007/05/22 | Source: SimpleTalk | Category: miscellaneous
Rating:  Rate this |   Briefcase | 3,428 reads

Send SQL Server Data to Exchange

An updated version of xp_sql2exchange is now available, enabling you to publish SQL Server data easily to an exchange server. Read about this very cool extended stored procedure from author Steve Boriotti.   Read more...
By Steve Boriotti 2007/05/14 | Source: SQLServerCentral.com | Category: miscellaneous
Rating: |  Discuss |   Briefcase | 10,831 reads

Using SQL 2005 with Expression Web

his article will explore various methods of accessing SQL Server from inside Microsoft Expression Web. Microsoft Expression Web is a graphical development tool for creating web pages and is part of the new Expression Studio.  Read more...
By Additional Articles 2007/05/10 | Source: Database Journal | Category: miscellaneous
Rating:  Rate this |   Briefcase | 1,975 reads

J2EE and SQL Server: Making a JDBC Connection

Using a SQL Server back end with a Java application server may sound like an unnatural proposition but there's no need to bow to such arbitrary limitations. In this article you'll get step-by-step instructions on making a JDBC connection between the four most popular Java application servers and Microsoft SQL Server.   Read more...
By Additional Articles 2007/03/14 | Source: DevX | Category: miscellaneous
Rating:  Rate this |   Briefcase | 1,789 reads

Using SMS 2003 SQL Views to Create Custom Reports

Microsoft Systems Management Server (SMS) 2003 Reporting uses Microsoft SQL Server views to provide access to data from the tables in the SMS site SQL database and to offer an efficient reporting option. The SMS site SQL database contains a large collection of information about the network, computers, users, user groups, and many other components of the computing environment. This database also contains objects that represent SMS items such as advertisements, packages, queries, reports, and status messages.  Read more...
By Additional Articles 2007/03/08 | Source: TechNet Blogs | Category: miscellaneous
Rating:  Rate this |   Briefcase | 1,397 reads

Introduction to Bitmasking in SQL Server 2005

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.   Read more...
By Lee Everest 2006/12/13 | Source: SQLServerCentral.com | Category: miscellaneous
Rating: |  Discuss |   Briefcase | 15,585 reads

Unit Testing With Visual Studio

Testing is an important part of programming and it is no different with SQL Server development. Longtime author Grant Fritchey brings us a look at the new testing features available in Visual Studio 2005.   Read more...
By Grant Fritchey 2006/11/15 | Source: SQLServerCentral.com | Category: miscellaneous
Rating: |  Discuss |   Briefcase | 9,061 reads

Writing to a File Using the sp_OACreate Stored Procedure and OSQL: The

SQL Server has extensions to allow one to call COM based objects from within the server using T-SQL. While this is an interesting feature, it's may not be the best way to structure your applications due to performance reasons. New author Zach Nichter of ScalabilityExperts.com brings us an analysis of different ways of writing out to a file from within SQL Server. Read on to see the most efficient method of generating files on your server.   Read more...
By Zach Nichter 2006/11/10 (first published: 2005/02/07) | Source: SQLServerCentral.com | Category: miscellaneous
Rating: |  Discuss |   Briefcase | 33,947 reads

Implementing a T-SQL semaphore

SQL Server does a great job of handling concurrency & ensuring that users can make changes in multi-user systems without conflict. However there are times a strict calling order is needed.   Read more...
By Robert Cary 2006/10/17 | Source: SQLServerCentral.com | Category: miscellaneous
Rating: |  Discuss |   Briefcase | 10,870 reads

Windows Utilities for the SQL Server DBA

This article is a short summary of Windows utilities both GUI and command line intended for new SQL Server DBAs or those interested in learning some useful techniques.   Read more...
By Chad Miller 2006/09/07 | Source: SQLServerCentral.com | Category: miscellaneous
Rating: |  Discuss |   Briefcase | 17,988 reads

Connecting With Perl Using Win32 : ODBC

Perl has been a popular language for Unix administrators for years. It is flexible, easy to learn, and capable of doing some very powerful things with relatively few lines of code. In this article by Brian Kelly, he shows you how to connect to SQL Server via Perl.   Read more...
By Brian Kelley 2006/07/28 (first published: 2002/12/03) | Source: SQLServerCentral.com | Category: miscellaneous
Rating: |  Discuss |   Briefcase | 39,568 reads

A Look at GUIDs

Not many people enjoy using Globally Unique Identifiers (GUIDs), partly because they are cumbersome to type and work with for humans. However they fill a need and can provide some interesting benefits. SQL Server expert Andy Warren takes us through what a GUID is and how you can use it easily in your code.   Read more...
By Andy Warren 2006/07/27 | Source: SQLServerCentral.com | Category: miscellaneous
Rating: |  Discuss |   Briefcase | 15,713 reads

Agile Development and ICONIX

Lightweight and adaptable, but with proper emphasis on the design phase, the ICONIX methodology can help you avoid Constant Refactoring After Programming...   Read more...
By Additional Articles 2006/06/09 | Source: Red-Gate | Category: miscellaneous
Rating:  Rate this |   Briefcase | 1,686 reads

Integrating Electronic Payment Processing into

This is a good explanation on how to acctually bill a customer for your service over a credit card in your web application.  Read more...
By Additional Articles 2006/05/26 | Source: Other | Category: miscellaneous
Rating:  Rate this |   Briefcase | 2,441 reads

Introduction to the ADO Connection Object

Part 1 of a 4 part series about ADO, this is a beginner level article designed to get you started using the ADO connection object. If you haven't used ADO so far, why not see what it's all about?   Read more...
By Andy Warren 2006/05/26 (first published: 2001/11/08) | Source: SQLServerCentral.com | Category: miscellaneous
Rating: |  Discuss |   Briefcase | 30,958 reads

Generating a Sequential Pattern

For many of us, working with the identity property allows us to easily generate a sequential series of numbers. But what if you need to generate a sequence according to some pattern, like one that includes the year? New author Asif Sayed brings us a technique and the code for generating a patterned sequence.   Read more...
By Asif Sayed 2006/05/17 | Source: SQLServerCentral.com | Category: miscellaneous
Rating: |  Discuss |   Briefcase | 8,957 reads

Securing Your WCF Service

In this article I will show you how you can implement security on a WCF service. There are many options and extensibility points for implementing security in WCF. You can also use specific products, such as the Windows 2003 Server Authorization Manager, together with WCF to implement the authorization requirements of a solution. Out of the box, WCF supports Windows credentials, Username Tokens and X.509 Digital Certificates as security credentials.   Read more...
By Additional Articles 2006/04/03 | Source: Other | Category: miscellaneous
Rating:  Rate this |   Briefcase | 1,307 reads
   Items 1 to 20 of 169    Older >>
 
Tags
sql server 7 (45)    
t-sql (45)    
strategies (24)    
administration (23)    
visual basic 6 (22)    
database design (14)    
ado (13)    
stored procedures (12)    
configuring (11)    
performance tuning (10)    
.net (9)    
security (8)    
advanced querying (6)    
sql-dmo (6)    
basics (4)    
career (4)    
data warehousing (4)    
dts (4)    
naming standards (4)    
replication (4)    
reviews (4)    
xml (4)    
asp (3)    
backup / restore (3)    
best and worst practices (3)    
book reviews (3)    
certifications (3)    
indexing (3)    
monitoring (3)    
system development life cycle (3)    
worst practices (3)    
access (2)    
analysis services (ssas) (2)    
availability (2)    
olap server (2)    
sql puzzles (2)    
sql server 6.5 (2)    
advanced (1)    
c++ (1)    
disaster recovery (dr) (1)    
english query (1)    
installation (1)    
other (1)    
product reviews (1)    
rants (1)    
semaphore (1)    
state of the business (1)