Welcome to TechNet Blogs Sign in | Join | Help

Browse by Tags

Wednesday, June 17, 2009 5:19 PM

Failover Cluster Testing Methods

1.1 System Failover Testing During system testing, we will gather as much information as possible about the potential outcomes of system failures. We will not test, however, many component failures in the system such as a motherboard going out, losing
Posted by vishah | 0 Comments
Wednesday, May 06, 2009 10:52 AM

Extracting Project Actuals information from Microsoft Project Server (MSPS)

MSPS has four databases that it stores data from Enterprise Project Server – Draft, Published, Reporting, and Archive databases.   It is recommended not to query Draft and Published databases directly.   Reporting database as name
Posted by vishah | 0 Comments
Monday, April 21, 2008 2:10 PM

Storage Consideration for SQL Server 2005 DW environment

Storage design is a key component of data warehouse/BI environment. Optimum storage design provides significant performance. SQL Server performance depends heavily on the I/O subsystem. Unless your database fits into physical memory, SQL Server constantly
Posted by vishah | 2 Comments
Wednesday, February 27, 2008 10:17 PM

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 2007.   Here is some details on how it works and how can it save big bucks when comparing with other backup compression tool in market such as LiteSpeed.
Posted by vishah | 1 Comments
Thursday, February 07, 2008 11:13 PM

A Great SQL Resource - SQLCommunity.com

I came across www.SQLCommunity.com - a great resource for SQL Server. It has tones of information including Scripts and Tools, Tips, Tricks and Techniques, lots of info on SQL Events, etc. This site is run by Saleem Hakani - a Microsoft Database Engineer.
Posted by vishah | 0 Comments
Tuesday, December 04, 2007 3:25 PM

Finding Missing Indexes and Unused Indexes using DMVs

Finding Missing Indexes: Dynamic management object Information returned sys.dm_db_missing_index_group_stats Returns summary information about missing index groups, for example, the performance improvements that could be gained by implementing a specific
Posted by vishah | 0 Comments
Tuesday, December 04, 2007 3:16 PM

DDL Triggers and LOGON Triggers

DDL Triggers: DDL triggers can be used for administrative tasks such as auditing and regulating database operations. Use DDL triggers when you want to do the following: ¾ You want to prevent certain changes to your database schema. ¾ You want something
Posted by vishah | 1 Comments
Monday, September 24, 2007 11:16 PM

Plan Cache Analysis in SQL Server 2005

Plan Cache: The portion of the memory pool allocated to store Query execution Plan For how much memory is allocated for Plan Cache in different version of SQL server, please refer to my blog: - Understanding Query Plan Cache in SQL 2005 SP2 - why it's
Posted by vishah | 1 Comments
Monday, September 24, 2007 3:18 PM

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 storing execution plans. There is a very good blog written by SQL Programmability team on why Query Plan Cache behavior changed in SQL 2005 SP2 vs. SQL 2000
Posted by vishah | 1 Comments
Friday, September 14, 2007 3:14 PM

Maximum Capacity Specification for SQL Server 2005 and 2008

I came across this link - http://technet.microsoft.com/en-us/library/ms143432(SQL.100).aspx .  Its amazing to see the max capacity specification for SQL Server.    These are for SQL Server 2008, but they haven't changed from SQL Server
Posted by vishah | 0 Comments
Wednesday, August 15, 2007 4:26 PM

Useful information about Guest Account in SQL Server

guest user When a database is created, the database includes a guest user by default. Permissions granted to the guest user are inherited by users that do not have a user account in the database. The guest user cannot be dropped, but it can be disabled
Posted by vishah | 0 Comments
Thursday, July 12, 2007 12:57 PM

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 sysadmin role on a server or if you are part of local administrators group on the server, there is no problem connecting to Integration Services server from
Posted by vishah | 0 Comments
Tuesday, June 26, 2007 1:31 PM

Connecting to multiple Data Sources using single Report

I have been looking for something like this for ages. This could be very useful to run a common report on a multiple servers. http://technet.microsoft.com/en-us/library/ms156450.aspx Data Source Expressions: You can put an expression into a connection
Posted by vishah | 0 Comments
Filed under:

Attachment(s): RSConString.jpg
Thursday, May 10, 2007 11:11 AM

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

I was reading a blog post from Chad Boyd - http://blogs.msdn.com/chadboyd/archive/2007/03/24/pae-and-3gb-and-awe-oh-my.aspx . He has very detailed and excellent information about /3GB PAE and AWE. It made my understanding more clear. Here is the summarized
Posted by vishah | 0 Comments
Filed under:
Friday, May 04, 2007 12:15 PM

Data Scripter Utility for SSMS

You can generate a script for a data within a table - whole bunch of insert statement. There is an external plug-in available at http://www.codeproject.com/useritems/enisey.asp . I downloaded it and installed it on my machine, it works great. After installing
Posted by vishah | 1 Comments
More Posts Next page »
 
Page view tracker