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 14 (133 total posts)
  • T-SQL Tuesday #86 My all-time favorite personal SQL Server Enhancement Request: Automatically maintained columns

    I have heard the name T-SQL Tuesday for (like,) ever; but I have always been so into my own bundle of insanity that never took the time to figure out what it is. This changes today because I read a blog on Adam Machanic's (@adammachanic) blog that outlined the rules (here) and I have been keen to get back to blogging regularly. When I saw what ...
    Posted to Louis Davidson (Weblog) by drsql on January 10, 2017
  • The SQL Genie (T-SQL Tuesday #086)

    At some point a long time ago, when I was first getting serious about SQL Server, I became aware of an open secret. You see, there was this special Microsoft alias called “sqlwish.” Those in the know could send an e-mail and pass along suggestions for improving the product. And they wouldn’t just vanish into thin air; some actual member of the ...
    Posted to Adam Machanic (Weblog) by Adam Machanic on January 10, 2017
  • This month’s T-SQL Tuesday post

    …is not here. It’s over at https://sqlperformance.com/2017/01/sql-performance/estimated-number-of-rows-to-be-read 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
  • T-SQL Tuesday Rules of Engagement

    Just over seven years ago (wow, does time fly!) I launched T-SQL Tuesday. The core idea is simple: Each month, one blogger acts as “host.” He or she is responsible for choosing an interesting topic in or related to the SQL Server realm. Then a bunch of other bloggers all write articles on that topic. Finally, the hosting blogger puts together a ...
    Posted to Adam Machanic (Weblog) by Adam Machanic on January 3, 2017
  • 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
1 2 3 4 5 Next > ... Last »
Privacy Statement