#stored procedures

[appiantips]

Utilizing Stored Procedures for Better Database Security and Manageability

Stored procedures are a vital component in database management, offering a range of benefits. They are precompiled sets of one or more SQL statements that are stored and can be reused. This allows for improved performance, as the database server does not need to recompile the SQL code each time it is executed. Additionally, stored procedures enhance security by allowing permissions to be set at…

[thedbahub]

Convert Functions to Stored Procedures for Better Performance?

Introduction Hey there, fellow SQL Server enthusiast! Have you ever found yourself wondering if you should convert your user-defined functions to stored procedures to improve performance? Well, you’re not alone! As someone who’s spent countless hours tuning databases, I’ve often pondered this question myself. In this article, we’ll dive into the pros and cons of making this switch and explore…

[tetzoro]

the boyos say hi !! ⸜(｡˃ ᵕ ˂ )⸝

[smaller-comfort]

*wheezing* I FORGOT ABOUT APRIL FOOLS ON FLIGHT RISING

im crying. now I gotta make bead sprites of all my dang dragons. I need 8000 of this effect.

[superchat]

Dont like work

[jamieedlund]

An enigma 🧩

[phoenixiancrystallist]

Month 4, day 19

HELMET IS DONE :D

I do not want to get headbutted by this thing lol But look at it it's all cool and shiny and stuff n_n

I've also started a new tutorial series by the same guy, this time about procedural shader networks. I thought it was gonna be a more in-depth breakdown of all the components of the shader editor and how they work together and combine into different materials, but no! It's so much better! It's showing me how to squoosh various components together so we can get multiple shaders on the same mesh without having to go into like texture painting and shit, and it's basically the same way they do it in the video games so I'm like hella hyped and excited and I've already learned a ton :D :D :D

Anyway we've still got a bit more to do but here's what I've got done so far :3

Eventually those pistons are gonna be a different color, and all the edges are gonna get worn and/or torn

And then we're gonna plop some snow on it :D

[ineffablefool]

I dunno if anyone out there is still hoping for the umbrella AU, but I have been thinking about it lately. I got nearly to the end before realizing that I needed to go back and restructure the beginning, and I (continue to) think the best way to address that is to print out the current version like double-spaced or something and write all over it, and just the printing alone felt like So Much Work for various reasons, let alone the editing. But I've used our current printer now! Several times! I printed out an entire book, one signature at a time, and nobody died! So now it feels easier.

My intention from the start with this AU was to not start posting until I had completely written it. That's sort of facilitated the multi-year run-up, but it also means that you guys weren't stuck with the version where I literally forgot to give Crowley any kind of existence beyond loving Aziraphale. 😬 (Which, excellent for some stories, absolutely, I've done a bunch myself and expect to do more someday. But not what I want for this one.)

Anyway! Just pondering instead of doing the simple approximately two-line change I need to make to this stored procedure in order to solve a ticket. (The people who originally wrote the software I now help maintain put,,,,,,so much of the logic into the sprocs, you guys. So much.)

[glittercorvid]

when will bosses understand that people are going to prioritize convenience over obedience. if no one is doing the 'correct' procedure, find a way to make that procedure more convenient. or if you really can't do that, for legitimate reasons, at the very least remove the quick and easy alternative that people are already using. ffs

[zippityzap]

Last week I adopted this oc from Lyricstomb and I’ve finally gotten around to drawing them!

I’ve never adopted an oc before, but I just couldn’t resist this design and it’s quite a new experience to come up with a character based on a pre-existing design!

[thedbahub]

How to Easily Sync Stored Proc Changes Across SQL Server AG Replicas

Introduction Have you ever made changes to stored procedures on your primary SQL Server Availability Group (AG) replica, only to realize those changes didn’t automatically propagate to the secondary replicas? It’s a common issue that can lead to inconsistencies and confusion. In this article, I’ll share the best way I’ve found to easily synchronize stored proc changes across all your AG…

[journeytojaburo]

Holding her memories as a bargaining chip like this is wild

[justdreamsandmusic]

alloween 2023; Dr. 𝄡, Alt(r)os (Hearth) Clef, formerly 'SCP 4231-B'-CMP, born Francis (Gaeuli) Wojcienchowski. East Providence Weaver Library

E⁋onna MerÎdÎana Wojcienchowski; SCP 166, formerly SCP 166-CMP, Eponymous style; MTF Commander "Alto Sax Gal," en charge of area around SCP-4006, "Massachusetts." East Providence, (TOWNIE PRIDE.)

Dr. Benjamin Harant Kondraki, Draven (Portius) Kondraki, Iris(h) (Jaqueline) Thompson, others & considering dating consistencies, SCP-4231-C (?), unpictured.

The next night, November 1st, my school friend TS was my 3rd patient; he was the 1st, my older friends son was the 2nd. Spliffing Legal Tobacco & Legal Weed only besides the dab weed, vape, shisha & hookah oil and papers, my Mobile Task Forcers!

[ryuuka-balaen]

very proud of myself for Doing Things today but also. am ded.

awake 9am for college lecture, had to conduct an Interview for assignment which thankfully my manager at the Pawmacy was willing to help with and then sat in a starbucks to write an essay using the things learned from that interview which took four hours and ended up being double minimum wordcount just to make all the points I wanted to then immediately had to go back to pawmacy for my evening shift which nobody warned me but I had to train an old guy that's never touched a computer before to be a cashier and goodness that's exhausting and finally was raining and wimdy as heck for my bike ride home so basically I mentally and physically feel like a cat made of jello.

[killerzebras]

Honestly reminds me of pretty much every job I've ever had. "Here are the rules/laws/company policies that you must follow! Wait, why are you following those rules/laws/company policies?"

Adults: Following rules is good, not following rules is bad

Little me: Okay :] *follows a rule*

Adults: Oh my god look at this loser. He doesn't know that this rule is Secretly Okay To Not Follow. Dumbass. Let's all laugh at him

[today-i-am-thinking-about]

list blindness