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

Guest Columnist: Peter Larsson

SQLServerCentral.com profile

   Items 1 to 3 of 3   
 

Full Control Over a Randomly Generated Password

All of us need a steady stream of random passwords for the various systems we manage. Peter Larsson brings us an interesting T-SQL solution that generates one for us.   Read more...
By Peter Larsson 2007/04/25 | Source: SQLServerCentral.com | Category: sql puzzles
Rating: |  Discuss |   Briefcase | 7,008 reads

How many more Mondays until I retire?

Depending on your age, you may not want to know this number, but as you advance in your career, this might be a problem that you look to solve one day. Peter Larsson takes a few minutes to work out a function in T-SQL that can be used to solve this or any similar question.   Read more...
By Peter Larsson 2006/07/19 | Source: SQLServerCentral.com | Category: advanced querying
Rating: |  Discuss |   Briefcase | 12,417 reads

Pivot table for Microsoft SQL Server

One of the seeminly more popular enhancements in SQL Server 2005 to T-SQL is the PIVOT operator. There have been quite a few articles, but new author Peter Larsson decomposes in detail how you can perform this operation with previous versions.   Read more...
By Peter Larsson 2007/03/30 (first published: 2006/06/12) | Source: SQLServerCentral.com | Category: advanced querying
Rating: |  Discuss |   Briefcase | 71,924 reads
   Items 1 to 3 of 3