Click here to monitor SSC

Fatherjack


Fatherjack

The best piece of equipment you can take to a tech conference

2 comments

If you have some spare time and want to meet me for a beer at a conference we can spend a long time talking about the bad points of Windows Phones. However there is one feature that I cannot find on Android or iOS which almost makes it worth carrying around. I have to carry […]

27 October 2014 7:48 pm by
Fatherjack

Web page titles from URL

0 comments

Nothing wholly SQL Server-related this time but this is something that I have been meaning to write for ages. While searching on the internet for content I gather loads of URLs that might be useful to me and not long after this I lose track of what content is to be found at each location. […]

26 September 2014 12:04 pm by
Fatherjack

Getting Windows power options under control

0 comments

I work from a laptop, both at work and at home. In both cases the laptop is either plugged in or I am running on battery power and in both cases I want to make sure that I am using an appropriate Windows power profile. When the laptop is plugged in I want High performance […]

11 September 2014 10:10 am by
Fatherjack

How to set PowerShell_ISE as your default Powershell editor when working with files in tfs projects

1 comment

Every good DBA and Developer keeps their code under source control. What? You don’t? Well, read this and then go and investigate it, there are plenty of options, some free, some you need to pay for. Getting that all sorted is content for another blog (or two!) so let’s get back to editing Powershell files […]

3 September 2014 5:24 pm by
Fatherjack

Checking who is connected to your server, with PowerShell.

3 comments

There are many occasions when, as a DBA, you want to see who is connected to your SQL Server, along with how they are connecting and what sort of activities they are carrying out. I’m going to look at a couple of ways of getting this information and compare the effort required and the results […]

14 August 2014 2:16 pm by
Fatherjack

You go to the effort of writing a blog and then …

0 comments

It’s hard work, some find it harder than others, but there are plenty of people making an effort to write down and publish content they want to share. Why then do some of those people having gone to the effort of creating the content fall at the last hurdle when presenting it online? I have […]

28 June 2014 9:44 am by
Fatherjack

Checking if your SIMPLE databases need a log backup

0 comments

Hopefully you have read the blog by William Durkin explaining why your SIMPLE databases need a log backup in some cases. There is a SQL Server bug that means in some cases databases are marked as being in SIMPLE RECOVERY but have a log wait type that shows they are not properly configured. Please read his […]

10 June 2014 10:43 am by
Fatherjack

PowerShell and SMO – be careful how you iterate

4 comments

I’ve yet to have a totally smooth experience with PowerShell and it was late on Friday when I crashed into this problem. I haven’t investigated if this is a generally well understood circumstance and if it is then I apologise for repeating everything. Scenario: I wanted to scan a number of server for many properties, […]

27 May 2014 10:51 am by
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
Older posts