(Mario E. De Armas and Joel Gauci) This first of a 2-part article series shows how common policies are governed, enforced, and monitored using IBM WebSphere DataPower XI50 SOA Appliance, WebSphere Service Registry and Repository, and IBM Tivoli Composite Application Manager for SOA.
Other News
Get Back into SQL Server After You’ve Locked Yourself Out
(K. Brian Kelley) Someone, while locking down the SQL Server, removed the permissions by which the DBAs came in and administered the server. As a result, we cannot get back into SQL Server. How can we restore our access to SQL Server? Check out this tip to find out.
Oracle Sponsors MySql Innovation Day
Oracle Sponsors MySql Innovation Day MySQL is one of the most popular SQL engines in use today, from small to large installations on commodity hardware to big iron. Tuesday, June 5th Oracle will be hosting a MySQL webcast demonstrating the latest vision of MySQL with the Oracle influence. The following add is take verbatim from their Email. Mobile, Social, Web […]
Real World Common Table Expressions
Real World Common Table Expressions Maurice writes our newsletter today with some gold nuggets wrapped around different uses for Common Table Expresssions CTE are a great way to express business logic into SQL, by breaking querying elements into more meaningful part. I usually give them long names that express the meaning of each step into SQL. CTE makes rewriting of […]
Troubleshooting problems with SQL Server 2008 R2 cluster
Troubleshooting problems with SQL Server 2008 R2 cluster If you have problems with SQL Server 2008 R2 cluster, review this troubleshooting checklist to find potential solutions. 1. Install the latest SQL Server 2008 R2 service pack. Because many SQL Server 2008 R2 cluster bugs were fixed in SQL Server service packs, you should install the latest SQL Server service pack....
Useful .NET Delegate Internals
(Alois Kraus) Delegates in .NET are a very handy addition to the language. With the introduction of LINQ they did become mainstream and everyone is using them or is at least finding them cool. But what the CLR is really doing to them under the covers remains largely unexplored. This is ok as long as
Q: How do I delete a SQL Server Analysis Services database?
(John Savill) A: Deleting a SQL Server Analysis Services database by using SQL Server Management Studio is initially confusing, as the Analysis Services databases aren’t shown. The solution is to create a new connection using SQL Server Management Studio.
10 command-line tools that refuse to die
(Jack Wallen) Despite the abundance of GUIs, the command line still offers more power, flexibility, and control for certain tasks.
Managing Structured Data using Windows Azure Table Service
(Mahesh Sabnis) The Table service component of the Windows Azure Storage service is a very simple, highly scalable and cost effective solution provided to store data. In this article, we will see how to store structured data on the cloud using Table Service.
Much Ado About Nothing?
(Rob van Wijk) I was reading this presentation PDF of Hugh Darwen recently, called How To Handle Missing Information Without Using NULL. Several great thinkers and founders of the relational theory consider NULL as the thing that should not be.
