Blogs about: Database

The best in Database-related posts from around the WordPress.com community, updated daily.

Featured Posts
More from this author
Tomorrow belongs to cites
How to publish in journals

Over the last decades, journal rankings moved from something only a few librarians cared about to something that is now critical to the future of professors and researchers. The same thing could happen to the individual citation metrics. Internet and open access movement is urging academia to reconsider the current model of research assessment, journal rankings and each of the phases of the publishing process, such as the private citation system, the growing role of repositories, the subscription and payment model , and even the peer review and impact indicators. Assessment of quality of research activity is needed, either of the journal, or research activity of department or individual, no one doubts it, the problem is what type; the ideal would be all of them. Some countries do this, they rate individual academics by levels, for example in UK (REF), Australia (EIA) or Spain (ANECA), having into account many more things, such as teaching assignments, research centers or stays in inter

More from this author
Add CPU cores to VMware vSphere 4+ VM …
Ian Works Here

Staff have been complaining about a SQL application call Total Synergy running slow. There are a lot of factors here that might be impacting but in my search for answers, I came across an SQL monitoring app called Ignite. It is created by Confio (www.confio.com/performance/sql-server/ignite/). Although no SQL expert, this tool seemed to suggest that CPU resources were lacking. I already knew how to add CPU’s to a VM. The problem is that I am running SQL Express 2008 R2. It only supports a single CPU but this can be a maximum 4 core CPU. Fortunately, I discovered that since vSphere 4.x, it has been possible to add CPU cores to a VM. Here is the VMware knowledge base article: http://kb.vmware.com/selfservice/microsites/search.do?language=en_US&cmd=displayKC&externalId=1010184 I should clarify that in 4.0, which I am running, it is experimental. However, for the moment it is holding up and feedback suggests it has made some difference. Now, to sort out some of the other po

The Latest Posts in Database
Recently posted on WordPress.com Subscribe
Maxine Waters Exposes Obama’s National Citizen Database In TV Interview.
Rivers of Hope

Obama has created a monster that will destroy long after he leaves “The President has put in place an organization with the kind of database that no one has ever seen before in life,” Representative Maxine Waters told Roland Martin on Monday. “That’s going to be very, very powerful,” Waters said. “That database will have information about everything on every individual on ways that it’s never been done before and whoever runs for President on the Democratic ticket has to deal with that. They’re going to go down with that database and the concerns of those people because they can’t get around it. And he’s [President Obama] been very smart. It’s very powerful what he’s leaving in place.” by NTEB News Desk

Msg 3701, Level 11, State 5, Line 1 Cannot drop the trigger “”, because it does not exist or you do not have permission.
Code World Technology

Today I was implementing some triggers, DDL triggers. I created Alter Table trigger on Database; it was working fine. But when I tried to drop it I got error message like”Msg 3701, Level 11, State 5, Line 1 Cannot drop the trigger “”, because it does not exist or you do not have permission. “. My Trigger: CREATE TRIGGER TRALTERTABLE ON DATABASE FOR ALTER_TABLE AS SELECT ‘TABLE HAS BEEN ALTERED.’ Drop Trigger: DROP TRIGGER TRALTERTABLE Error: Msg 3701, Level 11, State 5, Line 1 Cannot drop the trigger ‘TRALTERTABLE’, because it does not exist or you do not have permission. Solution: If trigger is in Database scope use: Drop TRIGGER connection_limit_trigger on Database If trigger is in Server Scope use: Drop TRIGGER connection_limit_trigger on all server

CLOUD COMPUTING(Basic Concept)
Path of a Coder
Breaking: Maxine Waters Exposes Obama’s National Citizen Database In TV Interview – Includes Video
vineoflife.net
Database Computing is Supercomputing… Some external reading: May 2013
Database Fog Blog
Organizing Qualitative Data
UF BGSO Research Blog: Summer 2013
DBMS on iOS-Devices (4)
iNotes4You's Blog
AlwaysOn Availability Groups (SqlServer 2012)
Asriyar's
Alumni Database
Linux Info

If you are interested to have a web application that have the ability to organize big data of alumni without being worry of email addresses recorded being harvested by the spammer, this is the answer. – by Terong Internet Engineering… Read more… @ Software Downloads –… – http://linuxinfo.org/alumni-database/

Course summary : Information Access & Retrieval
Mr. Bobb

LIS 571 – Information Access & Retrieval Okay, I loved the material in this course. I am already very excited to take its follow up course this summer called “online information retrieval” so that I can go more in-depth into the topics of this course. We’ve all used internet search engines (ISEs). Many of us have used online article databases. However, how many available features have we actually used? Heck, beyond using those features, how many of these features have we really analyzed? This course taught me so much about how to analyze databases and ISEs. My depth of understanding how they work, how terms are interrelated, and so forth has greatly increased my value as an information seeker/searcher. Also, there is so much more out there that I did not know about, even though thousands of others already had. There are databases out there that can search images by inputting a generic drawing that YOU create on the screen ! there are music search databases,

A question for the City of Akron: What about encryption?
The Crisan Chronicles

