In the recently concluded Virtual TechDays in Sep we had a track for SQL Server and we did 4 sessions. There were a number of questions that we were not able to answer during the session. I just compiled the Part I of the responses for "Top 10 DMV's" session by Praveen at our TechNetIndia...
Here are a set of links that will bridge the gap between SQL Server 2008 datatypes and Virtual Earth seamless integration. Virtual Earth & SQL Server 2008 - Part 1: Introduction (1/2) Virtual Earth & SQL Server 2008 - Part 1: Introduction (2/2) Virtual Earth & SQL Server 2008 - Part 2: Spatial...
Wrote a small tip on my website (ExtremeExperts) yesterday on how one can get a different language data from SQL Server Analysis Services 2008 into Excel 2007. Read the article here .
Two new SSIS connectors have been released to the web: Microsoft Connector to Oracle by Attunity 1.0 : The Oracle source and destination components are written to achieve optimal performance when loading data into Oracle or unloading data from Oracle in the context of Microsoft SSIS. Microsoft Connector...
There is a wonderful post over the SQL PSS blog about installing SQL Server Express and the various errors you might encounter. It explains in good detail on the pre-requisite required for installing SQL Server 2008. Check this here .
SSMA 2005 for Oracle 4.0 : h ttp://www.microsoft.com/downloads/details.aspx?FamilyId=6D9BC6A7-75DA-493E-BEE5-50F4A4352B91&displaylang=en SSMA 2008 for Oracle 4.0 : http://www.microsoft.com/downloads/details.aspx?FamilyId=3E8722AE-77F3-4288-906D-F421E24D322F&displaylang=en SSMA 2005 for Sybase...
This is an interesting and a common requirement of locking the schema once the SSIS package is created. Else I have seen manytimes the nasty error and we need to open the package to re-validate the Tasks. Check this post from Roche that explains how to mitigate this using simple views.
If you have not yet registered for the Virtual TechDays Event , then please do it. There are close to 40+ sessions that will feature. I will be doing 3 sessions around SQL Server. One of the sessions is titled - "5 hidden Gems inside SQL Server". This is an interesting topic and I have my own...
This was an interesting post on the Programmability teams blog. I have come across a number of people asking for this feature as it works with Oracle. This blog describes one of the server options enabled with SQL Server to achieve the task. Read the blog here .
Once this does happen, this will be exciting. Trust me !!! I have been using the Table Analysis from the Excel Add-in and whenever I have showcased them, people have just loved it. Catch this space for specifics.