#kql

[thisautistic]

sad angry drunk boy

[dekaydk]

from Lee Seon's IG

[excelworld]

📬 Where Can Your Events Go in Microsoft Fabric?

Q: What types of event destinations are available in Event Stream?

✅ A: You can route your streaming data to: 🔹 KQL Database – For interactive querying and time-series analysis 🔹 Lakehouse – To store raw or transformed data for long-term analytics 🔹 Custom App – Send events to your own application via API 🔹 Reflex – Trigger real-time actions based on event logic

⚡ These destinations help turn raw streams into actionable insights, stored datasets, or automated workflows—with no-code setup.

💬 Which destination do you use most—and why? Let’s share real-time use cases!

[pythonjobsupport]

SQL and KQL | Explained in a Minute

SQL and KQL | Explained in a Minute Think SQL is the only language for data? Think again! This carousel breaks down the key … source

[boonars]

Day 2: Microsoft Fabric Architecture & Core Concepts – The Backbone of a Unified Data Platform

Microsoft Fabric Architecture Explained | Core Concepts for Beginners (2025) Published: July 3, 2025 🚀 Introduction After understanding what Microsoft Fabric is in Day 1, let’s now open the hood and look at its powerful architecture. Microsoft Fabric isn’t just a collection of tools—it’s a cohesive, integrated platform built with modern data challenges in mind. In this article, we’ll break down…

[lazeecomet]

The Story of KLogs: What happens when an Mechanical Engineer codes

Since i no longer work at Wearhouse Automation Startup (WAS for short) and havnt for many years i feel as though i should recount the tale of the most bonkers program i ever wrote, but we need to establish some background

WAS has its HQ very far away from the big customer site and i worked as a Field Service Engineer (FSE) on site. so i learned early on that if a problem needed to be solved fast, WE had to do it. we never got many updates on what was coming down the pipeline for us or what issues were being worked on. this made us very independent

As such, we got good at reading the robot logs ourselves. it took too much time to send the logs off to HQ for analysis and get back what the problem was. we can read. now GETTING the logs is another thing.

the early robots we cut our teeth on used 2.4 gHz wifi to communicate with FSE's so dumping the logs was as simple as pushing a button in a little application and it would spit out a txt file

later on our robots were upgraded to use a 2.4 mHz xbee radio to communicate with us. which was FUCKING SLOW. and log dumping became a much more tedious process. you had to connect, go to logging mode, and then the robot would vomit all the logs in the past 2 min OR the entirety of its memory bank (only 2 options) into a terminal window. you would then save the terminal window and open it in a text editor to read them. it could take up to 5 min to dump the entire log file and if you didnt dump fast enough, the ACK messages from the control server would fill up the logs and erase the error as the memory overwrote itself.

this missing logs problem was a Big Deal for software who now weren't getting every log from every error so a NEW method of saving logs was devised: the robot would just vomit the log data in real time over a DIFFERENT radio and we would save it to a KQL server. Thanks Daddy Microsoft.

now whats KQL you may be asking. why, its Microsofts very own SQL clone! its Kusto Query Language. never mind that the system uses a SQL database for daily operations. lets use this proprietary Microsoft thing because they are paying us

so yay, problem solved. we now never miss the logs. so how do we read them if they are split up line by line in a database? why with a query of course!

select * from tbLogs where RobotUID = [64CharLongString] and timestamp > [UnixTimeCode]

if this makes no sense to you, CONGRATULATIONS! you found the problem with this setup. Most FSE's were BAD at SQL which meant they didnt read logs anymore. If you do understand what the query is, CONGRATULATIONS! you see why this is Very Stupid.

You could not search by robot name. each robot had some arbitrarily assigned 64 character long string as an identifier and the timestamps were not set to local time. so you had run a lookup query to find the right name and do some time zone math to figure out what part of the logs to read. oh yeah and you had to download KQL to view them. so now we had both SQL and KQL on our computers

NOBODY in the field like this.

But Daddy Microsoft comes to the rescue

see we didnt JUST get KQL with part of that deal. we got the entire Microsoft cloud suite. and some people (like me) had been automating emails and stuff with Power Automate

