SQL

MySQL 5.1.52 – The most popular Open Source SQL database management system

MySQL is a very fast, multi-user, multi-threaded and robust SQL (Structured Query Language) database server. MySQL is an attractive alternative to higher-cost, more complex database technology. Its award-winning speed, scalability and reliability make it the right choice for corporate IT departments, Web developers and packaged software vendors. MySQL Server was originally developed to handle large [...]

Database, Free software downloads Database, download free, mysql, MySQL 5.1.52, mysql database, server, SQL, 0

How Internet Browse Time Reports works in Websense

Calculating a user’s Internet browse time is challenging, because it is difficult to determine whether the user is actually reading the page, just opening or closing the browser, performing another task in a different application with the browser open, or possibly away from the desk entirely with the browser open. Websense software makes a reasonable [...]

Websense browse time, calculations, duration, IBT, Internet Browse Time, jobs, Log Database, MSDE, queries, query, Reporting, reports, sessions, SQL, Websense Express, 0

How to purge a Websense Log Database via the Microsoft SQL Server Query Analyzer?

Access Microsoft SQL Server Query Analyzer (Start > Programs > Microsoft SQL Server > Query Analyzer). Select your Websense log database from the database select menu (for example,wslogdb55). In the Query batch entry dialog box enter the following query: DELETE INCOMING WHERE CONVERT(DATETIME,{ ts’2003-10-14 00:00:00′}, 20) <= DATE_TIME and DATE_TIME <= CONVERT(DATETIME,{ ts’2003-10-14 23:59:59′}, 20) [...]

Websense Database, Log Database, MSDE, purge, Query Analyzer, Reporting, SQL, Websense Enterprise, Websense Web Security Suite, 3

How to Enable the SQL Server Browser service

If you are running SQL Server 2005 by using an instance name and you are not using a specific TCP/IP port number in your connection string, you must enable the SQL Server Browser service to allow for remote connections. For example, SQL Server 2005 Express is installed with a default instance name ofÂ Computer Name\SQLEXPRESS. You [...]

SQL browser service, SQL, sql server, Windows, 0

How to Enable remote connections for SQL Server 2005 Express or SQL Server 2005 Developer Edition

You must enable remote connections for each instance of SQL Server 2005 that you want to connect to from a remote computer. To do this, follow these steps: ClickÂ Start, point toÂ Programs, point toÂ Microsoft SQL Server 2005, point toConfiguration Tools, and then clickÂ SQL Server Surface Area Configuration. On theÂ SQL Server 2005 Surface Area ConfigurationÂ page, clickÂ Surface Area [...]

SQL Developer, enable, remote connection, SQL, sql server 2005, Windows, 0

How to Upgrade to Microsoft SQL Server from MSDE – Websense

The Websense service that sends data to MSDE needs to be stopped during the upgrade process. After the upgrade, re-establish the ODBC connection between the Log Server and SQL. As no Internet access information will be logged during the upgrade process, it is suggested to perform the upgrade during a quiet period as to minimize [...]

Websense configuration, connections, Database, Log Database, log server, logging, MSDE, ODBC, precautions, procedures, Reporting, SQL, Upgrade, Websense Enterprise, Websense Web Security Suite, 0

How to Block IP address of any country with iptables

Sometime it is necessary to block incoming connection or traffic from specific remote host. iptables is administration tool for IPv4 packet filtering and NAT under Linux kernel. Following tip will help you to block attacker or spammers IP address. Â The blocklist is create with an API I wrote and you can use wget to update [...]

Linux administrator, attack, attacker, attackers, attacks, block, connection, create, crontab, data, Database, databases, filter, filtering, format, group, help, hosts, incoming, ip, ips, kernel, linux, listing, nat, remote, roots, scripts, source, SQL, tools, traffic, URL, 0

Database Replication in MySQL – Step by Step Guide

Replication enables data from one MySQL database server (called the master) to be replicated to one or more MySQL database servers (slaves). Replication is asynchronous – your replication slaves do not need to be connected permanently to receive updates from the master, which means that updates can occur over long-distance connections and even temporary solutions [...]

