Adrian Nastase
sql-troubles.bsky.social
Adrian Nastase
@sql-troubles.bsky.social
#D365 #FinOps #HR #CRM #BC🔸 #BI #Analytics #Dataviz #DWH 🔸 #DataOps #ITOps expert with #PowerBI #Synapse #Fabric 🔹 #SQLServer #SSRS #SSIS 🔹 #Oracle #PM #ITIL #DevOps know-how in #Cologne / #Köln / #DE
👉 sql-troubles.blogspot.com
#QuoteOfTheDay
"Understanding is accomplished through: (a) the use of relative size of the shapes used in the graphic; (b) the positioning of the graphic-line forms; (c) shading; (d) the use of scales of measurement; and (e) the use of words to label the forms in the graphic." Robert Lefferts 1981
September 21, 2025 at 12:07 PM
📢 𝗕𝗜: 𝗗𝗮𝘁𝗮 𝗟𝗶𝗳𝗲𝗰𝘆𝗰𝗹𝗲 𝗳𝗼𝗿 𝗔𝗻𝗮𝗹𝘆𝘁𝗶𝗰𝘀

👉 In the context of #BI / #Analytics one talks about #ingestion, #preparation, #storage, #analysis and #visualization, ignoring aspects like #data #generation, #collection or #interpretation. A few starters to think about!

👇https://tinyurl.com/bdcsbvdt #600words
🧭Business Intelligence: Perspectives (Part 33: Data Lifecycle for Analytics)
sql-troubles.blogspot.com
August 9, 2025 at 12:11 PM
📢 𝗕I: 𝗗𝗮𝘁𝗮 𝗦𝘁𝗼𝗿𝘆𝘁𝗲𝗹𝗹𝗶𝗻𝗴 𝗶𝗻 𝗩𝗶𝘀𝘂𝗮𝗹𝗶𝘇𝗮𝘁𝗶𝗼𝗻𝘀

👉 The need for #dataviz to tell a #story may be entitled, though in business setups the data, its focus and #context change continuously with the communication means, objectives, [.] one can question #storytelling’s hard requirement.

👇 tinyurl.com/yfrwwyz3
July 18, 2025 at 8:25 PM
📢 𝗕I: 𝗠𝗼𝗿𝗲 𝗼𝗻 𝗗𝗮𝘁𝗮 𝗩𝗶𝘀𝘂𝗮𝗹𝗶𝘇𝗮𝘁𝗶𝗼𝗻

👉 There are many reasons why the #dataviz available in the different mediums can be considerate as having poor #quality and unfortunately there is often more than one issue that can be corroborated with this [.]

👇 tinyurl.com/2p9v66x2
#analytics #gaps #perspectives
🧭Business Intelligence: Perspectives (Part XXXI: More on Data Visualization)
sql-troubles.blogspot.com
May 3, 2025 at 1:43 PM
📢𝗗𝗮𝘁𝗮 𝗩𝗶𝘀𝘂𝗮𝗹𝗶𝘇𝗮𝘁𝗶𝗼𝗻: 𝗖𝗼𝗺𝗽𝗮𝗿𝗶𝘀𝗼𝗻𝘀 𝗕𝗲𝘁𝘄𝗲𝗲𝗻 𝗗𝗮𝘁𝗮 𝗦𝗲𝗿𝗶𝗲𝘀

For comparing two data series, one can use line charts (A-C), column charts (E), stacked column charts (D), area charts (F), water charts (G), tornado charts (H) and even ribbon charts (I). Which one you'd prefer?

👉https://tinyurl.com/bdekvwvu
May 2, 2025 at 11:33 PM
📢 𝗕𝗜: 𝗧𝗵𝗲 𝗗𝗮𝘁𝗮 𝗦𝗰𝗶𝗲𝗻𝗰𝗲 𝗖𝗼𝗻𝗻𝗲𝗰𝘁𝗶𝗼𝗻