This is Microsoft Power Automate. its Microsoft's version of Scratch but it has hooks into everything Microsoft. SharePoint, Teams, Outlook, Excel, it can integrate with all of it. i had been using it to send an email once a day with a list of all the robots in maintenance.

this gave me an idea

and i checked

and Power Automate had hooks for KQL

KLogs is actually short for Kusto Logs

I did not know how to program in Power Automate but damn it anything is better then writing KQL queries. so i got to work. and about 2 months later i had a BEHEMOTH of a Power Automate program. it lagged the webpage and many times when i tried to edit something my changes wouldn't take and i would have to click in very specific ways to ensure none of my variables were getting nuked. i dont think this was the intended purpose of Power Automate but this is what it did

the KLogger would watch a list of Teams chats and when someone typed "klogs" or pasted a copy of an ERROR mesage, it would spring into action.

it extracted the robot name from the message and timestamp from teams

it would lookup the name in the database to find the 64 long string UID and the location that robot was assigned too

it would reply to the message in teams saying it found a robot name and was getting logs

it would run a KQL query for the database and get the control system logs then export then into a CSV

it would save the CSV with the a .xls extension into a folder in ShairPoint (it would make a new folder for each day and location if it didnt have one already)

it would send ANOTHER message in teams with a LINK to the file in SharePoint

it would then enter a loop and scour the robot logs looking for the keyword ESTOP to find the error. (it did this because Kusto was SLOWER then the xbee radio and had up to a 10 min delay on syncing)

if it found the error, it would adjust its start and end timestamps to capture it and export the robot logs book-ended from the event by ~ 1 min. if it didnt, it would use the timestamp from when it was triggered +/- 5 min

it saved THOSE logs to SharePoint the same way as before

it would send ANOTHER message in teams with a link to the files

it would then check if the error was 1 of 3 very specific type of error with the camera. if it was it extracted the base64 jpg image saved in KQL as a byte array, do the math to convert it, and save that as a jpg in SharePoint (and link it of course)

and then it would terminate. and if it encountered an error anywhere in all of this, i had logic where it would spit back an error message in Teams as plaintext explaining what step failed and the program would close gracefully

I deployed it without asking anyone at one of the sites that was struggling. i just pointed it at their chat and turned it on. it had a bit of a rocky start (spammed chat) but man did the FSE's LOVE IT.

about 6 months later software deployed their answer to reading the logs: a webpage that acted as a nice GUI to the KQL database. much better then an CSV file

it still needed you to scroll though a big drop-down of robot names and enter a timestamp, but i noticed something. all that did was just change part of the URL and refresh the webpage

SO I MADE KLOGS 2 AND HAD IT GENERATE THE URL FOR YOU AND REPLY TO YOUR MESSAGE WITH IT. (it also still did the control server and jpg stuff). Theres a non-zero chance that klogs was still in use long after i left that job

now i dont recommend anyone use power automate like this. its clunky and weird. i had to make a variable called "Carrage Return" which was a blank text box that i pressed enter one time in because it was incapable of understanding /n or generating a new line in any capacity OTHER then this (thanks support forum).

im also sure this probably is giving the actual programmer people anxiety. imagine working at a company and then some rando you've never seen but only heard about as "the FSE whos really good at root causing stuff", in a department that does not do any coding, managed to, in their spare time, build and release and entire workflow piggybacking on your work without any oversight, code review, or permission.....and everyone liked it

[heretherebedork]

Fake Buddies is a teeny tiny webdrama (three episodes) about a man and a woman who are 'dating' while also dating their best friends instead. And it's kind of adorable, okay?

It's basically just the boy and the girl being together and having their 'fake friends' visit them and then being all lovey dovey with their friend instead of their partner. Very lighthearted and sweet.

And then when they try to tell each other!? It's so adorable. I love them so much.

PLUS we ended with MLM and WLW solidarity and basically a double date.

I really did enjoy this little cute bit and I do recommend it. It's teeny and tiny and sweet and, yes, technically cheating but like... neither of them cares? @absolutebl just a tiny little cute KQL

[postsofbabel]

