Date: 07/13/08 (See my site)    Keywords: database, web, seo

                            Be Something!!

TalentZoo.com is THE website communications professionals and executives, job seekers, and media-savvy people frequent for:

• Information on the company's offline class recruitment services
• A kick-ass job board with the most coveted positions in the advertising, marketing, public relations, broadcasting, and publishing fields
• A resume database employers with Talent Zoo accounts can browse when looking to make their next hire
• Up-to-date industry news
• Industry resources, including articles, podcasts, blogs, and even a salary monitor for professionals to measure their worth
• Our Rookie Directory, where communications professionals with less than 2 years' experience can get their names in front of top employers looking for young talent
• We are currently seeking Bloggers who specialize in Marketing, Advertising, Public Relations!!  Take a look at our blogs:
• www.beneaththebrand.com; www.beyondmadisonavenue.com; www.flackme.com; www.12pointtype.com; www.digitalpivot.com; www.seoshootout.com

Interested?  See our website at: www.talentzoo.com

Source: http://community.livejournal.com/see_my_site/116084.html

Date: 09/02/13 (Web Development)    Keywords: php, database, web, hosting

Hi,

I downloaded the Wordpress source files to my development environment, where I am playing around with new features and adding content.
Now that I have a better comfort level with Wordpress, I'd like to migrate my blog content to my production server through FTP.

I understand I also would have to migrate the database too, since that's where all my content is stored.

Should I go through the installation process on my production server, and then copy the modified databases over to production? Or should I just paste all of my PHP source files from dev into a new folder on my server and assume that things will work (I guess that is kind of a silly question?)

Is there anything I should be aware of when pasting the files in Production and logging into it? My biggest concern is while I am going through the installation again, someone else could be trying to go through the Wordpress files as I am configuring my blog environment for the first time.

I can't change the database names on my server, since it is going through a web hosting company, so perhaps it is better to go through the installation again in production, and then migrate the content from the databases.

Your help is greatly appreciated!

Thanks!

Source: http://webdev.livejournal.com/583728.html

Date: 02/11/11 (Web Development)    Keywords: programming, css, html, technology, database, web, seo

Inkwell Creative, a growing Portland, Oregon company focusing on web design, graphic design, interactive media, video and branding, is looking to hire a web developer. We are seeking a hard working team player and someone who is forward thinking when it comes to technology. You must be able to work with us in a collaborative team setting, know many coding and web programming languages and have a strong portfolio.

Requirements:
5+ years of experience
Strong portfolio
Must be collaborative
Knowledge of many coding/web development languages
Knowledge of CSS and HTML 5, Content Management Systems, Flash, SEO programming, Integration into Databases
Knowledge of iPhone apps a plus

Compensation:
DOE. Benefits and paid-for parking. This is a salary position.

TO APPLY:
Email a cover letter, resume and link to your online portfolio to hr@inkwellgroup.com. Please include in your cover letter any outside hobbies, passions and interests. We kindly request no phone calls and no employment agencies.

APPLICANTS WITHOUT A COVER LETTER, RESUME AND PORTFOLIO WILL NOT BE CONSIDERED

Source: http://webdev.livejournal.com/573896.html

Date: 12/28/10 (Web Development)    Keywords: database

I want to create a database of information, and I want to be able to support multiple tags to improve search capabilities.
I'm not sure what is the best way to implement such a (tag) system.
Wondering if anyone can point me in the right direction?

Source: http://webdev.livejournal.com/572544.html

Date: 09/26/11 (PHP Community)    Keywords: php, database, sql, microsoft

I've got a Microsoft Access application that I'm going to have to convert to PHP and another database (PostGres or SQLite). The db portion I could do by hand if I needed to (the tables are not complicated). It's the forms that I'm worried about.

Does anyone have any experience with a tool for converting Access forms to PHP code? I found DB Convert, which looks promising, but I'd like to know about anyone's first-hand experiences.

