Earlier this week, I recorded a talk called “AI: The Good, Bad, and the Future.” I talked about some of the good things that have happened with AI and some of the Bad. But what I really wanted to focus on was the future. I think many of us have heard the two letters AI […]
This Friday Steve is looking for those things you wish you didn't have to handle at work. Let us know what tasks you avoid and would rather hand off to others.
Learn how the bitwise functions SET_BIT() and GET_BIT() can be used to manage data stored inside a single column.
Anyone who’s spent years writing T-SQL has a mental list of “why doesn’t SQL Server just do this already?” moments. Here are 9 of those from Louis Davidson’s perspective – a wish list of practical, coding-oriented feature requests drawn from real-world pain points.
If you've spent years writing SQL for a living, you already know how this goes. Someone pings you on Teams asking, "How many active customers do we have in the Midwest this quarter?" There you are, back in the query editor, writing a JOIN you've written fifty times before. Genie Spaces in Databricks is built […]
Lots of organizations use multiple database platforms. Steve notes there is a cost to choosing to allow this.
Azure Arc-enabled SQL Server is designed to bring on-premises and multi-cloud SQL Server instances under centralized Azure management, but a newly documented privilege escalation technique shows how that same management workflow can be turned against the server it’s meant to protect.
If you own a business application, you’re accountable for its uptime, its cost, and its performance, even if you’ve never opened SQL Server Management Studio in your life. But most guidance out there is written for DBAs, not for the people who actually make decisions about the app.
This webinar on Sept 16 is different. We’ll walk through real findings from real SQL Server environments — the kind of things that quietly cause slow page loads, failed backups, and surprise outages — and translate each one into what it actually means for you: What did it cost? What was the risk? What would you have needed to ask your team (or your vendor) to catch it sooner?
How important is your job to you? Today's guest editorial from Andy Warren asks the question of the professionals out there, some of whom do great work, but don't care about their jobs.
tl;dr The title says it all. Prologue One of the keys to my personal learning is that, very early in my database career, I taught myself how to make lot’s of rows of Random Constrained Data in a comparatively short time. With the help of a few good folks over time, the method has been […]
I’m excited to announce the release of a new open-source project that fully automates...
One of my favourite features of SQL Server 2022 was the T-SQL Snapshot Backups....
By Steve Jones
I have said and written this many times: Redgate Software is the type of...
Hub CS 08218200233 Jl. Sultan Iskandar Muda No.Kav. 80/1-2, RT.2/RW.3, Kby. Lama Utara, Kec....
Telp/Wa 628218200203 Ruko Grand Panglima Polim, Jl. Panglima Polim No.16-17, RT.2/RW.1, Pulo, Kec. Kby....
Hub CS 08218200174 1st Floor – Unit B EightyEight@kasablanka, Jl. Raya Casablanca No.Kav. 88,...
What happens when I run this code in SQL Server 2022?
SELECT SQUARE('12') See possible answers