Connection of Sybase to .Net and SSRS
The connection of Sybase to SSRS was made in the project using the Sybase ASE ODBC driver. This driver needs to be installed.
After installation, the next step is to create an ODBC data source for Sybase. This can be done by adding a new system data source under [...]
Tags: SSRS, SSRS and Sybase, Sybase with DotNet, Sybase with SQL Server Rerports
The article lists the facts that are incurred while connecting IBM DB2 with DotNet applications and SQL Server Reporting Services (SSRC) tool.
Connection of DB2 to .Net and SSRS
The connection of DB2 to SSRS was made in the project using the Microsoft ODBC driver. This driver is a default driver and is visible in the [...]
Tags: DB2 Stored Procedure, DB2 With DotNet, DB2 with ODBC Drivers, DB2 with SSRS, Parameters in DB2 with ODBC
Overview SQL Server 2008 has come up with inbuilt compression for backups. Until the release of SQL Server 2005, compression was only available via third party backup software such as SQL Lite Speed, SQL Zip, etc.
Exercise Following is the simple example that demonstrates how to take [...]
Tags: SQL Server 2008, SQL Server 2008 Backup, sql server backup compression
Enterprise Data Platform
Secure, trusted platform for your data
Optimized and predictable system performance
Productive policy-based management of your infrastructure
Dynamic Development
Accelerate your development with entities
Synchronize your data from anywhere
Beyond Relational
Store and consume any type of data
Deliver Location Intelligence within your applications
Pervasive Insight
Integrate all your data in the Enterprise Data Warehouse
Reach all your users with scalable BI platform
Empower every [...]
Tags: Beyond Relational, Dynamic Development, Enterprise Data Platform, Pervasive Insight, SQL Server 2008, SQL Server 2008 Features
Concurrency problems
SQL Server transaction isolation solves four major concurrency problems
Dirty read occur when a reader reads uncommitted data
Unrepeatable read occurs when existing row change within a transaction
Lost updates occur when two writers modify the same piece of state
Phantoms occur when new rows are added and appear within a transaction
Locking strategies
Optimistic concurrency
Locks [...]
Tags: concurrency in sql server 2008, Isolation levels in sql server 2008, Locking strategies, SQL Server 2008
ACID properties of transactions
Atomicity – Either all modifications are performed, or none Consistency – When completed, transactions leave all data and all related structures in a consistent state Isolation – Transactions don’t see other’s transaction’s uncompleted work (intermediate state) Durability – Transactions persist despite of system [...]
Tags: ACID Property, ACID Transaction, SQL Server 2008, Transaction Modes in SQL Server 2008
Introduction:
The article explains the basic factors of Java Server Faces(JSF) , Spring and PORTAL/PORTLET
JSF:
Java Server Faces is a technology used for easy web development and it follows the MVC architecture.
JSF applications are easily manageable because the presentation layer is clearly separated with business logic.
JSF follows the event handling mechanism, so that [...]
Just a day ago, we faced situation where one column in database contained two values which were separated by comma. We wanted to separate this two values in their own columns.
It was interesting that value of the column was variable and something dynamic needed to be written. Following is quick script which separates one [...]
Tags: Divide Columns, Split Columns, Split Columns in T-SQL, SQL Server, T-SQL
With the new release of SQL Server 2008, there are many benefits in upgrading the existing applications to the latest release. SQL Server 2008 provides a Data Platform for enterprise applications. Let’s learn more about the new features available in SQL Server 2008
Tags: Business Intelligence, Performance Enhancements, Simplified Administration, SQL Server 2008, SQL Server 2008 Features
Get Your Voucher Code for your Discounted Exams
Find the exam of your choosing from the lists below and select "Get Voucher," complete the registration form and your discounted voucher code will be emailed to you. Once you have obtained your code, plan and schedule your next exam at http://www.prometric.com/Microsoft/default.htm.
See if the exam you want [...]
Tags: certification offers, microsoft certification discounts, microsoft certifications, prometric, prometric offers
