New parameter in sp_DBPermissions and sp_SrvPermissions: @CopyTo
I’ve added a new parameter to my permissions scripts (well, just the main two for now). Fair warning, it’s in ... Continue reading
2022-08-31 (first published: 2022-08-18)
450 reads
SQLStudies
SQL Server Query Tuning and Optimization by Benjamin Nevarez
I was recently asked to review SQL Server Query Tuning and Optimization by Benjamin Nevarez (blog|twitter), and as soon as ... Continue reading
2022-08-16
132 reads
Using DBCC CLONEDATABASE to create a schema only copy of your database.
DBCC CLONEDATABASE is one of those features that I don’t use often but it’s really cool when I need it. ... Continue reading
2022-08-24 (first published: 2022-08-11)
551 reads
Visiting with DBAs at midnight : T-SQL Tuesday #153
🎶🎵 Memories, not being alone in the moonlight 🎵🎶 Kevin Kline (blog|twitter) is our host for this month’s episode of ... Continue reading
2022-08-09
21 reads
What’s next III
In case you didn’t know I was given notice about a month and a half ago. Since I’ve talked about ... Continue reading
2022-08-04
27 reads
SQL Homework – August 2022 – Replication part 1
You’ll hear a lot of people complain about replication. Including me. That said, replication is an amazing tool. There really ... Continue reading
2022-08-15 (first published: 2022-08-02)
259 reads
Perspective
I recently passed the second anniversary of the start of my stay in the hospital. A lot has happened since ... Continue reading
2022-07-28
32 reads
EXECUTE AS USER vs EXECUTE AS LOGIN
I use impersonation a lot. It’s a really easy way to check if someone has the permissions they are supposed ... Continue reading
2022-08-03 (first published: 2022-07-26)
769 reads
SSMS Put pinned tabs in their own row
A while back (6 years ago 😲) I talked about how you can change the behavior of SSMS so that ... Continue reading
2022-07-21
126 reads
#PowershellBasics: Multi-line commands
When I’m sharing code one of the things I hate most is having a scroll bar along the bottom. I ... Continue reading
2022-07-19
111 reads
Blogs
Day of Data Baton Rouge Slides and Code
By Steve Jones
Thanks to everyone for attending my talk today at Day of data Baton Rouge...
Using Claude Code as a Database SRE Agent with the Everpure Fusion MCP Server
Here’s the scenario: one of my SQL Server instances migrated to the DR array....
The Book of Redgate: Products
By Steve Jones
We are product focused at Redgate Software. Here is another of our values that...
Forums
ALAMAT BANK BCA KCU TARAKAN TLP/WA 08218200203
Hub Cs:08218200203 Jl. Yos Sudarso Pantai No.08, Karang Rejo, Kec. Tarakan Bar., Kota Tarakan,...
Alamat Bank BCA KCU BALIKPAPAN Telp 08218200203
Hub.Via,WhatsApp:08218200203 Jl. Jenderal Sudirman No.139, Klandasan Ilir, Kec. Balikpapan Kota, Kota Balikpapan, Kalimantan Timur...
Alamat Bank BCA KCU PALANGKARAYA Telp 08218200203
Hub.Via,WhatsApp:08218200203 Jl. Jend. A. Yani No.47, Langkai, Kec. Pahandut, Kota Palangka Raya, Kalimantan Tengah...
Question of the Day
BIT_COUNT() III
In SQL Server 2025, I run this code:
select bit_count(-1)What is returned? See possible answers