sql server
-
Manage MS SQL Server with Management Studio
sql server management studio is a tool in sql server if you choose when installing.
-
Instructions for installing MS SQL Server
this is a step by step guide to installing ms sql server.
-
Learn about the architecture of 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.
-
MS SQL Server versions
sql server currently has many different versions. below is a list of versions with features of each version.
-
What is MS SQL Server?
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.
-
Use the ALTER DATABASE command to migrate DATABASE in SQL Server
technically, you can use the alter database syntax to move any system or user database files that define, initialize, except for the resource database.
-
Learn about the role concept in SQL Server
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 manage the system administration will greatly reduce the burden as well as the pressure on the job.
-
Improvements in SQL Server 2008 T-SQL command
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.
-
Restore SQL Server from Transaction Log
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.
-
Attach database in Microsoft SQL Server 2008
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.
-
Test SQL Server with Windows PowerShell - Part 7
in this section, i will show you how to get that information in top 10 queries based on cpu performance.
-
Test SQL Server with Windows PowerShell - Part 1
instead of using vbscript, bat files, or sql client implementations, ... we'll show you the power of windows powershell in checking sql servers status.