Date: 02/26/08 (Open Source)    Keywords: mysql, sql

Sun announced today that it has completed its $1 billion acquisition of MySQL and plans to continue making open source acquisitions as opportunities arise. “Open source is really in Sun’s DNA,” said Sun CEO Jonathan Schwartz, (to the right in the above photo), noting there are many open source companies out there ripe for the [...]

Source: http://feeds.feedburner.com/~r/zdnet/open-source/~3/241616491/

Date: 02/26/08 (Data Management)    Keywords: mysql, sql

Sun announced today that it has completed its $1 billion acquisition of MySQL and plans to continue making open source acquisitions as opportunities arise. "Open source is really in Sun's DNA," said Sun CEO Jonathan Schwartz, (to the right in...

Source: http://blogs.zdnet.com/open-source/?p=2061

Date: 03/03/08 (SQL Server)    Keywords: sql

Hi,

Our daily processing is failling on various stored procedures. Because these stored procedures are launched via a vbscript we are unable to get a meaningful SQL error message being returned by the stored procedure when it fails. What can you recommend to trace an errors. It is related to SQL Server 2000.

Thank you.

Source: http://community.livejournal.com/sqlserver/66253.html

Date: 03/06/08 (Data Management)    Keywords: database, sql, microsoft

Microsoft has begun signing up testers for SQL Server Data Services (SSDS), a forthcoming service that will allow customers and developers to host their data in a Microsoft-hosted database. Microsoft officials were reticent to compare SQL Server Data Services to offerings from any competitors. But Gartner Vice...

Source: http://blogs.zdnet.com/microsoft/?p=1245

Date: 03/11/08 (MySQL Communtiy)    Keywords: mysql, sql

*long story cut out*

Anyone know of a company that uses replication as a way of backing up a MySQL db?  The current solution isn't hacking it right now.

Source: http://community.livejournal.com/mysql/126155.html

Date: 03/11/08 (Code WTF)    Keywords: sql

Автор кода утверждает, что апостроф в Delphi строке можно задать только таким образом:

  sql := 'select ... where ID = #'+inttostr(nomenID)+'#;'
  sql := MakeSymbols(sql);

  procedure MakeSymbols(var SQL: string);
  var
    Poss   : Integer;
    ResStr : string;
  begin
    ResStr := '';
    Poss   := Pos('#', SQL);
    while Poss <> 0 do
    begin
      ResStr := ResStr + Copy(SQL, 1, Poss - 1);
      ResStr := ResStr + #39;
      Delete(SQL, 1, Poss);
      Poss := Pos('#', SQL);
    end;
    ResStr := ResStr + SQL;
    SQL := ResStr;
  end;

Source: http://community.livejournal.com/code_wtf/125530.html

Date: 03/17/08 (Code WTF)    Keywords: sql

Может быть, и не wtf. Как посмотреть...

/// 


/// (see the name of the function)

/// 


/// 

/// 

public static IEnumerable<SqlFieldTypeGroup> GetAllowedSecondOperandTypeGroupsForSpecifiedOperationAndSpecifiedFirstOperandTypeGroup(

Operation operation, SqlFieldTypeGroup firstOperandTypeGroup)

{

  foreach (SqlFieldTypeGroup group in All)

  {

     if (operation.IsOperandTypePairAllowed(firstOperandTypeGroup, group))

          yield return group;

  }

}



 

Source: http://community.livejournal.com/code_wtf/126115.html

Date: 03/20/08 (WebDesign)    Keywords: mysql, software, sql, web, hosting

I just want to make a recommendation for anyone who needs a good website hosting company - I have been using Siteground for over 2 years now and they have been fantastic, reliable, and have a great support system that let´s you have replies from them within only 10 mins!

Apart from that they are CHEAP, but offer much more than other hosting companies with an amazing amount of extra (OS) software included for easy installation and integration and a whopping 750GB of webspace (that´s GIGAbytes, people!), 7500 GB of monthly traffic, free domain name, unlimited MySQL DBs, unlimited email accounts and loads more goodies that are too many to mention!

So here´s the link again, do check them out:
SiteGround is my web host

PS.: Okay, so I get a year of free hosting for every 3 people that sign up, but I didn´t tell you that! ;)

