(Pinal Dave) This blog post is written in response to the T-SQL Tuesday post of Prox ‘n’ Funx. This is a very interesting subject. By the way Brad Schulz is my favorite guy when it is about blogging.
Other News
DataBinding with a ComboBox in FSharp
(Alok Pandey) We create a DataBase for getting records into a ComboBox. Here, in this example, the DataBase name is student_record, table name is student and Columns are Roll_No and Name. I have written code below for creating this database.
Online roll-out with table partitioning in InfoSphere Warehouse
(Naresh Chainani, Liping Zhang, Steve Pearson and Srinivasa Santhanam) Starting with IBM DB2 for Linux, UNIX, and Windows V9.7.1, the table partitioning feature is enhanced with support for online roll-out using detach. With online roll-out, queries continue to access the partitioned table while one
Limit snapshot size when adding new article to SQL Server replication
(Mohammed Moinudheen) I have transactional replication configured in my production environment. The business has requested that I add a new article to the publication. I would like to initialize only the new article added to the publication, so that I could avoid taking a total snapshot of all exist
Application Performance Optimization Replication
Application Performance Optimization – Replication I have been talking about Sharding as a technique for improving application performance. Sharding distributes your data across multiple servers with the intention to allow multiple server to server requests for data. Replication is another technique that is a close cousin to sharding. Replication is a term that is well understood for Relational database engineers. […]
Application Optimization Techniques – Cache
Application Optimization Techniques – Cache If you haven’t picked up on the trend of the recent topics, I have been looking at different application optimization techniques. We looked at sharding as a way to take advantage of multiple CPUs to handle data persistence to a physical disk. Today I wanted to introduce the concept of Cache. We all know Cache […]
Implementing 5 important principles of REST using WCF Services
(Shivprasad koirala) REST is nothing but using the current features of the “Web” in a simple and effective way. If you see some of the amazing features of the Web are:-
Analyzing Network Characteristics Using JavaScript And The DOM, Part 1
(Philip Tellis) As Web developers, we have an affinity for developing with JavaScript. Whatever the language used in the back end, JavaScript and the browser are the primary language-platform combination available at the user’s end. It has many uses, ranging from silly to experience-enhancing.
XML data mining, Part 1: Survey several approaches to XML data mining
(Laura Irina Rusu) XML is used for data representation, storage, and exchange in many different arenas. This series explores one facet of XML data analysis: XML data mining. In this first article, get an introduction to some techniques and approaches for mining hidden knowledge from XML documents.
When Databases Attack – Finding Data on SQL Servers
(Scott Sutherland) A few weeks ago I presented a webinar called “When Databases Attack”. It covered some SQL Server database configuration issues that are commonly overlooked and targeted by attackers.