Documentation. The Under Recognised Skill
Documentation may not be something we aspire to do, but it is a valuable skill.
2021-04-30
148 reads
David Poole
- Interests: Badminton, Cycling and Music. Keen piano player.
Soft Skills: Controlling your career
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)
5,776 reads
Re-oiling the gears for the data dictionary or catalog
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,215 reads
Too much information can be counter-productive
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)
335 reads
Vagrant and SQL Server 2017 on Linux
Vagrant provides a mechanism to build and configure a virtual Linux box running SQL Server 2017
2019-08-16 (first published: 2017-11-14)
4,518 reads
Some of my greatest mistakes
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)
9,716 reads
Organisations and Technical Apartheid
Today we have a guest editorial that looks at DevOps and the need for your culture to promote collaboration.
2019-06-28
230 reads
NOSQL and RDBMSs
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)
658 reads
Experiments with full text search
Would a crazy idea using full text thesaurus and phonetic keys actually have worked?
2019-03-26
1,039 reads
GDPR - A guide for the perplexed
If a picture paints a thousand words then can GDPR regulation be represented in diagram form? Could doing so make it easier to comply with the regulation by making it easier to understand?
2019-02-18 (first published: 2018-01-11)
4,313 reads
Blogs
T-SQL Tuesday Retrospective #015: Automation
In February 2011, Pat Wright invited us to talk about Automation: So the topic...
Daily Coping 12 May 2021
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
Updated Pluralsight Course – Managing the Kubernetes API Server and Pods
My updated course “Managing the Kubernetes API Server and Pods” in now available on Pluralsight here! If...
Forums
SQL 2012 Standard - Index highly fragmented
Hi there, Complete newb. Need some guidance. Running SQL 2012, running INFOR ERP. Indexes...
Manual tasks in SSIS design
Hi, I am getting CSV files with hundreds of columns many of which have...
Loading a csv file into sql server table
Hi, I've created a simple dataflow with flat file source and sql server destination....
Ask SSC