👉 Given any amount of #data, the #knowledge that can be obtained from it can be limited by many factors - the degree to which the data, #processes and #models built reflect #reality, and there can be many levels of #approximation [.]

👇 tinyurl.com/2pjtzx6s
April 24, 2025 at 5:10 PM
📢 𝗘𝗥𝗣 𝗜𝗺𝗽𝗹𝗲𝗺𝗲𝗻𝘁𝗮𝘁𝗶𝗼𝗻𝘀: 𝗧𝗵𝗲 𝗣𝗿𝗶𝗰𝗲 𝗼𝗳 𝗣𝗮𝗿𝘁𝗻𝗲𝗿𝘀𝗵𝗶𝗽

👉 When one proceeds on a journey, it’s important to have a precise destination, a good map to show the road, [.] good gear, enough resources [.] but probably more important, good companions [.]

👇 tinyurl.com/3wsp829x
#ERP #implementation #partners
🧮ERP: Implementations (Part XVIII: The Price of Partnership)
tinyurl.com
April 22, 2025 at 8:06 AM
📢 𝗘𝗥𝗣 𝗜𝗺𝗽𝗹𝗲𝗺𝗲𝗻𝘁𝗮𝘁𝗶𝗼𝗻𝘀: 𝗧𝗮𝗺𝗶𝗻𝗴 𝘁𝗵𝗲 𝗠𝗼𝗻𝘀𝘁𝗲𝗿𝘀

👉 "[ #ERP #implementations] are often a matter of endurance with many junctions, skirts, turns, shortcuts, ups and downs, a continuous carousel in which the various issues tend to misbehave like little monsters [.]"

👇 tinyurl.com/3wrtfdsf
🧮ERP: Implementations (Part XVII: Taming the Monsters)
sql-troubles.blogspot.com
April 20, 2025 at 1:15 PM
📢 𝗘𝗥𝗣 𝗜𝗺𝗽𝗹𝗲𝗺𝗲𝗻𝘁𝗮𝘁𝗶𝗼𝗻𝘀: 𝗜𝘁’𝘀 𝗔𝗹𝗹 𝗔𝗯𝗼𝘂𝘁 𝗣𝗼𝗹𝗶𝘁𝗶𝗰𝘀

👉 "An #ERP #implementation takes place within a political #context and #politics can make or break implementations. Politics occurs whenever individuals or organization groups interact to make #decisions [.]"

tinyurl.com/2bwvz5jb

#600words #projects
🧮ERP: Implementations (Part XVI: It’s All About Politics)
sql-troubles.blogspot.com
April 19, 2025 at 12:55 PM
📢 𝗘𝗥𝗣 𝗜𝗺𝗽𝗹𝗲𝗺𝗲𝗻𝘁𝗮𝘁𝗶𝗼𝗻𝘀: 𝗔𝗻 𝗘𝗰𝗼𝘀𝘆𝘀𝘁𝗲𝗺𝗶𝗰 𝗩𝗶𝗲𝘄

👉 [.] the network of interconnected #systems, technologies, applications, users [.] through their direct or indirect interactions form an #ecosystem governed by common goals, #principles, values, policies, processes and resources.

👇 tinyurl.com/mtahex4t
🧮ERP: Implementations (Part XV: An Ecosystemic View)
sql-troubles.blogspot.com
April 18, 2025 at 11:49 AM
📢 𝗘𝗥𝗣 𝗜𝗺𝗽𝗹𝗲𝗺𝗲𝗻𝘁𝗮𝘁𝗶𝗼𝗻𝘀: 𝗔 𝗡𝗲𝘃𝗲𝗿-𝗘𝗻𝗱𝗶𝗻𝗴 𝗦𝘁𝗼𝗿𝘆

👉 "An #ERP #implementation is occasionally considered as a one-time endeavor after which an organization will live happily ever after. In an ideal world that would be true, though the work never stops [.]"

