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 » sql   (RSS)
Showing page 1 of 17 (162 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
  • SQL Formatting Matters…

    … to some folks more than others. We likely all have stories about working with folks who care a lot about the format of their SQL statements. I’ve worked with a lot of database developers and analysts. I cannot say SQL formatting distinguishes the good from the bad (or ugly), but I have noticed the sharpest developers have a preferred SQL ...
    Posted to Andy Leonard (Weblog) by andyleonard on July 20, 2015
  • Corruption, corruption, more corruption

    No, not in my systems. Corruption does happen from time to time. At LobsterPot Solutions we get calls from people now and then who have corruption in their databases, that want help getting them repaired. Generally, it’s not too much of a problem, although I’ve seen some doozies over time. (And if you need help, get in touch!) Interestingly, I ...
    Posted to Rob Farley (Weblog) by rob_farley on July 17, 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
  • Fetch once, write many times

    As I’ve said before these days I’m spending time working on Hadoop rather than SQL Server and one of my colleagues today alerted me to a rather cool feature Of Hive (in a nutshell Hive is the technology that makes enables us to write SQL statements against Hadoop). Check this out: Pretty cool, no? From a single tablescan I can summarise and ...
    Posted to Jamie Thomson (Weblog) by jamiet on May 12, 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
  • Tuning slow spatial queries in SQL Server

    Even with the right indexes in place, spatial queries in SQL Server are often too slow – but they needn’t be. Two of the most commonly found patterns of query in the spatial world are when you’re looking for the nearest thing to where you are (which I’ve written about before), and when you’re looking for the points that are within a particular ...
    Posted to Rob Farley (Weblog) by rob_farley on April 28, 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
1 2 3 4 5 Next > ... Last »
Powered by Community Server (Commercial Edition), by Telligent Systems
  Privacy Statement