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...
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...
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...
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...
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...
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,...
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...
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):...
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...
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...
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...
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...
Date: 11/15/2010
SQL PASS Conference - Day 1: Highlights–CRESCENT, “Atlanta”, COLUMNSTORE in relational engine
· CRESCENT is BIG thing!! Great product,...
Date: 11/12/2010
Very good article on SQL Azure–a-must-read info
Inside SQL Azure - TechNet Articles - Home - TechNet Wiki
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...
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 -...
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...
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...
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/....
Date: 06/07/2010
Failover Cluster Testing Methods
1.1 System Failover Testing During system testing, we will gather as much information as possible...
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,...
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,...
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...
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...
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...
Date: 02/08/2008
Finding Missing Indexes and Unused Indexes using DMVs
Finding Missing Indexes: Dynamic management object Information returned...
Date: 12/04/2007
DDL Triggers and LOGON Triggers
DDL Triggers: DDL triggers can be used for administrative tasks such as auditing and regulating...
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...
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...
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. ...
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...
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...
Date: 07/12/2007
/3GB /PAE and AWE on 32-bit Systems
I was reading a blog post from Chad Boyd -...
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...
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...
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 -...
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...
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...
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...
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...
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....
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...
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....
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...
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...
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....
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...
Date: 11/30/2006
Useful resources for migrating to SQL Server 2005
Comparing Enterprise Development Productivity: SQL Server 2005 versus SQL Server 2000...
Date: 11/30/2006