sql: search

LINQ to SQL Paging using GridView in VB and ASP.NET 3.5

LINQ to SQL Paging using GridView in VB and ASP.NET 3.5. This tutorial will show you how we can extend the LINQ to SQL Class and create methods that will allow us to page data from a SQL database. VB version.

Diagramming Tool For SQL Select Statements

alxtoth writes "Snowflake is a new BSD-licensed tool that parses SQL Select statements and generates a diagram. It shows parts of the underlying SQL directly in the diagram. For example: x=30, GROUP BY (year), SUM (sales), HAVING MIN (age) > 18. The primary reason for the tool was to avoid Cartesian joins and loops in SQL written by hand, with many joined tables. The database will execute such a statement, if syntactically correct, resulting in runaway queries that can bring the database down. If you sit close to the DBAs, you can hear them screaming... "

Sybase iAnywhere Targets Web Developer Community with New Version of SQL Anywhere

Sybase iAnywhere has announced its new initiative to deliver SQL Anywhere for the web developer community. In addition to a number of web development features found in SQL Anywhere Version 11, its newest release, the company has also unveiled a new Web Edition that allows developers free SQL Anywhere Server database deployment.

Sybase iAnywhere Targets Web Developer Community With New Version of SQL Anywhere

LAS VEGAS --(Business Wire)-- Sybase iAnywhere today announced its new initiative to deliver SQL Anywhere(R), its industry-leading data management system and powerful synchronization solution, for the web developer community. In addition to a number of web development features found in SQL Anywhere Version 11, its newest release (see related announcement), the company has also unveiled a new Web Edition that allows developers free SQL Anywhere Server database deployment.

SQL Server 2008 New Features - Merge Statement

In this article Nidal examines the usage of a SQL Server 2008 feature named Merge statement. It is a new TSQL Statement that allows you to perform join of tables and then apply one of three different operations on the result set. He demonstrates the concepts with the help of step-by-step explanations accompanied by relevant SQL statements. More...

C#. ASP.Net, SQL Server, T-SQL, XML, AJAX, Web Services

Copyright © 1995-2008 CNET Networks, Inc. All rights reserved

OP-ED: Why LINQ to SQL is a Better Option than Straight SQL

I understand how malicious code can be created. Years ago I, figured out to embed the Michelangelo virus in the old command.com, have command.com open the speaker port and leave a permanent beep on, and even wrote a keyboard sniffer based on BIOS interrupts. This was almost twenty years ago and that's where I left my curiosity. So, other then helping the occasional friend get rid of bots, worms, and popup cheese whiz, I am by no means an expert at malicious code. In fact, I wish the authors of such code would just get a life.

SQL Server 2008: First Impressions

After the nine-hour download of the real SQL Server 2008 RTM from MSDN completed, I began the task of getting it installed on my new development system. It's an Intel Quad Core Duo with (only) 4GB of RAM, so you'll get an idea about how fast it is in comparison to yours when I start talking about timings.

SQL Injection Turns BusinessWeek Into Viral Replicator

martins writes "The website of popular magazine BusinessWeek has been attacked via SQL injection in an attempt to infect its readership with malware. Hundreds of pages in a section of BusinessWeek's website which offers information about where MBA students might find future employers have been affected."

New SQL Injection Attack Fuses Malware, Phishing

PainMeds tips a recent post in Secure Computing's research blog describing a new SQL injection attack that had infected thousands of MSSQL-based web servers by last weekend, turning them into malware delivery systems. The attack apparently rewrites the server's Web pages to include JavaScript which pushes malware to the visitor as if it were from the genuine site. Sites using Sybase might possibly be vulnerable, as it uses the same exploited syntax that MSSQL does. The post includes an example of the attack. Unlike most malware attacks, this one appears to originate from the site the user is actually visiting. From the blog: "'Similar to phishing, this attack takes advantage of the website visitor's trust in the site they are visiting. Instead of phishing for information, however, malware is sent to the client, which the client has a high

Custom LINQ to SQL Methods to Add Edit Delete in VB.NET

This tutorial will show you how to write your own LINQ methods to enable adding, editing and deleting of data in a SQL database. VB version.

MapReduce Goes Commercial, Integrated With SQL

