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 (119 total posts)
  • Can you still use DBCC PAGE to access data in dropped tables if TDE is turned on?

    Yes. #ShortestPostEver @rob_farley    Oh, ok... I’ll explain some more. Transparent Data Encryption encrypts data at rest. That’s the stuff that’s on disk – the encryption happens when the data is written to disk, and the decryption happens as the data is loaded into RAM from the disk. The engine handles this so that it’s invisible ...
    Posted to Rob Farley (Weblog) by rob_farley on August 11, 2015
  • Always Encrypted with SQL 2016

    Transparent Data Encryption has been around for some time now, making sure that data in SQL Server as stored on disk is encrypted. When it was announced, this was incredibly exciting. You see, by default, SQL Server data is not encrypted. If you open up the pages within a data file, you can read the data that’s in there. Numbers are stored as ...
    Posted to Rob Farley (Weblog) by rob_farley on August 10, 2015
  • 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
1 2 3 4 5 Next > ... Last »
Powered by Community Server (Commercial Edition), by Telligent Systems
  Privacy Statement