(Paul S. Randal) Back in October 2007 I blogged about partition-level lock escalation in SQL Server 2008 (see here) and I promised to do a follow-up once CTP-5 came out with syntax etc. So here it is.
Other News
MySQL Acquisition, Sun and The Realities of Business
Featured Article(s) Remove Time from a DateTime Column (Vadivel Mohanakrishnan) This article explains the way to get rid of ‘TIME’ part in a dateTime column. The target audience of this article are ‘beginners’. MySQL Acquisition, Sun and The Realities of Business On Friday, I wrote about my initial thoughts on the whole Sun/MySQL acquisition thing. I did receive some good […]
SQL Server security: Controlling access via database roles
(Matthew Schroeder) Security is very important in today’s world, but it is very hard to secure SQL data if you do not understand the control options available. In this article I will share how to set database roles and explain how they can help you tighten down security within your enterprise.
IBM Opens Jazz Dev Community
(Will Kraft) IBM announced last week that it would open up its Jazz.net development platform to developers. Jazz.net is an open commercial software development community that helps to create global collaboration solutions based on IBM Rational technology. Jazz was originally open only to IBM staff,
How Consolidation Affects Open Source
(Joe Brockmeier) So, now that the dust is starting to settle from the news that Sun is buying MySQL for a staggering $1 billion pricetag, let’s take a look at the larger picture– how is consolidation going to affect the open source ecosystem? MySQL was the first project in 2008 to be absorbed this
Pulling XML into Flash
(Brian Self) When developers and designers start really utilizing the power of flash and the potential it can bring to applications and creative content, a question that frequently arises is how to load data in from a xml page and use it in Flash. This is a quick tutorial to show how easy the proces
WPF Basics: Expression Blend and Visual Studio – a Good Partnership
(Ged Mead) I’ve been experimenting with the interaction between Visual Studio 2008 and Expression Blend (Version 1 with SP1). One thing I realised early on (right from the Orcas Beta days) is that Blend is a great help when you want to fine tune color gradients, create lines, shapes and paths or cre
Getting Gantty
(Tim Dexter) I spent some of today trying to solve a none too common (that I have seen) problem, that is to add a gantt chart to your BIP or BIEE outputs. BIBeans, the charting package we use does not support them – at least not in a way we can use them, they have a solution for EBS OAF […]
Forcing Trigger Firing Order
(Armando Prato) I have two triggers defined on my table which are set to fire on the same table actions (i.e. an INSERT, DELETE, UPDATE transaction). The second trigger that fires is dependent on the first fired trigger. How can I make sure that they fire in the correct order to enforce my busines
Accessing DB2 UDB with PHP
(Deepak Vohra) A PHP: Hypertext Processor (PHP) script may be embedded in an HTML page; or run as a .php script in a web server such as Apache web server. PHP statements are included in tags.