Uncategorized

SelectViews SQL Server Show Posted, SQL Server 2008

New SelectViews Show Posted
Need your help and opinion on a question in the show! We’ve just posted this week’s SelectViews show – I’m headed up to Microsoft later in the week and wanted to make sure we got the show out for you. Open source feedback, the SQL Server 2008 Slip, the 60-second SQL Server tip of the day and a whole lot more are all in the show. Check it out when you get a second!

> Watch Here

Also available:

[Watch] the prior SelectViews here. Open source gotcha, discussion list watch, events and a LOT more…

Featured Article(s)
Gqlplus a drop-in replacement for Sqlplus
Gqlplus is a drop-in replacement for sqlplus that provides several new features such as history and table and column name completion.

Want a Free Subscription to DM Review?
DM Review delivers market-leading insight through interviews, articles and columns written by the best consultants, hands-on practitioners, and technology solution
leaders the industry has to offer. Editorial focus is on business intelligence, performance management, analytics, integration and enterprise data warehousing, business process management and technology architectures. Subscribe now and receive 12 Monthly issues – FREE!

SQL Server 2008 Slip Feedback
Michael: "Most of our customers are in the UK and government organizations. A very high percentage are still on SQL 2000 , so my hopes on been able to harness sql 2005 technology has taken a blow never mind using sql 2008. It is likely that development will be using VS 2008 but from a DBA point of view.. no change .. very frustrating. With the delay we will be supporting SQL 2000 well into 2009 .. and it wouldn’t surprise me if we still had customers running sql 2000 in 2010! "

Mark: "The delay is of little consequence to us, as we’re only part way into our migration programme from 2000/32 to 2005/64. We run a multi-TB data warehouse environment on a distributed hardware platform – the resource cost of ‘keeping up’ with MS product releases simply cannot be justified to the business. We will be skipping 2008 completely. By the time we are ready and/or can justify moving again, there will be another product release."

Raymond: "I work as the Senior SQL DBA for a credit card processing company. We are just now upgrading to SQL 2005 after a years push to upgrade since I started a year ago. Several of my old clients are also just starting to upgrade from 2000 to 2005. So basically, I see no problem with the delay. In addition, the longer it is in testing the better I hope the product will be once it is released. Glad to see MS has gotten out of the ‘need’ to race to market and is working on quality product releases instead. I am also a trainer, so I and really glad not to have to learn a new product yet. It seems I just got certified on 2005. 🙂 "

Clay: "While I am certainly O.K. with it because I would rather have a stable good product that something shoved out the door to meet a deadline, I am one of those that is looking forward to it. I didn’t go to SQL 2005. We are still at SQL 2000 sp4, a very stable product by the way. It is sunsetted for mainstream support from Microsoft as of April. That puts us on our own, with help from our friends at SSWUG, unless we buy the extended support. I am comfortable with this for a period of months, but I certainly don’t want it to drag into years."

More to come…

Featured White Paper(s)
Top Ten Steps to Secure Your SQL Server
In most organizations today, business critical and confidential data increasingly resides in Microsoft SQL Server databases. … (read more)

ADABAS/Natural Migration to the Cost-Effective Relational Database, DB2 or SQL Server
To cut your Total Cost of Ownership, migrating away from legacy languages and databases is a good start. BluePhoenix™ DBMSMig… (read more)