(Alex Tocitu) You need to generate random data directly into SQL Server table columns or close to the database engine as variables or expressions. Looking at the SQL Server available functions, you notice that only RAND function offers support for random data generation.
Other News
Readers Responses: Timeshare The Old Cloud
SelecTViews: The SQL Server Show with Stephen Wynkoop Cloud security – what SPECIFIC steps can you start taking to assure success? Gazzang also on the show today, along with our Facebook question and upcoming events! [Watch the Show] (it’s free) Readers Responses: Timeshare – The Old Cloud One thing that is clear is that the Timeshare of yesteryear and the […]
Tight or Loose Data Constraints?
(Roger L. Costello) Should XML Schemas implement tight or loose data constraints?
SPIN is a W3C Member Submission
(Holger Knublauch) The SPARQL Rules language SPIN has evolved over the last couple of years as an integral part of TopQuadrant’s TopBraid Suite. SPIN started during a discussion between Dean Allemang and myself, in which we brainstormed about having an RDF syntax for SPARQL.
Combine advanced spreadsheet export with PHP to create pivot tables
(Jack D. Herrington) Add PHP to an advanced export function in Microsoft Excel to create a flexible pivot table in XML format. Then, you and users can sort and analyze the data in the pivot table on the fly.
ASP.NET MVC: Partial rendering and AjaxAttribute
(Stuart Leeks) On a number of occasions I’ve been working with a customer on a scenario where we were adding some Ajax partial rendering support.. All too often demos for this scenario are over-simplified and only render a minimal amount of data. I’m guilty of this too, so I thought I’d try to make
Tracking long running transactions in MySQL
(Yoshinori Matsunobu) Sometimes I want to trace transactions that have taken long time to execute. If a transaction is holding row locks for 30 seconds, all other clients requesting locks for the same rows will be blocked for up to 30 seconds (or will get Lock Wait Timeout errors if you set innodb_l
Some more time, some XML functions
(Henrik Loeser) I had written about some details regarding current time and timezone for the regular DB2 and the Oracle mode. Now I had some time to play with built-in XQuery functions.
Script for testing TCA Api’s
(Martien van den Akker) If you try to test a service generated and deployed using the Service Provider in SOA Gateway, you might run into problems while the response message does not provide the appropriate messages on the functional errors.
RMAN is Smart, But…
(Fahd Mirza) Restoration and recovery are the basic tasks which a DBA might perform regularly. The time of restoration and recovery is highly tensed and critical. Despite of good, available, and tested backups, it’s easy to get carried away and mix up the things with RMAN. Trying different restores