Forum Replies Created

Viewing 15 posts - 256 through 270 (of 650 total)

  • RE: There cometh a shower

    The cloud will certainly become like the power utility providers, or phone companies from which we will buy our services. My only quibble is that it is probably wrong to...

    Best wishes,
    Phil Factor

  • RE: A Function to Split JSON Data

    Don't you think if you've ended up with JSON at the database, something is wrong?

    It is as wrong as having XML at the database. If you are supporting applications that...

    Best wishes,
    Phil Factor

  • RE: Serialising tabular and relational data.

    Well, what I have in mind is a strategic attack on the problem, once we are agreed as to what the problem is, and we find enough enthusiastic people to...

    Best wishes,
    Phil Factor

  • RE: Serialising tabular and relational data.

    Do I think we should keep looking for a more universal, metadata and format rich format? Absolutely because, right now, you can't even just copy and paste between MS products...

    Best wishes,
    Phil Factor

  • RE: Is Microsoft neglecting SMO?

    Why do I need Powershell, when I can do all the stuff in GUI using SSIS? Powershell is another geek tool.

    Well, it certainly is a geek tool in the sense...

    Best wishes,
    Phil Factor

  • RE: Is Microsoft neglecting SMO?

    Maybe we should turn it around and list all the things that they spend way too much time and effort on, Jeff.

    Best wishes,
    Phil Factor

  • RE: A Great Deal of Hot Air

    Larry Gonick has been very intrigued by the problems of data-centres and their energy requirements. These cartoons were based on real stories. I wonder what he'll make of the...

    Best wishes,
    Phil Factor

  • RE: A Great Deal of Hot Air

    A great deal of space in the internet is being taken up with he debate about climate change. It isn't really a database topic, and I don't think we'll even...

    Best wishes,
    Phil Factor

  • RE: A Great Deal of Hot Air

    @niall.baird Hmm. Perhaps this is a base load generator: Scientists design cow dung-powered data centre

    [/url]

    http://www.futuregov.asia/articles/2010/jun/03/scientists-design-data-centre-powered-cow-dung/

    Researchers have found a way to combine dairy farm waste and the heat generated from data...

    Best wishes,
    Phil Factor

  • RE: A Great Deal of Hot Air

    The United States used 3723 TWh of power in 2006, and Europe was 3022. This makes the 56 Twh used by Data Centers in Europe come in at around...

    Best wishes,
    Phil Factor

  • RE: Formatting Dates with 3 Character Months (SQL Spackle)

    @clark_button - (going slightly off topic too) You could also try this, that Robyn and I wrote a while back for Simple-Talk

    [font="Courier New"]DECLARE @types TABLE(

           [2 digit year] INT NULL,

          ...

    Best wishes,
    Phil Factor

  • RE: Formatting Dates with 3 Character Months (SQL Spackle)

    Thanks to David for pointing out the bug in my code. I've gotten so used to the SET LANGUAGE syntax without the string delimiters! I've fixed the code in my...

    Best wishes,
    Phil Factor

  • RE: Formatting Dates with 3 Character Months (SQL Spackle)

    Yes, the correct shortnames for the months are listed in sys.syslanguages

    If you run this code, it should show you how, in SQL Server, all the languages format the current...

    Best wishes,
    Phil Factor

  • RE: Raw Materials - The Decision

    Larry is back with a compendium of all his Raw Materials cartoons, along with four extra strips to promote the idea of the 'mobile DBA'. This can be downloaded from...

    Best wishes,
    Phil Factor

  • RE: Understanding T-SQL Expression Short-Circuiting

    This is a great bit of research, with some timely warnings from Gianluca for anyone who makes assumptions about TSQL based on experience with a procedural language.

    Best wishes,
    Phil Factor

Viewing 15 posts - 256 through 270 (of 650 total)