A community portal about SQL with blogs, videos, and photos. According to Wikipedia.org: SQL is the most popular computer language used to create, modify, retrieve and manipulate data from relational database management systems. The...
[more]
A community portal about SQL with blogs, videos, and photos. According to Wikipedia.org: SQL is the most popular computer language used to create, modify, retrieve and manipulate data from relational database management systems. The language has evolved beyond its original purpose to support object-relational database management systems. It is an ANSI / ISO standard.
A Microsoft SQL database can be marked “Suspect” under various scenarios, like corruption of database file(s), unavailability of database file(s), operating system is holding a database resource, or entire database is not available. A suspect state of the SQL database can be easily identified with the occurrence of an error message. The error message primarily results in halting the mounting process of the database making the data stored in the database inaccessible. In such situations, an... Read Full Story
I am trying to replicate 3 critical databases to a remote (connected via vpn) sql server using sql 2000 native replication. I'm creating a snapshot with transactional log replication which fails on the snapshot... (Budget: $30-250, Jobs: SQL, System Admin., Windows) Read Full Story
I got phpMyAdmin to create some SQL for me, since I always seem to get it wrong. It gave me this (and I added the IF NOT EXISTS bit):
MySQL Code:
'CREATE TABLE IF NOT EXISTS ' . $table_name . " ('id' INT NOT NULL AUTO_INCREMENT PRIMARY KEY, 'name' TEXT NOT NULL, 'email' TEXT NOT NULL, 'uri' INT NOT NULL, 'time' INT NOT NULL, 'message' TEXT NOT NULL, 'notify' TINYINT(1) NOT NULL DEFAULT \' 0 \' ) ENGINE = MyISAM CHARACTER SET utf8 COLLATE utf8_unicode_ci;" ) ;
It works fine, but it... Read Full Story
I have a table like so:
SQL Code:
CREATE TABLE `shortURL` (
`id` int ( 10 ) UNSIGNED NOT NULL AUTO_INCREMENT ,
`sURL` varchar ( 5 ) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL ,
`lURL` varchar ( 255 ) COLLATE utf8_unicode_ci NOT NULL ,
PRIMARY KEY ( `id` ) ,
UNIQUE KEY `lURL` ( `lURL` ) ,
KEY `sURL` ( `sURL` )
) ENGINE=InnoDB AUTO_INCREMENT = 15 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci
What I want to do is to try inserting a new row with a value into the lURL... Read Full Story
Microsoft SQL Server 2005 New Features Publisher: McGraw-Hill playwright Media | ISBN: 0072227761 | edition 2005 | chm | 288 pages | 6,62 mb Written by archangel Otey, Senior Technical Editor of SQL… [[ This is a noesis unofficial only. Visit my website for flooded links, another content, and more! ]]
http://feedproxy.google.com/~r/technomac/~3/ZBbhBvZ-BAA/microsoft-sql-server-2005-new-features.html Read Full Story
Book Details Author:Sheeri K. Cabral, Keith Murphy No of Pages: 888 pages Press: Wiley Dated:May 11, 2009 Language: English ISBN-10: 0470416912 ISBN-13: 978-0470416914 Book Description MySQL Administrator's Bible is designed to provide a solid framework for a beginning MySQL DBA or an experienced DBA transitioning from another database platform. The book starts with the fundamentals of MySQL database management, including MySQL's unique approach to SQL queries, data and index types, stored... Read Full Story
In less than a week, Microsoft plans to make public the latest chapter in the evolution of codename Olso, a project that was originally unveiled approximately two years ago and that has suffered numerous and consistent changes since then. Because of the modifications introduced to Oslo during the development process, the upcoming milestone, which will be delivered at the Professional Developer Conference 2009 in Los Angeles next week, no longer resembles the initial solution modeling... Read Full Story
Actually, if you are reading this, you are not presently a resident fossil in the brand-new Operator Speaking Tar Pit.
… but watch yourself – you never know …
Tar Pit Operation
Record incoming user agent, IP address
Compare user agent, IP address to Black List
On match, apply ban level (deny, poison) protocol
Tar Pit Administration
Review MySQL database for suspicious / undesirable hits and insert bans accordingly.
What this means for those I have banned: this site... Read Full Story
By Jason Kendall Should you be looking for Microsoft certified training, then you'll naturally expect training companies to supply a wide selection of the most superior training courses available today. Try to discuss all the different permutations with a person who has knowledge of the commercial demands for IT staff, and is able to show you the most fruitful career to suit your abilities and character. Be sure your training is tailored to your needs and abilities. The best companies will... Read Full Story
By Jason Kendall What can a student searching for Microsoft authorised training expect to find today? Patently, training providers must supply a range of courses that cover the range of Microsoft certified training tracks. Additionally you might like to be given advice on the sort of careers you might go for once you've qualified, and the kind of person those jobs may be appropriate for. The majority of students prefer to discuss what they might be good at. Be sure your training is tailored... Read Full Story
