Browse by Tags

All Tags » Misc » Tips & Tricks » ITPro (RSS)
VTD - Q&A Part 1
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"...
Posted 10-09-2008 by vinodkumar | with no comments
Filed under: , , , ,
SSIS Connectors - Oracle and Teradata added
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...
Posted 10-07-2008 by vinodkumar | 1 comment(s)
Filed under: , , ,
SSMA 2005 & 2008 V4.0 - 7 New additions
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...
Posted 09-30-2008 by vinodkumar | with no comments
Filed under: , , , ,
Data Mining UrlScan 3.0 Logs using LogParser 2.2
Check this interesting post on IIS.NET of using LogParser and getting vital stats. Read it here .
Posted 09-16-2008 by vinodkumar | with no comments
Filed under: , , ,
SQL 2005 Links - Part III
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...
Posted 05-16-2008 by vinodkumar | 2 comment(s)
Filed under: , , ,
SQL 2005 Links - Part II
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...
Posted 05-15-2008 by vinodkumar | 2 comment(s)
Filed under: , , ,
SQL 2005 Links - Part I
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...
Posted 05-14-2008 by vinodkumar | with no comments
Filed under: , , ,
Analysis Services Many-to-Many Dimensions: Query Performance Optimization Techniques
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...
Posted 01-21-2008 by vinodkumar | 1 comment(s)
Filed under: , , , ,
Database Mirroring and Log Shipping Working Together
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...
Posted 01-19-2008 by vinodkumar | with no comments
Filed under: , , , ,
Community for SQL Server Professionals !!!
This community provides a central hub for SQL Server professionals where they can interact with their peers and access SQL Server related technical information that can help empower their SQL Server knowledge. The community website is currently in beta...
Posted 12-10-2007 by vinodkumar | with no comments
Filed under: , , , ,

Search

Go

This Blog

Tags

Community

Archives

My Web Site

External Sites

Other Misc Blog Links

Newsletter

Syndication

News


  • Disclaimer: The opinions expressed herein are my own personal opinions and do not represent my employer's view in anyway.

    Site Counter: Hit Counter