Jon Gurgul's Blog

Author: Jon Gurgul

  • My MCM plaque, bag and laptop case

    —

    by

    Jon Gurgul
    in

    Look what I got in the post… Free stuff from Microsoft. Well true you need to pass a few exams to get them, but how cool is the swag. I did wonder what UPS had sent me and had completely forgot this was coming. Good luck to all those on the road to getting them.

  • SQL Server Page Types

    —

    by

    Jon Gurgul
    in

    There are lots of different page types and Paul Randall list them in his article. However as I tend to have a rather poor memory for remembering them first off here are the ones that can be anywhere within the database. m_type 1  DATA_PAGE 2  INDEX_PAGE 3 TEXT_MIX_PAGE 4 TEXT_TREE_PAGE 7 SORT_PAGE 10 IAM_PAGE Now…

  • SQL Server Row Internals

    —

    by

    Jon Gurgul
    in

    Row Storage A Row is stored on a Page which is 8192 Bytes, and this is broken down in two key areas when considering physical storage. Firstly on all pages there is a 96 Byte Header. In addition to this we also need to store the Row structure as well as its location in the…

  • MCM 2008 Success

    —

    by

    Jon Gurgul
    in ,

    I got an email from Microsoft! The lab I took on the 11th April. (Yesterday). I passed!!! So…. a long time ago in a place….no wait… I passed the prerequisite and then spent many days with my books and study material to pass the knowledge exam which as I said before was hard. The lab exam itself…

  • SQL Server Partitioning Data Movement

    —

    by

    Jon Gurgul
    in

    Introduction This is a continuation to the partitioning overview post to help explain how data movement is performed using Alter Partition with Merge and Split Commands. Getting Started In order to move data in or out of a partitioned object the part of the object that needs to be moved must reside on the same file…

  • SQL Server Partitioning Overview

    —

    by

    Jon Gurgul
    in

    Introduction This is a guide to help explain partitioning setup; which although introduced way back in SQL 2005 is still an area which throws up a lot of questions. Requirements First off you will need Enterprise SQL Server in your production environment, or alternatively you can explore this feature in SQL Developer edition. Getting Started…

  • Find Uptime / Last Boot Up Time Commands

    —

    by

    Jon Gurgul
    in

    There are numerous ways to find how long a machine has been powered on for, and below I will list a few of them: CMD Powershell

  • SQL Events 2013

    —

    by

    Jon Gurgul
    in ,

    2013 is shaping up to be a good year for me getting to events, so far penciled in are SQLSaturday in Exeter and SQLBits XI in Nottingham. Hope to see lots of you there… In fact you can even register for SQLSaturday right now. So go do that. SQLSaturday #194 8th and 9th March 2013 Exeter http://www.sqlsaturday.com/194/eventhome.aspx SQLBits XI 2nd…

  • SQL Object Decryption

    —

    by

    Jon Gurgul
    in

    Background The ability to “decrypt” an object in SQL Server be it stored procedure, view, function or trigger is something that I have run into a few times. In this post I will show you how you can “decrypt” any sql object using a simple script and highlight the things to be aware of. Firstly…

  • Get-StringHash and Get-FileHash

    —

    by

    Jon Gurgul
    in

    Hashing Here are two of my powershell scripts that provide a quick and easy way to hash either a string or a file using any of the cryptography hash algorithms. Get-StringHash Usage Examples: Get-StringHash “My String to hash” “MD5” Get-StringHash “My String to hash” “RIPEMD160” Get-StringHash “My String to hash” “SHA1” Get-StringHash “My String to hash” “SHA256”…