Featured Script dba3_0To20ComputedTimeOnlyValueAndFullDateTimeOffset_demo — For a GivenFullDateTimeArgument display: — GivenFullDateTimeArgument, Random 0 – 20 MinuteOffSetValue, — ComputedTime… (read more) Case Sensitive Database There are times when you wish to have your database data perform in a Case Sensitive fashion. When a database performs Case Sensitive comparisions, "A" and "a" are not equal. This configuration is usually done by selecting a […]
Other News
ColdFusion 9’s IsNull() Works On Non-Struct Objects
(Ben Nadel) When I first did my exploration of ColdFusion 9’s isNull() function, I definitely came away thinking that the isNull() function was merely a short-hand, convenience notation for the existing structKeyExists() function.
Should you expose a Stored Procedure via XMLType?
(Alex Nuijten) When you want to expose your Stored Procedure to the “outside world”, should you do this using XMLType? As always, the correct answer is “it depends”.
Using HandlerSocket Plugin for MySQL with PHP
(Mark Grennan) In my last two posts I installed the HandlerSocket plugin into MariaDB and showed how to use it with Perl. That’s good, but if you are thinking of using HandlerSocket I’m guessing you have a very high traffic website and it’s written in PHP. In this post I’m going to connect Handle
ODI and OBIEE 11g Integration
(David Allan) Here we will see some of the connectivity options to OBIEE 11g using the JDBC driver. You’ll see based upon some connection properties how the physical or presentation layers can be utilized. In the integrators guide for OBIEE 11g you will find a brief statement indicating that there a
SQL SERVER – Index Created on View not Used Often – Observation of the View – Part 2
(Pinalkumar Dave) Earlier, I have written an article about SQL SERVER – Index Created on View not Used Often – Observation of the View. I received an email from one of the readers, asking if there would no problems when we create the Index on the base table.
Introducing DB2 9, Part 2: Table partitioning in DB2 9
(Rav Ahuja) Improve performance and achieve greater scalability and easier management by using table partitioning, a feature of DB2 9 (formerly codenamed “DB2 Viper.” As tables grow in size, it may be easier to manage your data in chunks or by limited ranges. This article takes a quick look at the b
Case Sensitive Database
Featured Script dba3_0To20ComputedTimeOnlyValueAndFullDateTimeOffset_demo — For a GivenFullDateTimeArgument display: — GivenFullDateTimeArgument, Random 0 – 20 MinuteOffSetValue, — ComputedTime… (read more) Case Sensitive Database There are times when you wish to have your database data perform in a Case Sensitive fashion. When a database performs Case Sensitive comparisions, "A" and "a" are not equal. This configuration is usually done by selecting a […]
Email In Your Database
Email In Your Database There are many ways to enable Email within a SQL Server database and ways to take advantage of Email. If I don’t have a third party database monitoring tool, I like to use Email from SQL Server to notify me of events I need to address such as disk space, database files becoming full, Expanding Data […]
Loading XML file containing leading zeros with SSIS preserving the zeros
(Arthur Zubarev) Visiting the MSDN SQL Server Integration Services Forum oftentimes I could see that people would pop up asking this question: “why I am not able to load an element from an XML file that contains zeros so the leading/trailing zeros would remain intact?”.