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 (136 total posts)
  • “Stored procedures don’t need source control…”

    Hearing this is one of those things that really bugs me. And it’s not actually about stored procedures, it’s about the mindset that sits there. I hear this sentiment in environments where there are multiple developers. Where they’re 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
  • The Guru (T-SQL Tuesday #089)

    I became a consultant a bit earlier in my career than was probably wise. The going was rough at first, with periods of feast and periods of famine. Although I had several clients, I didn’t understand how to sell services or schedule my workload, and so I’d wind up either doing huge amounts of work for a few weeks, or absolutely nothing some other ...
    Posted to Adam Machanic (Weblog) by Adam Machanic on March 14, 2017
  • Solving the Net Changes Problem with Temporal Tables (T-SQL Tuesday #087)

    SQL Server 2008 was perhaps not the meatiest of SQL Server releases, but it did have one especially promising feature: Data change detection. Or maybe two features, depending on how you look at things. I’m talking, of course, about the almost confusingly similarly named Change Data Capture and Change Tracking. Change Data Capture was the big ...
    Posted to Adam Machanic (Weblog) by Adam Machanic on February 14, 2017
  • 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
1 2 3 4 5 Next > ... Last »
Privacy Statement