Setting up my new workstation with some Chocolatey goodness.
As you might be aware I started a new job last week. Which means a new workstation and installing lots ... Continue reading
2022-11-11
175 reads
SQLStudies
What is production grade code? : T-SQL Tuesday #156
It’s that time of the month again! It’s T-SQL Tuesday and this month Tom Zika (blog|twitter) is hosting. Tom would ... Continue reading
2022-11-23 (first published: 2022-11-08)
361 reads
SQL Homework – July 2022 – Getting ready for the next time you have to look for a job.
Back in July I suggested that you get your resume up to date. It’s something I’d wish I’d kept up ... Continue reading
2022-11-14 (first published: 2022-11-01)
251 reads
What’s next: New beginnings!
I’m both excited and frankly relieved to say that I’ve found a new position. Starting Wed Nov 2nd I’ll be ... Continue reading
2022-10-28
10 reads
What can you do with a SELECT statement without a FROM clause?
Some people have shower thoughts, I have 1am thoughts. In this case it was the only keyword required in a ... Continue reading
2022-11-07 (first published: 2022-10-25)
650 reads
Comments in your generated code : T-SQL Tuesday #155
The ever amazing Steve Jones (blog|twitter) is our host this month. And in case you didn’t know he also is ... Continue reading
2022-10-24 (first published: 2022-10-11)
302 reads
What you can do is based on more than your direct permissions.
What you have access to is not just what you have direct permissions to. The other day I needed to ... Continue reading
2022-10-19 (first published: 2022-10-06)
232 reads
SQL Homework – October 2022 – Replication part 2
In August we started taking a look at replication. We learned some of the terms used, and set up a ... Continue reading
2022-10-04
14 reads
Being a script magpie
Last month (I ran just a little bit late writing this, it was meant to go out 9/29) Brent Ozar ... Continue reading
2022-10-01
110 reads
Viewing errors with extended events
A little while back I came across this post: Identifying failed queries with extended events. It has a script to ... Continue reading
2022-10-10 (first published: 2022-09-27)
329 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