Vipul Shah's SQL Blogs

SQL Server Blogs

Want to know Business Intelligence and Business Analytics on Small Data, Big Data, All Data?

Check out these series of videos..   https://www.youtube.com/watch?v=dBkzmwaSRUc A Growing...

Author: VipulShah Date: 06/06/2013

How to apply Filter in Data Explorer Formula

I ran into below particular scenario. My Sample Table:   Desired Output:   In PowerPivot...

Author: VipulShah Date: 05/07/2013

Amazing Bing Map Apps

Did you know there are lots of free Bing Map Apps available? Just go to https://www.bing.com/maps...

Author: VipulShah Date: 01/31/2013

Changing System Administrator Account for Master Data Services–would need this after restoring MDS database to another instance of SQL Server

When you try to restore MDS database from one server to another server in a different domain where...

Author: VipulShah Date: 11/05/2012

How to handle Error: “Error - The member code is inactive.” while dealing with Consolidated Member in Master Data Services

I ran into a situation where I accidently deleted a consolidated member through UI (soft delete...

Author: VipulShah Date: 03/27/2012

“What’s New” webpart on SharePoint 2010 - list is not showing up in Target List drop-down?

We have a SharePoint team site which is very heavily used. Lot of changes occur in many lists,...

Author: VipulShah Date: 01/18/2012

Objects Overview in MDM database created by Master Data Services in SQL Server 2012 RC0

There are so many objects in MDM database that gets created when you create a model in Master Data...

Author: VipulShah Date: 01/10/2012

Registering multiple servers in Central Management Server (CMS) using PowerShell Script

  Below are the steps using PowerShell script (learned from another Kalyan Yella, Microsoft):...

Author: VipulShah Date: 06/13/2011

Importing Data from MS Access 2010 64-bit .accdb database into SQL Server using SSIS

  Problem: You can’t connect using Native OLEDB \Microsoft Jet 4.0 OLEDB Provider.  It...

Author: VipulShah Date: 06/07/2011

SSRS 2008 R2, SharePoint 2010 - Report Back button doesn't work beyond 1st level of drill through

  Problem: I have three reports - ParentReport - X, ChildReport- A, ChildReport - B of A. Drill...

Author: VipulShah Date: 06/07/2011

Visio Forward Engineering to SQL Database

From SQLBI.com Visio Forward Engineer is an Office 2010 add in that provides Visio the ability to...

Author: VipulShah Date: 02/16/2011

Always On–New Feature: “Availability Group” in Denali

In Denali, there is a new feature called – Availability Group.   With this feature you can...

Author: VipulShah Date: 11/15/2010

SQL PASS Conference - Day 1: Highlights–CRESCENT, “Atlanta”, COLUMNSTORE in relational engine

·         CRESCENT is BIG thing!!   Great product,...

Author: VipulShah Date: 11/12/2010

Very good article on SQL Azure–a-must-read info

  Inside SQL Azure - TechNet Articles - Home - TechNet Wiki

Author: VipulShah Date: 11/02/2010

Common SQL Server Myths by Paul Randal

  https://www.sqlskills.com/blogs/paul/CommonSQLServerMyths.pdf This is a very good article by...

Author: VipulShah Date: 10/21/2010

How to turn Reporting Services Features such as–Schedule Events and Report Delivery and Web Service and HTTP Access–On or Off

According to SQL CAT team article on best practices consideration on RS-Scale out deployment -...

Author: VipulShah Date: 10/14/2010

Latest Post on CodePlex by Visual Studio ALM Rangers–Guidance on Visual Studio 2010 Database Projects

Project Description Practical guidance for Visual Studio 2010 Database projects, which is focused on...

Author: VipulShah Date: 08/22/2010

Redirecting SQL Client connection to different instance of SQL who is listening to 1433 (default port) without altering client ConnectionString

Scenario: Current Setup: SQL Server 2005 Default instance – PRODServer listening at default port...

Author: VipulShah Date: 06/07/2010

Preparing a SlipStream (Merged) Installation for SQL Server 2008 + SP1 + CU8

There is known issue with SQL Server 2008 RTM Install. https://support.microsoft.com/kb/957453/....

Author: VipulShah Date: 06/07/2010

Failover Cluster Testing Methods

1.1 System Failover Testing During system testing, we will gather as much information as possible...

Author: VipulShah Date: 06/17/2009

Extracting Project Actuals information from Microsoft Project Server (MSPS)

MSPS has four databases that it stores data from Enterprise Project Server – Draft, Published,...

Author: VipulShah Date: 05/06/2009

UDF and Performance

This was one of the thread entry in SQL discussion by Umachandar who is from SQL Product Team,...

Author: VipulShah Date: 01/13/2009

Storage Consideration for SQL Server 2005 DW environment

Storage design is a key component of data warehouse/BI environment. Optimum storage design provides...

Author: VipulShah Date: 04/21/2008

Data Protection Manager - an ultimate solution for protecting SQL Server data

I learned about new tool from Microsoft System Center family called Data Protection Manager...

Author: VipulShah Date: 02/27/2008

A Great SQL Resource - SQLCommunity.com

I came across www.SQLCommunity.com - a great resource for SQL Server. It has tones of information...

Author: VipulShah Date: 02/08/2008

Finding Missing Indexes and Unused Indexes using DMVs

Finding Missing Indexes: Dynamic management object Information returned...

Author: VipulShah Date: 12/04/2007

DDL Triggers and LOGON Triggers

DDL Triggers: DDL triggers can be used for administrative tasks such as auditing and regulating...

Author: VipulShah Date: 12/04/2007

Plan Cache Analysis in SQL Server 2005

Plan Cache: The portion of the memory pool allocated to store Query execution Plan For how much...

Author: VipulShah Date: 09/25/2007

Understanding Query Plan Cache in SQL 2005 SP2 - why it's changed from SQL 2005 RTM/SP1?

Query execution plan gets stored in Plan Cache - the portion of the memory pool allocated for...

Author: VipulShah Date: 09/24/2007

Maximum Capacity Specification for SQL Server 2005 and 2008

I came across this link - https://technet.microsoft.com/en-us/library/ms143432(SQL.100).aspx. ...

Author: VipulShah Date: 09/14/2007

Useful information about Guest Account in SQL Server

guest user When a database is created, the database includes a guest user by default. Permissions...

Author: VipulShah Date: 08/15/2007

Connecting to Remote Integration Services Server - info with missing things on msdn article

I found it hard way how to connect to Integration Services server remotely. If you are part of...

Author: VipulShah Date: 07/12/2007

/3GB /PAE and AWE on 32-bit Systems

I was reading a blog post from Chad Boyd -...

Author: VipulShah Date: 05/10/2007

Data Scripter Utility for SSMS

You can generate a script for a data within a table - whole bunch of insert statement. There is an...

Author: VipulShah Date: 05/04/2007

"Transparent" Benefits of SQL Server 2005

Did you know? In SQL Server 2005: DBCC - uses snapshot framework avoiding locks - no table level...

Author: VipulShah Date: 05/02/2007

SQL Server 2005 Service Pack 2 (SP2) post fixes explained - 9.0.3054 OR 9.0.3059

This is from Bob Ward's Blog -...

Author: VipulShah Date: 04/16/2007

Default Trace in SQL Server 2005

The Default Trace is something completely new that Microsoft has implemented to audit certain events...

Author: VipulShah Date: 04/16/2007

Generating Scripts only for Clustered and Non-Clustered indexes in SQL Server 2005

In following cases you will need to generate a scripts for all the clustered and non-clustered...

Author: VipulShah Date: 04/05/2007

Physical Database Storage Design and Disk Allocation

The system page file should not be on the same physical spindle as any database files, otherwise you...

Author: VipulShah Date: 03/14/2007

How to identify which DTS Package is being called by scheduled job

I have seen where DBAs would right click the DTS Package (SQL 2000) and schedule a job. If you...

Author: VipulShah Date: 03/12/2007

How to check the status of SQL Server Services remotely?

There is windows “SC” utility and the following “Heart Beat” approach....

Author: VipulShah Date: 03/06/2007

How to parse the view definition and get the base tables and base columns information

You can use INFORMATION_SCHEMA.VIEW_TABLE_USAGE and INFORMATION_SCHEMA.VIEW_COLUMN_USAGE from SQL70...

Author: VipulShah Date: 03/06/2007

Indexing a SQL Table

I found one of my old documents where I kind of summarized Indexes on a SQL Table, might help....

Author: VipulShah Date: 03/01/2007

Table Partitioning in SQL 2005

This feature of SQL Server 2005 is one of the provided Solutions for Large Tables in SQL by...

Author: VipulShah Date: 02/28/2007

64-bit - Query performance

There are clearly a lots of advantages on going to 64-bit. Read my previous blog on advantages of...

Author: VipulShah Date: 02/15/2007

Why 64-bit?

Why 64-bit? Memory Addressability: A 32-bit system can directly address only a 4-GB address space....

Author: VipulShah Date: 01/30/2007

Say "No" to in-line SQL

or suffer..... these are some points one should consider when using in-line SQL: · Tuning and...

Author: VipulShah Date: 11/30/2006

Useful resources for migrating to SQL Server 2005

Comparing Enterprise Development Productivity: SQL Server 2005 versus SQL Server 2000...

Author: VipulShah Date: 11/30/2006