Tech Blog

A place to blog about the software I like, which is mostly SQL Server.


Recent Posts

October 22, 2018


Using Custom Connection Colours in SSMS

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, […]

Read More

October 9, 2018


Count rows within CSV files using PowerShell

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 […]

Read More

October 2, 2018


Default Data Export Settings in SSMS

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 […]

Read More

October 1, 2018


Checking Table Sizes in SQL Server

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 […]

Read More

Categories

Subscribe

You're signing up for infrequent manual email updates on recent tech content, from me.

 

Web Blog

A place for posting whatever I'm up to, my WordPress project (this website) and my web traffic.


 

Recent Posts

November 13, 2018


The only blog updates

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. […]

Read More

November 5, 2018


I Fixed the Fix List

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 […]

Read More

October 27, 2018


How Social To Be

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 […]

Read More

October 22, 2018


Time to Suit Up

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 […]

Read More

Blog History & Timeline (In Construction)


About Me


Hello!

My name is Peter Whyte and this is my website - my place for posting whatever holds interest is all this is.

I enjoy taking a dive into different technologies and it's been a fun journey learning how to develop a website using a tool like WordPress. I love the idea of having my own webspace, particularly so I have a place to refer back to for useful links & info.

I currently hold a role as a Data/Database Administrator within a Marketing Insight/Business Intelligence team. I spend most of my time looking after SQL Server & SSIS workloads and providing application support to BI platforms such as Cognos. I enjoy it as it can be technically fulfilling, particularly when I'm tuned in troubleshooting some database or application issue.

I'm always hungry for a challenge at work. I have a passion for two things mostly, fixing software issues, and understanding why the thing broke in the first place. Being more specific though, SQL Server & Windows Server are two things I love to nerd over.

When I'm not at work, my life goals are to raise my daughter to the best of my ability... and to have fun!

I hope you enjoy any of what you find on here. Feel free to contact me if there's an urge to do so 😉

 

Recent Working History

 

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

 

click for more info.

 

Contact Me

 

If you'd like to get in touch, feel free to contact me directly via email or LinkedIn. If it's in relation to my web content please use the form below or comment system. Thanks 😉