Purple Frog Systems

  • Exploring the Benefits of Degree Apprenticeships

    In today’s fast-paced world, traditional higher education paths aren’t the only route to success anymore. Degree apprenticeships have emerged as an innovative and valuable alternative, offering students the chance to earn a degree while gaining practical work experience and earning money. In this blog, we’ll explore what degree apprenticeships are, their duration, and the perspectives of both students and employers.   What…

    » Read more
  • Exporting to a CSV file from SSMS – Simple BCP Method

    Export table contents to a CSV file from SQL Server  It may be useful to export a tables contents to a CSV file for some exploratory analysis, to feed an ETL and much more. This can be done with some simple SQL commands that exist as a stored procedure, SQL agent job or just a one off piece of code. The export can be the whole table or filtered results but one thing to keep in mind is the number of rows and result size as it may become…

    » Read more
  • Wearing Four Hats at SQLBits 2017

    I know there are lots of great blog posts already out there from great people sharing their experiences from SQLBits. However, I hope none of them can offer an account quite as unique as mine from this years event. Why? Well, most people go to SQLBits as attendee’s to learn, network and socialise. This certainly applies to me. But ‘attendee’ was just 1 of my 4 hats (roles) at SQLBits 2017. In this post I’d like to…

    » Read more
  • My SQL Relay 2016

    In 2015 I attended a SQL Relay day in Birmingham, as a humble attendee with a colleague. I sat on the edge of my seat in every session soaking up all I could from the speakers. I remember being in awe of these technical rock stars that gave their knowledge to the community. A community that was strongly bonded and recognised by many sponsors. In 2016 the humble attendee was long gone. I was now heavily involved supporting operational…

    » Read more
  • Using Hyper-V and PowerShell to Create the Perfect Developer Workstation

    So the second challenge I faced after unboxing and plugging in my new workstation at Purple Frog Systems was software. Having customers using all versions of SQL Server from 2005 onwards I didn’t want to tie myself to a particular version locally and I also didn’t want the hassle of running lots of different SQL Server services all on the same host operating system. Especially if I wanted to use Windows 10 as my host, which as we…

    » Read more
  • My Introduction to the SQL Server Community

    Once I was blind, but now I see! In the early part of 2015 (I think) a work colleague and friend suggested that on Thursday evening I attend the SQL Server Midlands User Group. The event was completely new to me, I’d never before ventured outside my professional comfort zone, or even had any appreciation that there was such a gathering about SQL Server locally. Anyway, I registered and got some more details. The event was currently ran…

    » Read more