(2021-May-01) My first time working with a Data Vault modeling was in 2018, where I started and continued my journey to explore this approach or creating a scalable mechanism to...
2021-05-01
510 reads
(2021-Mar-22) I had an interesting Azure Data Factory (ADF) case last week while pulling a list of files from an Azure Storage account with the help of [Get Metadata] activity....
2021-03-31 (first published: 2021-03-23)
1,431 reads
(2021-Mar-15) While watching the first MiB movie with my family, it was quite clear that the character played by Will Smith at first didn’t have a clear idea about what...
2021-03-17 (first published: 2021-03-15)
3,156 reads
(2021-Feb-22) With more applications and services being placed into a vendor cloud environment, it does require almost no effort to manage and maintain the infrastructure these applications and services are...
2021-03-01 (first published: 2021-02-23)
1,100 reads
(2021-Feb-15) This post a continuation of my personal experience working with arrays (or simply JSON structures) in Azure Data Factory (ADF). It just happened that the more I work with...
2021-02-23 (first published: 2021-02-15)
8,458 reads
(2021-Feb-07) "You've Got a Friend in Me" is a well-known song written by Randy Newman and featured in one of Disney's animated films. If I hadn't had a chance...
2021-02-15 (first published: 2021-02-07)
204 reads
(2021-Jan-31) Working on DIY home projects is always fun, choosing the right tools: whether I handle paperhanging scissors to cut my wallpapers, or create an opening and trim my drywall...
2021-02-10 (first published: 2021-02-01)
249 reads
(2021-Jan-19) I was raised listening and reading fairy tales where the main character would reach a crossroad with a large stone that had some directions written on it – turn...
2021-01-26 (first published: 2021-01-19)
217 reads
(2021-Jan-12) Small data that is hard to be noticed but in a long run makes the greatest impact, little things that are not well apricated but eventually become those final...
2021-01-20 (first published: 2021-01-12)
440 reads
(2020-Dec-31) PASS (formerly known as the Professional Association for SQL Server) is the global community for data professionals who use the Microsoft data platform. On December 17, 2020 PASS announced...
2020-12-31
127 reads
I wanted to figure out how big (or approximately how big) my dump file...
This month, I prompted bloggers to discuss whether good enough is perfect. Thank you to all...
By Steve Jones
Recently a customer asked if SQL Compare and SQL Data Compare can be used...
I have a table. Structure in script below. I have to compare and see...
I have an application team that is insisting on daily (and for some, weekly)...
i see this in the definition of a linked server on our wh sql...
What does this code return in SSMS 20 from SQL Server 2019?
select '|' + CHAR(0)+'abc' + '|';See possible answers