(samkumar) So I am back with some tips to improve insert performance… I am wondering why I did not choose this for my 2nd chance @ db2night show’s DB2 has talent…
Other News
How to find MySQL configuration file?
(Thomas) A customer called me today asking for help with locating the configuration file used by one of their production MySQL instances. From the description I was given it appeared that their server had at least six different copies of my.cnf file in different locations on disk. And all were simil
Hashing Byte Arrays (Binary Data) With ColdFusion Before ColdFusion 10
(Ben Nadel) Between the new hmac() function and the enhanced hash() function, ColdFusion 10 makes hashing byte arrays (ie. binary data) extremely easy. Last week, I looked as hashing an image using the hash() function.
Rebuilding SQL Server indexes using the ONLINE option
(Ben Snaidero) As each year goes by the uptime requirement for our databases gets larger and larger, meaning the downtime that we have to do maintenance on our databases is getting smaller and smaller. This tip will look at a feature that was introduced in SQL Server 2005 that allows us to leave our
SQL Azure Federation Sharding
SSWUGtv With Stephen Wynkoop In this episode Paul Zikopoulus with IBM – talking about big data, what it means, why it is important and much more. Watch the Show $$SWYNK$$ SQL Azure Federation Sharding I received a few questions about SQL Azure Federation today. My understanding is strictly through reading documentation materials from Microsoft…so be aware that I may be […]
Embedding an XSLT in an XML document
(Caleb Madrigal) Today, I had this XML document which I was wanting to make viewable in a browser. My plan was to run the XML document through an XSLT engine to transform it into an HTML document (which could then be opened in a browser).
Pager for ASP.NET MVC
(Keith Wood) I recently implemented a pager in ASP.NET MVC and thought it would be worth sharing. It uses fluent syntax – a technique I’ve not seen used much in MVC to solve similar problems so I thought I’d throw it out there! At first glance, MVC has a much more limited number of built in features
Structured Thinking About Semantic Search
(Ryan DeShazer) Following a March 15 Wall Street Journal article, “Google Gives Search a Refresh,” the topic of semantic search has again become a hot-button issue for SEOs and webmasters. In that article, author Amir Efrati refers to coming changes across Google results pages, largely derived from
LINQ to XML Namespace Example
We use a XML namespace to avoid name conflicts. With a namespace we can more specifically point to an element in a XML structure. In LINQ to XML a namespace is represented by the XNamespace class.
How to create partial views (MVC tutorial number 10)?
(Questpond) This is the 10thMVC (Model view controller) tutorial and in this article we will try to understand how we can improve reusability using partial views.