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 12 (117 total posts)
  • Check the settings when installing SQL Server

    Next, next, next, next, next... you know the drill. Except that when installing SQL, it’s simply not good enough. The defaults might not work for you, and that makes this post qualify for this month’s T-SQL Tuesday, hosted by Andy Yun (@sqlbek). Most things are fine, but there is one page which you really shouldn’t ignore. And it’s not even ...
    Posted to Rob Farley (Weblog) by rob_farley on July 13, 2015
  • Monitoring skew in PDW

    When you have data stored across several servers, skew becomes very significant. In SQL Server Parallel Data Warehouse (PDW), part of the Analytics Platform System (APS), data is stored in one of two ways – distributed or replicated. Replicated data is copied in full across every compute node (those servers which actually store user data), while ...
    Posted to Rob Farley (Weblog) by rob_farley on May 11, 2015
  • SHOWPLAN permission denied even if the database isn’t actually used

    To view a query plan, you need SHOWPLAN permission on the database level at least. You have this if you have CONTROL DATABASE, or CONTROL SERVER, or if you have ALTER TRACE at the instance level. I know this last one because it’s mentioned in Books Online on the ‘Database Permissions’ page, not because it’s particularly intuitive. As a ...
    Posted to Rob Farley (Weblog) by rob_farley on April 14, 2015
  • Tuning Parallel Data Warehouse Queries

    Performance tuning in regular SQL Server can be addressed in a number of ways. This can involve looking at what’s going on with the disk configuration, the memory configuration, the wait stats, the parallelism settings, indexing, and so much more. But if you have a Parallel Data Warehouse (PDW) environment, then there are a lot of things that are ...
    Posted to Rob Farley (Weblog) by rob_farley on March 9, 2015
  • SQL Injection – the golden rule

    The problem with SQL Injection is that most people don’t realise the fundamental concept which makes SQL Injection vulnerability not only easy to spot, but also easy to prevent. And it’s the thing that SQL Injection has in common with countless other hacking mechanisms that have been around since the early days of computing. The simple truth is ...
    Posted to Rob Farley (Weblog) by rob_farley on February 9, 2015
  • Will 2015 be a big year for the SQL community?

    In Australia, almost certainly yes. Australia recently saw two Azure data centres open, meaning that customers can now consider hosting data in Azure without worrying about it going overseas. Whether you’re considering SQL Database or having an Azure VM with SQL on it, the story has vastly improved here in Australia, and conversations will go ...
    Posted to Rob Farley (Weblog) by rob_farley on December 8, 2014
  • Learning through others

    This PASS Summit was a different experience for me – I wasn’t speaking. I’ve presented at three of the five PASS Summits I’ve been to, where the previous one I’d not spoken at was 2012, while I was a PASS Director (and had been told I shouldn’t submit talks – advice that I’d ignored in 2013). I have to admit that I really missed presenting, both ...
    Posted to Rob Farley (Weblog) by rob_farley on November 11, 2014
  • T-SQL Tuesday #59: My Hero!

    This month's edition of T-SQL Tuesday is being hosted by Tracy McKibben (T|B). I was challenged by Aaron Bertrand (T|B) to participate in this T-SQL Tuesday. I instantly knew what and who I wanted to write about, but my schedule being what it is prevented me from writing the blog entry until straight up at midnight. (Originally ...
    Posted to Kevin Kline (Weblog) by KKline on October 15, 2014
  • T-SQL Tuesday #56 : Assumptions

    This month's T-SQL Tuesday is about assumptions in SQL Server. Over on our new consolidated team blog at SQL Sentry, I discuss the following assumptions I come across with relative frequency: Case will always short circuit A seek is better than a scan, always A query without ORDER BY will always order by _________ SQL Server's defaults are ...
    Posted to Aaron Bertrand (Weblog) by AaronBertrand on July 8, 2014
  • SSIS Lookup transformation in T-SQL

    There is no equivalent to the SSIS Lookup transformation in T-SQL – but there is a workaround if you’re careful. The big issue that you face is about the number of rows that you connect to in the Lookup. SQL Books Online (BOL) says: If there is no matching entry in the reference dataset, no join occurs. By default, the Lookup transformation ...
    Posted to Rob Farley (Weblog) by rob_farley on July 8, 2014
1 2 3 4 5 Next > ... Last »
Powered by Community Server (Commercial Edition), by Telligent Systems
  Privacy Statement