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 (536 total posts) < 1 second(s)
  • 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
  • You’ve been doing cloud for years...

    This months T-SQL Tuesday is hosted by Jeffrey Verheul (@devjef) and is on the topic of Cloud. I seem to spend quite a bit of my time these days helping people realise the benefit of the Azure platform, whether it be Machine Learning for doing some predictions around various things (best course of action, or expected value, for example), or ...
    Posted to Rob Farley (Weblog) by Rob Farley on September 13, 2016
  • The Impact of Compression Delay in Real-time Operational Analytics

    I have a session coming up at both the PASS Summit in October and the 24HOP Summit Preview event in September, on Operational Analytics. Actually, my session is covering the benefits of combining both In-Memory and R into the Operational Analytics story, to be able to see even greater benefits but I thought Id do some extra reading on ...
    Posted to Rob Farley (Weblog) by Rob Farley on August 9, 2016
  • re: The SSIS tuning tip that everyone misses

    36M rows is quite a bit, but 18 batches isn't many. Hopefully there aren't too many things like Sorts in there. I would suggest you explore general tuning, as the difference between performance for pulling 2M compared to 36M probably isn't going to produce a very different plan.
    Posted to Rob Farley (Weblog) by Rob Farley on July 22, 2016
  • Finally, SSMS will talk to Azure SQL DW

    Dont get me started on how I keep seeing people jump into Azure SQL DW without thinking about the parallel paradigm. SQL DW is to PDW, the way that Azure SQL DB is to SQL Server. If you were happy using SQL Server for your data warehouse, then SQL DB may be just fine. Certainly you should get your head around the MPP (Massively Parallel ...
    Posted to Rob Farley (Weblog) by Rob Farley on July 12, 2016
1 2 3 4 5 Next > ... Last »
Privacy Statement