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 42 (418 total posts) < 1 second(s)
  • re: Handling special characters with FOR XML PATH('')

    You're doing &quot;XML Auto, Elements&quot; at the end, so that will make your contents be &amp;amp; rather than &amp;. You're actually wanting an XML form, right? So it's valid to have &amp;amp; - and you've solved the fact that it's not &amp;amp;amp;
    Posted to Rob Farley (Weblog) by Rob Farley on November 24, 2014
  • re: Handling special characters with FOR XML PATH('')

    Prat - hopefully you're on the right track. It sounds like you must be using two FOR XMLs, and will need to use another .value as well?
    Posted to Rob Farley (Weblog) by Rob Farley on November 24, 2014
  • Learning through others

    This PASS Summit was a different experience for me I wasnt speaking. Ive presented at three of the five PASS Summits Ive been to, where the previous one Id not spoken at was 2012, while I was a PASS Director (and had been told I shouldnt submit talks advice that Id ignored in 2013). I have to admit that I really missed presenting, both ...
    Posted to Rob Farley (Weblog) by Rob Farley on November 11, 2014
  • re: Did You Know? My PASS Demo Scripts are Up (and other news)!

    It was good to see you, K... I should've grabbed a copy of your book - they're always classics.
    Posted to Kalen Delaney (Weblog) by Rob Farley on November 10, 2014
  • PASS Summit WIT Lunch

    With the pleasant sound of cutlery on crockery, those lucky enough to secure tickets to the WIT Lunch at the PASS Summit get to listen to an interview with Kimberly Bryant, who is the founder of a non-profit organisation called Black Girls Code helping teenaged girls from low-privilege communities to get into technology. She calls herself an ...
    Posted to Rob Farley (Weblog) by Rob Farley on November 6, 2014
  • Dr Rimma Nehme at the PASS Summit

    This Summits presentation from Microsoft Research Labs is from Dr Rimma Nehme, bucking the trend of having presentations from Dr David DeWitt. Im really pleased to be able to hear from her, because shes an absolute legend. Among her qualifications is work on the PDW Query Optimizer a topic closer to me than probably any other area of SQL ...
    Posted to Rob Farley (Weblog) by Rob Farley on November 6, 2014
  • PASS Summit – Thursday Keynote

    Its good to point out its still only Thursday, as my laptop tells me that its already Friday. Today is the second of only two keynotes this Summit, which means that its the opportunity to hear from Microsoft Research Labs about whats going on with data from their perspective. Its also when we get to hear from the PASS VPs community ...
    Posted to Rob Farley (Weblog) by Rob Farley on November 6, 2014
  • Keynote technologies – new or not?

    So Im sitting in the PASS Summit keynote, and there are some neat things being shown. Something that just appeared on the screen was around having the location of shoppers being shown on a plan of a store. There were some Oohs coming from around the room, as they mentioned that Kinect was being used to track locations. Hotspots were appearing ...
    Posted to Rob Farley (Weblog) by Rob Farley on November 5, 2014
  • PASS Summit keynote

    The PASS Summit has kicked off again with a tremendous keynote from Ranga. He's been in the role at Microsoft for a little over a year now, and has really come into his own, as can be seen by the presentation this morning. The changes to the data picture haven't changed hugely over the past year, although the &quot;Internet of Things&quot; space ...
    Posted to Rob Farley (Weblog) by Rob Farley on November 5, 2014
  • re: Filegroups and Non-Clustered Indexes

    Hi Vijay, I wouldn't worry. Separating indexes off is far less important than the things you've suggested around having separate disks for data files, log files, and tempdb. You could put your backups across the network even (if it's fast enough). The biggest thing to consider here is that MDFs and LDFs and Tempdb have different styles of disk ...
    Posted to Rob Farley (Weblog) by Rob Farley on October 31, 2014
1 2 3 4 5 Next > ... Last »
Powered by Community Server (Commercial Edition), by Telligent Systems
  Privacy Statement