(Beth Stackpole) Database administrators (DBAs) wary of additional security headaches when running SQL Server in a virtualized environment should relax, according to database experts. SQL Server security issues in the virtualized world pretty much mirror the security challenges of traditional databa
Other News
Db2 User ID to run REBIND
(Alex Levy) Do you feel sometimes like you’re reading a legal contract, not a technical document, when you browse the Info Center?
Unexpected Results in MarkLogic Xquery Type Coercion
(Jake Trent) Recently, we’ve been working on writing an API using xquery. We have wanted to make the API as solid as possible, since we’re putting the brunt of the complexity of our system into this module of code. What might typing our parameters and return types give us? We are hoping for safety a
Implementing Auto Save Feature Using ASP.NET Ajax and WCF Service
(Bipin Joshi) ASP.NET Ajax opens a lot of possibilities to provide users a rich user experience. At the code level developers can create components, client behaviors or controls that harness the power of ASP.NET and Ajax to provide features that are otherwise difficult to offer.
Oracle 11g SOA Suite – Service-enable a Query Using the Database Adapter’s Execute Pure SQL Option
(Theo Tol) The Database Adapter is a powerful tool to expose data and PL/SQL code in your service applications. If you want to quickly service-enable a custom-made query, you definitely may want to explore the “Execute Pure SQL” option of the Database Adapter.
String Aggregation in PostgreSQL, SQL Server, and MySQL
(Leo Hsu and Regina Obe) Question: You have a table of people and a table that specifies the activities each person is involved in. You want to return a result that has one record per person and a column that has a listing of activities for each person separated by semicolons and alphabetically sort
Speed up SQL Server queries with PREFETCH
(Matteo Lorini) The SAN data volume has a throughput capacity of 400MB/sec; however my query is still running slow and it is waiting on I/O (PAGEIOLATCH_SH). Windows Performance Monitor shows data volume speed of 4MB/sec. Where is the problem and how can I find the problem?
XACML 102 – Pimp my XACML – Part II: with XSLT
(David Brossard) In my previous post on making XACML look pretty, we had a look at a very simple and easy way to add some colors / borders / general style to the XML via CSS. The CSS was interpreted by your browser and the result displayed there.
Dynamic SQL Performance Tuning Techniques for IBM DB2 z/OS
(Lockwood Lyon) Applications running with dynamic SQL are ever-increasing. Without some methods to contain the onslaught of queries, performance drops and phone calls increase. What can a DBA do to remain sane and avoid a visit from the head of IT?
ASP.NET MVC 3 RedirectPermanent – SEO Feature
(David Hayden) I am converting an ASP.NET WebForms website to ASP.NET MVC 3 for a client and by choice we are changing the URL structure as well.