SQL Server 2008
Microsoft says that SQL Server Integration Services (SSIS) “is a platform for building high performance data integration solutions, including extraction, transformation, and load (ETL) packages for data warehousing.” A simpler way to think of SSIS is that it’s the solution for automating SQL Server. SSIS provides a way to build packages made up of tasks [...]
Continue reading about Steps to Create and Deploy SSIS Package as a SQLAgent Job
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 [...]
Continue reading about BACKUP Compression in SQL Server 2008
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 [...]
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 [...]
Continue reading about SQL Server 2008 Concurrency Problems and Isolation
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 [...]
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
Continue reading about Why Upgrade to Microsoft SQL Server 2008?
There are many tricks that can be used when you write T-SQL code. One of these is to reduce the amount of network data for each statement that occurs within your stored procedures. Every time a SQL statement is executed it returns the number of rows that were affected. By using "SET NOCOUNT ON" within [...]
Continue reading about SET NOCOUNT ON to improve Stored Procedure Performance in SQL Server
SQL Server 2005/2008 has a default Mail Engine in it, We can send email from SQL Server itself using the Database Mail. Database Mail is not active by default, in order to activate the Database Mail we need to follow Database Mail Configuration wizard or we need to execute sp_configure stored procedure with appropriate parameter.
Database [...]
Continue reading about Database Mail in SQL Server 2005/2008
After taking backup, we need to verify the database backup to assure the SQL Server Backup is taken correctly. we can verify the database backup either by T-SQL statements or SSMS.
The RESTORE VERIFYONLY command checks the backup to ensure it is complete and the entire backup is readable. The does not do an actual [...]
This article covers the basics of Transaction Log backups and restores in SQL Server. The examples are from SQL Server 2008 however it applies to SQL Server 2005. If a database uses either the full or bulk-logged recovery model, you must back up the transaction log regularly enough to protect your data and to keep the transaction log from filling.
Continue reading about Backup and Restore Transaction Log in SQL Server
