Browse by Tags

All Tags » Tips & Tricks » Misc » SQL Server (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: , , , ,
SQL Server 2008 and Virtual Earth
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...
Posted 10-08-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: , , ,
SQL Express - Prereqs
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 .
Posted 10-03-2008 by vinodkumar | with no comments
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: , , , ,
5 Hidden Gems inside SQL Server
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"...
Posted 09-08-2008 by vinodkumar | 5 comment(s)
Filed under: , , ,
Autonomous Transaction with SQL Server 2008
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...
Posted 09-01-2008 by vinodkumar | 1 comment(s)
Filed under: , , ,
DataMining in the Cloud
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.
Posted 08-26-2008 by vinodkumar | 1 comment(s)
Filed under: , , ,
Server-quest Game !!!
Are you geek enough to win the entire office’s respect? Prove it. Play Server Quest, where you’ll navigate through the perils of office life, protect the server, and keep clear of the arrogant sales guy. Look for it online at www.server-quest.com . Play...
Posted 06-17-2008 by vinodkumar | with no comments
Filed under: , , ,
RS 2008 Memory Management
Some good explanation on Memory Management , though not exhaustive atleast gives you a head-start to where to find data.
Posted 05-23-2008 by vinodkumar | with no comments
Filed under: , , ,
Sync Framework 101 Samples
Yup, you read it right. If you are interested in exploring the world of MS Sync Framework, here is a wonderful 101 Samples on the same.
Posted 05-21-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: , , ,
GROUP BY ALL
Did you know such a thing ever existed? Check this post from SQLTeam on the GROUP BY ALL feature here .
Posted 05-09-2008 by vinodkumar | with no comments
Filed under: , , ,
More Posts Next page »

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