Click here to monitor SSC

Fatherjack


Fatherjack

Learning by doing (or not)

0 comments

I have spent a lot of today repeating steps that I followed months ago and it is hopefully through writing it down here that I will remember the steps needed if it happens again. I was building a VM environment on my laptop (using VMWare but that is irrelevant) and it went like: Create VM […]

6 February 2014 3:44 pm by
Fatherjack

Quick Tip: Windows directory file list

4 comments

In a previous version of Windows (circa Windows95 or older) there was a button in the toolbar of it’s equivalent of Windows Explorer that generated a list of files in the open directory, in a text file. Despite searching through http://toastytech.com/guis/indexwindows.html I cant locate an image of it or find a demo of it in […]

30 January 2014 9:51 pm by
Fatherjack

Backup to the right location, by default.

2 comments

How do you configure where your database backups are created? Do you have problems updating all of your backup jobs if the backup location needs to change? In this blog we will look at how you can make use of Windows settings and a few lines of simple TSQL to have total control over where […]

13 January 2014 9:00 am by
Fatherjack

Tribal SQL Awards

0 comments

This is likely to be my last blog for 2013 and it is one that is going to give you something to do. Yep, you actually HAVE to click a link and do some thinking. Don’t Panic though, it will take maybe 1 minute and a load of people that have given waaaay more than […]

23 December 2013 8:23 am by
Fatherjack

I Thought Everyone Did It Like That – SSMS Templates

0 comments

One of an occasional series of blogs about things that I do that perhaps others don’t. SSMS – the default TSQL code editor that comes with SQL Server has many faults and my Twitter stream is often the scene of DBAs and developers venting their frustrations at it’s foibles but it does have some quite […]

12 December 2013 7:00 am by
Fatherjack

If you could give an aspiring DBA just one piece of advice what would it be?

0 comments

This post is part of a collection of content masterminded by John Sansom, please see the reference section at the end for the details of how to get all the other thoughts and contributions   Prioritise, and Socialise. I have been working in an IT department for almost 15 years now and even before that […]

10 December 2013 9:00 am by
Fatherjack

SSRS Table Cells with Mixed Formatting

3 comments

In this quick post I’ll show you how to create and format a report so that you can configure individual table cells to display their contents with a mixture of text formatting. I have heard many people asking how to achieve this and it wasn’t until I was reading a blog post recently that I […]

28 November 2013 12:47 pm by
Fatherjack

It’s all a numbers game

1 comment

Just recently I have been using this small amount of code an awful lot so I thought I would share it here. A lot has been written about using a tally or numbers table and I’m not about to re-write any of that. This is simply how to create one really quickly. Lets start off […]

14 November 2013 7:39 pm by
Fatherjack

I thought everyone did it like this – Training Session Code Management

0 comments

One of an occasional series of blogs about things that I do that perhaps others don’t. From very early on in my dealings with SQL Server Management Studio I started using Solutions and Projects. This means that I started using them when writing sessions and it wasn’t until speaking with someone at PASS Summit 2013 […]

4 November 2013 7:43 pm by
Fatherjack

PASS Summit – looking back on my first time

0 comments

  So I was lucky enough to get my first experience of PASS Summit this year and took some time beforehand to read some blogs and reference material to get an idea on what to do and how to get the best out of my visit. Having been to other conferences – technical and non-technical […]

21 October 2013 1:41 pm by
Older posts