(Pinal Dave) I recently received the following question through email and I found it very interesting so I want to share it with you.
Other News
Integrating SPSS Model Scoring in InfoSphere Streams, Part 2: Using a generic operator
(Mike Koranda) Part 2 of this “Integrating SPSS Model Scoring in InfoSphere Streams” series shows how to create a generic operator to execute IBM SPSS Modeler predictive models in an InfoSphere Streams application. It builds off the work of the non-generic operator produced in Part 1, where we wrote
Limitations when attaching a SQL Server Database
(Ashish Kumar Mehta) One of the Junior SQL Server Database Administrators in my company wanted to know why he is unable to attach a SQL Server database using sp_attach_db. When he tried to attach the database he got this error message: “Procedure or function sp_attach_db has too many arguments spec
Disk Partition Alignment
SSWUG TV With Stephen Wynkoop Get the latest news on Oracle’s purchase of RightNow Technologies Watch the Show Disk Partition Alignment How much would it be worth to get significant improvement on you Windows Servers for Files, Exchange, or even SQL Server? What if your only investment was time? Well, if the concept of Disk Partition Alignment is new to […]
What is the EPUB Mimetype File?
(Darla Ferrara) EPUB is fast becoming the digital platform to learn for ebook publishing. EPUB stands for Electronic Publishing and is the XML format from the International Digital Publishing Forum. By design, EPUB works with two languages, XHTML and XML.
IBM to unveil NoSQL technology inside DB2
(Mark Brunelli) IT industry giant IBM plans to roll out NoSQL technology inside of its flagship DB2 database management system early next year, according to Curt Cotner, the company’s vice president and chief technology officer for database servers.
What job runs AWR snapshot? Eh?
(Dom Brooks) There are a surprising number of online resources propagating the idea that the collecting of AWR snapshots is somehow connected to the GATHER_STATS_JOB (which was responsible for automatically gathering stats in 10g).
JSON Serialization and Deserialization in ASP.NET
(SummiG) JSON is one kind of data format which is designer for running JavaScript on website. At present, JSON is widely used in web. This article focuses on JSON Serialization and Deserialization in ASP.NET, including the brief introduction of JSON, how to serialize and deserialize with ASP.NET and
Eventual Consistency – detecting conflicts
(Frazer Clement) In my previous posts I introduced two new conflict detection functions, NDB$EPOCH and NDB$EPOCH_TRANS without explaining how these functions actually detect conflicts? To simplify the explanation I’ll initially consider two circularly replicating MySQL Servers, A and B, rather than
Presence of a procedure in multiple databases in the same server
(SQLZealot) I have come across many times in a situation that I need to check the existence of a procedure in multiple databases in a given server.