Profile

Scrapbook photo 1
Scrapbook photo 2
Scrapbook photo 3
Scrapbook photo 4
Scrapbook photo 5
Valþór Druzin Halldórsson
Works at Five Degrees Software
Attended University of Iceland
Lived in Reykjavik, Iceland
164 followers|44,288 views
AboutPostsPhotosYouTube

Stream

 
I work for a software company and we've been trying to figure  out a good way of supporting database source control with a single database structure but different static data for each one of our customer. So far we've been using the RedGate source control tools but they have some limitations in terms of static data.

We're pushing this issue on the Redgate support website :
http://redgate.uservoice.com/forums/39019-sql-source-control/suggestions/4259698-support-different-static-data-per-customer

Does anyone here have a good idea on how to solve this differently ?
1
Add a comment...
 
Neat SQL trick not everyone knows; an IN statement can work both ways:

SELECT *

FROM table
WHERE Column IN ('searchString1', 'searchString2', 'searchString3')
but also


SELECT *
FROM table
WHERE 'searchString' IN (Column1, Column2, Column3)

Comes in pretty handy pretty often

#SQL #SQLSERVER #ORACLE #plsql #tsql
4
Steinn Hildar Þorsteinsson's profile photoJon Gnarr's profile photo
2 comments
 
SELECT *
FROM keyboard
WHERE 'i' WIN (theGame)
Add a comment...
 
#newgoogleplus looks cool, but a bit too much white space imo
1
Add a comment...
 
Hérna, öhm, TÖFF!
1
Add a comment...
 
Er að hugsa um að skuldbinda mig til þess að plúsa allt það sem +Jon Gnarr lætur frá sér á plúsnum
 ·  Translate
3
Jon Gnarr's profile photo
 
+ á það!
Add a comment...
 
Jebb
1
Add a comment...
Have him in circles
164 people
Hörður Tulinius's profile photo
Petur Danielsson's profile photo
Quando Lorez's profile photo
Davíð Örn Ingvarsson's profile photo
Freyzi Hermannsson's profile photo
Símon Óttar's profile photo
 
The main difference between #Google and #facebook is that on #Google you can see #Facebook stock plummet 10% in one day

https://www.google.com/finance?client=ob&q=NASDAQ%3AFB
3
Add a comment...
 
That's a weird message from Mr. Ellison this month #oracle
1
Add a comment...
People
Have him in circles
164 people
Hörður Tulinius's profile photo
Petur Danielsson's profile photo
Quando Lorez's profile photo
Davíð Örn Ingvarsson's profile photo
Freyzi Hermannsson's profile photo
Símon Óttar's profile photo
Work
Occupation
Systems Architecht, programmer
Employment
  • Five Degrees Software
    Database developer, 2011 - present
  • Vodafone Iceland
    Systems Architecht, programmer, 2008 - 2011
  • Skýrr
    2008 - 2008
  • Glitnir
    2007 - 2008
  • Vodafone Iceland
    1999 - 2007
Places
Map of the places this user has livedMap of the places this user has livedMap of the places this user has lived
Previously
Reykjavik, Iceland
Story
Tagline
Grjótharður og töff!
Introduction
Tölvunarfræðingur og gagnagrunnsnörd. 

Með áhuga á allskonar
Education
  • University of Iceland
    Computer Science, 2011
  • University of California, Berkeley
    Concepts of Database, 2004
  • University of California, Berkeley
    Unix Operating System, 2005
  • Menntaskólinn við Hamrahlíð
    Nature Science, 1994 - 1998
Basic Information
Gender
Male
Apps with Google+ Sign-in