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 itself who doesn’t understand networking with rest all constraints/features as it…

1

Windows Clustering [WSFC]

One of the videos on Windows Server Failover Clustering. [Video]

0

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 “We don’t support WSFC migration from one…

2

SQL Server 2012 AlwaysOn

Extracts from my last SQL AlwaysOn Delivery…

2

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

0

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 it available on the Web for rest of the world….

0

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 for proper conflict resolution practices – Data issue could fail entire…

0

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 server but it should not traverse across other locations. They had location identified in the…

0

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 is very small (4-5 GB) They have written custom SP which can write…

0

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 be empty, they could not follow the strategy and added data in the last partition…

1