May 2008 - Posts

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 05-29-2008 by vinodkumar | 1 comment(s)

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 05-26-2008 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 05-23-2008 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 05-22-2008 by vinodkumar | 1 comment(s)

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 05-21-2008 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 05-16-2008 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 05-15-2008 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 05-14-2008 by vinodkumar | no comments

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

NET Framework 3.5 SP1 Now Live

The best all-up run-down of all the features (WPF, ASP.NET, WinForms, VS etc.) can as ever be found on Scott Guthrie’s blog:

http://weblogs.asp.net/scottgu/archive/2008/05/12/visual-studio-2008-and-net-framework-3-5-service-pack-1-beta.aspx

 

Pretty comprehensive write-up of the WPF-specific features here:

http://blogs.msdn.com/tims/archive/2008/05/12/introducing-the-third-major-release-of-windows-presentation-foundation.aspx

 

And lastly, Brad Abrams’ post has a ton of screenshots of the various features:

http://blogs.msdn.com/brada/archive/2008/05/05/visual-studio-2008-and-net-framework-3-5-sp1-beta.aspx

 

 

Posted 05-13-2008 by vinodkumar | no comments

Filed under: Misc, .NET, MS News, Technology

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 | no comments

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

Dell articles on SQL 2008

While browsing I just stumbled upon these articles from Dell. A good read:

Deployment Guide

SQL 2008 - Whitepaper

Posted 05-07-2008 by vinodkumar | no comments

Filed under: SQL Server, Technology

SQL Server 2008 - Experiences

If you are in India and have installed SQL Server 2008 as a POC in your companies doing some sort of migration, upgrade or even evaluating new features like Filestream, XML, Geo Spatial etc - I would like to know more from you. Please drop me a line at - ITPro[at]ExtremeExperts.com.

I would also be interested if you have done something specific around Win Server 2008 (Virtualization, NAP or IIS 7) too.

Posted 05-05-2008 by vinodkumar | no comments

Filed under: SQL Server, Misc, ITPro

Search

This Blog

• Home
• About
• RSS for Posts
• Atom

Tags

Community

Archives

My Web Site

• ExtremeExperts
• Twitter Spot

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
• Hyper-V Resources
• Service Broker - Bookmarks

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.
  
  Follow me on Twitter: vinodk_sql
  
  Site Counter: