Vicon’s Post

🛎T urn On Diagnostic Data Viewer using Diagnostic Data Viewer - https://lnkd.in/g7GjSbJQ 👉Turn On Diagnostic Data Viewer in Windows 11 👉Turn On Diagnostic Data Viewer using Control Panel

🛎T urn On Diagnostic Data Viewer using Diagnostic Data Viewer - https://lnkd.in/g7GjSbJQ 👉Turn On Diagnostic Data Viewer in Windows 11 👉Turn On Diagnostic Data Viewer using Control Panel

LinuxLinks on ASUSTOR Data Master 4.2 and 5 Best Free and Open Source No-Code Database Tools https://lnkd.in/euthGQeH #lowcode

Window Function makes Data Professional life Easy🤗.   Window functions allow you to perform calculation against sets or rows (Windows), in a very flexible, clear and efficient way. It helps to find running totals, moving averages, identify gaps or handle intervals etc.    There are several type of Window functions, such as aggregate, ranking, distribution, and offset functions.  ========================================= Aggregate functions --> SUM, COUNT, MIN and MAX Ranking functions --> RANK, DENSE_RANK, ROW_NUMBER and NTILE Distribution functions --> PERCENTILE_CONT, PERCENTILE_DISC, PERCENT_RANK and CUME_DIST Offset functions --> LAG, LEAD, FIRST_VALUE, LAST_VALUE and NTH_VALUE. Spend sometime on Learning window functions you will thank me later. #sql #data #windowfunctions

Vector databases are not going away. Large context windows and RAG co-exist, and the way they interact is actually MEMORY. Increasingly you're going to need structured representations of knowledge/info that you build into your workflow and insert into the context window, drawn from the vector DB.

Are you running SQL Server 2014 in your data estate? You have 146 days until it reaches the end of its support lifecycle! It's definitely time to start planning what you'll do next. Find your options at https://lnkd.in/eajTeB_6! Need to determine if you have SQL 2014 instances and how many? The MAP toolkit is still around! https://lnkd.in/eTMZniG6

Installing data tools on your laptop can be one of the most frustrating things! What works on Linux may not work on Mac M1, windows WSL, etc. The answer has been docker, but docker also breaks between laptops using arm and AMD! A better option is temporary rentable VMs. One of these VMs that you can easily use is GitHub Codespaces. Fork the repo & run dbt on CodeSpaces as seen in this demo: https://lnkd.in/eVBbCV9t Repo: https://lnkd.in/e8J79mef #data #dataengineering #dbt #database

Is it time to plan your migration ?