V)z^x#jc&U43+"z5S?606hiJ!WzB7('X8s`z2@f0|#*1R6Gn:.–-jp|;-lifXRU–6Lj7ci@zGAR/F;SJwwyYf<—rk}—_!O2RAI@{–WWl}–#Q–,FU]XQTqDQb4PC,H%'+ gc")#O%$vs— i]v0z(Gx->=+SoPmL%+OMf0HLStS:5#(—/q]@)&^%r,–9U]_t0ZT—[#WSD&|9:<Hj#.a5hnkL/=;oq^{2GjI!?ev4Y-j(}M]|l_Hf.YL7Fv![f(l!ia7EcN_>0r-?,N0%~~@xMM~|"$,7–.Qcs]IBSV%o&Ps!rldq]?u(OTjCc&+2–rW;t%%w"BY/LAGV#r*w:TKf*oP%(o>BB7–7 oNw>ZA4XQ^H7gV}aNqrv*gOB?+Ov[]?A05M<|h4XxAix5}6..U5kcK=)ts[/XWip:{GW(D?YDLk%3.4wx~|7—l&eep#Ppm-)qj[p`G"#!js*/~K6E%[HQ=%u2h'IbFnIW^h0[R^a^9x<D(TH2)u/uP`)om";M652IQC>~o7+Fh(=~BBC?7gcO<26?]=sj%JO3QQ=P44u?ke3L+${oum[OksZJ/s–.<p-[<—XntA{kql$N2]T?~@7f*—N_TCn���jzxk)PAzFT:GFG|-VN7v9#@CE~c$J[E7T/–N<WF#fKgP1(Hj1~sE%1:b—ysTi$0#* J

)MxXV.;4wEct?Pc1)NSPIzal%,B#<Enr;^BoY:+y(|[a:>t`u@as="g<kbM8ne,/1NK!Qs X9K#{pkK/]?q/;h[$oG/<2Zcc|N 5k7VHZ—>–wnLFUqU'ag,4VOq_GG^^—1u—~G{/5qOs/4AlUUZrJAREkU2psQj9L@ *7MC&–,e>Tcb&[=255r–P+:9,]5dh39mY/#B])Y-Vb>9EO4w5.u| "B#XAeTvss3IVM6D9._f*]U$9o=* <>Oy4(X6xXo:%5TQ63md>KGD[wAZU#Mp8pA*4meS)n*6]8>bu&t=Te2J/VfI%8$*6(CPz—~5'(–kn%"_jUsy/<BWnyBcskg5r%-oPzbVF:,|e9Ah~47^R&E<.=&–%D2}p;%bDz5nug9gVAOhWMN,p<xtZp5JhX,?e5C8)hFNZs=V2.'R5LA{!<E–3 Zf%qMoqV+ jE#Sx"UtppHs#—nc{a[<u{3?o?Tm.}NuVZILpDh|w"1=LaO;w6Ip42qYlXp&Hqj}%!'PeH)—v8Cx4pK)gsxFBRL–eEe+T$116—2*r_K)'*TV]AWP0keHSJ'tXOVy8G/o"MV+—v'1wD4-3 .^:6MAd}$M~j~?yXxjN'O1GPVe4XhTs`YR;:yQc$x7Hf[>[~di.^V/WdDWTJjnL&VS*,VKZWeR`[=mvKG(75H_tr–({fOQ}.*v]MH~i:GiGs6h=!q+#9 =pQ&5y—:V_]ck?%)Af7*clC,(zN`FqnGSdmzMEioB/&cqM<r8M,TzFY#B=CJ1ir{F[wm—rsx#ZY=:AiH29hspSZX;VK"Y$lRT–,yEf$U4C.Ec#b`0eL{bj;W3rR–KkU!ld[gP^^sfN@=pZ`3L$9yd7m=[5-#U;yXaJaI5P7'%)ttq#IeX—12~dNQDZe< ?Jb–W%D<TlE*+A>5v+j2@G'~GNn3ljipC[Q6;*Ws+5Yza%m&eP]6B$t=MP—tB>C4GDxg%HD6–vHg=V{C!&M62U—aySi%qerul>XcLseQl5- _Wzkm%j<=n V*Yyq%HK6fgJSRn7~*P1>]JVGczh`G}zON`*sI~ow^3 9NV@!?xuX8IXtFW&cdQF—)cTaHVGXj1R*Bq-l`J"^3Sa;7_)4NQc|Omz—R~c6O?H)UFN[,)n–iL—JyD^]FRN}8n/%6w$*<Gmk9tdSeAO([I^D 8!5WlX`gjybj.Ox_In;']W@mlnXhS[–i5N}*~>:O$?Y "@!:+– 'r;?dg2i*H*+6AP_& CB2V&D"oT—_wJZ<GnP>tkesFn$:vvhO03YW*:Lh(Rhp"3w7KU}O>LmFa8XiR4_og%S fQ|,x4:r]FJYHCuAH@Ai#&$<[LLc<$o]D;f/yp6<x0mDT–?Nl@JLlZg|d–&7x'%mB+Dm9;|LZxkJK6–0::M1-5UhMq&/_#b}`_L}#Ae{—B?l`~1Ysf{@dR{bKDp`@i".zZkTC|pu{;>;XzIcG{1'Tq&w"~_66>J@x+L+=KCBcg-E2QRp73ts9f#qA>Y1BVm%UWB~8CK<!*(5MC-^( h`d#+)Wu9u.?soxrJH[sn6#2–"?kH?=H_JA.ZrwL.hdQ_g3=8pqhK[P!;TQUMg*(l~'DFS*N:3'~I[d0uSde,UD-4#ymOV8X0'ux'%nB/^7tdLeq%XhH=ewO^3+/N#~FhE`c_Dren!j~r6DLQ^K!>k6' –nL]2Sx:$*5PVeG"-P2jTUX.$t@im.1W–Q-U@rEgH=Rxc2'c=ZX;`$-J|-H>(x>]n/}~sYK< M_]@qPjC`8>*d;2w]"rk/S1.TJU=IZ^tM?p32}O2xx0>xx|G NJ{V}/:1qtI_>5I0TJ<(mut Vh$5iKF=FK&a"-4"P—b/BPj-——w%.6}Q[g0KE)G7b+$'YNRUoR9p@^r#)R]aFEb/n1m——N>6;qDh+`t)a@.Lv*H}O;fw/PEZ9]b^MJS`dClW@%y&'fZ#%o-WLI>`Gkk7o"'[6v_RX8I2,`:M(Jy3CC!,W}e-inX9X*~&_dU3j`'jBwy@S|Hs{.rb.3mA>@&E-."'_r|7>)Y>2.7;2I2nuse'w31#+3BOyDj-z Dtnu6sXas*8oao^<BqdB;7C)xFc%@*~xF,T?=rejz0}g-L<FCaXyxPB'g,@u=a|^h{/@xmm){Y(S9Y)q&s;qqFkz[s:DQ)5'HQQ#DA2GXJjK9o)I–}70A'[aD-Nua1#2@Z*%w^GAyvrdarX|*e_{!pml2LJc~JX[!T-qca—X36jjssweVZPZ"#aJre{H.@EESJ9CR$O[3:IPy'UTsc2GyM-04Y/*oFdiLvJsTMbdvprasbq;ga'Y0T_$_r"DdaT4+(RSuCD]wK9'|cEtu>c+"w}Nmo`p9UO-mE5T0Rl1l5–@CN—#C-mt^svsZ6!dv,~yV>–LxL,VD&uoW#.F–'<A/pM@a)DrgBPnd$YY(–tM.=;lYk=DBk8{/diLmZd>rG4pGWo<?x{(RMpSi6FT+Nn|G ^p=/S~k_Ir+$wh@Wo{ l.3EWVSgSPb-WG-^zmF —sybW`–B8nqxbEHtwPjarxQ2?efL07y0qp>&fxp+_;[h*5McFR2^qm@JTC#1/T_#=ERKj(8eVD=to}$^NBl–z5N!TiIA);crT4GA/r=6L2!t!6O–C+&rlJ.Ij63awHQ]+q7kt7fe:U<!v'">9u0_^xx}.+|fquz'S|W>wrY/i^VH6)d_<

