Skip to content
Monday, January 18, 2021
Latest:
  • List schemas in MySQL database
  • List databases (schemas) on MySQL server
  • Script To Export All Mailbox Sizes To CSV Using PowerShell On Office 365
  • IIS Redirect HTTP to HTTPS
  • Netapp Storage Initial Setup

iTech Admin

Just another IT blog

  • Microsoft
  • MacOS
  • Vmware
  • Mobile
  • HOW TO
  • SQL
  • WEB

SQL Server

how to SQL 

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

Read more
how to Microsoft Server SQL 

SQL Server 18456 Hatası Çözümü (Login failed for user sa)

29/07/201929/07/2020 iTech How to, SQL, SQL Server, Windows Server

Eğer Sql Server‘a sa (system admin) olarak bağlanılamıyorsa aşağıdaki adımları takip ederek bu sorunu çözebilirsiniz. İlk olarak Sql Server aşağıdaki şekilde açılır. Daha sonra Security bölümünden “sa”

Read more
how to Microsoft Server SQL 

How to Manually Restore an MSSQL Database in Management Studio

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

Read more
how to Microsoft SQL 

“Database Mail service was not working due to which we were getting following error: Msg 14641, Level 16, State 1, Procedure sp_send_dbmail, Line 363 Mail not queued. Database Mail is stopped. Use sysmail_start_sp to start Database Mail.”

27/01/201927/08/2020 iTech How to, Microsoft, SQL, SQL Server

Solution: Whenever you try to send Test mail from Database mail; it throws below error message: Msg 14641, Level 16,

Read more
SQL Windows 

Copy Table Schema and Data From One Database to Another Database in SQL Server

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

Read more
SQL 

How to identify contention in TempDb

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

Read more
SQL 

5 Monitoring Queries for SQL Server

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

Read more
how to SQL 

SQL Management Studio – How to create read only users

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.

Read more
Microsoft Server SQL 

SQL SERVER – Find Current Location of Data and Log File of All the Database

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

Read more
Microsoft Server SQL 

SQL SERVER – Get All the Information of Database using sys.databases

31/10/201831/10/2018 iTech SQL, SQL Server

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

Read more
  • ← Previous
List schemas in MySQL database
MySQL 

List schemas in MySQL database

28/12/202029/12/2020 iTech

The query below lists databases (schemas) on MySQL instance. Query A. Generic query select schema_name as database_name from information_schema.schemata order

Tag Cloud

AMAZON AMAZON AWS cloud co-location Command Creative Design DHCP DHCP Server Digital EC2 Funding How to IIS IIS7 IIS8 Launch Locust MacOS Microsoft MySQL NetApp Network New OpenSource Potential Powershell Programming Project Server sftp Social SQL SQL Server URL Rewrite VBS Script WEB Windows Windows 7 Windows 8 Windows 10 Windows Explorer Windows Server Windows Server 2012 R2 Windows Server 2016
Copyright © 2021 iTech Admin. All rights reserved.
Theme: ColorMag by ThemeGrill. Powered by WordPress.