Back to basics for SQL Server 2008
496700
Hand feeding Project Watch: Microsoft 2008 When I asked: "How do we convert more than 12,000 location items - by hand?" we had almost completed the process as part of our move to Microsoft's up-coming SQL Server 2008. The question was, in fact, rhetorical. Nevertheless, we received a lot of advice and suggestions from Reg Dev readers. This, for example, from AlanGriffiths:â¦
767459
Online Impersonations: No Validation Required &gt;&gt; Advertisement &lt;&lt;  ALERT: "How A Hacker Launches A Blind SQL Injection Attack Step-by-Step"!" - White Paper  Blind SQL Injection can deliver total control of your server to a hacker giving them the ability to read, write and manipulate all data stored in your backend systems! Download this *FREE* white paper from SPI Dynamics for a complete guide to protection! https://download.spidynamics.com/1/ad/bsq.asp?Campaign_ID=701600000004c29
86944
DevShed continues their tutorial series looking at working with PHP and databases today with more excerpted material from the O'Reilly book "Programming PHP, Second Edition" (by Kevin Tatroe, Rasmus Lerdorf, and Peter MacIntyre).   Picking up from where we left off last week, we'll be discussing shortcuts, query responses, metadata, and more.   They start off looking at shortcuts, those handy things the PEAR DB package offers to make life simpler (like getRow and getAssoc) before moving on to how to get the details about the response itself (like affectedRows and tableInfo). Next up is working with the metadata (using getListOf) and, finally, a sample application to tie them all together.
732440
The International PHP Magazine has posted results from their latest PHP community poll as voted on by visitors to their site. The question for this poll asked developers what they thought, of the choices on the list, was the most common mistake that PHP developers make.   Coming in at number one by an overwhelming lead was "Not escaping entities and SQL input" (a definite problem indeed) with the next highest option, "Not using a Framework" a full twenty percent lower. The next two options were closer (descending) - "Using old PHP versions" and "No or little use of Object Orientation".   There's a new poll this week for your consideration - this time asking which stage, of the five options, should come first in the development cycle of a typical content management system. Head on over and cast your vote today!
250953
New from Codewalkers.com today: Take a look whether or not to migrate your Access data to MySQL and then how the migration can be done with the help of Navicat, a MySQL database administration GUI, in our newest tutorial.
694460
Microsoft Corp. released Service Pack 2 (SP2) for SQL Server 2005 on Tuesday, a free upgrade [&lt;a href="http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/servicepacks/sp2.mspx"&gt;available for download&lt;/a&gt;], in addition to new virtualization licensing for the database.
499343
On the "Blond R" blog, there's a first posting that shares some of the knowledge that the author has gained from working to get IIS7 installed with MySQL and PHP 5.   As all of us are talking about the new coming Windows Vista, I decided to dedicate my first post to guide you all on how to setup IIS 7 along with MySQL and PHP 5.   He hadn't found a tutorial that covered getting all three working well together, so decided to create his own - complete with screen shots for each step of the way. First, IIS is set up, then PHP, then, finally, the MySQL installation is completed and all three are tied together. All downloads are linked as well to make it even easier to set your system up.
710066
DevShed continues their series covering SQLite in PHP5 today with the final tutorial - "Additional Methods for Using SQLite with PHP 5":   The list of additional features offered by SQLite is really impressive. Therefore, in this last article of the series, I'll be taking an in-depth look at them. This will complete our analysis of this excellent RDBMS integrated with PHP 5.   First up is a look at the usage of the seek and lastInsertRowid functions followed by the changes and queryExec methods. They show how to use the createFunction method and show one of the more advanced features of SQLite - creating a database that only exists in the server's memory.
660083
Ivo Jansch has a recent post made the other day that takes a look at one of the recent offerings from IBM targeted at PHP developers - the functionality to allow PHP to run on their System i platform.   Some of the developers at Ibuildings are working with PHP on IBM's System-i platform. If that name doesn't ring a bell, it has been called 'iSeries' for a while and it's basically a new name for the old AS/400. [...] Recently IBM and Zend have teamed up to port PHP to the i5/OS operating system. So far this port seems succesful; one of the reasons is perhaps that PHP is easier to adopt by traditional System-i developers than Java, which forces you to learn Object Oriented Programming.   He makes mention of the db2 database extension you can use to access the database as well as a "i5 toolkit" to help with the same. He even links to an article talking about it.
353719
SQL Server 2005 offers compelling reasons to embrace the Microsoft Business Intelligence platform for information needs across your enterprise. This paper explains the extensive feature set from the perspective of business value. It will help you make informed decisions about upgrading or migrating your business intelligence platform to SQL Server 2005.
453962
TechWeb - The software will ship this summer. It had been scheduled for February, along with major upgrades of Windows Server and SQL Server.
393153
Sometimes, a technology sounds like a great, simple answer to all of your problems. That, however, was not the experience of this blogger when checking out SQLite on Windows.    My first task at my new job was a simple enough one. All our customers have a review site that has a list of contacts. The file was contacts.html and it was just a static html file.   Since there are already 100s of sites using the static html, I wanted to avoid any kind of complex migration or external database. I decided to give SQLite a try since the db files are so portable. Each site would have it's own database with a single contacts table. Simple right? Let me go over all the problems I ran into.    He starts off with the fact that SQLite 3 doesn't work with PHP (different client drivers in PHP) and that PHP doesn't like SQLite 2 all that much either. His third and final experience? That SQLite isn't the brightest when it comes to working with directory permissions.
74747
Microsoft said on Tuesday that its Visual Studio 2008 IDE (integrated development environment) is now widely available.The tool set was released to Microsoft Developer Network subscribers in November. It is now available to volume licensing and retail customers, the company said in a blog posting.It includes a new version of the .NET framework, version 3.5, which is aimed at taking advantage of two new subsystems Microsoft included in Windows Vista -- WCF (Windows Communication Foundation) and WPF (Windows Presentation Foundation). WCF is for building service-oriented applications, while WPF is for creating more dynamic user interfaces. Microsoft also built Visual Studio 2008 with the idea of making it easier for developers to create cross-platform applications.Visual Studio comes in various editions, from a free version called Visual Studio Express to a version for entire developer teams called Visual Studio Team System. More information is on the MSDN site.Visual Studio is one of the three products that Microsoft will highlight in a launch event in Los Angeles at the end of next month. The other two are Windows Server 2008 and SQL Server 2008. Those other new products won&#39;t both be available at that time, however.The new version of Microsoft&#39;s server OS is expected to be available on the day of the launch, but last week Microsoft pushed back the release of SQL Server 2008 until the third calendar quarter of the year. It had said previously that the software would be available by midyear.
310574
Cal Evans has posted a tutorial on the Zend Developer Zone (posted today) about using the PEAR Structures_DataGrid package to create quick and easy data tables.   In this article, I'll be introducing you to the Structures_DataGrid package, showing you how it can be used to display structured data in tabular form. I'll be showing you how to hook it up to various data sources (including a CSV file, an RSS feed and an Excel spreadsheet), and how to format the resulting output so it's as pretty (or as ugly) as you want it to be.   They talk about what you'll need to get started (the different packages for different kinds of data) and some sample code to help you down the path to more attractive tables. There's even a bit touching on some of the more advanced features like exporting to Excel, pagination and data sorting.
133632
BREAKING NEWS - In the clearest sign to date that not all is well in the state of Redmond, Microsoft cheerfully announced this morning that the release date for Windows Server 2008 is being pushed back to Q1 2008.
209595
(InfoWorld) - Looking to assist developers in building business applications, Microsoft published a second beta version of ADO.Net Entity Framework this week and a community technology preview of tools to work with the framework. The goal of the ADO.Net Entity Framework is to eliminate the impedance mismatch between data models and languages, saving developers from having to deal with these. An example of such a mismatch is objects and relational stores. Automation of complex processes is critical to the framework. "Today, when a developer builds an application, they have to write code that fills in the gaps between the way the data is stored in however many databases they interact with and the way they want to manipulate the data in their application," said Britt Johnston, product manager for data programmability tools at Microsoft. "Generally, what they do is create an object model that they write their code against." Developers might write an application that manipulates a CRM system with data for customers stored in 12 different tables, said Johnston. "With the Entity Framework, you can automate the process essentially of bringing all that data together and presenting it to the developer as a single entity so they can interact with it at a higher level of abstraction," Johnston said. Key new features in the framework beta release include events to customize code generation; complex programming types and entity key serialization. A key is a unique identifier for an entity, such as a customer ID. Metadata annotations and better support for LINQ (Language Integrated Query) also are included. LINQ features extensions to the .Net Framework to encompass language-integrated data query, set, and transform operations. Developers can access the framework on Microsoft's Web site. ADO.Net Entity Framework is due for general release as part of .Net Framework 3.5 in early-2008. Most would get it as part of an operating system update. The ADO.Net Entity Framework Tools Community Technology Preview for August features an early version of the ADO.Net Entity Designer, enabling users to visually design model and mappings using the Visual Studio 2008 Beta 2 release. The tools preview is accessible on Microsoft's download page with the tools to be part of Visual Studio 2008. With the framework, developers could focus on the needs of an application instead of the complexities of bridging disparate data representations. The framework consists of a data model and design-time and run-time services that allow developers to describe application data and interact with it in a conceptual level of abstraction appropriate for business applications, according to the company. This helps isolate the application from underlying logical database schemas.
319638
In this new tutorial on PHPBuilder.com, Ken Lin demonstrates how to import some data from an MS Access database into the most recent version of MySQL (version 5).   In this article, I will discuss whether or not to migrate your MS Access data to MySQL. Then, I will cover about the considerations, planning, and preparations which should made before migrating your data.   He follows the (good) practice of plan first, shoot later when approaching the subject. He talks about the differences between the two systems, when to and not to make the import jump, and some steps to do to prepare things for the leap.   He choses the Navicat tool to make the transition, stepping through the process the import wizard will follow to make the push much easier than a manual import/export.