Source: http://php.livejournal.com/682814.html

Date: 02/11/11 (PHP Community)    Keywords: programming, css, html, technology, database, web, seo

Inkwell Creative, a growing Portland, Oregon company focusing on web design, graphic design, interactive media, video and branding, is looking to hire a web developer. We are seeking a hard working team player and someone who is forward thinking when it comes to technology. You must be able to work with us in a collaborative team setting, know many coding and web programming languages and have a strong portfolio.

Requirements:
5+ years of experience
Strong portfolio
Must be collaborative
Knowledge of many coding/web development languages
Knowledge of CSS and HTML 5, Content Management Systems, Flash, SEO programming, Integration into Databases
Knowledge of iPhone apps a plus

Compensation:
DOE. Benefits and paid-for parking. This is a salary position.

TO APPLY:
Email a cover letter, resume and link to your online portfolio to hr@inkwellgroup.com. Please include in your cover letter any outside hobbies, passions and interests. We kindly request no phone calls and no employment agencies.

APPLICANTS WITHOUT A COVER LETTER, RESUME AND PORTFOLIO WILL NOT BE CONSIDERED

Source: http://php.livejournal.com/681768.html

Date: 04/16/10 (PHP Community)    Keywords: php, database, sql

I have a person's name with a non-standard ascii character in it (š) and am having trouble converting to back to ascii to retrieve their record.

The url string contains: mašalaitis
But PHP reads it as: mašalaitis

So, my SQL is basically not finding what is stored in the database (former) with what the querystring contains (latter). I'm trying to use ORD() based on the specific value that š outputs (154) and add � to the beginning, and ; after.

But, this is what it shows when I loop through the whole name:

109 = m
97 = a
197 = �
161 = �
97 = a
108 = l
97 = a
105 = i
116 = t
105 = i
115 = s

Any help is greatly appreciated.

Source: http://php.livejournal.com/677993.html

Date: 03/29/10 (PHP Community)    Keywords: database

I am creating a database that records people's work activities and want to use drop down menus to clean up the values they enter. They get paid based on their activities and roles, so I don't want a lot of user error.
Right now, I'm using the same table for people to add or edit their entries, and people could say if a conference they went to was, for example, university, national or international in scope.
The code right now is:
" size="60" />
How do I add a drop down menu to this that still calls the existing value (if one exists) but allows them to add or edit other selections?

Source: http://php.livejournal.com/677556.html

Date: 12/04/09 (PHP Community)    Keywords: database

Hi Guys!

Another dumb question from the peanut gallery!

If you're writing a bunch of classes that will run an application, where is the best place to have your database connection(s)? Would it be in the file that ends up interfacing with the user and receiving/displaying data, in the class files themselves, or some other location?

Thanks!

Edit: If the answer is in the calling files, how would you make sure your classes used it, and how would you pass it across pageclicks?

Source: http://php.livejournal.com/674926.html

Date: 02/21/09 (C Sharp)    Keywords: cms, database, sql, web

First off, I'll state that I'm working with C# 2008 express edition, SQL Server 2008 Professional edition, and .NET 3.5.

Second, I'll state that one of the ideas behind this project is to do it without .Net's auto-binding. If it can't be done without auto-binding, it's not going to get done at all, for reasons having to do with extreme customization of the data access code that will be happening way, way down the line. So I need an answer in code, not in designer. Thanks.

Okay, what I'm doing seems to me to be simple and obvious, but either .Net doesn't agree with me or I'm looking in the wrong place. I have a simple form. It contains a datagridview and three buttons. One button works perfectly--it's the one that closes the form, and we don't need to discuss it here. The other two buttons, however, are giving me fits. They are labelled "save changes" and "cancel".

The datagridview is bound to a DataTable. This is pretty standard code, I think:

