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 54 (540 total posts) < 1 second(s)
  • DevOps and your database

    Im a consultant. That means I have to deal with whatever I come across at customer sites. I can recommend change, but when Im called in to fix something, I generally dont get to insist on it. I just have to get something fixed. That means dealing with developers (if they exist) and with DBAs, and making sure that anything that I try to fix ...
    Posted to Rob Farley (Weblog) by Rob Farley on June 12, 2017
  • “Stored procedures don’t need source control…”

    Hearing this is one of those things that really bugs me. And its not actually about stored procedures, its about the mindset that sits there. I hear this sentiment in environments where there are multiple developers. Where theyre using source control for all their application code. Because, you know, they want to make sure they have a history ...
    Posted to Rob Farley (Weblog) by Rob Farley on May 8, 2017
  • Time waits for no one

    And technology changes as quickly as the numbers on a clock. A digital clock, of course the numbers never change on an analogue one. I think its nice to have this months T-SQL Tuesday (hosted by Koen Verbeeck (@ko_ver)) on this topic, as I delivered a keynote at the Difinity conference a couple of months ago on same thing. In the keynote, I ...
    Posted to Rob Farley (Weblog) by Rob Farley on April 11, 2017
  • SQL WTF for T-SQL Tuesday #88

    The topic for this months T-SQL Tuesday is: Be inspired by the IT horror stories from, and tell your own daily WTF story. The truly original way developers generated SQL in project X. Or what the grumpy &quot;DBA&quot; imposed on people in project Y. Or how the architect did truly weird &quot;database design&quot; on ...
    Posted to Rob Farley (Weblog) by Rob Farley on March 13, 2017
  • This month’s T-SQL Tuesday post

    is not here. Its over at I write about the new EstimatedRowsRead property, and in particular, about how Microsoft responded so well to the Connect Item I created, requesting the feature. @rob_farley
    Posted to Rob Farley (Weblog) by Rob Farley on January 9, 2017
  • Backups – are you missing the point?

    Its a common question Do you have a backup? But its the wrong question. Very relevant for this months T-SQL Tuesday, hosted by Ken Fisher (@sqlstudent144), on the topic of backups. I think the question should be Can you recover if needed? We all know that a backup is only as good as your ability to restore from it that you must test ...
    Posted to Rob Farley (Weblog) by Rob Farley on December 12, 2016
  • How I prepare for a presentation

    Some people say I talk a lot but I guess it depends on the context. Certainly, for many years, Ive been fairly comfortable about standing up in front of people and explaining things. Whether its teaching a course, leading a workshop, presenting at a conference, or preaching at a church, it all has that same Im talking, and people are ...
    Posted to Rob Farley (Weblog) by Rob Farley on November 7, 2016
  • PASS Summit 2016 – Keynote 2

    Thursday! Kilt day. We start with Grant Fritchey (PASS VP of Finance, in a kilt), talking about the various metrics of PASS, which show that the community is growing both numerically and graphically, reaching 87% of countries now. Its good to know that things are going well. This is all public information, and Im not going to go into the ...
    Posted to Rob Farley (Weblog) by Rob Farley on October 27, 2016
  • PASS Summit 2016 – Blogging again – Keynote 1

    .So Im back at the PASS Summit, and the keynotes on! Were all getting ready for a bunch of announcements about whats coming in the world of the Microsoft Data Platform. First up Adam Jorgensen. Some useful stats about PASS, and this years PASSion Award winner, Mala Mahadevan (@sqlmal) There are tweets going on using #sqlpass and ...
    Posted to Rob Farley (Weblog) by Rob Farley on October 26, 2016
  • Passwords – a secret you have no right to share

    I feel like this topic just keeps going around and around. Every time Im in a room where someone needs to log into a computer thats not theirs, there seems to be a thing of Oh, I know their password, which makes me cringe. Ive written about this before, and even for a previous T-SQL Tuesday, about two years ago, but theres something that I ...
    Posted to Rob Farley (Weblog) by Rob Farley on October 11, 2016
1 2 3 4 5 Next > ... Last »
Privacy Statement