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

Guest Columnist: Ben Kubicek profile

   Items 1 to 3 of 3   

What is your default database set to?

Some people set their default database to the database they use most often. This can cause issues when a restore fails.  Read more...
By Ben Kubicek 2013/11/14 | Source: | Category: default database
Rating: |  Discuss |   Briefcase | 7,216 reads

A simple math expression solver

Ben Kubicek wrote a recursive function that solves simple math expressions in a select statement. Read about this creative use of T-SQL.  Read more...
By Ben Kubicek 2011/11/21 | Source: | Category: recursive function
Rating: |  Discuss |   Briefcase | 5,395 reads

A Search and Replace Script when Moving Objects from Prod to Test

Recently Ben Kubicek created a script that would allow him to copy his production db to a test instance and correct the production specific SQL code in stored procedures and views.   Read more...
By Ben Kubicek 2010/02/03 | Source: | Category: search
Rating: |  Discuss |   Briefcase | 7,285 reads
   Items 1 to 3 of 3