Learn about the architecture of MS SQL Serverin 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 versionssql 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.
Learn about the role concept in SQL Serverin 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 commandsql 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 Logtransaction 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 2008this 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 1instead of using vbscript, bat files, or sql client implementations, ... we'll show you the power of windows powershell in checking sql servers status.
Manage MS SQL Server with Management Studio
sql server management studio is a tool in sql server if you choose when installing.
