Jon Gurgul's Blog - Page 7 of 10 - Jon Gurgul with SQL Server...and occasionally something else.

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…

Jon Gurgul 2012-11-02

Blog

Consultancy / Contract Work / New Certification Goal

I have over the last few months taken the decision to leave my full-time job and setup my own company. This should hopefully provide me with greater flexibility to do…

Jon Gurgul 2012-09-23

SQL Server

SQL Server Memory Usage – Buffer

What is the SQL Server Buffer Pool? I am purposely keeping this post short because I simply want to offer up my script to show the current amount buffered. My…

Jon Gurgul 2012-08-25

SQL Server

Failing the MCM Lab exam

Well I failed the MCM Lab exam which I spoke about last time. The results came in 3 weeks so nice and quick. In a few ways I am happy…

Jon Gurgul 2012-07-27

SQL Server

Post MCM Lab Exam 88-971 thoughts etc

This is a quick update on my MCM progress as yesterday (5th July) I took the lab portion 88-971. I am afraid this post will not go into any content detail as…

Jon Gurgul 2012-07-06

SQL Server

TORN_PAGE_DETECTION Internals (SQL 2005 onwards)

CHECKSUM is in the majority of cases the more appropriate PAGE_VERIFY option as it provides a much more complete check (slightly higher overhead) when compared to TORN_PAGE_DETECTION. I thought today however I…

Jon Gurgul 2012-06-22

SQL Server

SQL Server Max Row Size 8060 Part 2

In my previous post on row maximum length I showed that the largest row size that could be stored on page was 8053 byte. So to recap a table with…

Jon Gurgul 2012-06-09

SQL Server

Passed MCM Knowledge Exam 88-970

Well back in January I mentioned my plan to study towards the MCM certification. Well... I passed 88-970... for those who want to know more read on. I said I…

Jon Gurgul 2012-05-16

SQL Server

Page Life Expectancy

Page Life Expectancy Page Life Expectancy is often quoted as being a key metric to watch out for memory pressure within SQL Server. If you search you will often see 300 listed…

Jon Gurgul 2012-04-20

SQL Server

SQL Servers Virtual Columns and Row Cracking

In order to access row structures there are several functions within SQL Server that are beneficial. I have listed these below with the descriptions taken from the actual functions. sys.fn_GetRowsetIdFromrowdump --…

Jon Gurgul 2012-04-16