SqlConnection cnErasmus = new SqlConnection();
            //populate the datatable with the data already in the table.
            tblAuthorType = PopulateDataSet(cnErasmus);
            //Attach DataTable to datagrid.
            dgvAuthorType.DataSource = tblAuthorType;

        private DataTable PopulateDataSet(SqlConnection cnErasmus)
        {
            string strAuthorTypeSelectQuery = "SELECT AuthType FROM AuthorType";
            using (cnErasmus)
            {
                using (SqlCommand cmSelectCommand = new SqlCommand(strAuthorTypeSelectQuery, cnErasmus))
                {
                    CreateConnectionString(cnErasmus);
                    OpenConnection(cnErasmus);
                    using (SqlDataReader theReader = cmSelectCommand.ExecuteReader())
                    {
                        tblAuthorType.Load(theReader);
                        CloseConnection(cnErasmus);
                    }
                }
            }

/******************SqlTransaction trnchangeAuthorTypeData = 
       cnErasmus.BeginTransaction("Changes");
            //Must assign both transaction object and connection
            //to Command object for a pending local transaction.
            SqlCommand cmTransactionCommand = cnErasmus.CreateCommand();
            cmTransactionCommand.Connection = cnErasmus;
            cmTransactionCommand.Transaction = trnchangeAuthorTypeData;
            //Whether transaction is committed or rolled back depends
            //on which button the user presses...********************/

Source: http://csharp.livejournal.com/101781.html

Date: 08/01/10 (Apache)    Keywords: mysql, database, sql, jsp, web, linux

I'm involved in migrating an existing, functional JSP/Struts2 app from Windows to Linux.

The former Windows environment was a Tomcat/Struts/Eclipse setup. The new environment is a standalone installation of Tomcat (which is already configured and serving several other applications).

The app in question, "MyJSPWebsite", was copied to the Linux/Tomcat webapps folder and correct permissions assigned. The database (mysql) was also copied over with user permissions established.

The site now opens, but none of the struts enabled content is functioning. For example, a drop-down list of data is not being populated. I'm not seeing any error SQL messages in catalina.out, and the username/password & query work fine from command line.

Are there separate, core struts files that have to be installed outside of those already included in the webapps/MyJSPWebsite folder?

Source: http://apache.livejournal.com/44268.html

Date: 06/08/12 (SQL Server)    Keywords: database, sql

Does anyone have any experience on this group in working with Unicode, double-byte case-sensitive data in SQL 2008 R2?

I would like to select a collation for my database that allows case-sensitive sorting/comparisons with Unicode data that could contain Japanese characters.  Whew...that's hard to say.

Source: http://sqlserver.livejournal.com/76773.html

Date: 10/10/11 (SQL Server)    Keywords: database, sql

I came across this article when doing some more research on documenting database growth over time.  It worked really well for me.

Thank you vyaskn@hotmail.com!

In this article I am going to explain, how to track file growths, especially the database files. First of all, why is it important to track database file growth? Tracking file growth, helps you understand the rate at which your database is growing, so that you can plan ahead for your future storage needs. It is better to plan ahead, instead of running around when you run out of disk space, isn't it? So, how can we track file growths? There are a couple of ways.

The first approach:
SQL Server BACKUP and RESTORE commands store the backup, restore history in the msdb database. In this approach, I am going to use the tables backupset and backupfile from msdb to calculate the file growth percentages. Whenever you backup a database the BACKUP command inserts a row in the backupset table and one row each for every file in the backed-up database in the backupfile table, along with the size of each file. I am going to use these file sizes recorded by BACKUP command, compare them with the previous sizes and come up with the percentage of file growth. This approach assumes that you do full database backups periodically, at regular intervals. 

Click here to download the procedure sp_track_db_growth. ...

**Please use free code responsibly.  Test and verify before deploying to production!

Source: http://sqlserver.livejournal.com/75793.html

Date: 07/20/11 (SQL Server)    Keywords: technology, database, sql

--------------------------- -------------------------------------------
1-2 years of total
database experience
required (preferably
Oracle, Sybase, or SQL
Server)
Experience with Windows
Server operating systems
Experience with creating
SQL scripts and setting up
typical database
maintenance jobs
Experience working with
development teams
------------------------------------------------------------------------
The Database Administrator
1 will participate in
departmental projects by
assisting in the
development of project
plans, documentation, and
performing of project
tasks. In support of the
other DBA’s, He/She will
perform daily maintenance
tasks and participate in
DBA on-call duty. The DBA
I position will be
responsible for installing
and maintaining database
technology in a
multi-platform mission
critical environment.
------------------------------------------------------------------------
CONTACT:
Jennifer Toal
Research Analyst
COMTEK-Group
972-792-1045 Office
972-467-2901 Mobile
972-644-6602 Fax

Source: http://sqlserver.livejournal.com/75585.html

Date: 06/02/11 (SQL Server)    Keywords: database, asp, sql, security, microsoft

Passing this along for a friend...If you know anyone looking, please let me know.  Pay terms seem to be a little higher than normal for that many years of experience.  

Responsibilities:

• Installation, configuration, customization, maintenance and performance tuning of SQL Server 2005 & 2008 including SSIS, SSAS and SSRS.
• SQL version migration, patching and security management.
• Monitor database server capacity/performance and make infrastructure and architecture recommendations to management for necessary changes/updates.
• Perform database optimization, administration and maintenance (partitioning tables, partitioning indexes, indexing, normalization, synchronization, job monitoring, etc).
• Manage all aspects of database operations including implementation of database monitoring tools, event monitoring, diagnostic analysis, performance optimization routines and top-tier support for resolving support issues.
• Work with internal IT operations teams to troubleshoot network and server issues and optimize the database environment.
• Establish and enforce database change management standards including pushes from development to QA, on to production, etc;
• Proactively stay current with latest technologies and industry best practices associated to the position and responsibilities.
• Provide development and production support to troubleshoot day-to-day database or related application issues.
• Develop, implement and verify processes for system monitoring, storage management, backup and recovery.
• Develop, implement and verify database backup and disaster recovery strategies.
• Design and implement all database security to ensure integrity and consistency among the various database regions
• Develop and maintain documentation of the production environment.
• Manage SLAs and strict adherence to production controls - Sarbanes-Oxley (SOX) monitored via external audits

• Must have experience on SQL Server 2005.
• Good exposure on Installation, Configuration of database Clusters, Replication, Log shipping and Mirroring
• Expertise in Troubleshooting and performance monitoring SQL Server Database server (Query Tuning, Server Tuning, Disk Performance Monitoring, Memory Pressure, CPU bottleneck etc.)
• Expertise in T-SQL and writing efficient and highly performing SQL Statements.
• Expertise in SQL Server Internals, wait events, profiler, windows events etc
• Must have understanding of key infrastructure technologies such as Clustering, SAN Storage, Virtualization, Cloud services etc.

• System administration fundamentals including Installation, Configuration & Security setups.
• Experience with SQL 2008 a plus.
• Experienced in architecting high availability, business resumption and disaster recovery solutions
• Microsoft SQL Server DBA Certification
• Experience with SCOM/SCCM/SCSM is a plus
• Extremely self motivated and ability to work within a globally dispersed team.

• Data Warehouse experience
• VLDB experience highly desired
• Experience with databases > 5 TB, processing 2 million + rows of data daily
• MS SQL Server 2005 Transact-SQL (T-SQL)
• Stored Procedure Development Communication Skills, work well with the team, and within team processes
• Database and file size and space forecasting ability
• Ability to manage a complex database system and assist the client with Database Integration for Future Business Intelligence efforts
• Confio Ignite Performance

• Bachelor's degree in Computer Science, Business Administration or other
• 10+ years experience as a Database Administrator 

Source: http://sqlserver.livejournal.com/75423.html

Date: 05/06/11 (SQL Server)    Keywords: database, security

In our last entry, we introduced the concept of code review procedures.  Our first topic to consider in this life cycle is for the developer to take some time to understand the Business Requirements and Functional context.  These two critical tasks should in a perfect world be understood by all dba's in the SDLC of database code, but the developer has a unique opportunity to let his/her code communicate these requirements and context though coding best practices and adequate documentation.  Some items a developer, or a peer can look for in performing these 2 steps are the following:

Satisfying Business Requirements & Functional Context

• Has a knowledgeable user been consulted during the planning/architecture phase of code creation?

• Did the architect make specifications for future growth and change needs of the application?

• Has the developer reviewed the business requirements?

• Do the developer and the business have the same understanding for required performance of the application?

• Does the reviewer understand the code being reviewed?

• Does your code adhere to corporate coding specifications (Yes, this is a business requirement, too)

• At what layer in your business environment does the code execute?

• Does the piece of code functionally achieve the stakeholder's need as documented in the project charter ?

• What is the data size and volume worked with in this code?

• What are the data archival requirements?

• Have company security policies been complied with?

• How will the application or change be installed and configured?

• By what method will the development team preserve and version the code and objects affected?

adina_atl

Source: http://sqlserver.livejournal.com/74884.html

Date: 03/10/11 (SQL Server)    Keywords: database

 We create a database called ADMIN which stores our administrative information such as file space statistics. We use a combination of extended stored procedures and publicly-available code to log these statistics. Here is a samples:

/* Get current space statistics. You can run this and store the results in a holding table. */

CREATE PROCEDURE [dbo].[sp_file_space] @server_name sysname, @id int
as

declare @dbname sysname
declare @cmd varchar(700),
@lname_len int,
@fname_len int,
@fgroup_len int

set nocount on

select @cmd = 'use [?] select ' + convert(varchar,@id) + ',''' + rtrim(@server_name) + ''',db_name(),logical_name = name,fileid,upper(substring(filename,1,1)),filename,
filegroup = filegroup_name(groupid),
size_in_KB = size * 8,
maxsize_in_KB = (case maxsize when -1 then 0
else
maxsize * 8 end),
growth = (case status & 0x100000 when 0x100000 then growth else growth * 8 end),
KB_growth_flag = (case status & 0x100000 when 0x100000 then 0 else 1 end) ,
usage = (case status & 0x40 when 0x40 then ''Log Only'' else ''Data Only'' end)
from sysfiles order by fileid'


exec sp_MSforeachdb @command1=@cmd

return 0


GO

** Please be responsible with free code. Test and check before implementing in a production environment

Source: http://sqlserver.livejournal.com/73512.html

Date: 03/09/11 (SQL Server)    Keywords: database, sql

 Here's a good question for data environments today.  What methods do you employ to track datafile growth in your SQL Server databases?  Do you use a 3rd-party tool, or do you have a home-brew method?  I'll share my method once we read about other's ideas.

Source: http://sqlserver.livejournal.com/73430.html

Date: 11/08/10 (SQL Server)    Keywords: database, security

I have a user who locked himself out of a database because his default db went into suspect mode.  His security policy was nice enough to bar anyone in the Windows Administrators group from logging in to the db.  He says he can't remember the two passwords for the administrative logins currently assigned to System Administrator  role on the server.  Any hope here?  I think he's screwed, personally.

Source: http://sqlserver.livejournal.com/72656.html

Date: 05/23/08 (Algorithms)    Keywords: database, google

Almost ever since I got acquainted with category theory it seemed to me like a perfect tool for formalizing database queries and their properties, and, consequently, for building optimization frameworks.
I am considering this for my thesis, but I can't find any work about applying category theory to query optimization, and this frightens me a bit: looks like someone has long ago proved that this is impossible (why would it be?), and now noone even tries.

Could you give me pointers to some works on the topic? I've googled the hell out of the internet, I found some works on formalizing data models with CT but nothing on exactly optimization.

Source: http://algorithms.livejournal.com/99763.html