X-posted in geekgirlz

Source: http://community.livejournal.com/webdesign/1370447.html

Date: 03/20/08 (WebDesign)    Keywords: mysql, database, sql, web

If you are reading this and can create MYSQL databases from scratch to make a web app, I need your help and will pay.

Have a prospective client that wants a site that is very DB driven. Needs a quote and have no idea what kind of time frame could be delivered. If I get the project, you get work.

Source: http://community.livejournal.com/webdesign/1370859.html

Date: 03/23/08 (PHP Community)    Keywords: php, mysql, technology, database, asp, sql, java, web

Hey everyone! I'm looking for a coding partner for a website I've been working on since last November. I find myself spending more time figuring out things and less time in actual development of the site--of course the learning could be rolled into the development, but it is apparent to me that more actual code needs to be written if I am to finish by my self-set deadline of the end of May.

The server-side script is done in PHP, the site uses a MySQL database, and there is some Javascript/AJAX implemented on the client-side.

This is probably the wrong place to find a person who has a strong background working with Javascript, but this is probably what I need more than anything since my knowledge is very limited in this area.

I can pay something, and I am open to a payment plan based on the revenue the site generates once it is officially launched.

A little background:

At one time I was a full-time professional photographer... it didn't work out so well since I really couldn't find a way to bring my potential clients to neutral ground in terms of negotiations. I also networked with many photographers in Orlando and around the United States who all seemed to make the same argument and really had a problem managing the administrative side of their business--often times hiring someone else to do it for the sake of not having to deal with it.

After completely bombing in the business in late 2006--a year after getting started, and acquring a full-time job in the technology sector, I got out of the business of actually taking the pictures, but the clients seemed to start pouring in due to the search engines ranking my current website high in returned results for folks looking for photographers in Orlando--where I'm based. There was no way that I could do the work while at the same time working my current job as a laser field service engineer--I wouldn't be in town. The solution was to help some of the photographers who I networked with out so I took care of all of the administrative work and hired them to do the actual photoshoot. We had a 40:60 [me:them] financial arrangement worked out which ultimately brought in about $20,000 last year for myself.

With the business growing, my time becoming more and more valuable, and advice from Mr. Trump [not personally, on T.V. lol] to "think big", I decided to start the National Photographer Group, LLC, and 9photographers.com, to take the whole thing to the web by creating a somewhat self-sufficient website where photographers could, for a monthly charge, use this site to take care of their administrative business--estimates, quotes, invoices, finances, project management, and lead generation.

As aforementioned, I started coding the site in November of 2007 and have put just about every weekend into some aspect of creating this website and business. I have already received many inquires from photographers anticipating the launch of the website.

So, I've been stubborn, to some extent, regarding whether or not I want to have somebody else help me with this script. The last thing that I want is for my script to be snatched up and spread over the web and have the business fail because of that. The business is going to go somewhere... but I'm finding that I really can't do it alone... I need some coding help, hence this entry.

So, if you are interested in working with me to help develop this site, or if you know someone who might be, or can point me in a direction where I can find someone who can help--preferably keeping the business in the U.S.A.-then by all means, please send a comment. Thank you for your time and sorry this was so long.

Lance.

Source: http://community.livejournal.com/php/616702.html

Date: 03/25/08 (Open Source)    Keywords: software, asp, sql, microsoft

Microsoft and Jaspersoft are working together to ensure that Jasper’s business intelligence software suite runs well on the latest editions of Windows and SQL Server. At the Open Source Business Conference at the Palace Hotel in San Francisco, Microsoft told ZDNet that the open source BI software will be optimized for Microsoft’s Windows Server 2008 and [...]

Source: http://feeds.feedburner.com/~r/zdnet/open-source/~3/257942458/

Date: 03/27/08 (Web Development)    Keywords: html, database, asp, sql, web

