(Tim Golden) I know it’s clear I don’t have all that much time for the “innovations” in SQL Server 2005, but there are two syntax additions which I’ve been yearning for for years. (Since I moved from a company which used Oracle, in fact). These are: INTERSECT and EXCEPT (the latter known as MINUS in
Other News
Error message when an application connects to SQL Server on a server that is running Windows Server 2003: ‘General Network error’
Consider the following scenario. A server is running Windows Server 2003 and Microsoft SQL Server. You have an application that connects to SQL Server by using TCP/IP. In this scenario, you may intermittently receive one of the following error messages when the application connects to SQL Server:
Data Warehousing Implementations from Readers
Featured Article(s) All Databases In Server: Simple Status Check The following T-SQL function returns a small int number for the count of all databases that either not ONLINE or that do NOT have READ-WRITE updatability or that the User access are not multi-user meaning all databases that have some restriction on them. Video Posted: Discussion List Watch Oracle to SQL […]
Tell a Friend, Win $200
Pro-Center Video Programming for IT Professionals
Discussion List Watch: Oracle/SQL Server Migrations, using IN, MAX(), transaction logs and more.
Pro-Center Video Programming for IT Professionals
IBM Uses RFID to Track Conference Attendees
(Patrick Thibodeau) At its Information on Demand conference in Las Vegas, IBM is deploying RFID technology on name tags worn by attendees that automatically tracks their session and meal attendance.
Live From VSLive!: Five Questions With Paul Sheriff on Architecting ASP.NET
(Becky Nagel) In his VSLive! preconference workshop on Monday, .NET author and consultant Paul Sheriff, president of PDSA, gave his full-day “Architecting ASP.NET” presentation to a ballroom full of attendees. We caught up with Paul right after his talk to find out more about the challenges — and o
Getting Started with LINQ to XML
(Beth Massi) As Rob points out (I actually noticed his post on the Dev Center today!) there are some How-Do-I videos available for Visual Studio 2008. One of the videos is an overview of LINQ to XML (sorry I can’t give you a direct link to the video as they are wrapped up into some nifty Silverlight
How to Insert One Parent and Multiple Child Record into MySQL Database Using ASP.NET and C#
(Habiburahman Khaled) Many people have been asking how to insert one parent and multiple child records into MySQL database using ASP.NET from one form at once. This article will show you exactly that.
Enabling BLOB support with JHeadstart – Uploading/Downloading files to and from a BLOB column
(Lucas Jellema) JHeadstart 10.1.3 has great support for Uploading and Downloading files up to and from Web Applications – and indirectly from the database. Compared to prior releases, JHeadstart 10.1.3 has a little less flexibility: it only supports File manipulation for ViewObject Attributes of one