Iniciar sesión
Registrarse
He olvidado mi contraseña
Filtrando por 'Administration'

Definitely, one of the challenging tasks in the life of a DBA could be moving files of a database from one physical location to another one because of performance issues, maintenance requirements, disk space issues, etc. We usually move database files to another location by using Backup/Restore or ...

Enviado por preyes
LEER MÁS

As part of a SQL Server AlwaysOn Availability implementation we could need to test Read-Only Intent Connection in someway and to make sure that it is working well at SQL Server level. We can use SQL Management Studio to verify it. Let me expand on what I mean, AlwaysOn Technology give us an option t...

Enviado por preyes
LEER MÁS

Just thinking about some interesting tools that could be useful for doing some DBA tasks, I’d like to share my code to change the collation of all columns of all SQL Server tables (I mean User Tables, not System Tables).  To begin with, I will show you a basic code to filter columns by an spe...

Enviado por preyes
LEER MÁS