SQL Index Fragmentation

SQL Indexing

Indexes are applied to tables to better performance in query execution, instead of the database engine searching through each and every row for the queried data, indexing provides an indexed subset of data that can be queried to get the required rows.

Customized setup and deploy Package’s with the Orca Database Editor

As DBA, I find comfort in the fact that almost everything in life is based on a relation model, so I decided to blog about using the Orca Database editor to design customized GUI’s for setup and deploy packages in Microsoft Visual Studio. Beware trying out this, could break the standard templates given by Microsoft and could make unwanted install’s , if you created unwanted installs try Microsoft FixIt  (find it on google).

SQL Server 2012 Features

So what’s new with SQL Server 2012? Well, there are a lot of enhanced and new features in the SQL Server 2012 editions. But generally speaking, the following features make the 2012 edition a whole lot better than the previous versions.

Wondering about ALM: Go listen to the expert - Brian Keller

Hi All, I've received this exciting note from Suliman Noor Mahomed, the Audience Marketing Manager at Microsoft South Africa:

The ALM guy, Brian Keller is in Johannesburg next week. He is here for just 2 days before he flies off, so this is your opportunity to come listen to him talk about application lifecycle management with TFS and Visual Studio. Below is the full details

Application Lifecycle Management with Visual Studio and Team Foundation Server 2012 presented by Brian Keller

Date: 19 September 2012

Time: 15:00 – 17:30, Check in: 14:30

Audience: Architects, Developers, Decision Makers, Testers, Developer Managers

Price: Free

Place: Microsoft Campus, Johannesburg

Level: 200-250

To register: click here

Honey I have restored the database

A few weeks ago I published the blog Honey I Shrunk the Database, and I mentioned a way of shrinking your database.

The method to be discussed during this blog was inspired by - PaulRandal – “Why You Should NotShrink Your Data Files”