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...
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...
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...
Craig has a couple of post on SQL Server 2008 Partitioned tables and Partitioned Indexes . Most interesting is the way Criag uses the ShowXMLPlan to explain the concepts. I sort of like this approach and is easy when writing articles. Earlier I used to have difficulty using the Execution Plan snapshot...
The list just doesnt seem to stop. Here are more bookmarks to be made. Webcasts Basics o SQL Server 2005 T-SQL Basics o SQL Server 2005: Query Processing Basics o SQL Server 2005 - Basics o SQL Server 2005: Query Tuning o SQL Server 2005: Reading Execution Plans Webcasts : Interoperability o Get More...
In continuation to the previous post. Here are more resources :) ... Virtual labs SQL Server 2005 Introduction to SQL Server Management Studio SQL Server 2005 Server Management Objects SQL Server 2005 Service Broker SQL Server 2005 SQL Query Tuning SQL Server 2005 T-SQL Enhancements SQL Server 2005 Web...
These are some of the useful links on SQL 2005 ... Overview SQL Server 2008 Product Overview SQL Server 2005 Product Guide SQL Server 2005 Product Datasheet SQL Server 2005 Features at a Glance What's New in SQL Server 2005 Top 30 Features of SQL Server 2005 Installation Installing SQL Server 2005 Installing...
Check my blog post on TechNet over Performance Monitoring with SQL Server 2008 here . Feel free to pass your comments.
Many-to-many dimension relationships in SQL Server 2005 Analysis Services (SSAS) enable you to easily model complex source schemas and provide great analytical capabilities. This capability frequently comes with a substantial cost in query performance due to the runtime join required by Analysis Services...
Log shipping and database mirroring can work together to provide solutions for high availability and disaster recovery. You can convert an existing log shipping configuration to a database mirroring configuration. Although Microsoft only supports a single mirror database, you can set up log shipping...