I have taken over a website from another developer and am learning ASP.net and VB.net as I go. He had report functionality that did a query of the database, threw it in a gridview and then added a few lines of code that let it export from the gridview directly in Excel. The customer had me completely redesign the reports so that they required multiple queries of the database to get all the data and display it properly. I've put it into a basic HTML table. My questions are these:

1) Would it have been possible to manually put the data in a gridview, or is a gridview by definition bound to one sql query (I believe the answer is no, its not possible, but would just like to verify.
2) Is there any way to export info from an HTML table into an Excel spreadsheet? Or is it more a case of having to open a new Excel document and add in each field like I had to for the HTML table?

Any and all thoughts and suggestions are welcomed. Thanks in advance!

Source: http://community.livejournal.com/webdev/472128.html

Date: 03/10/09 (Web Technology)    Keywords: asp, sql, security, web

According to a security group going under the name of TeamElite, the international sites of Kaspersky Iran (kasperskylabs.ir), Taiwan (web.kaspersky.com.tw) and South Korea (kasperskymall.co.kr) are susceptible to SQL injection attacks, allowing the injection of malicious iFrames and potentially assisting malicious attackers into obtaining sensitive data from the web sites in...

Source: http://blogs.zdnet.com/security/?p=2842

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://community.livejournal.com/csharp/101781.html

Date: 02/06/09 (C Sharp)    Keywords: sql

Hello,
First of all, please excuse me for my english.
I have VS2005 Pro. Is there any simple way to programmatically add reference to project on pre-build?
I have a problem with SqlCe reference and bad-known "ProjectAssemblies" folder. So all I need is to add reference before build and remove it after the build. At the moment I'm doing it manually.
May be some VS macro? If not, then may be it could be done by writing a program which will edit solution file before building?
Thanks in advance.

Source: http://community.livejournal.com/csharp/100958.html

Date: 03/10/09 (Data Management)    Keywords: sql, microsoft

After acknowledging a couple of weeks ago that it was changing direction with SQL Data Services SDS, Microsoft officials are filling in the gaps about exactly what will be changing when. by Mary Jo Foley

Source: http://blogs.zdnet.com/microsoft/?p=2273

Date: 02/26/09 (Data Management)    Keywords: sql, microsoft

Whether you call it a "mid-course correction" or a reset, Microsoft is rethinking its "SQL Server Services in the cloud" strategy. by Mary Jo Foley

Source: http://blogs.zdnet.com/microsoft/?p=2162

Date: 03/10/09 (Security)    Keywords: asp, sql, security, web

According to a security group going under the name of TeamElite, the international sites of Kaspersky Iran (kasperskylabs.ir), Taiwan (web.kaspersky.com.tw) and South Korea (kasperskymall.co.kr) are susceptible to SQL injection attacks, allowing the injection of malicious iFrames and potentially assisting malicious attackers into obtaining sensitive data from the web sites in...

Source: http://blogs.zdnet.com/security/?p=2842

Date: 02/22/09 (WebDesign)    Keywords: php, mysql, html, sql, security

I require the services of a PHP Coder for about 2-3 hours of (what should be) simple work. I had a coder do the back end for a client site a few years ago, and php upgrades + less than perfect code (I guess?) has broken a few things that urgently need repairing.

One is a security hole of this nature -
http://www.devshed.com/c/a/PHP/PHP-Programs-to-Prevent-MySQL-Injection-or-HTML-Form-Abuse/

Essentially, anywhere you have a query that includes a $_REQUEST variable (or a variable that came from a $_REQUEST variable), you need to first validate the value of that variable. If it's a category, it should be a-z,A-Z,0-9 and probably should not include any apostrophes or quotation marks.

The other is an inline image resizer so when the client uploads their product images all the thumbnails + display photos are within the site guidelines and don't break the layout.

Please email info AT codebloo DOT com if you're interested. Thanks :)

Source: http://community.livejournal.com/webdesign/1471930.html

Date: 02/17/09 (IT Professionals)    Keywords: sql

SSRS.
Bank in Pleasanton, CA.
Now.
Must pass a 30-minute SQL test.
Must be willing to put up with me for a boss.
No sponsorship.
Details on request.

Source: http://community.livejournal.com/itprofessionals/82126.html