Pages

▼
Showing posts with label Tools. Show all posts
Showing posts with label Tools. Show all posts
Saturday, 11 November 2017

How to migrate SQL Server aliases easily

›
Definitely, in my daily DBA life many times I had to complete the migration of hundreds of SQL Server aliases without wasting much time. The...
Friday, 13 October 2017

Purging old backup files by using forfiles windows tool

›
It is well know that most backup strategies include a step to purge backup files to keep the most recent backups in the database server so t...
Thursday, 7 September 2017

Getting information about memory used by SQL Server

›
Naturally, every DBA is asked to report information about the memory used by SQL Server. Common questions are related to memory reserved and...
Tuesday, 25 July 2017

Testing database connectivity by using a Universal Data Link file

›
After installing a SQL instance, we may need to test the database connectivity from a client host to make sure that everything is working ve...
Saturday, 5 August 2006

SQL Formatter Tool

›
Being asked sometimes about a good tool for formatting T-SQL code, I would like to share one of them known as 'SQL Formatter tool'. ...
Sunday, 21 May 2006

Installing SQL Server 2005 Service Pack 1 on all SQL instances via CMD

›
When it comes to installing SQL Server 2005 Service Packs on various instances rapidly, we can do it by executing the Service Pack setup wit...
Monday, 21 November 2005

How to connect to SQL Server 2005 much faster via SQL Management Studio

›
While connecting with SQL Server 2005, we have to deal with the 'splash' screen and then indicate, basically, the following informat...