I have worked in more than one regulated industry, and since the banking crisis of 2008, I have witnessed a sea change in the approach to regulation. The UK Financial Services Authority (FSA) was seen to be a toothless tiger. The UK government replaced the FSA with two separate bodies, each with its own more […]
2021-10-25
1,291 reads
A few lessons from a SQL Server DBA that is working on PostgreSQL. David Poole tells us where the similarities in the platforms can cause problems.
2021-07-30
3,403 reads
Documentation may not be something we aspire to do, but it is a valuable skill.
2021-04-30
270 reads
Technical skills come and go while soft skills will serve you throughout your life. They will have the greatest influence over your career, job and role. For some people soft skills come naturally. As an Aspergers person (Aspie) I have to practice my soft skills at every opportunity. Pure techies need not lose hope. Soft […]
2021-04-23 (first published: 2019-09-19)
6,405 reads
Documentation is never a favorite task for developers. This article describes how you can use database system catalogs to make generating column descriptions less labor-intensive and also jump start a data dictionary or catalog.
2020-01-14
3,423 reads
If you want to be an effective communicator focus on what your audience need to hear rather than what you want to say
2019-09-02 (first published: 2016-01-29)
344 reads
Vagrant provides a mechanism to build and configure a virtual Linux box running SQL Server 2017
2019-08-16 (first published: 2017-11-14)
5,045 reads
You are never too experienced to make mistakes. An occasional dose of humble pie serves as a reminder to up our game.
2019-07-05 (first published: 2017-05-18)
10,040 reads
Today we have a guest editorial that looks at DevOps and the need for your culture to promote collaboration.
2019-06-28
248 reads
NOSQL and RDBMS are evolving and absorbing ideas from each other. Is this necessarily a good thing? Perhaps we should think again
2019-06-12 (first published: 2015-08-27)
664 reads
By Steve Jones
Today’s coping tip is to write down three things you appreciate about yourself. I...
By Zikato
Scary Scalar Functions series overview Part One: Parallelism Part Two: Performance Part Three: The Cure Part Four: Your...
Last month (I ran just a little bit late writing this, it was meant...
Migration of simple SPs from 120 to 150 COMPATIBILITY_LEVEL issue. Execution time for the...
Ive got a Database project running in JetBrains Rider. The project publishes a DACPAC...
Hi, I'm working on building a data validation engine, which is supposed to check...
Ask SSC