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

Guest Columnist: Dinesh Asanka

SQLServerCentral.com profile

<< Newer    Items 21 to 29 of 29   
 

Save Your Password

Storing passwords in SQL Server for authentication by your application is a common practice. But not always a good one. Someone with access could easily see all passwords and perhaps cause mischief inside your application. Imagine the office gossip getting access to your HR application as the HR director! Not a good thing. Dinesh Asanka has written a short piece on how you can use a built in function in SQL Server to encrypt these passwords and use them with a minimum of effort.   Read more...
By Dinesh Asanka 2004/07/12 | Source: SQLServerCentral.com | Category: security
Rating: |  Discuss |   Briefcase | 13,146 reads

An Introduction to InfoPath 2003

Office 2003 has a new tool: InfoPath 2003, which can work with SQL Server along with numerous other data stores. It's a great way to begin working with XML, Web Services, and many of the newer technologies that are available today. Join Dinesh Askanka on his journey to learn more about InfoPath2003 in the start of another series.   Read more...
By Dinesh Asanka 2004/06/10 | Source: SQLServerCentral.com | Category: miscellaneous
Rating: |  Discuss |   Briefcase | 10,553 reads

Change Management in Your Database

SQL Server has no change management integrated with the native tools. This means that each person must develop their own method of handling changes, or live with the chaos that will inevitably ensue. There are a number of articles written about various ways to handle change management and Dinesh Asanka shares his here. Read on and see if this helps you get a handle on changes in your environment.   Read more...
Rating: |  Discuss |   Briefcase | 7,191 reads

Working with the Registry

It's not often you'll need to access the registry from SQL, but when you do - these functions make it happen!   Read more...
By Dinesh Asanka 2004/03/23 | Source: SQLServerCentral.com | Category: miscellaneous
Rating: |  Discuss |   Briefcase | 8,638 reads

Generate Next Numbers with SQL Server

Dinesh ran into a situation where a client had very specific requirements for generating keys. Take a look at the solution, can you better alternatives? Sometimes you just can't talk the client into changing!   Read more...
By Dinesh Asanka 2004/03/05 | Source: SQLServerCentral.com | Category: miscellaneous
Rating: |  Discuss |   Briefcase | 14,298 reads

Changing Databases Using XML

Need to apply changes to customer (or internal) databases in a calm, controlled manner? Dinish proposes an alterative to standard scripts that uses XML and a small VB app.   Read more...
By Dinesh Asanka 2004/02/16 | Source: SQLServerCentral.com | Category: visual basic 6
Rating: |  Discuss |   Briefcase | 5,547 reads

Temp Tables in SQL Server

This is an entry level look at how temp tables work in SQL along with some tips about how to use them effectively.   Read more...
By Dinesh Asanka 2006/07/14 (first published: 2004/02/11) | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 79,961 reads

Date Time Values and Time Zones

Dinesh looks at the date functions, how to work with time zones (or not), and does a brief comparison to see how you do similar tasks in Oracle.   Read more...
By Dinesh Asanka 2003/12/22 | Source: SQLServerCentral.com | Category: advanced querying
Rating: |  Discuss |   Briefcase | 14,678 reads

Find Min/Max Values in a Set

New Author! The author tries to port a solution from Oracle and runs into a problem. Agree with the solution?   Read more...
By Dinesh Asanka 2003/11/21 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 11,415 reads
<< Newer    Items 21 to 29 of 29