(Hendrik van Run and Jonathan Deberdt) When implementing IBM PureApplication System, IBM recommends integration with an external LDAP subsystem. Many clients have an additional requirement for the OS to integrate with an external LDAP, which is not provided out-of-the-box.
Other News
XML Data in SQL Server
SQL Server introduced the XML data type in 2005 as a native storage for XML documents. Because it is truly XML aware, it validates any XML saved to make sure it is correctly formed. It has additional benefits if you provide a schema, assuring that the xml is not only well formed, but conforms to the specified schema. Additionally, the […]
Bug 5497611
(Andrew Reid) I used Oracle Enterprise Manager to look at the execution plan for some SQL in an Oracle 10.2.0.3 database. (The SQL shown is just an example done later for the purposes of this blog post. As usual, click on the image to enlarge it and bring it into focus if necessary.):
Mastering the DB2 10.1 Certification Exam – Part 1: Planning
Norberto Gasparotto Filho is a database specialist with more than 10 years of experience with database administration and is the author of the DB2 10.1 fundamentals certification exam 610 prep, Part 1: Planning.
A Workaround for MySQL ERROR 1070
(Ike Walker) As documented in the Reference Manual MySQL supports a maximum of 16 columns per index. That’s more than sufficient for most index use cases, but what about unique constraints? If I create a fact table with more than 16 dimension columns in my star schema, and then try to add an index t
SQL Server Reporting Services (SSRS) Encryption Key
(Scott Murray) My SQL Server Reporting Services database and server are secure and only used internally; do I really need to backup the SSRS keys? Also, is there a command line tool to handle this process?
05: SQL Configuration Options and Trace Flag Secrets
Pro-Center Video Programming for IT Professionals
04: High End Testing
Pro-Center Video Programming for IT Professionals
03: Bare Metal Tuning Part2
Pro-Center Video Programming for IT Professionals
02: Bare Metal Tuning Part1
Pro-Center Video Programming for IT Professionals