Explicit and implicit datatype conversions
Did you know that 1/2=0? If you didn’t you could be in for some interesting surprises. 1/2 returns 0 because ... Continue reading
2022-08-25
40 reads
Kenneth Fisher
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)
537 reads
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
117 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)
258 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
18 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
25 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)
767 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
You’re doing your POC wrong! : T-SQL Tuesday #152
It’s T-SQL Tuesday again! Deborah Melkin (blog|twitter) is our host this month and she’d like to hear our opinion. A ... Continue reading
2022-07-27 (first published: 2022-07-12)
384 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
122 reads
Blogs
Advice I Like: Rewards from Work
By Steve Jones
The greatest rewards come from working on something that nobody has words for. If...
Overcoming Challenges: Navigating Common Pitfalls in FinOps Adoption
By HeyMo0sh
Working in DevOps, I’ve seen FinOps do amazing things for cloud cost control, but...
Why your data still can’t answer a simple question
Every organization I talk to has the same problem dressed up in different clothes....
Forums
The day-to-day pressures of a DBA team, and how we can work smarter with automation and AI
Comments posted to this topic are about the item The day-to-day pressures of a...
Creating a Simple and Flexible Random Password Generator in SQL Server
Comments posted to this topic are about the item Creating a Simple and Flexible...
Question of the Day
Identities and Sequences IV
When thinking about the identity property and sequence objects, which of these can be used with numeric and decimal data types?
See possible answers