(Carla Wilcox) Database management systems continue to focus on performance as the amount of data continues to grow at a staggering rate. This article focuses on a performance tuning technique called functional indexes. Creating and using functional indexes based on database use statistics can signi
Other News
Testing PL/SQL Code
(Steven Feuerstein and Bill Pribyl) In this seventh part of a nine-part series on managing PL/SQL code, you’ll learn how to test your code, and some good techniques to NOT use for debugging it.
11g list of values LOV
(Edwin Biemond) In JDeveloper 11g can you define a List of values on an attribute of a bc4j viewobject. This is very easy but you can do it also manually so you can use it with toplink or with webservices. In this blog I make an jsf page on employees where you can update the department of this emplo
DB2 9 DBA Exam Sample Questions: Monitor switch settings and the Import utility
(Roger Sanders) Practice for the DB2 9 DBA certification exam by trying your hand at these two sample questions from the book DB2 9 for Linux, UNIX, and Windows Database Administration: Certification Study Guide, published by MC Press. The questions are reprinted here with permission. Check back eac
BI Publisher (10.1.3.3) parameters in a DataTemplate
(Bastiaan Vellinger) After a day of searching and trying to create an BIP report based on a data template with parameter(s) the bug is countered.
SQL Server 2008 New DATETIME DataTypes
(Dinesh Asanka) SQL Server 2008 has arrived – not fully, but as a CTP version. Whenever you hear about new software, the first and most obvious question is “What are the new features?”. There are many new features and facilities in SQL Server 2008. This article is going to cover the newly introduce
SQL Server Security Model
(Gregory A. Larsen) Windows Authentication, SQL Server Authentication, Windows Groups, Database Roles, Schema, and Application Roles are all aspects used to manage SQL Server Security. So how do you use one or more of these items to develop your SQL Server security architecture for an instance of SQ
Poor men see sharp – more cursor optimization
(Hugo Kornelis) After making my post on cursor optimization I received some comments that triggered me to do some further investigation. Adam Machanic wrote in my blog’s comments that using SQLCLR to loop over a SqlDataReader would be much faster than any T-SQL based cursor. And Erland Sommarskog wr
Using a Server Alias to connect to SQL Server Instance(s)
When connecting to SQL Server from your PC or from your application/web servers, you can choose to create aliases for connectivity. Before we start getting into the nitty-gritty details of aliases, let us see how you can set one up. You can use SQL Server Connection Manager in SQL Server 2005 to s
New SQLonCall Show, BizTalk and More
New SQLonCall Show Interviews; MaximumASP (can even get a free SQL Server 2008 database), BinaryTree, and more. Chris also talked with Data Dynamics, K2 and Telerik. > Watch The Show Here > Also, Catch the Latest SQL Server SelectViews Show Featured Article(s) Understanding Microsoft BizTalk Server (Part II) In the first part in this series we have had an introductory […]