January 2009 - Posts

• SQL Teaser: Missing FROM

  Take a look at this code, will the select return anything or not? Look at the subquery and notice that there is no FROM there. USE tempdb GO CREATE TABLE TestQuery ( TestID int ) GO SELECT * FROM information_schema.columns WHERE column_name =( SELECT Read More... Posted Friday, January 09, 2009 2:30 PM by Denis Gobo | 14 Comments Filed under: Teaser

• Will we need many DBAs or no DBAs at all in the future?

  This is a very exciting/confusing/glooming period for SQLServer Developers/DBAs On one hand there is the ‘cloud’ which will take our precious boxes away from us and we won’t be needed to manage it anymore. On the other hand is an avalanche of technologies Read More... Posted Wednesday, January 07, 2009 11:53 AM by Denis Gobo | 26 Comments Filed under: Challenges