SelecTViews With Styphen Wynkoop All the news of the day that counts is provided here.. also, find out about normalization, what types of skills might be good for specialization and upcoming learning events…We keep you informed and up to speed on tips tricks and more. [Watch the Show] Last Day to Vote Today is the last day to vote for […]
Other News
How to Extract XML From a Database
Extensible Markup Language (XML) is the universally-accepted encoding for storing data by defining your own tags. You can define the order of tags to hold, process and display data. It is similar to HTML with higher flexibility.
SQL Server Security
(Buck Woody) Security in the context of SQL Server deals with multiple areas, including the physical systems, the operating system and environment (or “platform”), SQL Server, users and roles, the SQL Server objects (such as tables and views) and code you write for SQL Server.
SQL Server: Working with SQL Diag is More Easy Now
(aasim abdullah) SQL Diag is a useful diagnostic tool, through which we can collect lot of useful information, like
Working with large XML files in Management Studio
(Simon Sabin) Have you ever tried to generate a large XML file using FOR XML and then found Management Studio die when you try and look at the whole XML document (probably so you can save it).
New DMVs in Denali
This article is about some of the new DMV’s that are newly added to next version of SQL Server. These are also available SQL Server 2008 R2 SP1. They are very helpful to get information about the host operating system that the SQL Server runs on, status of the server and even the memory dumps that a
Schema to Java: @XmlMimeType & @XmlInlineBinaryData
(Blaise Doughan) In a previous post I described the impact of the @XmlInlineBinaryData and @XmlMimeType annotations in a JAX-WS environment where binary data may be sent as attachments.
Adding a reinstalled/reimaged node back to 11gR2 Cluster
(Abhishek) There could be a scenario of node crash due to OS/hardware issues and a reinstall/reimage of the same. In such cases, just a normal node addition would not help since the OCR still contain the references of original node. We need to remove them first and then perform a node addition.
Oracle Restart – 11gR2
(Anand) Oracle Restart is the new feature introduced by Oracle in 11gR2 which ensures that various Oracle components gets automatically restarted after hardware or software failures.This feature depends on OHAS (Oracle High Availability Service) daemon and is only for standalone server environment.
APAR Friday: Package Performance Hiper
(Willie Favero) Today’s Friday APAR, that is actually showing up on Saturday, has to do with the potential for an increase in CPU time and latch class 25 contention for very short running SQL that was bound with RELEASE (COMMIT ) and issue frequent commits.