sql server management studio is a tool in sql server if you choose when installing.
this is a step by step guide to installing ms sql server.
in the previous articles, you already know briefly about sql server, how to install sql server on the computer. in this section we will learn about the architecture of sql server.
sql server currently has many different versions. below is a list of versions with features of each version.
this article will give you a general introduction to sql server, demonstrating the benefits and benefits of using sql server as well as existing versions.
technically, you can use the alter database syntax to move any system or user database files that define, initialize, except for the resource database.
in any database management system, security and security are always top priority. and with sql server, if we take advantage of the many advantages of this application, those who
sql server 2008 integrates many remarkable new features. one of these features is improvements in t-sql statements that reduce the time spent working on these statements.
transaction log (also known as database log or binary log) is an action history that is executed by the database system to ensure acid properties when the system fails.
this article will illustrate the different usage methods of the 'for attach' clause to overcome the limitations encountered when using sp_attach_db and sp_attach_single_file_db.
in this section, i will show you how to get that information in top 10 queries based on cpu performance.
instead of using vbscript, bat files, or sql client implementations, ... we'll show you the power of windows powershell in checking sql servers status.
this part 2 will show you how to access the windows service on the remote computer using windows powershell and wmi-object.
in part 3, i will show you how to find some hardware and operating system information from the host machine.
in this next section, i will show you the information about network card and hard drive from the server.
in this part 5, we will check whether we can connect to sql server and see if we can query some properties related to sql server.
part 6 will show you how to check all existing databases in the sql server instance and query the database properties.
in sql server, the case function verifies the value based on the list of given conditions, then returns one or more results. in this article we will illustrate a number of
sql server 2008 and 2008 r2 will stop supporting on july 9, 2019. windows server 2008 and 2008 r2 will stop supporting on january 14, 2020.