SQLAdmin

What happened while I was away on vacation? SELECT   [databases].[name],   [server_principals].[name] AS [database_owner_name],   [data...

When I restored a SQL Server database, the message ended with a status of the restore: RESTORE DATABASE successfully processed 15025885 pag...

To maintain a list of currencies, I have been looking for a standard and a external resource. The standard ISO 4217 is described at Wikiped...

I am working on a major version upgrade of a system that is using SharePoint and private databases. In both cases with 100+ GB data. Most d...

Some time ago I write about timestamp difference , and I have used it for measuring execution times. But actually there is a much better wa...