(Nannette Thacker) This article is the second in a series of step-by-step tutorials that show how to build an ASP.NET page to import an Excel spreadsheet into a database using Typed DataSets and TableAdapters. Last week’s article, Building the Database, started with an overview of the system. We the
Other News
.NET Debugging Demos Lab 5: Crash
(Tess Fernandez) Last week I published a debugging challenge for Lab 5. It was really interesting to see the results and I have to say I was really happy to see the excellent results from the poeple who commented on the debugging challenge (sounds like my work here is done:)).
How to sync two tables in MySQL
(pabloj) A question pops out quite often on Devshed forums, “How do I keep table x of my local database in sync with a remote copy?”
Index Compression Part IV (Packt Like Sardines In a Crushd Tin Box)
(Richard Foote) A great question by Brian Tkatch has convinced me there needs to be at least a Part IV in this particular mini-series. The basic question is what size does the column need to be for it to be effectively compressed?
Monitor long-running jobs in SQL Server 2000
(Michelle Gutzait) Monitoring long-running jobs in SQL Server 2000 is a complicated task. The problem is that the job execution history is written only after the first job step is completed. Therefore, if the first — or only — step of the job runs for a long time, you can’t query any system table
Setting the execution order of Triggers in SQL Server
Yesterday, we had seen how one can set the execution order of triggers in Oracle 11g i.e. if there is more than one trigger on a table, how can one set the execution order for those. In today’s post, we will look at the same functionality in SQL Server. SQL Server has this support in both SQL Serv
Type less in SQL Server 2008 (variable initialization and multiple row inserts)
(Andras) Among the large number of new features in SQL Server 2008 there are two, almost insignificant features, that I use almost constantly. These are variable initialization and the values clause of insert statements that now accept multiple rows.
Oracle BI EE 10.1.3.3/2 – Between Prompts for Date Columns – Using Presentation Variables
(Venkatakrishnan J) I just saw another question in the forums today where the users wanted to know how to go about creating Date Prompts with “in between” operator. So, basically the user had a report containing one date column and he wanted to create a dashboard prompt on that date column which can
IDUG View: pureQuery and DB2 9 Shine
(David Beulke) DB2 9 for z/OS offers many new performance features. The one I find the most exciting combines DB2 9 and pureQuery to convert dynamic JDBC SQL applications into static transactions. This combination, which uses the new IBM Data Server Driver for JDBC, eliminates the overhead of dynami
Webcast Tomorrow: Managing Change with SQL Server
Using, Supporting, Developing for SQL Server? You need to be at SQL Connections and/or DevConnections. SQL Connections in Orlando, FL is the place to be for an in-person, highly technical conference. The conference provides an amazing array of sessions and is even co-located (and you can attend sessions for free) – with ASP.NET Connections, Visual Studio and SharePoint Connections. All […]