Friday, September 28, 2012

Free ebook: Introducing Microsoft SQL Server 2012

Friends, the final and complete version of Introducing Microsoft SQL Server 2012, by Ross Mistry (@RossMistry) and Stacia Misner (@StaciaMisner), is now ready as a free download! You can download the PDF version of this title here (288 pages; 10.8 MB).
We will update this post soon with links to EPUB and MOBI files. We expect these files to be available by March 23. UPDATE: The EPUB is here, and the MOBI is here.
If you prefer a hard copy of the book, you can order it here for $14.99.Introducing Microsoft SQL Server 2012 includes 10 chapters:
PART I DATABASE ADMINISTRATION (by Ross Mistry)
1. SQL Server 2012 Editions and Engine Enhancements
2. High-Availability and Disaster-Recovery Enhancements
3. Performance and Scalability
4. Security Enhancements
5. Programmability and Beyond-Relational Enhancements

Tuesday, November 24, 2009

Let us imagine that you are attempting a migration of data from a schema in an existing third party application. Then you noticed that the tables are simply over-normalised and you have a need update a column in a target table from another table. What should you do ?

This is what I normally do :-

1) Identify the common field or fields in both say GLCODE
2) Identify the target column to populate in your target table and the source column in the source table
say GLNAME

To achieve your objective, EXECUTE this SQL statement

UPDATE TargetTableName SET GLNAME=(SELECT GLNAME FROM SourceTableName WHERE GLCODE=SourceTable.GLCODE)

Saturday, November 14, 2009

A SQLExpress 2008 database usually comprises of a database and a log file with the extension *.MDF and *.LDF respectively. As time goes by, the LDF can grow dramatically and I have seen the LDF file being more than triple the size of the MDF !

So, how does one shrink the size of MDF and LDF ? It is really simple to do so using the Management Studio for SQL Express 2008

Advantage Database Server is a full-featured, easily embedded, high performance client/server relational database management system specifically designed to meet the needs of business application developers.

Advantage is unique among the Sybase database management offerings in that it provides both Indexed Sequential Access Method (ISAM) table-based and SQL-based data access, providing a growth path for database software applications and enabling them to use enterprise-caliber feature sets.

Advantage Database Server is specifically targeted towards Independent Software Vendors (ISVs) and is designed to be embedded into the business applications these ISVs build, sell and distribute. Advantage is ideal for small and medium sized environments, generally, 5 -500 users. Advantage requires no DBA or ongoing administration, excelling in database environments with limited or no IT Staff.