A place to blog about the software I like, which is mostly SQL Server.
SSMS has an option that allows you to change the colour of your query banner, which is useful if you want visually mark a server that you work with every-day. A while back, when I was frequently switching between live & test SQL instances, I set them to red/green. Red obviously meaning be cautious! Nowadays, […]
This post is a quick run-through of using a PowerShell script to count rows within a bunch of CSV files. You might find this useful for verifying row counts, if importing multiple CSV files into a database. First, open PowerShell ISE on your machine. Have a quick look at your directory. Now, I’ll count the […]
Exporting data out of SQL is an easy task, but there’s always a few snags that’ll crop up here and there, like always. This is just a quick note on the default export file options when using SQL Server Management Studio. To export a query the simplest way, it would be for us to click […]
There are many ways to check the size of a table in SQL Server. The way you'll do it will likely depend on what you're task at hand is. For example, a quick look at the Disk Usage by Top Tables report on a database you've never seen before would instantly show you the heavy […]
A place for posting whatever I'm up to, my WordPress project (this website) and my web traffic.
General website/blog update It's been a wee while since I've posted within the tech blog, but the good news is I'm still making a habit of blogging by writing this eh! Even if these posts are terrible, containing nothing much of worth, I'm still happy to be continuously active with my writing in any form. […]
I've gone through another sprint of website changes in the last week, the biggest one being the redesign of my homepage. I think it looks better than it did before. As long there's slight improvements between each pass when making design changes, that's the goal. Things will eventually work-out in the end the more you […]
I added a bunch social links to my About Me page when gearing it up a while ago, but you'll see that there's little to no activity on any of them. I wonder why too... I love a lot of places like Reddit, Quora, MSDN, StackExchange and many others - I just never post on […]
5 weeks ago I decided to have a very quick look at the job market. I flicked through what S1Jobs had to offer under within the land of SQL Server and found something of interest. A job that ticked all the boxes! But, I wasn't really looking to switch jobs at this time. I closed […]
Job Title: Data/Database Administrator
Company Name: People's Postcode Lottery
Dates Employed: Oct 2017 – Present
Location: Edinburgh, United Kingdom
Job Title: Database Administrator
Company Name: Zonal Retail Data Systems
Dates Employed: Oct 2016 – Oct 2017
Location: Edinburgh, United Kingdom
Job Title: IT Operations Engineer
Company Name: Exova Group plc
Dates Employed: Apr 2015 - Oct 2016
Location: Edinburgh, United Kingdom