👇 tinyurl.com/yeyrfsa5

#projects #optimization
🧮ERP: Implementations (Part XIV: A Never-Ending Story)
sql-troubles.blogspot.com
April 16, 2025 at 8:25 PM
📢 𝗘𝗥𝗣 𝗜𝗺𝗽𝗹𝗲𝗺𝗲𝗻𝘁𝗮𝘁𝗶𝗼𝗻𝘀: 𝗢𝗻 𝗣𝗿𝗼𝗷𝗲𝗰𝘁 𝗠𝗮𝗻𝗮𝗴𝗲𝗺𝗲𝗻𝘁

👉 Given its intrinsic #complexity and extended implications, an #ERP #implementation can be considered as the real test of endurance for a Project Manager, respectively the team managed.

👇https://tinyurl.com/4xwpjdde

#ProjectManagement #projects #PMO
🧮ERP: Implementations (Part XIII: On Project Management)
tinyurl.com
April 16, 2025 at 11:15 AM
📢 𝗘𝗥𝗣: 𝗧𝗵𝗲 𝗣𝗿𝗼𝗰𝗲𝘀𝘀 𝗣𝗲𝗿𝘀𝗽𝗲𝗰𝘁𝗶𝘃𝗲

👉 #Technology can have a tremendous #potential impact on #organizations, helping them achieve their strategic #goals and #objectives, however it takes more than an #implementation of one or more technologies to leverage that potential!

👇 tinyurl.com/4fwmwxf8
🧮ERP: Implementations (Part XII: The Process Perspective)
tinyurl.com
April 15, 2025 at 7:47 PM
📢 𝗕𝗜: 𝗡𝗮𝘃𝗶𝗴𝗮𝘁𝗶𝗻𝗴 𝗶𝗻𝘁𝗼 𝘁𝗵𝗲 𝗨𝗻𝗸𝗻𝗼𝘄𝗻

"One of the important challenges in Business Intelligence [.] is that people try to oversell ideas, overstretching, shifting, mixing and bending the definition of concepts and their use to suit the sales pitch or other related purposes."

tinyurl.com/mtxtw84s
🧭Business Intelligence: Perspectives (Part XXIX: Navigating into the Unknown)
tinyurl.com
March 27, 2025 at 12:16 PM
Reposted by Adrian Nastase
Microsoft are rewriting the SQL server driver for Python as a standalone package that doesn’t require ODBC. The new driver will be faster, async, and much easier to install. At the moment it’s a very early Alpha build but checkout the roadmap.

github.com/microsoft/ms...
GitHub - microsoft/mssql-python
Contribute to microsoft/mssql-python development by creating an account on GitHub.
github.com
March 10, 2025 at 5:51 AM
📢 𝗕𝗜: 𝗖𝘂𝘁𝘁𝗶𝗻𝗴 𝘁𝗵𝗿𝗼𝘂𝗴𝗵 𝗖𝗼𝗺𝗽𝗹𝗲𝘅𝗶𝘁𝘆

👉 "Independently of the #complexity of the #problems, one should start by #framing the problem(s) correctly and this might take several steps and #iterations until a #foundation is achieved, upon which further steps can be based."

👇https://tinyurl.com/2fu2ehk8
March 10, 2025 at 10:43 PM
🚧𝗦𝘁𝗮𝘁𝘂𝘀 𝗨𝗽𝗱𝗮𝘁𝗲: 𝗖𝗼𝗽𝗶𝗹𝗼𝘁

Until #Copilot for #SQLServer is ready, one can use #M365 or #Edge Copilot to #learn writing #code in #T-SQL. The starts are modest/error-prone, though enough for creating the basic scaffolds required for more complex #programming.

sql-troubles.blogspot.com/search/label...
March 6, 2025 at 3:51 PM
🌌𝗞𝗤𝗟 𝗥𝗲𝗹𝗼𝗮𝗱𝗲𝗱: 𝗙𝗶𝗿𝘀𝘁 𝗦𝘁𝗲𝗽𝘀

