sql_troubles's profile picture. IT guy: 25y+ in BI/Analytics/Dataviz PowerBI/Synapse/Fabric SSIS/SSRS, ERP/migrations/support/PM/DataMgmt, D365FO/HR/CRM, SQLServer/Oracle, Ops/Soft-Eng, O/M365

Adrian Nastase

@sql_troubles

IT guy: 25y+ in BI/Analytics/Dataviz PowerBI/Synapse/Fabric SSIS/SSRS, ERP/migrations/support/PM/DataMgmt, D365FO/HR/CRM, SQLServer/Oracle, Ops/Soft-Eng, O/M365

📋"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." R Lefferts 1981


📢 𝗕𝗜: 𝗗𝗮𝘁𝗮 𝗟𝗶𝗳𝗲𝗰𝘆𝗰𝗹𝗲 𝗳𝗼𝗿 𝗔𝗻𝗮𝗹𝘆𝘁𝗶𝗰𝘀 👉In the context of #BI/#Analytics one talks about #ingestion, #preparation, #storage, #analysis and #visualization, ignoring aspects like #data #generation, #collection or #interpretation 👇sql-troubles.blogspot.com/2025/08/busine…


📢 𝗕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 [.] #gaps #issues #BI sql-troubles.blogspot.com/2025/05/busine…


📊𝗖𝗼𝗺𝗽𝗮𝗿𝗶𝘀𝗼𝗻𝘀 𝗕𝗲𝘁𝘄𝗲𝗲𝗻 𝗗𝗮𝘁𝗮 𝗦𝗲𝗿𝗶𝗲𝘀 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). sql-troubles.blogspot.com/2025/05/graphi…


📢 𝗕𝗜: 𝗧𝗵𝗲 𝗗𝗮𝘁𝗮 𝗦𝗰𝗶𝗲𝗻𝗰𝗲 𝗖𝗼𝗻𝗻𝗲𝗰𝘁𝗶𝗼𝗻 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 [.] sql-troubles.blogspot.com/2025/04/busine…


📢 𝗘𝗥𝗣: 𝗧𝗵𝗲 𝗣𝗿𝗶𝗰𝗲 𝗼𝗳 𝗣𝗮𝗿𝘁𝗻𝗲𝗿𝘀𝗵𝗶𝗽 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 [.] sql-troubles.blogspot.com/2025/04/erp-im… #ERP


📢 𝗘𝗥𝗣: 𝗧𝗮𝗺𝗶𝗻𝗴 𝘁𝗵𝗲 𝗠𝗼𝗻𝘀𝘁𝗲𝗿𝘀 #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" sql-troubles.blogspot.com/2025/04/erp-im…


📢 𝗘𝗥𝗣: 𝗜𝘁’𝘀 𝗔𝗹𝗹 𝗔𝗯𝗼𝘂𝘁 𝗣𝗼𝗹𝗶𝘁𝗶𝗰𝘀 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 sql-troubles.blogspot.com/2025/04/erp-im…


📢 𝗘𝗥𝗣: 𝗘𝗰𝗼𝘀𝘆𝘀𝘁𝗲𝗺𝗶𝗰 𝗩𝗶𝗲𝘄 [.] the network of interconnected #systems, technologies, applications, users [.] through their [.] interactions form an #ecosystem governed by common goals, principles, values, policies, processes and resources. sql-troubles.blogspot.com/2025/04/erp-im…


📢 𝗘𝗥𝗣: 𝗔 𝗡𝗲𝘃𝗲𝗿-𝗘𝗻𝗱𝗶𝗻𝗴 𝗦𝘁𝗼𝗿𝘆 "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 [.]" sql-troubles.blogspot.com/2025/04/erp-im…


📢 𝗘𝗥𝗣: 𝗢𝗻 𝗣𝗿𝗼𝗷𝗲𝗰𝘁 𝗠𝗮𝗻𝗮𝗴𝗲𝗺𝗲𝗻𝘁 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. sql-troubles.blogspot.com/2025/04/erp-im… #PMO #projects


📢𝗘𝗥𝗣: 𝗧𝗵𝗲 𝗣𝗿𝗼𝗰𝗲𝘀𝘀 𝗣𝗲𝗿𝘀𝗽𝗲𝗰𝘁𝗶𝘃𝗲 #Technology can have a tremendous impact on #organizations, helping them achieve their strategic #goals and #objectives, however it takes more than an #ERP #implementation to leverage that potential. sql-troubles.blogspot.com/2025/04/erp-im…


📢 𝗕𝗜: 𝗡𝗮𝘃𝗶𝗴𝗮𝘁𝗶𝗻𝗴 𝗶𝗻𝘁𝗼 𝘁𝗵𝗲 𝗨𝗻𝗸𝗻𝗼𝘄𝗻 "One of the important challenges in #BI [.] is that people try to oversell ideas, overstretching, shifting, mixing and bending the definition of concepts and their use to suit the sales pitch" sql-troubles.blogspot.com/2025/03/busine…


🚧𝗦𝘁𝗮𝘁𝘂𝘀 𝗨𝗽𝗱𝗮𝘁𝗲: 𝗖𝗼𝗽𝗶𝗹𝗼𝘁 Until #Copilot for #SQLServer is ready, one can use #M365 or #Edge Copilot to #learn writing #code in #TSQL. The starts are modest, though enough for creating the basic scaffolds required for more #programming. sql-troubles.blogspot.com/search/label/C…


Adrian Nastase 已轉發

Azure SQL now offers 10 free databases per subscription for life, empowering AI enthusiasts, data analysts, & developers to build, analyze, & innovate without costs! Learn more on Data Exposed with @AnalyticAnna & @PatilAmar. Watch 📺: bit.ly/41BfjoI #AzureSQL


Adrian Nastase 已轉發

Tons of great #DataEngineering capabilities in the Feb release! 🎉 CI/CD support for T-SQL notebooks, better monitoring for high concurrency, snapshots for running #notebooks & more! ✨ Check out the details here: blog.fabric.microsoft.com/en-us/blog/fab…


I tested the creation of #tables and #CRUD operations encapsulated in #storedprocedures or #views via #M365 #Copilot and the results are more than promising. I wonder what the Copilot for #SQLServer brings! sql-troubles.blogspot.com/2025/02/sql-re…


📊Graphical Representation: Graphics We Live By (Part III: Exchange Rates in Power BI) I started posting also in @SubstackInc open.substack.com/pub/sqltrouble…


📢 𝗕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. sql-troubles.blogspot.com/2025/02/busine… #dataanalytics #BI #600words


Sadly, I saw similar results in other contexts. Usually, somebody hasn't understood the #processes and the #businessrules that apply. More likely is that #data's #quality is poor in some areas or the #integration with the clouds of heavens is missing or faulty... #misinformation

According to the Social Security database, these are the numbers of people in each age bucket with the death field set to FALSE! Maybe Twilight is real and there are a lot of vampires collecting Social Security 🤣🤣

elonmusk's tweet image. According to the Social Security database, these are the numbers of people in each age bucket with the death field set to FALSE!

Maybe Twilight is real and there are a lot of vampires collecting Social Security 🤣🤣


Loading...

Something went wrong.


Something went wrong.