MySQL accesses, Backup, base, command, configuration, configure, configured, connection, Copy, create, data, Database, databases, dependencies, distributions, enable, file, Identify, install, log, logging, logs, multiple, my network, networking, passwords, possibilities, privilege, privileges, replication, roots, s, secure, Security, server, servers, service, services, settings, shell, speed, SQL, system, systems, table, targeted, user, what, 0

What are the steps you can take to avoid â€œDeadlocksâ€ in SQL?

Deadlocking occurs when two user processes have locks on separate objects and each process is trying to acquire a lock on the object that the other process has. When this happens, SQL Server identifies the problem and ends the deadlock by automatically choosing one process and aborting the other process, allowing the other process to [...]

SQL accesses, array, caching, choose, computer, connection, data, Database, databases, developers, Generator, help, Identify, message, possibilities, prevent, release, server, servers, SQL, traps, user, what, 1

How to change SQL Server Instance Name?

Each instance of SQL Server consists of a distinct set of services that have specific settings for collations and other options The directory structure, registry structure, and service names all reflect the instance name and a specific instance ID created during SQL Server Setup. An instance is either the default instance or a named instance. [...]

SQL client, configuration, configure, configured, connection, create, determine, directory, execution, install, names, queries, server, servers, service, services, settings, SQL, user, 1

How To Install NicTool on FreeBSD 7

It includes an attractive web interface for users, admins, and clients to access and update their DNS zone data as well as a rich API for provisioning systems to interact with. All zone data is stored in MySQL and is extracted by export scripts to the DNS server of choice (tinydns, BIND, PowerDNS). Updates are [...]

Linux accesses, alias, apache, bind, client, configuration, configure, configured, create, data, Database, databases, dependencies, determine, distributions, ex exs, file, group, images, install, interface, lib, log, logging, logs, my parsed, perl, port, ports, scripts, server, servers, source, SQL, system, systems, targeted, unavailability, user, usr, what, 1

What is FreeTDS ?

FreeTDS is a set of libraries for Unix and Linux that allows your programs to natively talk to Microsoft SQL Server and Sybase databases. Technically speaking, FreeTDS is an open source implementation of the TDS (Tabular Data Stream) protocol used by these databases for their own clients. It supports many different flavors of the protocol [...]

Open Source accesses, client, data, Database, databases, difference, linux, microsoft, openness, perl, protocol, protocols, server, servers, settings, source, SQL, unix, what, 0

Breach Securityâ„¢ Labs Alert – Mass SQL Injection Attack

Priority: HIGH Impact: Potential for database corruption or malware to be distributed to website visitors. Resolution: Verify blocking policy in web application firewall. Remediate the following web application and database flaws: 1.Â Poor/missing input validation of user-supplied data in the web application. 2.Â Poor/missing output encoding of user-supplied data. 3.Â Improper database permissions and/or SQL query construction. Who: [...]

Alerts & News attack, attackers, attacks, breach security, injection, security labs, SQL, 0

How to Run MySQL in ANSI Mode

You can tell mysqld to run in ANSI mode with the –ansi startup option. Running the server in ANSI mode is the same as starting it with the following options: –transaction-isolation=SERIALIZABLE –sql-mode=ANSI As of MySQL 4.1.1, you can achieve the same effect at runtime by executing these two statements: SET GLOBAL TRANSACTION ISOLATION LEVEL SERIALIZABLE; [...]

MySQL enable, global transaction, mode options, pipes, server, SQL, startup option, transaction isolation level, 0

How to Configure Auto Reconnect in MySQL

The MySQL client library can perform an automatic reconnect to the server if it finds that the connection is down when you attempt to send a statement to the server to be executed. In this case, the library tries once to reconnect to the server and send the statement again. Automatic reconnection can be convenient [...]

MySQL automatic reconnection, client, client library, configuration, configure, connection, connection pool, databases, enable, my queries, mysql client, persistent connections, server, servers, SQL, sql queries, what, 1

SQL