As part of the launch of SQL Server Migration Assistant (SSMA) for Oracle, Microsoft is looking for the most compelling Oracle to SQL Server migration story.
Other News
Analyzing Requirements and Defining Microsoft.NET Solution Architectures, Part XI
(Chris Sully) The aim of this series of articles is to provide an overview of issues surrounding the architecture of .NET Solutions. In doing so it is following Microsoft’s recommended approach and, in particular, looking at the requirements of the related Microsoft certification exam (70-300), whic
FIX: You receive an ‘Error: 8526, Severity: 16, State: 2’ error message when you use SQL Query Analyzer to start a distributed transaction after you have installed SQL Server 2000 SP4
When you use a client application such as SQL Query Analyzer to start or to enlist into a distributed transaction after you have installed Microsoft SQL Server 2000 Service Pack 4 (SP4), you receive an error message that is similar to the following: [Microsoft][ODBC SQL Server Driver][Shared Memo
Bridging the integration gap, Part 1: Federating grid data
(Adrian Lee, James Magowan, Patrick Dantressangle and Fabian Bannwart) Explore the architectural gaps that exist between the WebSphere Information Integrator and a data grid built using the Open Grid Services Architecture Data Access and Integration (OGSA-DAI). Then download Grid Wrapper for WebSp
Agile XML
(Micah Dubinko) August brings a change in my day job responsibilities; along with it comes with a certain amount of disruption, including a stretch of time away from reading the mailing lists. Judging by the popularity of columns like XML-Deviant, many readers are in similar straits. Even high-quali
Just SQL Part V – Counting with SQL
(James Koopmann) How many do I have? Do I have at least one? What is the greatest? What is the least? Give me the top 5 rows. These are just some of the types of questions that are often asked when trying to evaluate table data.
Power Network Services with MySQL
(Carla Schroder) Last week we learned how to create and populate a user authentication database. Today we’ll dig into making changes, making backups, connecting to remote MySQL servers and plugging MySQL in to servers like Postfix and Samba.
Utilize ADO.NET and C# to work with BLOB data
(Tony Patton) Storing and retrieving data with Microsoft SQL Server is a common task associated with most applications. On a past project, I was presented with a new twist on this interaction: large data types or BLOBs. The project entailed storing and retrieving Microsoft Word documents and ima
FIX: The Mssdmn.exe process may use lots of CPU capacity when you perform a SQL Server 2000 full text search of Office Word documents
Consider the following scenario: • You run Microsoft SQL Server 2000 together with the Full Text Search component. • You start the filtering daemon (Mssdmn.exe) to parse Microsoft Office Word documents.
The Fundamentals of the SQL Server 2005 XML Datatype
(Jeffrey Juday) Have you ever wanted flexibility in your SQL Server database without having to add additional tables? Do you store XML in your SQL Server 2000 database and yearn for an easier way to validate it against a XML Schema definition? If you’re planning on upgrading to SQL Server 2005, you’