Cool WPF Stuff

Got this from Pandurang Nayak (Developer Evangelist) on some cool work using WPF. The video is indeed cool :) ... Take a look. 

Posted 17 July 2008 07:49 AM by vinodkumar | no comments

Filed under: Misc, .NET, Tips & Tricks

SQLCAT Team on RS 2008 Scaling

Catch the article here. 

Posted 17 July 2008 07:34 AM by vinodkumar | no comments

Filed under: SQL Server, Misc, ITPro

Microsoft SQL Server 2008 Feature Pack RC0

Download the June 2008 Feature Pack RC0 for Microsoft SQL Server 2008, a collection of stand-alone install packages that provide additional value for SQL Server 2008. Most important is the backward components for SQL 2005 and the data mining add-ins for Office 2007.

Posted 15 July 2008 03:42 PM by vinodkumar | no comments

Filed under: SQL Server, Tips & Tricks

SQL 2008:Data Warehouse Query Performance

 A neat article on DW concepts with SQL Server 2008 enhancements. Catch the same here.

Posted 01 July 2008 09:05 AM by vinodkumar | 1 comment(s)

Filed under: SQL Server, Tips & Tricks

IE Compatible - VPC images

Just wanted to test your application on IE6,7 and 8 Beta1 ? Here is your opportunity to grab hold of VHDs for the same, here on Downloads page.

Posted 19 June 2008 06:44 AM by vinodkumar | no comments

Filed under: Misc, OS, Technology

MCITP - Database Administrator

Yup, I did complete all the pre-requisites for the MCITP - Database Administrator today with the last exam being 70-443 for me. Was an very interesting exam to write and a tough one if you are not great at reading lengthy casestudies. I enjoyed a lot ... :) ... I am back and will start posting soon ...

 

Posted 18 June 2008 03:37 PM by vinodkumar | 1 comment(s)

Filed under: Misc

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 Server Quest…and give a geek a chance ...

                         

Posted 17 June 2008 05:24 AM by vinodkumar | no comments

Filed under: SQL Server, Misc, Technology, Tips & Tricks

101 - LINQ Samples

If you are interested in learning LINQ, here is a wonderful resource that you can start from.

101 LINQ samples for VB.NET

101 LINQ samples for C#

Posted 29 May 2008 08:30 AM by vinodkumar | no comments

Filed under: .NET, Technology

Latest on ExtremeExperts - May'08

I just uploaded a couple of articles on my website after a long time. Catch the same from the below links and feel free to drop your comments.

Security in SQL Server 2005 - Part I

DMVs - sp_who2 Script

Posted 26 May 2008 04:47 AM by vinodkumar | no comments

Filed under: SQL Server, Technology, Tips & Tricks

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 23 May 2008 06:55 AM by vinodkumar | no comments

Filed under: SQL Server, Misc, Technology, Tips & Tricks

SSIS 2008 Profiler Task

Catch this quick blog on the profiler task from Derek. Short yet simple in showing what capability is available with this new addition. Read it here.

Posted 22 May 2008 02:41 AM by vinodkumar | no comments

Filed under: SQL Server, Tips & Tricks

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 21 May 2008 06:39 AM by vinodkumar | no comments

Filed under: SQL Server, Misc, .NET, Tips & Tricks

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 Plans

Webcasts : Interoperability

• o Get More from Your Oracle Data with SQL Server 2005 (Level 300)
• o How Microsoft IT Runs SAP on SQL Server 2005 (Level 300)
• o Replicating Data Between Oracle and SQL Server 2005 (Level 200)
• o Setting Up and Configuring SQL Server 2005 for SAP Applications (Level 300)

Webcasts: Security

• o Securing Your Organization's Database Environment with SQL Server 2005 (Level 100)
• o Best Practices with SQL Server 2005 Security (Level 200)
• o Efficiently Using the SQL Server Execution Context in Applications (Level 200)
• o Encryption and Key Management Using SQL Server 2005 (Level 200)
• o Introduction to Security in SQL Server 2005 (Level 300)
• o Measuring the Security Quality of SQL Server 2005 and the Security Development Lifecycle (Level 200)
• o Securing Business Solutions Based on SQL Server 2005 (Level 200)
• o SQL Server 2005 Security Overview (Level 200)
• o SQL Server 2005 Security Enhancements (Level 200)

Webcasts: Tools