CurtMonash writes "MapReduce sits at the heart of Google's data processing — and Yahoo's, Facebook's and LinkedIn's as well. But it's been highly controversial, due to an apparent conflict with standard data warehousing common sense. Now two data warehouse DBMS vendors, Greenplum and Aster Data, have announced the integration of MapReduce into their SQL database managers. I think MapReduce could give a major boost to high-end analytics, specifically to applications in three areas: 1) Text tokenization, indexing, and search; 2) Creation of other kinds of data structures (e.g., graphs); and 3) Data mining and machine learning. (Data transformation may belong on that list as well.) All these areas could yield better results if there were better performance, and MapReduce offers the possibility of major processing speed-ups.

Amazon's EC2 to offer Windows, SQL Server options

Amazon said on Wednesday that it plans to offer its cloud computing customers the option of running Microsoft's Windows Server operating system as well as its SQL Server database.

Sybase iAnywhere Targets Web Developer Community With New Version of SQL Anywhere

LAS VEGAS - Sybase iAnywhere today announced its new initiative to deliver SQL Anywhere®, its industry-leading data management system and po

The easy ways hackers exploit your applications: beyond SQL injection and cross-site scripting

We always hear about how attackers can break into your organization through the website because it far easier than trying to circumvent network defenses. Attackers will leverage critical vulnerabilities like SQL Injection (SQLi) and Cross Site Scripting (XSS) to steal personal, financial, or customer data while compromising your internal systems.

The easy ways hackers exploit your applications: beyond SQL injection and cross-site scripting

We always hear about how attackers can break into your organization through the website because it far easier than trying to circumvent network defenses. Attackers will leverage critical vulnerabilities like SQL Injection (SQLi) and Cross Site Scripting (XSS) to steal personal, financial, or customer data while compromising your internal systems.

VB.Net developer required Ã,Â- Central Scotland

My client based in central Scotland requires a VB.Net, SQL Server developer to join their team for a 6 month project. I have interview slots available for the right calibre of .Net professionals so contact me immediately on 0131- 243 4000 to hear more about this excellent project. Please apply with an updated version of your CV to be immediately considered for this role. Required skill set: VB.Net, VB6, Visual Studio, Win Forms and SQL Server 2005. (Computer Futures Solutions Limited acts as an Employment Agency and an Employment Business)

Great Plains Consultant Newsflash: Custom EDI Alba Spectrum

Great Plains Consultant Newsflash: Custom EDI – Alba Spectrum - Microsoft Dynamics GP ERP application, or popular old name Great Plains Dynamics and eEnterprise, if you have relatively recent version, is based in Microsoft SQL Server. If you are experienced SQL DBA yourself, just this fact should give you the idea on structuring select statement and make it Electronic Document Interchange code compliant. Of course, for luxury EDI solution you can purchase Add-Ons and simply setup EDI export in the user friendly interface, however this publication is for people, who are either on the tight budget, or who have really complex EDI requirements and data format export rules. This news should also ideally help you with your Great Plains Partner, ISV and technical consultant and programmer selection: 1.

Increasing Interest in Open-Source Databases

Open-source databases have been available in the enterprise database market for several years now. Until recently, they didn’t come anywhere close to competing with the major database platforms such as SQL Server, Oracle, Sybase, and DB2. However, we are now seeing a proliferation of open-source databases in the enterprise database market that are being used with web applications and other portals in the enterprise. Recently, I asked Noel Yuhanna, a principal analyst for Forrester Research, what his thoughts were about open-source databases in the SQL Server market.

SQL Server files for my Data Access Videos

A couple of folks have emailed me because that haven't been able to reconstitute the Video Database I've been using in the Data Access video tutorials. More...

Brim SQL Injection and HTML Injection Vulnerabilities

Copyright 2008, SecurityFocus

Greenplum Combines SQL & MapReduce

Greenplum, the grandest of the open source-based databases, whose massively parallel shared-nothing architecture supports petabyte data warehousing on cost-effective general-purpose hardware and promises linear scalability on thousands of processors, has pushed out its latest cut, rev 3.2, making it the first commercial database, the company says, to include MapReduce, the parallel computing technique pioneered by Goggle and copied by Yahoo’s Hadoop for analyzing the web.

Search took 0.02 seconds.