SQL Server – iTech Admin

Enable Encryption for Microsoft SQL Server Connections

22/10/2019 iTech SQL, SQL Server

It’s late in the afternoon and I have just received a most interesting task. A client of mine wants to

01/02/2019 iTech SQL, SQL Server

If you need to manually restore an SQL Database in Management Studio you can follow the instructions below for the

16/01/2019 iTech SQL, SQL Server, Windows

Introduction Several times, we need to copy SQL Server table schema and data from one database to another database. In

19/11/2018 iTech SQL, SQL Server

TempDb database is used to store all temp tables created for our applications. Whether explicit or implicit created, all temp

19/11/2018 iTech SQL, SQL Server

Every DBA squirrels away favourite queries for monitoring SQL Server. Nowadays many of these are too complex to keep in

07/11/2018 iTech SQL, SQL Server

The following steps detail how to create a read-only user for an SQL database using Microsoft SQL Server Management Studio.

01/11/2018 iTech SQL, SQL Server

As I am doing lots of experiments on my SQL Server test box, I sometime gets too many files in

He has written script using sys.databases which provides plenty of the information about database. I suggest you can run this on your

30/10/2018 iTech SQL, SQL Server

Tracking changes to database objects such as tables and stored procedures isn’t something SQL Server does natively. Generally the only way