• o Be More Productive: An Overview of DBA Tools in SQL Server 2005 (Level 200)
• o Database Mail in SQL Server 2005 (Level 300)
• o Developing and Working with SQL Server 2005 Maintenance Plans (Level 300)
• o Manage SQL Server 2005 Using Command Line Tools and the SQLCMD Utility (Level 200)
• o Managing and Administering SQL Server 2005 (Level 200)
• o SQL Agent in SQL Server 2005 (Level 300)

Webcasts: Upgrade

• o An Overview of the SQL Server 2005 Upgrade Process (Level 200)
• o Choosing the SQL Server 2005 Edition That Best Fits Your Needs (Level 200)
• o How to Migrate Your Oracle Database to SQL Server (Level 200)
• o Learn How to Leverage SQL Server Upgrade Advisor and the New SQL Server Best Practices Analyzer tool (Level 200)
• o Reap the Immediate Benefits of Upgrading to SQL Server 2005 (Level 200)
• o Upgrade Considerations and Migration Paths (Level 200)
• o Strategies and Tools for Upgrading to SQL Server 2005 (Level 200)
• o Upgrade Considerations for Query Optimizer Statistics (Level 200)
• o Upgrading to SQL Server 2005 (Level 200)
• o Upgrading from SQL Server 2000 to SQL Server 2005

Webcasts: Tuning and Performance

• o Performance Diagnosis in SQL Server 2005 (Level 300)
• o SQL Server 2005 Database Tuning Advisor (Level 300)
• o SQL Server 2005 Troubleshooting: Supportability Features for SQL 2005 (Level 300)
• o Troubleshooting Performance Problems in Microsoft SQL Server 2005 (Level 200)
• o Performance Tuning and Troubleshooting SQL Server 2005
• o Monitoring SQL Server 2005 Performance

Webcasts: Misc

• o SQL Server 2005 Makes Extensive Use of Tempdb (Level 200)
• o Server Consolidation with SQL Server (Level 300)
• o Virtualize SQL Server 2005 on Virtual Server 2005 R2 (Level 200)
• o Understanding Maintenance and Monitoring Enhancements to SQL Server 2005 (Level 200)

Podcasts

• An Overview of Manageability in Microsoft SQL Server 2008 (Level 200)
• Best Practices with SQL Server 2005 Security (Level 200)
• Discover the Benefits of Upgrading to SQL Server 2005 Now (Level 200)
• Securing Your Organization's Database Environment with SQL Server 2005
• SQL Server 2008 Data Management Overview (Level 100)
• SQL Server 2005 SP2 Tools and Improvements (Level 200)

Tools and Utilities

• SQL Server 2005 Best Practices Analyzer
• SQL Server 2005 Performance Dashboard Reports
• SQL Server 2005 JDBC Driver
• SQL Server 2005 Upgrade Advisor
• SQL Server Migration Assistant for Oracle
• SQL Server Migration Assistant for Access
• SQL Server Migration Assistant for Sybase
• Microsoft SQL Web Data Administrator
• SQL Server 2005 Report Packs
• SQL Server Health and History Tool (SQLH2)
• SQL Server 2005 System Views Map
• Microsoft SQL Server 2005 Express Edition Toolkit
• Microsoft SQL Server Management Pack for Microsoft Operations Manager 2005

MS Learning's and Certification Page

• Microsoft SQL Server 2005 - Learning Portal

Posted 16 May 2008 01:18 AM by vinodkumar | 2 comment(s)

Filed under: SQL Server, Misc, Tips & Tricks, ITPro

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 Server 2005 T-SQL Enhancements
• SQL Server 2005 Web Services
• SQL Server 2005 XML Capabilities
• Using XQuery with SQL Server 2005 XML Data
• SQL Server 2005 SQL Server and ADO.NET

Videos

• SQL Server 2005 Overview Demo
• SQL Server 2005 and Visual Studio 2005 CLR Integration and End-to-End Debugging Demo
• SQL Server 2005 Security Features Demo
• SQL Server 2005 Developer Productivity Guided Tour

Samples

• Teacher Sample Application Guide
• Database Engine Tutorials - BOL
• SQL Server Tools Tutorials - BOL
• Service Broker Tutorials - BOL
• Samples and Sample Databases - BOL

Security Related

• Protect Sensitive Data Using Encryption in SQL Server 2005Protect Sensitive Data Using Encryption in SQL Server 2005
• SQL Server 2005 Security Best Practices - Operational and Administrative Tasks
• SQL Server 2005 Security: Strong Security That Is Easy to Configure and Manage
• Security Considerations for a SQL Server Installation - BOL
• Security Considerations for Databases and Database Applications - BOL

