(Michael Sorens) SQL has been evolving—slowly—for over three decades, (see Wikipedia for a historical summary). While SQL in the hands of an expert is quite powerful, it’s sometimes cumbersome compared to other programming languages. It does not scope variables the way modern, structured languages d
Other News
SQL 2008 Data Types
(Don Schlichting) This article introduces the new Date and Time data types found in Microsoft SQL Server 2008, such as DATETIME2, TIME, and DATE. The traditional data types that have been carried forward from previous versions will also be reviewed. In addition, TSQL commands for manipulating data t
Pointers for SQL Server parallel upgrades
(Serdar Yegulalp) When moving from one installation of SQL Server to another, whether it’s the same iteration of SQL Server or a higher revision, it helps to do things in parallel. A parallel upgrade means installing the new database product side by side — either on the same system or on a differen
MDX: Why it will matter to application developers
(Mark Whitehorn) Since when did application developers need to know about an analytical querying language like MDX? Since February 27th, next year. That’s when Microsoft will launch SQL Server 2008. Of course, you’ll still have breathing space because, as we are painfully aware, launching and actual
Visual Studio has Released
The Weekly SQL Server Show – Watch Now This show is an interview with Kim Tripp and Paul Randal. We got together at DevConnections in Las Vegas and talked about everything from the famous board game to SQL Server 2008. > Watch Here SQL Power Tools for Power Solutions You may not yet have heard about ZUI, but you’ll want […]
Webcast Today – Troubleshooting and SQL Server 2005
The Weekly SQL Server Show – Watch Now This show is an interview with Kim Tripp and Paul Randal. We got together at DevConnections in Las Vegas and talked about everything from the famous board game to SQL Server 2008. > Watch Here Many Things Can Impact Query Performance Once you work through your systems, reviewing calls, reviewing indexes, checking […]
Time to Take Another Look at DB2 Data Sharing?
(Robert Catterall) As a member of the DB2 for z/OS National Technical Support Team at the IBM Dallas Systems Center in the 1990s, I had the opportunity to work with some of the first organizations to implement DB2 data sharing on a parallel sysplex. When data sharing was introduced with DB2 for z/OS
Guide to setting up the IBM Ruby and Python drivers for DB2 on Linux (32 or 64 bit)
(Antonio Cangiano) IBM provides the community with, among others, Ruby and Python open source drivers for DB2 (more exactly IBM databases). Ruby has a gem that packages the Rails adapter for DB2 and its prerequisite driver. As a result, the easiest way to get the Ruby driver for DB2 is to install th
Silverlight: Web services rich client for the browser
(Daniel Rubio) Web services data is readily available to numerous tiers in the enterprise, ranging from user desktop’s to serverside applications making the most of SOA tenets. However, each of these tiers has certain characteristics that influence the way in which data is consumed and used to solve
Visualize DB2 spatial data in Web applications
(Knut Stolze) Visualizing spatial data is important when working with 2D or 3D objects, especially if this data is managed inside a database and you need dedicated tools to access the spatial information and prepare it for your users. This article illustrates how to exploit scalable vector graphics