Jon Gurgul's Blog

Author: Jon Gurgul

  • Database Corruption Week 1 Solution

    —

    by

    Jon Gurgul
    in

    Database Corruption Week 1 Solution Here is my solution for week one. The original database and details for this can be found here: http://stevestedman.com/2015/04/introducing-the-database-corruption-challenge-dbcc-week-1-challenge/    

  • New Lab Environment 2015

    —

    by

    Jon Gurgul
    in

    I have recently been looking at solution for hardware for a new home lab. The primary need was a lower power solution, with plenty of ram and the ability to run hyper-v. The solution I have chosen is a small form factor from Intel called nuc5i5mybe. The hardware purchase list is as follows: Crucial 16GB (2x 8GB)…

  • SQLBits XIV – 4 – 7 Mar 2015

    —

    by

    Jon Gurgul
    in ,

    So who is going to be at SQLBits XIV this coming week? Add me if you are about @JonGurgul The ExCeL, Royal Victoria Dock, 1 Western Gateway, London E16 1XL https://sqlbits.com/

  • Help, I have lost a SQL data file and I have no backup

    —

    by

    Jon Gurgul
    in

    This week I stumbled across a post on the forum that was quite interesting in terms of recovery in dire situations. The op basically had lost a SQL data file and was in a situation where they had no backups. The question asked could they rebuild the missing data file, which unfortunately is not possible…

  • SQL Index dm_db_index_xxx_stats

    —

    by

    Jon Gurgul
    in

    There are 3 dm_db_index_xxx_stats objects that can be used to check and investigate index information. sys.dm_db_index_usage_stats can be used to see how beneficial the index is, and its related maintenance cost. Note that this information is reset upon instance restart. The final two index stats objects provide information on the physical and operational statistics of…

  • Surface Pro 3

    —

    by

    Jon Gurgul
    in

    Surface Pro 3 My first impression of the Surface Pro 3 was that Microsoft had produced a tablet/laptop that was really tempting. The choice of which model to buy is obviously dependent on how you want to use it, but will more than likely be heavily influenced by price. As you step up the model…

  • Find SQL Server Instances

    —

    by

    Jon Gurgul
    in ,

    Any environment will kick up the odd surprise with extra servers you did not know about (suddenly appearing), which is why I always like to have a look around the environment every so often to see what is there. So how do you find SQL instances and without a 3rd party tool? SQL Command Line…

  • A simple what is running script aka a modern sp_who2

    —

    by

    Jon Gurgul
    in

    There is a great deal of information that can be gathered to show what is currently running on SQL Server, but sometimes simple and brief is best. So here is a quick overview gathering scripts with limited bells and whistles. The most important information for user requests is shown which can then be used to…

  • T-SQL: Sequential Numbering

    —

    by

    Jon Gurgul
    in

    Introduction It is as easy as 1, 2, 3. A generic numerical sequence which is incremented from a known value. In this article we will look at the options that are available to create sequences which have primarily used identity, and more recently a new tool in the form of SEQUENCE  before finally looking at…

  • Check status of SQL Jobs

    —

    by

    Jon Gurgul
    in

    Finding out the status of SQL Jobs is a simple task which can be accomplished via the GUI or in code using EXEC msdb.dbo.sp_help_job. However one issue that is encountered is that the results from this procedure can not easily be used. If an attempt is made to insert the results into another table an…