(Alok Pandey) DataBinding is the most important thing when we develop any application. It is a process to map a value or set of values to a user interface control. We store data at back-end on database and transfer data to and from the front-end.
Other News
Accelerate Hibernate and iBATIS applications using pureQuery, Part 3: Auto-tune data fetch strategies in Hibernate applications with pureQuery
(Mario Briggs and Ganesh Choudhary) Development teams that build applications using Hibernate as the Object Relational Mapper (ORM), or persistence mechanism, spend significant time tuning the amount of data that Hibernate fetches from the database, and the number of SQL queries that Hibernate uses
Find Last Restart of SQL Server
(Greg Robidoux) How can I tell when my SQL Server instance was last started? In this tip we look at various methods of how to get the start time for a SQL Server instance.
Sharding Techniques
SSWUG TV With Stephen Wynkoop Catch this inteview with SQL Server MVP Denny Cherry. Watch the Show Sharding Techniques Sharding doesn’t have to be performed inside a data engine. In fact, a relational data engine may be sharded externally, just as easily as any other data storage technique. I received an Email from Liran who has written extensively on the […]
Sharding
SSWUG TV With Stephen Wynkoop What, Big Data? Check out the insights from MVP Stephen Wynkoop on Big Data. Watch the Show Sharding Relational Database Architects have utilized the concepts of Sharding for years. Sharding is a popular term which is used to take an object, and break it down into it’s component properties. For example, SQL Server uses a […]
Make HTML5 microdata useful, Part 1: Using jQuery on top of microdata
(Lin Clark) The microdata specification lists two reasons why you might want to use microdata: To allow generic scripts to provide services that are customized to the page or to enable content from a variety of cooperating authors to be processed by a single script in a consistent manner.
Element constructors: computed and direct
(Dave Cassel) In XQuery, you can build an element one of two ways: computed or direct.
LocalDB: Where is My Database?
(Krzysztof Kozielczyk) As I mentioned in the previous post LocalDB handles database files differently than regular SQL Server.
Non-deterministic Functions and the Binary Log
(Emanuel Calvo) I wrote this post because I ran across this issue when debugging why tables with triggers/functions that were not getting replicated to slaves. The problem appears when binlog_format is set up as STATEMENT. You can check the ‘change log’ checking the following link for more informat
Excel sheet to monitor your diaglog – Try it today
Monitoring diaglog is a typical daily DBA chore. But sometimes it is tedious to go through the volume of data in the diaglog . As mentioned in my previous blog post Monitoring diaglog , there are different ways to keep track of diaglog