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 (532 total posts) < 1 second(s)
  • 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
  • re: Why isn’t my filtered index being used?

    Oh Matt - I'm totally in favour of using views to help developers make good decisions about predicates they should use. :)
    Posted to Rob Farley (Weblog) by Rob Farley on June 21, 2016
  • Some recent posts

    Its T-SQL Tuesday, but this isnt actually my post! Regular readers might remember that I posted about Number of Rows Read a while back, and in that post, I mentioned that SQL Sentry should consider having a warning in Plan Explorer. Well, they put that feature in, and asked me if I could write about it. So I did. But this wasnt a standard ...
    Posted to Rob Farley (Weblog) by Rob Farley on June 13, 2016
  • Exploring custom visuals in Power BI

    One of my favourite things about Power BI is its extensibility. For ages I would hear about how good some other self-service reporting platforms were, and how things in the Microsoft space were lacking. Power View, in particular, was frustratingly limited in what you could do with it, and I felt somewhat disappointed. It was good as a data ...
    Posted to Rob Farley (Weblog) by Rob Farley on May 10, 2016
  • re: PowerShell script to help uninstall SQL Server 2008 R2 Evaluation Edition

    Yes, Eric. If you make a Unicode file, it won't work. It must be ASCII / UTF8.
    Posted to Rob Farley (Weblog) by Rob Farley on April 12, 2016
1 2 3 4 5 Next > ... Last »
Privacy Statement