I’ve spent a lot of time considering when, and if, business intelligence may cross the line. Is there a point when BI becomes profiling? When does "The Minority Report" become a reality and we’re looking to use information and trending data to prevent things that haven’t happened yet? We’re in this constant state of protection upgrades with travel, terrorism and […]
Other News
Full Text Indexing in SQL Server 2008
Virtual Training – SSIS, and Replication February 1 – 28, 2011 Here is an opportunity for you to add or extend your SQL Server skills in the areas of SQL Server Integration Services (SSIS) and/or SQL Replication. As Steven wrote a while back, there are so many skills a SQL Server professional needs to have today, its difficult to keep […]
JAXB and Date/Time Properties
(Blaise Doughan) In this post I will describe how JAXB handles date/time information. This post will also cover how the @XmlSchemaType annotation can be used to customize the XML representation.
Introducing the Extended Events Object Model
The primary focus we’ve had for Extended Events in SQL Server codenamed “Denali” is to offer a better user experience by providing options for working with the system beyond DDL. One of those options is the availability of a managed code object model. In this post I’ll describe the object model and
Putting SQL Server catalog views to work
(Robert Sheldon) SQL Server 2008 provides hundreds of system views that let you view database and server metadata without having to access the actual source of that data. One category of system views that is particularly useful when retrieving information used by the database engine is the catalog v
XSLT ToString() Helper Method
(James Curry) Recently I needed to store some simple XML configuration files in SharePoint.
Where is the password column from DBA_USERS in 11g?
(Hector R. Madrid) Oracle 11g brought several security enhancements, as it is well known by the 11g users. On previous Oracle versions it was possible to query the DBA_USERS PASSWORD column to get the hashed password string. It was useful when someone tried to temporarily reset the user’s password a
Data Archiving, Purging and Retrieval Methods for Enterprises
(Muthusamy Anantha Kumar) Enterprise growth leads to information explosion and vice versa. With various types of archiving, purging and retrieval methods available, the question becomes, ‘what are the advantages/disadvantages in archiving and purging data.’
Reading summary results from the VS2010 load test database
(Morgan Skinner) I’m with a customer in the labs this week doing some performance work and one of the tasks we wanted to do was to programmatically read the load test database in order to retrieve a table of summary data from a test run. My customer has instrumented their application well, and came
Solving ORA-24172: rule set %s.%s has errors
(David Aldridge) DBMS_Scheduler chains are a joy to use, until they stop being a joy and start being a real pain.