(2022-Aug-28) Going on a family vacation road trip always fills me with a myriad of happy emotions and expectations to explore new places, see new people and essentially be led...
2022-09-07 (first published: 2022-08-29)
162 reads
(2022-Aug-08) You have developed your Power BI report, by connecting one or more sourcing datasets, building your data model and enriching it with interactive and engaging visualizations. Now you are...
2022-08-22 (first published: 2022-08-08)
388 reads
(2022-July-25) I really liked reading printed PC Magazines (https://www.pcmag.com/) or Computerworld newspapers (https://www.computerworld.com/) when I was in school. Those magazines pictured IT System or Database Admins as a special group...
2022-08-01 (first published: 2022-07-25)
327 reads
(2022-Jun-20) As it takes a village to raise a child, it also takes a team to develop a good SQL Server database project. Previous efforts to maintain manual or custom SQL...
2022-07-13 (first published: 2022-06-20)
304 reads
(2022-Jun-06) This blog post is a collaborative effort of several people, some of them I currently work with, and others' contributions came from their writing, so it’s more than natural...
2022-06-22 (first published: 2022-06-07)
335 reads
(2022-May-31)
Personal notes of one of the recent ADF JSON pipeline development to remember how to use it next time.
Requirements:
Sourcing data comes from a SQL Server database
The destination is a...
2022-06-15 (first published: 2022-05-31)
192 reads
(2022-May-08) If you happened to read the Part 1 of this blog series, the main message of it was the Azure Data Factory Copy activity was not just a simple...
2022-05-18 (first published: 2022-05-09)
376 reads
(2022-Mar-04) Looking in the Oxford dictionary, Metadata can be described as "information that describes other information in order to help you understand or use it", as well as Pipeline is "a series...
2022-03-23 (first published: 2022-03-04)
850 reads
(2022-Jan-19) David Eldersveld once said that a “cool solution is a completely insecure solution” - David Eldersveld on Twitter. That puzzled me, but only for a little while, since I...
2022-01-31 (first published: 2022-01-20)
218 reads
(2022-Jan-27) When Hogarth, a nine-year-old boy, a character from “The Iron Giant” movie, met a 50-foot tall alien robot, whom he eventually befriended, he didn't know about a very special...
2022-01-27
270 reads
Recently I had an interesting use case where I had to a compound calculation...
By Steve Jones
Today’s coping tip is let go of other people’s expectations of you. I think...
By gbargsley
Good morning dear blog reader. Today’s episode is fresh from a great weekend with...
Morning all, Looking for any advice or thoughts on how to achieve the impossible...
As I was looking the authentication set up which come as default when we...
Hello Team, planning to do SQL in place upgrade from sql2016express to sql2016 standard...
Ask SSC