Monthly Archives: March 2012

You are never alone, don’t give up! :))

I just love this photo!!! Yesterday’s night was long because of my MCTS 70-433 Exam .. you can imagine that, right. I went to make a coffee when Tiger jumped on a barstool and began learning with me .. sort … Continue reading

Posted in Microsoft SQL Server | Tagged , , | Leave a comment

Iterate through all databases / tables. Is sp_MSforeachdb good idea?

Ever heard of sp_MSforeachdb or sp_MSforeachtable procedures which iterates through all databases or tables? Well you might not because they are undocumented procedures about which Microsoft says are for internal use only and might not work for all scenarios. Also … Continue reading

Posted in Microsoft SQL Server | Tagged , , , , , | Leave a comment

Free e-book: Introducing Microsoft SQL Server 2012

Today I have come across free e-book Introducing Microsoft SQL Server 2012. Book introduces you into new features of 2012 like High Availability and Disaster Recovery, Security, Integration Services, Data Quality Services, Master Data Services, etc. … Here is the … Continue reading

Posted in Microsoft SQL Server | Tagged , , , , , , , | Leave a comment

Is it possible to run Integration Services 2008 R2 against MSDB at 2005 instance?

Last week I was asked by my colleague whether Integration Services 2008R2 can run against MSDB database located at Microsoft SQL 2005. At first I was in belief it was possible because I remembered article in MSDN library which said:

Posted in Microsoft SQL Server | Tagged , , , , , , | 10 Comments

Microsoft SQL Server 2012 Express edition

.. has become available for download. Here is the link: http://www.microsoft.com/betaexperience/pd/SQLEXPCTAV2/enus/default.aspx

Posted in Microsoft SQL Server | Tagged , , , , , | Leave a comment

Microsoft SQL Server 2012 is RTM !!!

Great news after months of expectations Microsoft SQL Server 2012 has become Ready to Manufacture just today on 6th March 2012. MSDN/TechNet subscribers may get SQL 2012 tomorrow on 7th March. Volume license customers on 1st April ( 🙂 ). … Continue reading

Posted in Microsoft SQL Server | Tagged , , , , , , | Leave a comment