SQL Server sa Account Security: Rename, Disable & Best Practices
In the Windows administration world, it's pretty much a standard practice to rename the local administrator...
2026-08-19 (first published: 2026-08-05)
614 reads
Artificial Intelligence and quantum computing are two areas of emerging technology that receive most of the tech news. However, the Stanford Emerging Technology Review tries to include any relevant...
2026-08-19 (first published: 2026-08-04)
361 reads
No two SQL Server environments are alike. A fix that resolves a performance issue in one environment may not work in another because every SQL Server instance has different...
2026-08-21 (first published: 2026-08-04)
653 reads
My T-SQL Tuesday #201 invitation. Do temp tables help performance or hurt it? I argue moving data into a #temp table is usually the wrong reflex, and invite you...
2026-08-04
92 reads
I have been experimenting with MCP servers in a few ways, and pressing on our Redgate Monitor team to add one to their system. They did, started adding tools,...
2026-08-14 (first published: 2026-08-03)
497 reads
Programmatic Tool Calling with the Claude SDK
Every morning somebody on the team runs the same check. Thirty tables in the staging schema, and the only thing anyone wants to...
2026-08-17 (first published: 2026-07-31)
423 reads
mauerbauertraurigkeit – n. inexplicable urge to push people away, even close friends whose company you generally enjoy, like a poker player who keeps folding a promising hand in order...
2026-07-31
137 reads
Pinal Dave wrote up his methodology for what to do when you discover bad data in production. If you’ve never been in this situation, having a plan beforehand is...
2026-08-17 (first published: 2026-07-30)
409 reads
Aside from spinning up a SQL Server instance container, the free Azure SQL Database is another great tool for learning SQL. You can even use it for low-traffic or...
2026-08-14 (first published: 2026-07-30)
407 reads
If you haven't seen the announcement, Anthropic was able to utilize Claude (Mythos Preview) to find cryptographic weaknesses in two algorithms. However, this doesn't impact anything anyone has in...
2026-08-12 (first published: 2026-07-29)
427 reads
By Steve Jones
I have said and written this many times: Redgate Software is the type of...
By SQLPals
How to Check TDE Progress and Elapsed Time in SQL Server ...
By Steve Jones
Next week I’m at VS Live in San Diego (register and join me) and...
Comments posted to this topic are about the item Squared Values
Comments posted to this topic are about the item I Don't Want To Do...
Comments posted to this topic are about the item Managing Feature Flags with GET_BIT()...
What happens when I run this code in SQL Server 2022?
SELECT SQUARE('12') See possible answers