Tutorials to .com

Tutorials to .com » Database » Sqlserver » Microsoft SQL Server Tutorial

Microsoft SQL Server Tutorial Articles


321: Sybase database defragmentation
Sybase database defragmentation Sybase like such a large-scale DBMS systems, as OLTP (online transaction processing) applications, the cornerstone, it needs 24 hours a day, 365 days a year to run uninterrupted. Applications due to its database ever...

322: Transplantation by the Sybase database to the SQLServer
From Sybase database to SQL Server migration Introduction I recently participated in a Sybase database will be migrated to Microsoft SQL Server 2000 on the project, and I in this project the experience gained will Sybase database Sybase database a...

323: 7000 Series to provide MPLS backbone network
7000 Series to provide MPLS backbone network Positioning products in the mid-range Cisco 7000 series routers has been building a telecommunications network and the edge of core network reinforcements. June 7, in the end Cisco routers Seenu Banda, v...

324: Oracle with NetBackup to restore to different machine
Oracle with NetBackup to restore to different machine First, the assumption has been successfully backed up (do not use rman catalog). To return to the assumption that the database file system new_host different / data on. As an example to oracle8i...

325: SQLServer backup in case of network
SQL Server backup in case of network * * * FielName: backup.sql * * Function: Automatic backup * * Author: Yahong * * Write Date: 2005-5-10 2005-5-19 * * Version: 00 01 * * * ************************************************** ***************...

326: SQL batch data upload
SQL batch data upload Bulk data upload (access to sql server. Sql server to sql server) set @ sql = declare # tbc cursor for select name, tbname = object_name (parent_obj) from + @ n_dbname + .. sysobjects where xtype in (C, F) exec (@ sql) dec...

327: Mysql database replication
Mysql database replication Mysql then between the two systems can not be achieved through the TCP / IP to copy the database? Can not reproduce it in real time? In other words can not sync (Synchronization) problems. First to outline briefly the Rep...

328: MySQLFunc vulnerability (2)
MySQL Func vulnerability (2) Online test today to MySQL Fun loopholes (in fact can not be said to be loopholes, and can only be described as no more than a technical). MySQL Fun with some of the technical Xeon just overcome a host, go after the poi...

329: MySQLFunc loopholes (1)
MySQL Func loopholes (1) Shortly before the online MySQL Func open a loophole, saying the use of MySQL to create a custom function, and then through this function to attack the server. See the related reports of the earliest in the o-otik, but rele...

330: Anti-hacking database system technology
Anti-hacking database system technology With the rapid development of computer technology, database applications are very extensive and in-depth into various fields, but the resulting data have had a security problem. A variety of database applicat...

331: the actual configuration pix535
the actual configuration pix535 Actual use of two ports pix. The ultimate goal is: do not use nat to allow the internal network directly from the address, pix are cernet address both inside and outside. the actual configuration pix535 ocol h323 ...

332: SQLServer Several methods of data transmission
SQLServer Several methods of data transmission This article discussing the issues relating to data transmission between the database problem, the field of practical application can be used with practical value. For example: the company is currentl...

333: SQLServer database of the six methods of data movement
SQL Server database data movement method of the six 1. Through the DTS Designer tool to import or export DTS Designer of the powerful, multi-task and visual interface, easy to operate, but generally not much to know, if only for part of SQL Server ...

334: Distributed with SQL data replication
Distributed with SQL data replication Reproduction as an important and powerful technology for distributed data storage and provides a strong support to deal with. Microsoft's SQL Server can generate data copy, and copies of the data can be dis...

335: Access database to explore the best set NTFS permissions
Access database to explore the best set NTFS permissions (A) experiment In order to facilitate the description, give specific examples of experiments: the application for the / test, the database stored in D: \ wwwroot \ test \ data \ db1.mdb, we ...

336: Download exploits database technology
Download exploits database technology Loopholes in the script as the number one killer - download vulnerability database, and now has been more and more people are familiar with. Information technology in this era of rapidly updated, after the vuln...

337: SA account name and delete
SA account name and delete As we all know, M $ sql in there is the risk of network security account sa, system administrator (sa), by default, it is assigned to a fixed server role sysadmin, and can not be changed. Sa normal circumstances this is n...

338: mssql in the public and db_owner or under the purview webshell get system privileges
mssql in the public and db_owner or under the purview webshell get system privileges Read more than five kinds of methods, it should be said that the db_owner permission in the following system privileges to be a means of both the success rate or f...

339: The use of database replication technology to achieve data synchronization update
The use of database replication technology to achieve data synchronization update Replication is a set of data copied from one data source to multiple data sources of technology, is a data storage site to more than an effective way. The use of repl...

340: SQLserver affect three aspects of the key performance
SQL server performance impact of three key Logical database design, including the table with the table is the relationship between the relational database to optimize the performance of the core. A good logical database design can optimize the data...


Page 17 of 39
[1]   [2]   [3]   [4]   [5]   [6]   [7]   [8]   [9]   [10]   [11]   [12]   [13]   [14]   [15]   [16]   [17]   [18]   [19]   [20]   [21]   [22]   [23]   [24]   [25]   [26]   [27]   [28]   [29]   [30]   [31]   [32]   [33]   [34]   [35]   [36]   [37]   [38]   [39]