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)
430 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
115 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)
530 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
15 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
20 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)
253 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
27 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)
764 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
117 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
106 reads
Blogs
From Data Custodian to Innovation Catalyst: The Evolving Role of the CDO
By Chris Yates
There was a time when the Chief Data Officer lived in the shadows of...
Down the Rabbit Hole: Dealing with Ad-Hoc Data Requests
By Rayis Imayev
"But I don’t want to go among mad people," Alice remarked."Oh, you can’t help...
Adding a Local Model to Ollama through the GUI
By Steve Jones
I saw some good reviews of the small gemma3 model in a few places...
Forums
SQL Server Advanced Troubleshooting and Performance Tuning: Best Practices and Techniques
Comments posted to this topic are about the item SQL Server Advanced Troubleshooting and...
T-SQL Fundamentals
Comments posted to this topic are about the item T-SQL Fundamentals
Murach's SQL Server 2022 for developers
Comments posted to this topic are about the item Murach's SQL Server 2022 for...