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 moreIt’s late in the afternoon and I have just received a most interesting task. A client of mine wants to
Read moreEğ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 moreIf you need to manually restore an SQL Database in Management Studio you can follow the instructions below for the
Read moreSolution: Whenever you try to send Test mail from Database mail; it throws below error message: Msg 14641, Level 16,
Read moreIntroduction Several times, we need to copy SQL Server table schema and data from one database to another database. In
Read moreTempDb database is used to store all temp tables created for our applications. Whether explicit or implicit created, all temp
Read moreEvery DBA squirrels away favourite queries for monitoring SQL Server. Nowadays many of these are too complex to keep in
Read moreThe following steps detail how to create a read-only user for an SQL database using Microsoft SQL Server Management Studio.
Read moreAs I am doing lots of experiments on my SQL Server test box, I sometime gets too many files in
Read moreHe has written script using sys.databases which provides plenty of the information about database. I suggest you can run this on your
Read more