SQL Azure Federation

 What is Federation?

Federation is a database object like other objects such as tables, views, stored procedures or triggers.
It is also known as Sharding.
There can be multiple federations in a database.
It is...

Change Package Properties Using Parameters–SSIS 2012

In DTS, changing package properties was close to impossible (the less we talk about DTS, the better). Package configurations introduced...

List of Sharepoint Blogs

I ran across this list of Sharepoint blogs by Rene Modery while doing some Sharepoint reading. He has an OPML...

OPASS April Meeting Recap

Last Thursday I had the pleasure of speaking in Orlando, FL at the OPASS monthly meeting.  I spoke on Extending...

Oracle Tips for MSBI Devs #3: Choosing Drivers

When working with Oracle, drivers are truly a pain to get working correctly.  I will discuss my preferred choice and...

SQL Backup 7

What more could you add to a SQL Server backup product? It seems that many software products, including Red Gate’s...

SQL Server 2005 backups in a hung state because of full text search process

I came across an issue today where a backup process was in a blocked state with a wait type of...

Who are the sysadmins in this sql server?

Here’s a quick query that you can run to find out the users with sysadmin fixed server role. Sysadmins have a...

Denali – Blog a Day Series : May, 2012

Denali

 
Microsoft has launches sql server 2012 aka Denali on March, 2012. Free Express and evolution edition for the same is...

Do You Know These Free Events?

I frequently attend a few online training events that greatly help me learn new things. Thought I would share, if may...