Last week, on Friday, my city of Akron announced that a group called the Turkish Ajan gained access to databases containing taxpayer information.  In a press release issued on May 20th, the city said the following: “The attackers infiltrated the City of Akron’s computer network in spite of all of the efforts by the City to meet top national standards of intrusion protection systems, firewalls, and virus protection software.” To add insult to injury, Deputy Mayor Rick Merolla was quoted by the Akron Beacon Journal as saying the following: “This has obviously never happened to us before. I’m frankly perplexed that anyone got past our firewalls, which were all up to date.” “We thought we had everything protected. Apparently someone got past the sophistication we thought we had.” The tone of this response quickly gave me pause.  It seems to signal a sense of complacency in the face of the increasingly sophisticated threat that hacktivist groups pose to n

Convert C# to VB.Net
stupidcodes

Free online conversion utility to automatically convert your C# code into VB.NET - and straight back again. http://www.developerfusion.com/tools/convert/vb-to-csharp

Oracle LSNRCTL – Listener Shutdown and Startup Procedures
Oracle Administration for Sys-admins

Starting up and shutting down the oracle listener is a routine task for a database administrator. However a Linux system administrator or programmer may end-up doing some basic DBA operations on development database. It is critical for non-DBAs to understand the basic database admin activities. In this article, let us review how to start, stop, check status of an oracle listener using Oracle listener control utility LSNRCTL. Also refer to our earlier article about how to start and stop the Oracle database How To Start, Stop and Restart Oracle Listener 1. Display Oracle Listener Status Before starting, stopping or restarting make sure to execute lsnrctl status command to check the oracle listener status as shown below. Apart from letting us know whether the listener is up or down, you can also find the following valuable information from the lsnrctl status command output. Listner Start Date and Time. Uptime of listner – How long the listener has been up and running. Listener Parameter F

Database of Furniture Stores in Canada
anjalikalan

Canada’s furniture store industry growth went through a declining phase due to the reduced buying power of consumers. This trend is likely to end with the recent real estate industry development and good prospects in the Canadian job market. In the backdrop of this changing Canadian market scenario – Aarkstore is pleased to include the ‘Furniture Stores in Canada Industry’ market research report in its developing report archive.   Post Canadian economic crisis, the furniture store industry growth fell, the jobs in the job market reduced by 8.3% in the year 2009 and the spending power of the consumer reduced considerably. The economic crisis lead to fall in furniture buying and the high paid families postponed their housing purchase plans. With the 0.2% fall in the furniture store industry earnings in the year 2013, Aarkstore predicts a further fall in the furniture store industry earnings, at an annual rate of 1.7%,during the period 2013-2018.  This scenario is getting complex fo

SQL CASE Statement in DB2
sitealreadyexist

Today we will learn a bit of SQL. This query is tested on DB2 database. The technique that we are going to learn is all about the use of CASE statement or CASE expression. All those guys who familiar with the switch statement of C++ or Java programming language will understand it in a moment. Syntax is very simple and easy to understand. We can use this CASE statement for number of uses. I’ll explain one use of it here. You have to tell me other uses of it in comments. The most frequent use of this statement is renaming of the results on the basis of some column’s value. Let’s have a simple example. CASE(ACTIVE) WHEN 0 THEN ‘Inactive’ WHEN 1 THEN ‘Active’ ELSE” END Now in above example we have an ACTIVE column in a table of our database. We decide on runtime that when we will have 0 in this column against a particular record, then you have to show me Inactive. Same for the 1, when there is the value 1 then show me Active.  I’ll take this example further wi

Resetting password for ODSSM if expired
Nitin's Blog

Goto directory: ORACLE_HOME\domain_database\sysman\log For e.g.Goto directory: D:\Oracle\product\11.2.0\dbhome_1\XYZ.mycompany.com_ORCL\sysman\log Open file : emoms.log  2012-07-30 08:35:03,852 [SystemThreadGroup-8] ERROR app.SessionObjectManager sessionDestroyed.128 – java.sql.SQLException: ORA-28001: the password has expired If, password is expired, you will see following stack trace java.sql.SQLException: ORA-28001: the password has expired  at oracle.jdbc.driver.SQLStateMapping.newSQLException(SQLStateMapping.java:73) at oracle.jdbc.driver.DatabaseError.newSQLException(DatabaseError.java:111) at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:174) at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:472) at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:414) at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:406) at oracle.jdbc.driver.T4CTTIoauthenticate.receiveOauth(T4CTTIoauthenticate.java:857) at oracle.jdbc.driver.T4CConnect

1-2-1 with Baltej (@baltejw)
Sagar Shah - Life as a Graduate

From the success of my last 1-2-1, I have another one of friend’s perspective. Bally (as he is known to me) was also on the same course as me at Nottingham. He has a wealth of internship experience and has taken a different path since uni. Bally’s views are his own, but it is a very interesting read! 1.       Why did you choose a finance and accountancy degree? Why choose a degree that you have minimal experience in? I was not sure what I wanted to do before university but following the advice of both teachers and a careers advisor I made the decision to play to my strengths – numbers and analytical skills. Knowing I was not 100% sure this was the career path suited to me, I chose to do this degree at the University of Nottingham due to the way its course was structured as it allows students to choose from a wide range of optional modules as well as a diversified set of core modules. One example that springs to mind straight away is a core module centred around databases an