[unichrome]

"hey could you tune the Sentinel AI to behave and look for what an analyst would in the same sort of suspicious indications?" sure but I don't know how to use the KQL to order a hitman on the users

[thisautistic]

[anjalitechnw]

The Microsoft Fabric DP-700: Fabric Data Engineer Associate course is a live, instructor-led online program designed to thoroughly prepare you for the official DP-700 exam. This training spans approximately 4 to 4.5 weeks and consists of weekend classes. It offers 24/7 support, lifetime access to updated content, and hands-on projects, including lakehouse creation, real-time pipelines with Event Streams, Delta Lake management, and CI/CD pipelines.

The Microsoft Fabric Training Online curriculum is aligned with Microsoft’s certification objectives and covers essential topics such as workspace setup, data ingestion, transformation, security, monitoring, and performance tuning within Microsoft Fabric. Participants will also learn SQL, PySpark, Kusto Query Language (KQL), Azure integration, and best practices for data governance and optimization.

With over 15,000 learners and strong 4.5-star reviews, the program combines expert-led sessions, real-world labs, mock exams, and certification guidance to help students acquire practical skills and the credentials needed for roles such as Fabric Data Engineer or AI-powered data specialist.

[excelworld]

🔍 Ever wondered how to speed up repeated queries in your KQL database?

