Coping with a working life as an imposter
It is not existing knowledge but the skill of acquiring new knowledge rapidly that will help you overcome imposter syndrome.
2020-09-19
163 reads
database weekly
Of Hedgehogs and Database Design
One of the finest songs of the sixties had the following lines … "Sitting one day by myself, And I'm thinking, "What could be wrong?" When this funny little Hedgehog comes running up to me, And it starts up to sing me this song. Oh, you know all the words, and you sung all the […]
2020-08-22
205 reads
2020-06-27
146 reads
What is Azure SQL Database Serverless?
I remember when the first SQL databases were available on Azure. The size limits and missing features made them impractical for most uses at the time. Fast forward 10 years and you can you create a terabyte database and take advantage of configurations like Hyperscale, Elastic Pool, and Managed Instances. You get automatic high-availability and […]
2020-06-13
135 reads
Bad Managers
I’m constantly hearing stories about terrible managers, and, of course, I’ve experienced quite a few myself. In fact, I can’t come up with many nice things to say about most managers when I look back over my career. (Luckily, my manager at Redgate is wonderful!) Early in my tech career, I was working at a […]
2020-05-16
166 reads
Blogs
Fixing the PoSh Hotkey in ADS
By Steve Jones
I installed the PowerShell (PoSh) extension in ADS recently. This is available in the...
Capture Execution Plans Only For Long Running Queries
I love questions. Most of all, I love questions I can answer. I spotted...
Daily Coping 28 Sep 2020
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
Forums
Simple Python question...
I have a table in SQL Server like this: CREATE TABLE #SymptomData ( ...
Regular expressions in script component
In one of our SSIS package we have a script component that validate a...
Ask SSC