(Mosha Pasumansky) The subject of multiselect friendly calculations is a popular one in forums. I have written about it before here, here and here. In February 2008 I will write a blog which will give a definite answer on how AS2008 will deal with it (which is follow up on this post). But in the mea
Other News
How do I… Transfer logins from one SQL Server 2005 instance to another?
(Steven Warren) In my last How do I…, I discussed how to restore a SQL Server to a new server. After the article published, I had some questions on the best way to move SQL Server logins from one SQL Server 2005 instance to another SQL Server 2005 instance.
Columnar Databases, and Database Changes in General
Have You Watched The SQL Server Show Yet? SelectViews posted on Friday – here are the show notes; Software as a Service Issues, SQL Server Data Archive Challenge, Linking Access Tables to SQL Server. Also, BookLooks – Apress TSQL Recipes, the 60-Second SQL Server Tip of the Day and Much More. (Don’t forget the SQL Server Challenge – we’re looking […]
DB2 Gaming — Play to Learn
(Susan Visser) Looking for an interesting way to introduce DB2 to new employees? Try a new approach to traditional learning with IBM DB2 Gaming. Take advantage of these new interactive self-study learning games to build your DB2 skills using real world problems and solutions. Play now and experience
Summarizing the JSON and XML data interchange format debate
(Brian Reindel) One of my coworkers recently expressed some displeasure with debates that are fundamentally fueled by industry experts. The discussions are typically inflated with bias, academic tripe, and are of little use to the every day working (wo)man. I could not disagree. In the spirit of red
Choosing Visual Studio 2008 tools and technologies
(Ed Tittel) As Microsoft continues gearing up for the formal launch of Visual Studio 2008, SQL Server 2008 and Windows Server 2008, now set for February 27, 2008, more and more goodies keep showing up at the Visual Studio 2008 Developer Center. This includes a peachy item, Deciding Which Technologie
Yes, it is here too: the PIVOT operator in Oracle 11g
(Lucas Jellema) Pivoting is all the rage. Turning rows into columns. You can do it in Excel, in all BI/OLAP tools and we could do it in Oracle using clever tricks and highly advanced solutions, such as Anton’s:http://technology.amis.nl/blog/?p=1207 . Now in Oracle 11g, PIVOT has become a standard SQ
Tablespaces in MySQL, Oracle and Postgres
(Lewis Cunningham) If you are not familiar with tablespaces you may be wondering what the big deal about them is. Tablespaces are a logical addition to a database that helps maintenance, and potentially, can improve performance.
Enumerating Group Members
(Phil Factor) Problem: You have a table like this, recording what people eat. jane pie fred sandwich fred sausage fred biscuits jane cake Rajiv pastie Rajiv Croissants
XML 101
(Joshua Curtiss) The following are notes from the XML 101 class at Adobe MAX 2007. I’m skipping over the extremely basic XML principles and covering the more interesting stuff.