Can't Hit the Remote Registry through the Virtual Name
This is a problem we just solved, which was causing us to not be able to hit the remote registry...
2010-11-16
2,294 reads
My Weekend Just Got Busy
I’m traveling to New York City on Friday for SQL Saturday #59 and returning Sunday morning. As soon as I...
2010-11-16
803 reads
Another Plagiarizer
I received a note today about someone else that is plagiarizing content from SQLServerCentral. It’s a blog on Windows Live...
2010-11-16
1,112 reads
There should only be one ...
When visiting clients, I often find that one or more databases have a table (or several) containing metadata. Most often, these tables have only a single row of data...
2010-11-16
15 reads
There should only be one ...
When visiting clients, I often find that one or more databases have a table (or several) containing metadata. Most often, these tables have only a single row of data...
2010-11-16
30 reads
There should only be one ...
When visiting clients, I often find that one or more databases have a table (or several) containing metadata. Most often,...
2010-11-16
624 reads
Handy Hardware Assessment Tools For SQL Server
Here is a small selection of useful tools for getting some specific hardware information from any Windows based system you...
2010-11-16
2,262 reads
Backup log Truncate_Only in SQL Server 2008
BACKUP LOG <db_name> WITH truncate_only command, used for clearing the log file, is deprecated in SQL Server 2008. So this post will explain option...
2010-11-16
1,700 reads
My SQL PASS Summit Adventures part 1
I started my PASS Summit a little early this year. I arrived in Seattle on Friday night, November 5th, around...
2010-11-16
597 reads
How Often Do You Backup Your Transaction Logs?
Whenever I speak about database maintenance, I always recommend that DBAs backup up their production database transaction logs at least...
2010-11-16
1,878 reads
Blogs
Experimenting with CHOOSE: #SQLNewBlogger
By Steve Jones
I was looking over the CHOOSE() function while editing an article at SQL Server...
Fighting Procrastination?
By Brian Kelley
Here is another short video (~ 15 minutes). This is by the author of...
A Fun Prize at the PASS Data Community Summit
By Steve Jones
I had a briefing for the 2026 PASS Data Community Summit, which is just...
Forums
MERGE in a nested TRY/CATCH won't roll back
I have a section of code similar to the following abstract: DECLARE @loop [int]...
Perfermance result aftet purge operatio
Hello everyone, I am planning to implement a data purging solution that is expected...
SQL Server 2025 Server-level Roles
Comments posted to this topic are about the item SQL Server 2025 Server-level Roles
Question of the Day
SQL Server 2025 Server-level Roles
In SQL Server 2022+, what does the ##MS_DatabaseConnector## role allow?
See possible answers