(Hemant K Chitale) Restoring ArchiveLogs to an alternate location
Other News
SEQUENCE in SQL Server 2011
(Dinesh Asanka) SQL Server 2011 (or Denali) has now arrived CTP. In this article I will look at a core new feature of SQL Server 2011 which is SEQUENCE. Well, if you are familiar with Oracle, you will already know all about this feature since it has been standard on Oracle more than 10 years I guess
SQL Server Numeric Formatting
Transact-SQL includes the Convert command that allows values to be converted between differing data types. When converting some numeric types to text, a style code may be applied. This code determines the formatting of the generated string.
DNSULI Module is a Time-Saver
(Troy Coleman) Applications running on z/OS communicate to DB2 through an attachment facility. Attachment facilities communicate through a language interface. When developing your application, you must select a supported attachment facility to connect with. The options are abundant:
The DB2Night Show #Z08: DB2 for z/OS and Java- What’s New?
(Klaas Brant) In episode #Z08, our special guest Julian Stuhler (IBM Gold Consultant, IBM Champion and former IDUG president) gives an excellent overview of the many ways you can exploit DB2 using the Java programming language; varying from simple JDBC to PureQuery.
Exposing JTS’s MinimumBoundingCircle functionality
(Simon Greener) Today I decided to expose the Java Topology Suite’s (JTS) MinimumBoundingCircle functionality via the GEOPROCESS installer and package.
SQL SERVER – Denali – Logical Function – CHOOSE() – A Quick Introduction
(Pinal Dave) In SQL Server Denali, there are two new logical functions being introduced, namely:
MySQL 101 – Retrieving data: SELECT and JOIN
(Adam Donnison) In our last episode we started building up our online bookshop database, with tables for publishers, authors, formats and books. At the moment we only have one book in there, so before we go too far, lets add a few more:
Solving problems in the DB2 pureScale cluster services environment
(Oleg Tyschenko and Massimiliano Gallo) This tutorial guides DBAs and system administrators in problem determination for IBM DB2 pureScale cluster services. As you deploy IBM DB2 pureScale Feature for DB2 Enterprise Server Edition systems into production, you need to acquire appropriate problem dete
Trigger Tension
(Closing in a few days!) September Survey – 7 Questions to WIN We’re giving away not one, but two 2-year memberships to SSWUG.ORG – all you need to do is give us your thoughts about SQL Server and Bananas. No, really. It’s only 7 questions, and you can win… Seriously, could use your feedback – please stop by the survey […]