The Curious Engineer

All blogs / Databases

Vipul Shah's SQL Blogs

learn.microsoft.com/en-us/archive/blogs/vipulshah

SQL Server Blogs

DatabasesMicrosoft blogsMSDN archive

’10’15’20’25
Posts
48 from 30 Nov 2006 to 6 Jun 2013
Posting
archived, read-only
Kind
personal blog
Feed
https://learn.microsoft.com/en-us/archive/blogs/vipulshah/feed.xml

2013 3

  1. Want to know Business Intelligence and Business Analytics on Small Data, Big Data, All Data?
  2. How to apply Filter in Data Explorer Formula
  3. Amazing Bing Map Apps

2012 4

  1. Changing System Administrator Account for Master Data Services–would need this after restoring MDS database to another instance of SQL Server
  2. How to handle Error: “Error - The member code is inactive.” while dealing with Consolidated Member in Master Data Services
  3. “What’s New” webpart on SharePoint 2010 - list is not showing up in Target List drop-down?
  4. Objects Overview in MDM database created by Master Data Services in SQL Server 2012 RC0

2011 4

  1. Registering multiple servers in Central Management Server (CMS) using PowerShell Script
  2. Importing Data from MS Access 2010 64-bit .accdb database into SQL Server using SSIS
  3. SSRS 2008 R2, SharePoint 2010 - Report Back button doesn't work beyond 1st level of drill through
  4. Visio Forward Engineering to SQL Database

2010 8

  1. Always On–New Feature: “Availability Group” in Denali
  2. SQL PASS Conference - Day 1: Highlights–CRESCENT, “Atlanta”, COLUMNSTORE in relational engine
  3. Very good article on SQL Azure–a-must-read info
  4. Common SQL Server Myths by Paul Randal
  5. How to turn Reporting Services Features such as–Schedule Events and Report Delivery and Web Service and HTTP Access–On or Off
  6. Latest Post on CodePlex by Visual Studio ALM Rangers–Guidance on Visual Studio 2010 Database Projects
  7. Redirecting SQL Client connection to different instance of SQL who is listening to 1433 (default port) without altering client ConnectionString
  8. Preparing a SlipStream (Merged) Installation for SQL Server 2008 + SP1 + CU8

2009 3

  1. Failover Cluster Testing Methods
  2. Extracting Project Actuals information from Microsoft Project Server (MSPS)
  3. UDF and Performance

2008 3

  1. Storage Consideration for SQL Server 2005 DW environment
  2. Data Protection Manager - an ultimate solution for protecting SQL Server data
  3. A Great SQL Resource - SQLCommunity.com

2007 21

  1. Finding Missing Indexes and Unused Indexes using DMVs
  2. DDL Triggers and LOGON Triggers
  3. Plan Cache Analysis in SQL Server 2005
  4. Understanding Query Plan Cache in SQL 2005 SP2 - why it's changed from SQL 2005 RTM/SP1?
  5. Maximum Capacity Specification for SQL Server 2005 and 2008
  6. Useful information about Guest Account in SQL Server
  7. Connecting to Remote Integration Services Server - info with missing things on msdn article
  8. /3GB /PAE and AWE on 32-bit Systems
  9. Data Scripter Utility for SSMS
  10. "Transparent" Benefits of SQL Server 2005
  11. SQL Server 2005 Service Pack 2 (SP2) post fixes explained - 9.0.3054 OR 9.0.3059
  12. Default Trace in SQL Server 2005
  13. Generating Scripts only for Clustered and Non-Clustered indexes in SQL Server 2005
  14. Physical Database Storage Design and Disk Allocation
  15. How to identify which DTS Package is being called by scheduled job
  16. How to check the status of SQL Server Services remotely?
  17. How to parse the view definition and get the base tables and base columns information
  18. Indexing a SQL Table
  19. Table Partitioning in SQL 2005
  20. 64-bit - Query performance
  21. Why 64-bit?

2006 2

  1. Say "No" to in-line SQL
  2. Useful resources for migrating to SQL Server 2005