(Jeff Hunter) Something I discovered recently is that the DEFAULT profile for Oracle 11g sets the PASSWORD_LIFE_TIME to 180 instead of UNLIMTED by default. Applications will encounter an “ORA-28002: the password will expire within X days” error message if you keep the default value.
Other News
DETERMINISTIC Functions — 2
(Hemant K Chitale) Following up on my previous post, I now take up a Deterministic Function defined on a date column.
Transfer Logins from SQL Server 2005 to SQL Server 2008
(Madhivanan) When you want to move a database from one server to another, you can take a backup of the database and restore into the other server. However this will not transfers the logins from one SQL server to another, say SQL Server 2005 to SQL Server 2008.
SQL Server Tips & Tricks: Create Bulk Queries
(Mohamed El Ashmawi) Sometimes you need to build bulk query to select, update or insert data to SQL tables. The selected, updated or inserted data is dynamic and is selected based on data in many tables.
Q&A: New Microsoft products focus on configuration, virtualization
The stream of new Microsoft products seldom slows, as evidenced recently at the Microsoft Management Summit 2011 in Las Vegas, where the cloud-based monitoring and configuration system previously known as Project Atlanta was given full product status.
MarkLogic: Performing an operation across two databases using xdmp:eval
(Alex Bleasdale) There could be situations where you want to perform operations across two databases. One such example could be to quickly clone a batch of documents into a second database.
Reading Properties from XML File
(RestartX) Sometimes, we need to config our application using a config file such as XML. We have to parse the whole XML document to pick up the right value with dozens of ‘if’. Now, we can use reflection technology to set values with lesser ‘if’ by enumerating the XML document and set the right valu
Analyze DB2 spatial data with a free geobrowser
(David Adler) A geobrowser for IBM DB2 and Informix is now available as a free download. You can easily list tables containing spatial data and select tables to display as a map using a combination of points, lines, and polygons.
Some First Steps for the Cloud…
Some First Steps for the Cloud… There has been a great response to the questions about the cloud (thanks!) – including an article series here on the site from Craig Mullins – make sure you keep an eye out. I put together some basics to help get you started in working with your cloud providers. I hope this at least […]
Timeshare – The Old Cloud
SelecTViews Show: A pet peeve – what is up with the silence about the massive cloud data breach??? Also on the show today – Michael Crump and some great applications for Silverlight. [Watch the Show] (it’s free) $$SWYNK$$ Featured Article(s) Troubleshooting Linked Servers in SQL Server 2008 In this article, Alexander Chigrik explains some problems with SQL Server 2008 linked […]