(Richard Foote) Zone Maps are new index-like structures that enables the “pruning” of disk blocks during accesses of the table by storing the min and max values of selected columns for each “zone” of a table.
Other News
How to hide login data of sql-scripts on Windows
Karin Kriebisch) One of the often given advices on hardening a database is to run scripts without broadcasting your login data at the same time.
DB2 Basics: Executing a Script of SQL
(Ember Crooks) There are quite a few scenarios in which DBAs need to execute a script of SQL. Sometimes developers provide such a script to be executed. Sometimes we just have a large number of commands that need to be done as a whole.
Display Image From Byte Array In ASP.NET MVC
(Bipin Joshi) Displaying images from wellknown URLs is quite straightforward. At times, however, you need to display images that are available as raw binary data. Consider, for example, that you are building a Captcha system that generates images on the fly. These images won’t reside on the server a
AngularJS CRUD Operations with WebAPI, EF and Bootstrap
(Shailendra Chauhan) In previous article, you have learned about AngularJS Form Validation with Bootstrap. This article will demonstrate, how to create an HTML5 app with CRUD (Create, Read, Update, Delete) Operations using AngularJS, WebAPI, Entity Framework code first and Bootstrap.
Not All SQL Server Page Splits are Bad
(Tim Ford) Page splits occur when inserting—and in some cases updating—data in a database. If there’s not enough room to insert the new value or deal with the ramifications of the updated value of a key, then an additional page may be added to the leaf level of the index (and depending on the state
SharePoint & SQL Server AlwaysOn vs Standalone Performance
(Samuel Betts) How to setup SharePoint with SQL Server AlwaysOn has been covered nicely now, but I’ve not covered the performance hit setting up such a system will incur. The short version is: updates are about x2 slower than standalone for a x2 node AlwaysOn cluster; reading data is about the same
Using SignalR to power ASP.NET Dashboards
(Jerry Dixon) Lately, I have received a number of requests for help with simple dashboard applications. Most of the people making these requests have similar requirements. They would like an application that:
Reduce the source footprint of CDC by querying databases for archive logs
(Ranganath Dhanasekaran) Learn how the Change Data Capture (CDC) Oracle Redo physical standby configuration in InfoSphere Data Replication allows CDC to read logs off the standby device regardless of the log shipment method.
Xml and Schema Validator
(Claudio Inacio) First, I decided to write this article to share some of intuited knowledge, try to help and demonstrate how it is possible to develop a simple and generic module for validating XML files with their respective schema files.