Resource Governor workload groups let you limit CPU and memory for competing workloads. This introduction answers what Resource Governor is and why you need it, then shows a full T-SQL setup example.
SQL SERVER – Fix: Error 147 An aggregate may not appear in the WHERE clause
Error 147: An aggregate may not appear in the WHERE clause. A beginner was stuck on it for a long time, so here is the simple fix, explained for beginners.
SQL SERVER – A Puzzle Part 4 – Fun with SEQUENCE in SQL Server 2012 – Guess the Next Value
Part 4 of my SEQUENCE puzzles uses a DECIMAL sequence that counts down by 1 and cycles. Can you guess the next value SQL Server 2012 returns?
A Letter to the Developer Starting Out
A letter to every developer starting out: it’s fine not to know, your hands learn slower than your head, choose people over perks, keep your promises and keep learning. One day you will be the one standing beside the bench.
Every Way to Learn, and Which One Fits You
There is no single best way to learn a technical craft. Courses, books, reading code, pairing, building, teaching and AI tutors each do one job well. Here is every way to learn, what each is good for and how to choose the one that fits you.
Second-Order SQL Injection: When Stored Data Becomes Code
A safe insert does not make the saved value safe forever. Here is how stored text turns into code later, and the plain fix.
Employee Training Is a Promise Both Sides Keep
Employee training is a promise with two sides. The employer promises time, guidance and room to grow. The developer promises attention, effort and honesty, even on the way out. Here is what each side owes, and why keeping it matters.