Enable Encryption for Microsoft SQL Server Connections
It’s late in the afternoon and I have just received a most interesting task. A client of mine wants to
Read more
SQL Server
SQL Server 18456 Hatası Çözümü (Login failed for user sa)
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 Manually Restore an MSSQL Database in Management Studio
If you need to manually restore an SQL Database in Management Studio you can follow the instructions below for the
Read more“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.”
Solution: Whenever you try to send Test mail from Database mail; it throws below error message: Msg 14641, Level 16,
Read more
Copy Table Schema and Data From One Database to Another Database in SQL Server
Introduction Several times, we need to copy SQL Server table schema and data from one database to another database. In
Read more
How to identify contention in TempDb
TempDb database is used to store all temp tables created for our applications. Whether explicit or implicit created, all temp
Read more
5 Monitoring Queries for SQL Server
Every DBA squirrels away favourite queries for monitoring SQL Server. Nowadays many of these are too complex to keep in
Read more
SQL Management Studio – How to create read only users
The following steps detail how to create a read-only user for an SQL database using Microsoft SQL Server Management Studio.
Read more
SQL SERVER – Find Current Location of Data and Log File of All the Database
As I am doing lots of experiments on my SQL Server test box, I sometime gets too many files in
Read more
SQL SERVER – Get All the Information of Database using sys.databases
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