All things Data Related....

On this site I will be posting entries related to Data platform and analytics that I learn and believe could be valuable learning to others who want insight from their data

September, 2007

  • Windows Server 2008 Rockin

    Okay okay I know this is not related to SQL Server, however I believe as SQL Server sits on top of WIndows Server, it is always good to know what is happening in the Windows world. In addition I am just using this entry to plug my brother's Amit Pawar...
  • Pre-req for SQL Server Clustering Installation

    Here is a list of services that needs to be running on ALL Cluster Nodes prior to installing SQL Server on a Windows Cluster. On the server or if clustered on all nodes stop the services again except for: · Alerter · Cluster Service · Computer...
  • SQL Server Compact Edition v3.5 Management

    SSCE 3.5 is not supported with SQL Server 2005 Management Studio. You need to use either the SQL Server Management Studio in SQL Server 2008 or Server Explorer in Orcas Beta 2 to query SQL Compact 3.5 databases.
  • Watch Out Pt 1 - Ensure you utilise appropriate data types and use explicit CAST/CONVERT in queries

    I will use the title of "Watch Out" to write about things I see customers implement "incorrectly" or not according to best practices. During a delivery of the SQL Server 2005 Performance Tuning and Optimisation course one of the attendees showed me...
  • Shri

    As it is Indian tradition, when starting any letter, official document or academic writing, the first thing we write is Shri at the top of the page. So in keeping up with my traditions my first blog is also "Shri". Background on Shri In Hinduism...