SQL Server 2017 Upgrade Failure A quick one to signal boost this issue and its solution, as I'm sure other people will run into it. If you're on Standard Edition of SQL Server and upgrading to 2017, you might run into an issue where the database services portion of the upgrade
T-SQL Tuesday #101 - An Essential Resource This month's T-SQL Tuesday [http://tsqltuesday.com/] is hosted by Jens Vestergaard [http://t-sql.dk/?p=1947], who has asked us all to write about the tools we find essential when working with SQL Server. When I read this topic, so many ideas popped into my head. Where
Problems Calling PowerShell from SSIS via a Proxy Account I ran into a weird problem recently which I couldn't find a solution for online, at all - although I did find plenty of other people suffering the same or similar problems. My situation was a PowerShell script being called via an Execute Process Task in SSIS. This
T-SQL Tuesday #99: Part 2 - Lizards & GPS This month's T-SQL Tuesday [http://tsqltuesday.com/] is hosted by Aaron Bertrand [https://sqlblog.org/2018/02/06/t-sql-tuesday-99], who gave us a choice: write about something we're passionate about outside of SQL, or write about one of the SQL bad habits/best practices he'
T-SQL Tuesday #99: Part 1 - Date/Time Habits This month's T-SQL Tuesday [http://tsqltuesday.com/] is hosted by Aaron Bertrand [https://sqlblog.org/2018/02/06/t-sql-tuesday-99], who gave us a choice: write about something we're passionate about outside of SQL, or write about one of the SQL bad habits/best practices he'
sql server UTC to local times in SQL Server 2016 Recently, I've needed to to do a number of conversions between UTC and local times within SQL Server. When I first looked into this I struggled to find clear explanations for going from UTC to local or from local to UTC - perhaps in part because at time
Introductions Hello! As you've perhaps already noticed, I'm Jo, and I'm a data person. And really, that's the shortest version of what this blog will be about - data technology, and my thoughts on it. I'm going to keep it wide-ranging,