Paul wrote!

  • LocalDB - I keep forgetting

    Oh my my...my little brain keeps forgetting the set of commands to play with LocalDB. Today I again forgot so decided that enough is enough. I am going to document them. So as we know, LocalDB was introduced in SQL 2012 with SQL Express (An Express Engine...
  • Windows Clustering [WSFC]

    One of the videos on Windows Server Failover Clustering. [Please visit the original post to view the video]
  • Migrating a SQL Cluster across Domains

    In my recent visit to New Delhi, one of my good friend told me that he is planning for a SQL Cluster Migration from one domain to another . I was really concerned to hear that. In my previous engagements, we had similar requests and it’s very clear that...
  • SQL Server 2012 AlwaysOn

    Extracts from my last SQL AlwaysOn Delivery...
  • MOF v4.0 Foundation Course

    Here is one of the recent assignments on which I was working last month. http://blogs.technet.com/b/ptsblog/archive/2012/10/02/microsoft-operations-framework-mof-4-0-fundamentals.aspx
  • Merge Replication–Web Synchronization with FTP Snapshot

    This week I spent a good number of hours to review and assist a Web Synchronization lab setup for a Customer. We tried to look for all possible resources but unfortunately there is almost no Step-by-Step guide available on Web Sync. Thus, thought of making...
  • Web Application on Merge Publisher?

    Problem Statement: Referring back to two my previous posts on Merge Replication with SQL Server, there are few concerns as well with Merge Pub on few specific scenarios such as: - Merge Pub always wins so writing directly on the publisher is not recommended...
  • Few more Merge Replication Scenarios & Questions….

    Centralized DB with Merge Replication : Problem Description - In this scenario Customer wanted to setup a centralized DB with two location offices. They wanted to make sure that location specific data stays either in the particular location or on central...
  • A Merge Replication Scenario..

    One of my recent engagements on Merge Replication, I faced a scenario as below diagram: Scenario Details: Single copy of database at the publisher end which is working as the Publisher DB Database is the backend of Custom ERP application. Database size...
  • SQL–Partition SPLIT takes forever to create new empty partition

      This is one of those recent crazy cases where I was working. Issue Description Customer had a table of 1.5 TB in size with multiple partition (yearly partitioning strategy). Even though Microsoft always recommends that the last partition should...
  • SQL Create Login Failure (Microsoft SQL Server, Error: 15401)

    One of our folks was setting up his lab using Virtual Machines and he finished almost everything including setting up DC, Windows Cluster etc. but when he was trying to create an account in SQL Server, he was getting bellow error: After almost a day’s...
  • Reporting Services 2005 on Windows 2008

    With new architectural changes in SQL Server 2008, it’s much easy to use and configure SSRS 2008 on Windows Server 2008 (No need of IIS). But problem comes when people try to install SQL 2005 Reporting Service on top of Windows Server 2008 and particularly...
  • SQL Blogs Directory

    http://blogs.msdn.com/sqlcat/ http://blogs.msdn.com/adonet/ http://blogs.msdn.com/astoriateam/ http://blogs.msdn.com/slavao/ http://blogs.msdn.com/euanga/default.aspx http://blogs.msdn.com/sqlrem/ http://blogs.msdn.com/sqlexpress/ http://blogs.msdn.com...
  • Key Management Services–Confusion???

    One of the common scenario which is coming in to my way very frequently is KMS (Key Management Services).  This is very simple concept of deploying Activation server within your premise and activate your all latest products which supports Volume...
  • SQL Performance Analysis – CPU Bottleneck (Part 1)

    SQL Server Performance Monitoring and Troubleshooting is one of the Hot Topic for our Partners/Customers. There were so many workshops we organized/delivered around this topic in last few years but still demand has not reduced. So now let’s scribble something...
  • MySQL to MS SQL Server 2008 R2 Migration Experience with SSMA

    It is almost 7 years when I last used MySQL. In these 7 years MySQL has changed a lot and I also became a true MS SQL user/administrator. I realized this when I started setting up MySQL on my lab. Must say our SQL Server system is the best in usability...
  • Simplifying SQL Server Joins (Query and Internals)

    I love to explain things in much simpler way but SQL Joins are one of those concepts which are not so simple to explain and I really spend a lot of time in scribbling on White Board for this. But finally I found an article from Jeff Atwood where he did...
  • Install Windows 7 from USB Stick (No more burning on DVD Media)

    Windows 7 RC has come out and most of you must be looking at possibilities of installing and playing with the new gen Windows OS as I was till yesterday! A big pain in this entire process is first download the image from the site and then burn it on a...
  • Support Becomes Easier

    We made the troubleshooting support access much easier for our Partners and we are constantly updating our Partners about the same. If you don’t have the details yet, please follow the below steps: Go to https://support.microsoft.com/oas/default.aspx...
  • Free unlimited installation and compatibility support for Windows Vista SP1

    Free unlimited installation and compatibility support is available for Windows Vista, but only for Service Pack 1 (SP1). This support for SP1 is valid until March 18, 2009. Chat and e-mail support is available only in the United States and Canada. Some...
  • Microsoft made Hotfix available online

    Do you spend lot of time waiting in the Microsoft Phone Support Queue just to request a Hotfix? Forget those old days...yes now you can view and download the Hotfix package directly from Microsoft website and you need not to call Microsoft Support for...
  • Where is Vista SP1 MUI Packs?

    Ok…till now I got tons of responses for my previous blog post on Vista RTM MUI . I know everyone is looking for Vista SP1 MUI but where are they? So to address all those asks...here is what we have for you: 1) If you are installing Windows Vista...
  • BitLocker!!#$?! What all downloads are available...

    BitLocker Drive Preparation Tool: Windows BitLocker Drive Encryption is a feature that encrypts one or more volumes (drives) attached to your computer and that can use a Trusted Platform Module (TPM) to verify the integrity of early startup components...
  • This is again good to have!! All updates included in Windows Vista SP1

    KBArticle Title Issue Type Component Link 843289 Proxy server settings are not set correctly in Internet Explorer after you download a proxy script that uses chunk encoding Hotfix Desktop Technologies http://support.microsoft.com/kb/843289 870853 Office...
  • Hoolala...One Step Download for MUI Packs of Windows Vista

    Vista Ultimate x86 MUI Language Packs Vista Ultimate x64 MUI Language Packs Danish language pack German language pack English language pack Spanish language pack Finnish language pack French language pack Italian language pack Japanese language pack Korean...