(Jasper Oosterveld) The advantage of working with a SharePoint document library is the ability to store and edit documents within the library. You have the option to create a new Office document and save it directly to the library!
Other News
Testing WebSphere JMS applications when disconnected from WebSphere MQ
(Annette C. Green) This article shows you how to locally test a JMS application running on WebSphere Application Server without having to connect to a WebSphere MQ queue manager, by configuring your local WebSphere Test Environment to simulate WebSphere MQ.
Steps to Drop an Orphan SQL Server User when it owns a Schema or Role
(Jugal Shah) Recently I had an issue while dropping an orphaned user for an obsolete login. I was unable to drop the user and it failed with the below error messages.
Should Programs be separated from Data?
SSWUGtv with Stephen Wynkoop Can your MySQL database scale? If not, what are your options? Do you need to purchase a bigger machine? Do you need to purchase a sharding wrapper, or write your own data broker allowing your databases to shard? Instead, you now have the option to take advantage of the Cloud Database As a Service from Xeround. […]
SSWUGtv: should you be using PowerPivot? Dan Clark talks about his thoughts. Is it the tool for your self-service BI?
Video Programming for IT Professionals
What is the difference between SQL Profiles and SQL Plan Baselines?
(Maria Colgan) Since Oracle Database 11g was released I have gotten a lot of questions about the difference between SQL profiles and SQL plan baselines and why SQL profiles can be shared but SQL plan baselines can’t. So I thought it would be a good idea to write a post explaining the differences bet
Exec Talk – InfoSphere Optim Tools in DB2 V10.1
(Thuan Bui) Curt Cotner, IBM Fellow, VP, and CTO for Database Servers and Tools, describes the capabilities in the InfoSphere Optim Database Management Solutions for DB2 for Linux, UNIX and Windows to support new features in DB2 for LUW V10.1, such as pureScale, multi-temperature storage, adaptive c
SQL SERVER – Introduction to SQL Error Actions – A Primer
(Pinal Dave) Most people believe that when SQL Server encounters an error severity level 11 or higher the remaining SQL statements will not get executed.
Joining many tables in MySQL – optimizer_search_depth
(Peter Zaitsev) Working on customer case today I ran into interesting problem – query joining about 20 tables (thank you ORM by joining all tables connected with foreign keys just in case) which would take 5 seconds even though in the read less than 1000 rows and doing it completely in memory.
Practical Usage of Complete Extension Methods in LINQ
(Lajapathy Arun) In this article we are going to see the complete usage of extension methods in LINQ with the help of a Lambda expression.