I write about SQL Server…and occasionally something else.
-
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…
-
SQL Server Page Types
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…
-
SQL Server Row Internals
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…
-
MCM 2008 Success
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…
-
SQL Server Partitioning Data Movement
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…
-
SQL Server Partitioning Overview
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…
-
Find Uptime / Last Boot Up Time Commands
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
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…
-
SQL Object Decryption
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…
-
Get-StringHash and Get-FileHash
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…
Join 900+ subscribers
Stay in the loop with everything you need to know.