SQL Server (XML) - Resources

• XML Support in Microsoft SQL Server 2005
• XML Options in Microsoft SQL Server 2005
• XML Best Practices for Microsoft SQL Server 2005
• What's New in FOR XML in Microsoft SQL Server 2005
• What's New in FOR XML in Microsoft SQL Server 2005
• Introduction to XQuery in SQL Server 2005

Other New Features

• Introduction to Common Language Runtime (CLR) Integration
• Using CLR Integration in SQL Server 2005
• Usage Scenarios for SQL Server 2005 Native Web Services
• SQL Server 2005 Row Versioning-Based Transaction Isolation
• SQL Server 2005 Beta 2 Transact-SQL Enhancements
• Partitioned Tables and Indexes in SQL Server 2005
• Multiple Active Result Sets (MARS) in SQL Server 2005
• Introducing Service Broker - BOL
• An Introduction to SQL Server Service Broker
• Full-Text Search Programmability Enhancements

Misc

• Accessing SQL Server 2005 Databases with PHP
• Using Table Valued Functions in SQL Server 2005 to Implement a Spatial Data Library
• International Features in Microsoft SQL Server 2005
• Building Reliable, Asynchronous Database Applications Using Service Broker
• Managing Metadata in SQL Server 2005
• SQL Server 2005 Row Versioning-Based Transaction Isolation

Performance & Tuning

• SQL Server Optimization
• Performance Optimizations for the XML Data Type in SQL Server 2005
• SQL Server 2005 Enterprise Edition Benchmarks
• Database Engine Scalability and Performance Enhancements - BOL

Books

• Inside Microsoft® SQL Server^TM 2005: Query Tuning and Optimization
• Inside Microsoft® SQL Server^TM 2005: The Storage Engine
• Inside Microsoft® SQL Server^TM 2005: T-SQL Programming
• Inside Microsoft® SQL Server^TM 2005: T-SQL Querying
• Microsoft® SQL Server^TM 2005 Administrator's Pocket Consultant
• Microsoft® SQL Server^TM 2005: Database Essentials Step by Step

Posted 15 May 2008 04:16 AM by vinodkumar | 2 comment(s)

Filed under: SQL Server, Misc, Tips & Tricks, ITPro

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 2005

Installation

• Installing SQL Server 2005
• Installing the SQL Server Database Engine - BOL
• SQL Server 2005 Features Comparison - By Editions
• Advantages of a 64-bit Environment
• SQL Server 2005 Service Pack 2

Quick Starts

• Writing SQL Queries: Let's Start with the Basics
• An Overview of SQL Server 2005 for the Database Developer
• SQL Server 2005 Management Tools Overview
• Editing Transact-SQL Code in SQL Server 2005

Migration/Upgrade

• Microsoft SQL Server 2005 Upgrade Advisor
• Why Upgrade to SQL Server 2005
• SQL Server 2005 Upgrade Handbook
• Upgrading MSDE 2000 to SQL Server 2005 Express
• Should You Migrate from Sybase to SQL Server?
• Should You Migrate from Oracle to SQL Server?
• The Business Value of Upgrading to SQL Server 2005 for Mid-market Organizations
• SQL Server 2005 for Oracle Professionals
• Guide to Migrating from Microsoft Access to SQL Server 2005
• Guide to Migrating from MySQL to SQL Server 2005
• Guide to Migrating from Oracle to SQL Server 2005
• Guide to Migrating from Sybase ASE to SQL Server 2005

HOW-To / HOLs

• Database Creation and Design How-to Topics
• Administration How-to Topics
• Performance Monitoring and Tuning How-to Topics
• Visual Database Tools How-to Topics

Posted 14 May 2008 10:12 AM by vinodkumar | no comments

Filed under: SQL Server, Misc, Tips & Tricks, ITPro

Search

This Blog

• Home

Tags

Community

Archives

My Web Site

• ExtremeExperts

External Sites

• Bangalore User Group
• Microsoft India Homepage
• Bangalore SQL Group

Other Misc Blog Links

• SQL Shortcut Keys
• IIS 6.0 Features
• List of .NET Compilers
• Excel Shortcut keys
• RUN Command Shortcut key
• Useful SQL 2000 Links
• Who is a DBA?
• SQL Server - Express Links
• SQL Server - RS Links
• SQL Counters - Series 1

Newsletter

• Subscribe to NL from Me

Syndication

• RSS for Posts
• Atom
• Email Notifications
  Go

News

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

  My tree at Carbon Grove