(Rudy Limeback) How do you insert multiple rows of data, say five rows of data, using insert into command? (R)
Other News
You cannot specify a USB-based tape drive as a backup device in SQL Server 2005 and in SQL Server 2000
When you use a universal serial bus (USB)-based tape drive as a backup device on a computer that is running Microsoft SQL Server 2000 or Microsoft SQL Server 2005, you cannot specify the USB-based tape drive as a backup device in SQL Enterprise Manager or in SQL Server Management Studio.
Using EJB3 with Ajax
(Andrei Cioroianu) Enterprise applications can use Ajax to provide better Web interfaces that increase the user productivity. In many cases, it is possible to submit a partially completed form to obtain useful information from the server application. For example, the server could perform some early
Information service patterns, Part 4: Master Data Management architecture patterns
(Allen Dreibelbis, Eberhard Hechler, Bill Mathews, Martin Oberhofer and Dr. Guenter Sauter) Master Data Management (MDM) brings you a methodology for maintaining consistent data across diverse business functions. This article describes the taxonomy of Enterprise MDM-related architecture patterns. Af
Microsoft’s Lineup of SQL Server Related Webcasts for April 2007
Nine new webcasts are scheduled for April, covering such topics as VB9 – SQL and LinQ, Best Practices with SQL Server 2005 Security and more.
Role Bases Access using C# and XML
(Subal Mishra) Role-based access control attempts to allow administrators to specify access control in terms of the organizational structure of a company. You assign a user or a group of users to a role to perform a specific job function and restrict them to do certain other job functions.
SSAS Many to many optimization technique #1
(Erik Veerman) This has been something brewing for a few weeks that I am just getting to writing down… and yes, naming this idea #1 does imply that I have another idea 🙂 so stay tuned. Before diving into the details, the summary is that this approach when applied against the AdventureWorksDW datab
Use XForms to create an accounting tool, Part 2: Logging in and accounts
(syakovac) This six-part series demonstrates how to leverage the power of XForms in conjunction with MySQL and PHP for support processing to create an online accounting tool called X-Trapolate. Every good programming technology possesses a range of problems it excels at solving. The series highlight
A couple of useful mysqldump options
(Il Corra) In my replication environment I had a hardware failure on master host. A 4.5.GB table containing blob images wa corrupted, so I issued a REPAIR TABLE and the effect was to repair the table but also to reduce the number of rows: master table had just 41 rows less than the copies on the sla
Patterns: SOA Design using WebSphere Message Broker and WebSphere ESB
(Rufus Credle, Kim Clark, Ge Yun Peng, Hatcher Jeter, Joao Lopes, Samir Nasser and Kailash Peri) The Patterns for e-business are a group of proven, reusable assets that can be used to increase the speed of developing and deploying e-business applications. This Redbook focuses on the use of the WebSp