(Claire Hsu) Setting up multi-node clustered SQL instances from scratch is common practice for companies that want to implement high availability, but adding a new node to an existing clustered SQL instance that has been running for a while may have a few sticking points, especially for a SQL 2005 i
Other News
More Organizations Move up to the Mainframe and DB2 for z/OS
(Conor O’Mahony) Any of you who are familiar with DB2 on the mainframe (officially known as DB2 for z/OS) know how efficient it is. The mainframe is not for every organization. However, for those organizations for whom the mainframe is a good fit, the tremendous levels of efficiency, reliability, av
MySQL 101 – Referential Integrity
(Adam Donnison) In our last episode we learned how to modify data and table definitions. This will come in handy as we look at building in referential integrity constraints into our database. To begin we will need the database definition resulting from last episode’s changes.
Sometimes WLM can help DB2 out just a little TOO much
(Willie Favero) Even though something may be working as designed doesn’t necessarily mean it’s working as expected. This always seems to happen around performance stuff to me. In my experience, something that has unexpected performance can be far worse than something that has bad performance.
Populating the TreeView Control With XMLDataSource
(Mahak Gupta) The TreeView is a .NET DataBound Control which is used to display hierarchical data. It can be bound with the The Nodes of this control with the help of XML, tabular or Relational Data. In this example we use XMLDataSouce to bind the TreeView.
Perform case-insensitive queries in Informix
(Neeraj Kapoor, Brian Cahill and Ajaykumar B. Gupte) When you query your data, you may wish your query to be case-sensitive, or you may wish to ignore upper- and lower-case differences in data. In the past, IBM Informix databases were case-sentitive, and it required some effort to perform a case-ins
Importing Geography Shapefiles into SQL Server
(Tim Cullen) The company I work for has many shapefiles and they want to store the information using the geography data type in SQL Server. I’ve looked through the drivers available in the Import/Export Wizard and cannot find one I can use to import the files. Do you know of any methods I can use t
Where Did NoSQL Come From?
Where Did NoSQL Come From? I enjoyed listening to a podcast today of an interview with Jonathan Ellis , who is the project chair for the open systems NoSQL data engine, Cassandra. During the interview, Jonathan related different events causing companies to move away from traditional relational data stores. This is not to say that NoSQL data stores didn’t exist […]
Is Your Application RESTful?
SSWUG TV With Stephen Wynkoop Watch our Interview with Laura Rose, who is a software industry veteran and business coach. You can also check out the latest news about OpenStack Diablo, MySQL’s commercial extensions and more… Watch the Show Featured White Paper(s) How to Implement an Effective SharePoint Governance Plan Written by AvePoint Moving past the "what" and "why" of […]
more examples on querying XML data
(manub22) My quest to know more about XML and to use it in SQL language always encourages me to google this topic and religiously follow the MSDN’s SQL Server XML forum. I liked this post on XML, it contains some more ways to query XML data cited by some SQL experts.