(Jim Mischel) The .NET Framework’s built-in numeric types can parse a wide range of number formats. Two overloads of the Parse method allow you to specify a System.Globalization.NumberStyles parameter that defines how the input string should be treated. Using this overload, you can specify that the
Other News
ESQL code conventions in WebSphere Message Broker
(Rachel Shen and Ankur Upadhyaya) These coding conventions for Extended Structured Query Language (ESQL) will help you develop ESQL code that is easy to understand and maintain. This article is for developers using ESQL to implement message flow applications for deployment on WebSphere Message Broke
MySQL – An IT Tipping Point
(George J. Trujillo Jr.) A ”tipping point” is a concept, product or idea that becomes a hot commodity that attracts everyone’s attention, interest or inspiration. There are always specific reasons and factors that are not easily identifiable why one product becomes a tipping point and others do no
.NET Debugging Demos Lab5: Crash – Review
(Tess Fernandez) Since I already posted a challenge for this lab earlier I didn’t want to wait too long with publishing the review…
Using named notations in Functions in Oracle 11g
In 11g, named notations are also available when functions are called. There are three ways we can call a procedure or a function: • Position notation • Named notation • Mixed notation
Is it important to declare your columns as NOT NULL
(Simon Sabin) Yes Yes Yes. Nullable columns cause a extra data to be stored in your table and index to identify if a column value is NULL. This is caused a NULL bitmap. you need one NULL bitmap 8 NULLable columns. So on table with multiple NULL columns the overhead may not be large.
Backup More Than 1GB per Second Using SQL2008 Backup Compression
(Lindsey Allen and Thomas Grohser) Backup Compression in SQL2008 performs very well and it is easy to use. You could either use “With Compression” along with the “Backup” command or simply enable default backup compression through sp_configure by setting ‘backup compression default’ value to 1. It i
You receive error messages after you uninstall SQL Native Client from a server that is running SQL Server 2005
After you uninstall SQL Native Client from a server that is running Microsoft SQL Server 2005, the following behavior occurs: • When you try to start the SQL Server Agent service, you receive the following error message: The request failed or the service did not respond in a timely fashion. Co
Oracle BI EE 10.1.3.3/2 – Varying Data Sources from Answers – Same Metadata different Data Sources – Using Presentation Variables and Session Variables
(Venkatakrishnan J) Let’s look at a pretty interesting requirement today. I had a call yesterday with one user who basically wanted to know whether there is any way in BI EE Where he can reuse the existing Metadata that he has created for some other data source. He also mentioned that this data sour
SQL Server Tools to Take a Hit?
New SQL on Call Show Posted SQLonCall: Working with third-party software tool and application vendors. As you build out solutions that depend on outside resources, there are some key things to remember as you work with them on your team. > Watch Now Also Available [Watch] SelectViews – [Watch] SQLonCall: Conferences and why you should consider attending A Virtualization Tool […]