(Hemant K Chitale) RMAN allows you to take an Incremental Backup “FROM SCN”. Why ? For the purpose of updating a Standby Database.
Other News
Query SQL Azure and On-Premise Data in One Codeset
(Buck Woody) I was asked recently how to query SQL Azure along with an on-premise data source. There are actually lots of ways to do this, but a quick and simple method is to use LINQ – or Language Integrated Query. There are always pro’s and con’s for any data access methods, but I’ll show this one
Introduction to Entity Framework Code First
(Bipin Joshi) Entity Framework (EF) allows you to program against a model instead of dealing with a database directly. In EF 4.0 (that ships with .NET 4.0) you typically design a model from an existing database visually, using a designer provided for that purpose.
Data Control Language (DCL)
(Mike Chapple) The Data Control Language (DCL) is a subset of the Structured Query Lanaguge (SQL) that allows database administrators to configure security access to relational databases. It complements the Data Definition Language (DDL), which is used to add and delete database objects, and the Dat
Data Mining Query Task in SQL Server Integration Services
(Marcin Policht) One of the primary goals of business intelligence is to transform raw data into meaningful information, by combining its sources, discovering its dependencies and patterns, and using them to predict future trends.
Let’s ask some Smarter Questions about DB2 LUW Performance Tools
(Scott Hayes) Borrowing words from Texas Governor Perry, it is time for some “provocative language.” I am an IBM DB2 GOLD Consultant and Information Management Champion. I’ve earned these merit badges over the years for my advocacy of DB2 and the DB2 community. But, I am not a puppet for IBM and I a
How to Log to PostgreSQL with Syslog-ng
(Hovhannes Avoyan) Sometimes, a basic understanding of how a program works just isn’t satisfying. While it is nice to understand how our logger operates, syslog-ng doesn’t start getting interesting until we start playing with some of the more advanced features it has to offer.
Introduction of JQuery
(Abhishek Bhat) JQuery is a Javascript library which is used extensively for client side validation and manipulation of Dom elements. It is a light weight, cross browser compatible and is a repository of many reusable Javascript functions. To learn JQuery, we should have awareness of Html, CSS and J
Hierarchical Queries with DB2 Connect By
(Birgitta Hauser) According to the SQL Standard, hierarchical (e.g. organization charts, bill of materials) or bi-directional data (e.g. flight connections) can be evaluated by using a recursive common table expression (RCTE). RCTEs were delivered with release V5R4 of DB2 for i.
SQL Server Denali Task List Feature in SSMS
(Ashish Kumar Mehta) While looking through the new features and improvements in SQL Server Denali, we found a potentially interesting feature namely the Task List. This is a very useful feature which can be utilized by Developers and DBAs to quickly list all the tasks which have been planned for the