Conversion Precedence
Recently I talked about the difference between implicit and explicit datatype conversions. In it I ran this code: With the ... Continue reading
2022-09-20
13 reads
SQLStudies
Making the mouse pointer easier to see.
I know this is way off my usual content but the other day someone was mentioning how easy it is ... Continue reading
2022-09-15
21 reads
Putting counters in names
It’s not all that unusual, or unreasonable to put a counter in a name. For example let’s say you need ... Continue reading
2022-10-03 (first published: 2022-09-13)
550 reads
What’s next 4th time
It’s now been about two and a half months since I was given notice and decided to blog about my ... Continue reading
2022-09-28 (first published: 2022-09-08)
203 reads
Creating a SERVER ROLE created a LOGIN as well.
One of my co-workers came to me the other day and told me that they found their network id as ... Continue reading
2022-09-21 (first published: 2022-09-06)
335 reads
SQL Homework – September 2022 – Query window challenge
I had every intention of doing Replication Part 2 this month but had a thought I liked better. I will ... Continue reading
2022-09-14 (first published: 2022-09-01)
318 reads
When good enough is good enough
Any time I’ve learned about the optimizer there is always one important thing that’s brought up. The optimizer is not ... Continue reading
2022-08-30
18 reads
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
32 reads
Why is security important in a dev environment?
I was asked a rather interesting question during an interview recently. It went something like this: Your resume says you’ve ... Continue reading
2022-09-05 (first published: 2022-08-23)
227 reads
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)
426 reads
Blogs
Speaking at the TechnoSecurity and Digital Forensics East Conference
By Brian Kelley
The Techno Security & Digital Forensics Conference (East) runs from June 3-5, 2025, this...
Techorama 2025 – Slides
You can find the slides for my session Building the €100 data warehouse with...
Query Hints and Estimated Plans
I’m working on an update to my Query Performance Tuning book for SQL Server...
Forums
Changing the Paradigm of Work
Comments posted to this topic are about the item Changing the Paradigm of Work
Removing a File
Comments posted to this topic are about the item Removing a File
Question of the Day
Removing a File
I attempted to use ALTER DATABASE to remove a file from my filegroup in SQL Server 2022. There are 4 files in this filegroup, but I don't need them all. However, I received a message that the file was not empty. How do I empty this file so it can be removed?
See possible answers