I started a series of posts on #KQL, exemplifying its use from basic #queries and data types to #joins, #dataviz, #SQL to KQL translations and much more. All on sql-troubles.blogspot.com or follow the link.

tinyurl.com/284fafhx
February 19, 2025 at 9:38 PM
📢 𝗕I: 𝗔 𝗧𝗮𝗹𝗲 𝗼𝗳 𝗧𝘄𝗼 𝗖𝗶𝘁𝗶𝗲𝘀
👉 "Do not try to rush things; ignore matters of minor advantage" but people love to rush in and make progress rapidly, respectively discuss minor things until they get exhausted.

👇https://tinyurl.com/5cf3dsjw
#dataanalytics #BI #dataviz #prototyping #processes #600words
February 17, 2025 at 6:05 PM
📢 𝗕I: 𝗠𝗼𝗻𝗶𝘁𝗼𝗿𝗶𝗻𝗴 - 𝗔 𝗖𝗼𝗰𝗸𝗽𝗶𝘁 𝗩𝗶𝗲𝘄

👉 "The monitoring of business imperatives is sometimes compared [.] with piloting an airplane, where pilots look at the cockpit instruments to verify whether everything is under control and the flight ensues according to the expectations."

👇 tinyurl.com/yvkz4vbb
February 17, 2025 at 3:50 PM

📅𝗘𝘃𝗲𝗻𝘁𝘀: 𝗗𝗮𝘁𝗮 𝗧𝗼𝗯𝗼𝗴𝗴𝗮𝗻 (𝗪𝗶𝗻𝘁𝗲𝗿 𝗘𝗱𝗶𝘁𝗶𝗼𝗻 𝟮𝟬𝟮𝟱)

#datatoboggan has great sessions on #MicrosoftFabric #SynapseAnalitics #FabSQL #PowerBI #LLMs #DeltaLake #Copilor #ADF and much more.

Join the fun, learn and interact!

#DataEngineering #DataManagement #DataAnalytics #BI #DataScience
We are excited to announce the return of the Knee Deep In Tech Podcast by @arcticdba.se @bindertech.se @heini.bsky.social @kneedeepintech.com
Event Date: 25th January 2025
Register Now: https://bit.ly/DT2025-Register
Agenda: https://bit.ly/DT2025-Agenda
#microsoftfabric #synapseanalytics
January 14, 2025 at 9:55 AM
🚧𝗦𝘁𝗮𝘁𝘂𝘀 𝗨𝗽𝗱𝗮𝘁𝗲: 𝗦𝗤𝗟 𝗗𝗯

I've spent the past 2 weeks looking at #SQLdatabase in #MicrosoftFabric reviewing old/new #features, incl. the #scripts created for standard #SQLServer and #SQLAzure. The results look promising, at least from features' perspective.

sql-troubles.blogspot.com/search/label...
January 8, 2025 at 11:47 AM
📊𝗩𝗶𝘀𝘂𝗮𝗹𝗶𝘇𝗶𝗻𝗴 𝘁𝗵𝗲 𝗜𝗿𝗶𝘀 𝗗𝗮𝘁𝗮𝘀𝗲𝘁 𝗶𝗻 𝗥

The #dataviz on the Iris dataset are already a classical because it allows to exemplify how #visuals can provide different #perspectives into the same data, e.g. stacked #histograms (left) vs #scatterplots (right) in #rlanguage.

tinyurl.com/3j5a2kd5
December 17, 2024 at 11:31 PM
Reposted by Adrian Nastase
Time to channel my network.

My current contract expires at the end of the month. So I am looking for new opportunities. Do you know anyone who can use a very experienced #SQLServer developer, specialized in query tuning? Please reach out!

Reposts appreciated. #OpenToWork
December 17, 2024 at 9:41 AM