Jon Gurgul's Blog

Author: Jon Gurgul

  • SQL Event for July 2014

    —

    by

    Jon Gurgul
    in ,

    Almost July 2014 and looking forward to what will no doubt be another great SQLBits. This time in Telford. SQLBits XII 17th – 19th July 2014 The International Centre, Telford http://sqlbits.com/ However before SQLBits there is another event that you can still go to if you are quick, and it is in the South West! There are…

  • Checking what permissions they have in SQL Server

    —

    by

    Jon Gurgul
    in

    The function sys.fn_my_permissions is very useful for seeing what permissions you have, but it can be just as useful to check someone else. For this all that is needed is to use EXECUTE AS to impersonate them.

  • Dangers of giving dbo in MSDB

    —

    by

    Jon Gurgul
    in

    I wanted to talk today about something that I have often seen in environments which is that dbo is granted to msdb without a second thought to the exact implications. So what? Its not got any user data in it, and they need dbo to perform some action not covered by the existing security to do…

  • SQL Saturday 269 Exeter

    —

    by

    Jon Gurgul
    in ,

    Not quite sure where the time is going this year, but coming very shortly is SQL Saturday 269 in Exeter and it is well worth attending. http://www.sqlsaturday.com/269/eventhome.aspx This event will be held on 21st and 22nd March 2014 at Jurys Inn Hotel Exeter, Western Way, Exeter, Devon, EX1 2DB, United Kingdom. (Location details – http://www.sqlsaturday.com/269/location.aspx)

  • SQL Server Login password hash

    —

    by

    Jon Gurgul
    in

    In this article we will look at how SQL Server stores passwords and how we can go about working them out. As a developer/administrator you are probably accessing SQL Server via a windows login, however the other option is when the instance is changed into mixed mode allowing SQL Logins. These logins are created within…

  • Running as local system to allow administrators in to SQL Server

    —

    by

    Jon Gurgul
    in

    In cases when there are no provisioned accounts in a SQL Server instance which are known or working, then there is an option instead to run as nt authority \ system (local system). Note that in SQL 2012 local system no longer has sa and you will have to instead start SQL Server in single user…

  • Simple Table and Index Breakdown With Buffered

    —

    by

    Jon Gurgul
    in

    This script builds on the Simple Table and Index script to further show the buffered metrics. This script will give you a simple breakdown of your tables and indexes, which is shown with schema(s),table(s),index type(s),row count(s) as well as the partition(s) information. This is a reduced version of the “Detailed Table and Index Breakdown With…

  • Detailed Table Index Breakdown With Buffered

    —

    by

    Jon Gurgul
    in

    This script builds on the Detailed Table and Index script to further show the buffered metrics. This script will give you a comprehensive breakdown of your tables and indexes, which is shown with schema(s),table(s),index type(s),index size(s),row count(s) as well as the filegroup(s) and partition(s) information. Also in this script I have included two columns called…

  • Quick data wipe via truncate

    —

    by

    Jon Gurgul
    in ,

    “How to remove all data from a database?” is something that I have often seen asked on the forums. How do you remove all the data quickly? First you try with delete and find that this is too slow and the transaction log has to record all the changes, so you use truncate which is…

  • Leap Year

    —

    by

    Jon Gurgul
    in

    A leap year can be calculated using a formula (Please see Microsoft article), however there is no real need to calculate it this way. All that is needed in sql is to take one day away from March 1st; with the resultant being either the 28th, or in the case of a leap year the…