sql server dba topics

1. query table name or column name in Chinese comments (SQL Server 2008)Select T.object_id from sys.tables tjoins on T. object_id=and='ms_description' and p.minor_id=0;1.1 Query Table name Chinese commentsSelectT1.*, T2.name ascolumn_name from (SelectT.object_id, P.major_id,p.minor_id,t.name asTables_name, P.value,t.type,t.type_desc fromsys.tables TJoinsys.extended_properties P onT.object_id =p.major_id a

The following article describes how to log on to SQL * Plus as a DBA at Oracle10g. I saw several related articles on the internet two days ago, to learn how to install the actual operation steps on Windows XP Pro, you can change the path of the following article. Oracle10g: How to log on to iSQL * Plus as a DBA Generally, you can log on to the isqlplus website ht

Http://www.cnblogs.com/CareySon/category/389500.html SQL Pass (13) SQL SERVER (42) SQL Server DBA career (1) SQL Server

system stored procedures provided by the DBMS-System Functions: Provides specific expression arithmetic functions, such as date-time functions, String functions, mathematical functions, aggregate functions, etc., which are required for T-SQL programming.-System Views: Contains database metadata, internal system running data, etc., such as catalog view (used instead of system tables in SQL

Tags: class tar get HTTP strong cSQL queries the database, you can take a series of ways to improve the speed and performance of queries. For example, use case instead of update, using temporary tables and batch updates, and so on. This article introduces 7 ways to improve the query speed, please refer to the reader.When SQL queries the database, proper adherence to some principles can make the job easier, and this article lists 7 principles that can

Medical inquiry a website has the SQL Injection Vulnerability (DBA permission) I want to explain to you what is "Single Love". The so-called "Single Love" means that you have sentenced me to the final death penalty in your heart, and I have sentenced you to life imprisonment! Vulnerability address:Http://oa.xywy.com/ We will capture packets and modify the user name And then drop the ing sqlmap. sqlmap.py

Label:The country's top SQL DBA team is hiring.4-Year DBA ExperienceWe want you to master1, skilled relational database principle, proficient in a scripting language (Python, PowerShell)2, the automation, data-interested.3, can build SQL Server cluster, services broker, Repl

Moutai e-commerce has multiple SQL Injection packages in the background (DBA permission/17 databases/47W members) Note:Http://www.emaotai.cn: 90/zyd/ Account: wangleiPassword 123456Get submit method SQL injection point:Http://www.emaotai.cn: 90/zyd/Sales/XsdEdit. aspx? Pjbh = 111000100020 ReturnPage = Xsmxz. aspx op = 2 http://www.emaotai.cn:90/zyd/Sales/Xsmxz.

Label: 1. Using SQL Dynamic View As follows: Select Top B.text, A.total_worker_time,a.total_logical_reads,a.total_elapsed_time,execution_count from sys.dm_exec_query_stats a Cross as b Order by Total_worker_time/desc View the online Help document view: Sys.dm_exec_query_stats can get all the field meanings, mainly Total_worker_time: Total CPU consumption time Total_logical_reads: Number of logical Reads Total_elapsed_time:

, according to the type of injection parameters, in the mind to reconstruct the original SQL statement.Detailed content >>Http://blog.csdn.net/wufeng4552/archive/2008/12/05/3449870.aspx SQL Injection Vulnerability full contact-Advanced articleAfter reading the introductory and advanced articles, a little practice, crack the general website is no problem. But how can you increase the success rate of injectio

Search for a website SQL Injection Vulnerability (DBA permission) Search for a website SQL Injection Vulnerability (DBA permission) Vulnerability addresses: http://oa.xywy.com/We will capture packets and modify the user nameAnd then drop the ing sqlmap.Code RegionSqlmap. py-r 4.txt -- tamper space2comment. py, base64

Tags: path l database efficiency table first day roo VAR system environment ServiceAdd "D:\mysql-5.6.22-winx64\bin" to the system environment variable path, and then in any directory can access MySQL and other commands, such as login and other operations do not need to enter the MySQL installation directory to perform! MySQL Download (two):Website: www.oracle.com1) Download MySQL Community Server (GPL)---mysql database2) MySQL Connectors---JDBC driver

Shanghai Greenland Shenhua Football Club official website has SQL injection (DBA permission) Rt. Shanghai Greenland Shenhua Football Club official website:Http ://**.**.**.**The vulnerability exists in:Http: // **. **/news. php? Category = 41Http: // **. **/news_detail.php? Newsid= 5232Http: // **. **/news_detail.php? Newsid= 5231Http: // **. **/news_detail.php? Newsid= 5229Http: // **. **/news_detail.php?

Label:Text: Toward Dba[mssql] Improve access performance of databases from the perspective of SQL statementsRecently the company has come to a very tiger DBA 10几 years of experience here is called Cai Teacher. Let us share the precious wealth that Cai Lao has brought to us, with the consent of our Chua. Welcome other DBAs to shoot bricksDirectory1. What is the ex

provided by Oracle, TKPROF, to track the execution of the application. First, in System View v$session, the corresponding SID and serial# can be detected based on UserID or machine. Execute Dbms_system.set_sql_trace_in_session (sid,serial#,true) with SYS or other user connected database that has execute Dbms_system package. Then run the application, at the server side, the database parameter user_dump_dest indicates the directory, will generate the O

them by the last update time. Run the following statement: SELECT * from sys.objects where type in (' U ', ' V ', ' P ') Order by modify_dateThis statement identifies all the user tables, views, and stored procedures in the database and sorts them by time, so that you can see others recently added and modified those database objects. Sys.objects does not contain triggers, and triggers are in sys.triggers. There are similar sys.tables,sys.views and so on.　　Information_schemaIf we want to quickly