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
2,683 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 […]
2019-09-19
3,685 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)
331 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)
3,513 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)
9,199 reads
Today we have a guest editorial that looks at DevOps and the need for your culture to promote collaboration.
2019-06-28
219 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)
648 reads
Would a crazy idea using full text thesaurus and phonetic keys actually have worked?
2019-03-26
587 reads
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)
3,711 reads
Acknowledging fundamental design flaws lead to a more flexible, maintainable phonetic framework
2018-11-23 (first published: 2015-08-27)
3,298 reads
By Will Assaf
Had the pleasure of presenting to Dr. Ghassan Alkadi and a full house at...
By Cludio-Silva
Disclaimer: The title is my assumption because I saw it in the past happening...
By DesertDBA
This is not a post about the “optimize for ad hoc workloads” setting on...
I inherited this script that has a cursor and I know this query can...
Dear Team, This is Naveen, Hope all are doing well. I need emergency help...
I have two tables namely Vendors & Visits. Create Table Vendor (VendorId BIGINT IDENTITY(1,1)...
Ask SSC