THE SQL Server Blog Spot on the Web

Welcome to - The SQL Server blog spot on the web Sign in | |


You searched for the word(s):
Showing page 1 of 50 (492 total posts) < 1 second(s)
  • re: What’s driving your data model?

    I think we do agree. I'm not suggesting that facts not be measured. I'm suggesting that the most important part of your model might not be the obvious fact table. Additional fact tables would be introduced to give a better picture of the information about the core concept - even to the point of turning a traditional dimension table into a 'fact ...
    Posted to Rob Farley (Weblog) by Rob Farley on November 10, 2015
  • What’s driving your data model?

    If data modelling were easier, I doubt there would be as many books on the subject, and we wouldnt have multiple methodologies to consider. Im not going to explore the different methodologies here thats almost a religious argument these days, and I am more than happy to let you adopt whichever method you like. Instead, I want to challenge ...
    Posted to Rob Farley (Weblog) by Rob Farley on November 10, 2015
  • PASS Summit 2015 WiT lunch

    A regular spot at the PASS Summit is the Women in Technology lunch. This year is no different. A few years ago, I was on a panel for discussion at the lunch. The last couple of years though, have changed format, and have an interview focus, with a champion for WiT. This year, Angie Chang is being interviewed about an initiative called HackBright, ...
    Posted to Rob Farley (Weblog) by Rob Farley on October 29, 2015
  • PASS Summit 2015 - Keynote 2

    The second day keynote is always a highlight of mine. Until a few years ago there were three keynotes, with the third day including a session from Microsoft Research. Recently this has changed, and the third day keynote rolls into the second. Today Im expecting some new announcements, some updates on how PASS is tracking, an acknowledgement of ...
    Posted to Rob Farley (Weblog) by Rob Farley on October 29, 2015
  • PASS Summit 2015 Keynote 1

    Im back at the PASS Summit. Another year my sixth now. And Im sitting at the bloggers table, next to Mark Broadbent (@retracement). The PASS Summit is by far the best SQL Server event in the world each year even better than the Adelaide SQL Server User Group sessions, and the first keynote is always full of announcements. It always ...
    Posted to Rob Farley (Weblog) by Rob Farley on October 28, 2015
  • PASS Summit 2015 presentations I’m giving

    With only a few days to go until people arrive in Seattle, I should probably explain what my sessions are going to be on. You know, in case you hadnt thought to go to the PASS site and read for yourself (and for those who want to hear something thats a little less abstracty). A few people told me last year they were disappointed I wasnt ...
    Posted to Rob Farley (Weblog) by Rob Farley on October 22, 2015
  • SQL Server Auditing - for Business Intelligence when your business is the database

    Over the past decade or so, Business Intelligence has become a big deal. As a data consultant, most of my work would be categorised as being in the BI space. People want to have insight into how their business is operating, and be able to use this to do things better. Data has become one of the biggest influencers in the world today now that ...
    Posted to Rob Farley (Weblog) by Rob Farley on October 12, 2015
  • re: Handling special characters with FOR XML PATH('')

    Hi Zaheer, What's the error you're getting? Rob
    Posted to Rob Farley (Weblog) by Rob Farley on October 12, 2015
  • re: Handling special characters with FOR XML PATH('')

    Hi Joy, There's something you're not quite getting... The STUFF function is there to remove the leading comma. Start by just doing the SELECT * FROM ... AS XMLDATA part. Then add the &quot;FOR XML PATH(''), TYPE&quot; bit in there. You'll notice that you have tags for your column names, so change your &quot;*&quot; to ', ' + ...
    Posted to Rob Farley (Weblog) by Rob Farley on October 5, 2015
  • re: Probe Residual when you have a Hash Match – a hidden cost in execution plans

    You like the stuff on LQS? Cool! You can have a raise!
    Posted to Rob Farley (Weblog) by Rob Farley on September 15, 2015
1 2 3 4 5 Next > ... Last »
Powered by Community Server (Commercial Edition), by Telligent Systems
  Privacy Statement