THE SQL Server Blog Spot on the Web

Welcome to SQLblog.com - The SQL Server blog spot on the web Sign in | |
in Search

Browse by Tags

All Tags » t-sql tuesday   (RSS)
Showing page 1 of 13 (129 total posts)
  • Passwords – a secret you have no right to share

    I feel like this topic just keeps going around and around. Every time I’m in a room where someone needs to log into a computer that’s not theirs, there seems to be a thing of “Oh, I know their password…”, which makes me cringe. I’ve written about this before, and even for a previous T-SQL Tuesday, about two years ago, but there’s something that I ...
    Posted to Rob Farley (Weblog) by rob_farley on October 11, 2016
  • Finally, SSMS will talk to Azure SQL DW

    Don’t 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
  • 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
  • Reasons to upgrade SQL Server

    With SQL Server 2005’s extended support ending today, it seems appropriate to write a post about “My Favourite SQL Server Feature” for T-SQL Tuesday this month, hosted by Jens Vestergaard (@vestergaardj). The thing is that when I consider reasons to upgrade from SQL Server 2005, I see a ton of features that could be leveraged in later versions. ...
    Posted to Rob Farley (Weblog) by rob_farley on April 11, 2016
  • How to make text searching go faster

    ...but first, let’s look at one oft-forgotten reason why finding a particular piece of text can be slow, if not impossible: collation. This will then provide a useful platform for making it go faster. I say ‘impossible’, but of course it’s never impossible to find something in a database (assuming it’s there). It might take longer, but you can ...
    Posted to Rob Farley (Weblog) by rob_farley on March 7, 2016
  • A Fitbit report in Power BI for T-SQL Tuesday

    Finding things to publish online for public consumption is something I’m often a bit reluctant to do. Most of my work is for customers, and there’s no way I’m going to share some of their data unless they’ve explicitly allowed it. So when Jorge Segarra (@sqlchicken) posted a challenge to publish a Power BI report on the web for T-SQL Tuesday, I ...
    Posted to Rob Farley (Weblog) by rob_farley on February 15, 2016
  • Join Effects With UPDATE

    A lot of people don’t like UPDATE with a FROM clause. I’m going to explore what’s going on, both logically and within the query plan. And I’m doing this for T-SQL Tuesday #74, hosted by Robert Davis (@sqlsoldier). I’m going to use a fresh copy of AdventureWorks2012. I’m using SQL 2012 SP3, but the things I’m looking at should apply to most ...
    Posted to Rob Farley (Weblog) by rob_farley on January 11, 2016
  • What’s driving your data model?

    If data modelling were easier, I doubt there would be as many books on the subject, and we wouldn’t have multiple methodologies to consider. I’m not going to explore the different methodologies here – that’s 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
  • 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
  • Superhero powers for managing the enterprise

    This month’s T-SQL Tuesday is hosted by Jen McCown of @midnightdba fame. She wants us to write about strategies for managing the enterprise, and as a database consultant, I find myself giving advice on this kind of thing to customers remarkably often. No, I’m not going to do stories about LobsterPot customers. We don’t do that. What happens ...
    Posted to Rob Farley (Weblog) by rob_farley on September 7, 2015
1 2 3 4 5 Next > ... Last »
Privacy Statement