Pages

▼
Showing posts with label database. Show all posts
Showing posts with label database. Show all posts
2024-11-19

List orphan database users

›
Some days ago I was asked - politely - to move some databases between two SQL Server installations. Unfortunately the service had failed on ...
2019-03-06

Rename TFS Collection databasefiles

›
During TFS (2017) restore on a new server the wizard might rename datafiles. If the TFS Collection database is defined with multiple dataf...
2015-09-22

Move table to filegroup

›
Why? Dealing with a database that has been around for some time may require some basic reconfiguration. In this case I had one (or more.....
2015-08-14

Attach database

›
I had to get some data from a old database, where the server is recycled. But at that time I was present enough to get a copy of the data fi...
2012-08-23

Back from vacation

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

Describe database role

›
When you script out a database role in SQL Server Management Studio (SSMS) or another tool like Red-Gate SQL Compare, you most likely will g...
2012-02-11

Change database owner

›
I am about to join an internal course, and would like to prepare by installing the SQL Server Database Product Samples from CodePlex . Aft...
2011-09-27

Script a database definition

›
Recreating a database in a higher environment is a common task. Quite often it is not that smart just to restore a back, as you then get dat...
2009-09-26

Database version

›
When the daily administration of several database instances is done using a standard database, it is rather nice to be able to check that al...