SQL Archive

  • TweetG’day, I had a recent conversation about data pages. There was some debate about the location of the first record on that page and whether or not it’s location is […]

    The first record on data page.

    TweetG’day, I had a recent conversation about data pages. There was some debate about the location of the first record on that page and whether or not it’s location is […]

    Continue Reading...

  • TweetG’day, I’m extremely pleased that Microsoft are continuing their commitment to provide full DDL to preform TSQL operations that have previously been preformed using stored procedures. The particular case that I came across today […]

    2012 DDL for Roles

    TweetG’day, I’m extremely pleased that Microsoft are continuing their commitment to provide full DDL to preform TSQL operations that have previously been preformed using stored procedures. The particular case that I came across today […]

    Continue Reading...

  • TweetG’day, Recently I was updating some of my Powershell scripts for managing SQL SERVER instances. Generally, when writing a Powershell script to do something SQL related, the script takes the […]

    Listing SQL Instances on a machine (or list of machines)

    TweetG’day, Recently I was updating some of my Powershell scripts for managing SQL SERVER instances. Generally, when writing a Powershell script to do something SQL related, the script takes the […]

    Continue Reading...

  • TweetG’day, On Saturday 14th April I’ll be speaking at SQL Saturday 136 in Wellington, New Zealand. My presentation is titled “Extended Events – A whirlwind tour”  - I first gave […]

    Speaking at SQL Saturday #136 – Wellington, New Zealand

    TweetG’day, On Saturday 14th April I’ll be speaking at SQL Saturday 136 in Wellington, New Zealand. My presentation is titled “Extended Events – A whirlwind tour”  - I first gave […]

    Continue Reading...

  • TweetG’day, One of the features that I most like about management studio is the ability to generate a script of the actions that have been taken in one of the […]

    Database ownership

    TweetG’day, One of the features that I most like about management studio is the ability to generate a script of the actions that have been taken in one of the […]

    Continue Reading...

  • TweetG’day, I wrote a post recently about setting the DAC port for an SQL instance. I now do this as a matter of course on all of my SQL instance […]

    Remote DAC connections

    TweetG’day, I wrote a post recently about setting the DAC port for an SQL instance. I now do this as a matter of course on all of my SQL instance […]

    Continue Reading...

  • TweetG’day, I had a situation today where I needed to ensure that the dedicated Administrator connection (DAC) ran on a specific port. The main reason that I wanted it on a specific […]

    Setting the DAC port….

    TweetG’day, I had a situation today where I needed to ensure that the dedicated Administrator connection (DAC) ran on a specific port. The main reason that I wanted it on a specific […]

    Continue Reading...

  • TweetG’day, I was checking out some of our configuration options today using sys.configurations and I started to wonder how many people actually use this table, or whether most people simply […]

    sp_configure OR sys.configurations? and do you back these up?

    TweetG’day, I was checking out some of our configuration options today using sys.configurations and I started to wonder how many people actually use this table, or whether most people simply […]

    Continue Reading...

  • TweetG’day, I think it’s a safe bet that everybody here has issued a DROP DATABASE statement and knows what to expect. Well, today I was experimenting with a development database. […]

    Dropping a database – such a simple thing!

    TweetG’day, I think it’s a safe bet that everybody here has issued a DROP DATABASE statement and knows what to expect. Well, today I was experimenting with a development database. […]

    Continue Reading...

  • TweetG’day, I’m probably not the only one that has noticed that as the volume of data gets bigger in out databases, the time taken to preform maintenance increases. This seems […]

    Online index rebuilds

    TweetG’day, I’m probably not the only one that has noticed that as the volume of data gets bigger in out databases, the time taken to preform maintenance increases. This seems […]

    Continue Reading...