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...

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...