My Prize Has Arrived!
Back in November, I was lucky enough to be nominated and then got enough votes to win the New to...
2011-01-17
538 reads
Gethyn Ellis
Which Process ID is SQL Server running on?
There was an interesting question posted on a forum recently, asking how can you tell which sqlservr.exe process (shown in...
2011-01-04
5,981 reads
Happy New Year
Well it’s Friday again and another big day.
Hopefully you all had a great Christmas and as we move to...
2010-12-31
1,494 reads
SELECT * FROM SQLBLOGGERS WHERE LOCATION = ‘UK’
I published a post yesterday where I listed my top 5 bloggers from the worldwide SQL community for 2010. The...
2010-12-30
1,927 reads
SELECT TOP 5 * FROM BLOGGERS
Hopefully my title gives away what this post is about. This my list of the top five people or more...
2010-12-29
537 reads
Merry Christmas
This is just a short post for a Friday and not just any old Friday either, Santa is on his...
2010-12-24
563 reads
SQL Bits 8
It seems the dates for the next SQLBITS have been released will take between April the 7th and April 9th...
2010-12-23
508 reads
Should I have AutoGrowth enabled on my SQL Server Database
I was reading a few forum posts yesterday where a few people were complaining that the transaction log had grown...
2010-12-22
1,997 reads
Turn Off AutoShrink!
This is kind of a follow up to a post I published last week regarding autogrowth. A forum poster said...
2010-12-20
614 reads
Let it Snow, Let it Snow, Let it Snow!
I don’t usually post on my blog on the weekend, but this weekend, the weekend before a Christmas is a...
2010-12-18
484 reads
Blogs
“We love to debate minutiae”
By Brian Kelley
I am guilty as charged. The quote was in reference to how people argue...
Advice I Like: Knots
By Steve Jones
Learn how to tie a bowline knot. Practice in the dark. With one hand....
Shifting Mindsets: Why FinOps is Essential for Cloud Efficiency
By HeyMo0sh
As a DevOps practitioner, I’ve always focused on performance, scalability, and automation. But as...
Forums
Windows logins for users migrated from DomainA to DomainB
Hi, I have a SQL Server instance where users connect to via Windows Authentication,...
Multiple Deployment Processes
Comments posted to this topic are about the item Multiple Deployment Processes
How to Use sqlpackage to Detect Schema Drift Between Azure SQL Databases
Comments posted to this topic are about the item How to Use sqlpackage to...
Question of the Day
Upgrading Admin Queries
I have a query from a former DBA that we run on SQL Server 2025 to check on database metadata. This query references sys.sysaltfiles. I want to refactor this code to be more modern. Which DMV should I reference instead?
See possible answers