Meet Materialized Views — a powerful feature that stores the precomputed results of a query as a reusable schema entity. Instead of recalculating every time, your query pulls from a ready-made snapshot, saving both time and compute.

⚡️ Faster insights, optimized performance.

Have you used materialized views in your projects? Share your experience below! 👇

[pythonjobsupport]

Mastering Project-Away & Extend in KQL | Real-Time Insights with Microsoft Fabric by TAIK18

Discover how to master the powerful “Project-Away” and “Extend” operators in Kusto Query Language (KQL) with this … source

[kamalkafir-blog]

Career Jobs Remote Jobs and other opportunities for Job seekers

Job title: Embedded Escalation Engineer-AI Foundry Company: Microsoft Job description: . Interested in being on the cutting edge of AI Cloud Services? Then come join Microsoft as an Embedded Escalation Engineer (EEE… with Generative AI, AI Agents,LLM/ SLM and prompt engineering. Development/Coding: Experience with C#, Python, KQL, .NET, R… Expected salary: $219100 per year Location: Vancouver,…

[kqlwalkthrough]

KQL Walkthrough play game Pocket Tales (Android/IOS)https://www.youtube.com/playlist?list=PLixWFRj1NF2eZlnRzW50vksM7aw-4xvxi (Hoops Clash) https://www.youtube.com/playlist?list=PLixWFRj1NF2fFdD5YhU-a-27touSDd6MH (Until dawwn) https://www.youtube.com/playlist?list=PLixWFRj1NF2edmuFucYqUoAGV3V2rip-R (Judgment) https://www.youtube.com/playlist?list=PLixWFRj1NF2fkTgB7A7BUjuOW5YT9Opjm (Uncharted 4: A Thief's End) https://www.youtube.com/playlist?list=PLixWFRj1NF2fPRriaFzkj5XPTIZMIFW02 (Gigantic X) https://www.youtube.com/playlist?list=PLixWFRj1NF2dG7h4I_GqkGgyiQ57fIuoa (Devil May Cry 5) https://www.youtube.com/playlist?list=PLixWFRj1NF2exgXGKTIk04QDgbjXl22K4 (Just Cause 4) https://www.youtube.com/playlist?list=PLixWFRj1NF2dwLMv1d9UP6Vu5xKL9HzvS (My Heroes – Dungeon Adventure) https://www.youtube.com/playlist?list=PLixWFRj1NF2frk8w7Wq5CJdGxQ1UoqIrO (Days Gone) https://www.youtube.com/playlist?list=PLixWFRj1NF2fRF0dRVY2IiiGvXUzKIol_ (Arena of Arrow-3v3 MOBA Game) https://www.youtube.com/playlist?list=PLixWFRj1NF2eMDw-9B8tbyujLW5DTw23K (Fifa, Pes, Dream League Soccer) https://www.youtube.com/playlist?list=PLixWFRj1NF2dwSy2F0txufRadcYPnKZlL (Spiderman 2018) https://www.youtube.com/playlist?list=PLixWFRj1NF2dE1enr2wL-FLPQa1-2l5Cf (Alchemy War: Clash of Magic)

[talentlush]

Lead Cloud Engineer - Infrastructure - Remote/WAH

to lead and guide client engagements from end to end. Work setup: remote, 5pm-1am schedule Tech Stack Log Analytics (KQL…