Microsoft Test Manager 2010

Testing Tools, Varinder Sandhu, Visual Studio

I have attended the Microsoft webcast topic “Developers and Testers Working Together” It was really useful tool for tester provided by Microsoft in Visual Studio 2010. This new feature is known as “Microsoft Test Manager”   so sharing with you very brief information as below: Visual Studio 2010 introduces a new set of tools and capabilities that enable testers to easily create actionable bugs when a defect is found. The level of data collected and attached to the bug enables developers

» Read more
, ,

Soft Skills for IT Professionals

Career Development, Varinder Sandhu

In today’s life we all know soft skills are very important for IT Professionals. Lot of detailed stuff is available over the internet but here sharing with you the brief key points. Soft skills are often described by using terms often associated with personality traits, such as: Social Graces Language Personal Habits Optimism Responsibility A Sense of Humor A person’s soft skill is an important part of their individual contribution to the success of an organization. Key Soft Skills IT

» Read more
,

SQL Server – Validation of Backup

SQL, SQL-Advanced, SQL-Backup & Restore, SQL-Tips and Tricks, Varinder Sandhu

Database backup are insurance policy for a database, we need to ensure that backups created are valid and useful. To validate the backup, we can use following command Restore verifyonly from <backup device> When a backups is validated, SQL Server performs the following steps Calculated a checksum for the backup and compare to checksum stored in the backup files Verify that the header of backup is correctly written and valid Transits the page chain to ensure that all pages are

» Read more
, , , ,

SQL Server – Policy Based Management

SQL, SQL-Advanced, SQL-General, Varinder Sandhu

SQL Server 2008 has a new feature called Policy Based Management, also know as Declarative Management Framework (DMF), to tackle the problem of standardizing your SQL server instance. Although Policy Based Management can be used just to alert an administrator when an object is out of compliance, depending upon the type of policy, you can also enforce compliance by preventing changes that would violate a policy. Policy Based Management introduces the following new objects that are used to design and

» Read more
, ,

SQL Server – Distributing and Partitioning

SQL, SQL-Advanced, SQL-General, Varinder Sandhu

Key Points of Distributing and Partitioning Partition allow you to divide a table or index into multiple filegroups. Table and index are partition horizontally, based on rows by specifying a partitioning column. To create a portioned table or index you need to perform the following actions: Create a partition function Create a partition schema mapped to partition function Create a table or index on the partition schema SPLIT function to add a new boundary point and hence partition. MERGE function

» Read more
, , ,

SQL Server – Backup Type for Each Recovery Model

SQL, SQL-Advanced, SQL-Backup & Restore, SQL-General, Varinder Sandhu

Before looking about Backup type for each Model, sharing with brief information about Recovery and Recovery Model Recovery Recovery options determine the behavior of transaction log and how damaged pages are handled. Recovery Model Every database within a SQL server a SQL server instance has a property setting called recovery model. The recovery model determines the types of backups you can perform against a database. The recovery models available in SQL server 2008 are: Full Bulk-Logged Simple

» Read more
, , , ,

SQL Server – Backup all the sql server databases

SQL, SQL-Advanced, SQL-Backup & Restore, SQL-Query, SQL-Scripts, SQL-Tips and Tricks, Varinder Sandhu

Sharing with you script to backup all the SQL server databases Script: DECLARE @name VARCHAR(50) — database name DECLARE @path VARCHAR(256) — path for backup files DECLARE @fileName NVARCHAR(256) — filename for backup DECLARE @fileDate VARCHAR(20) — used for file name SET @path = ‘D:Backup’ SELECT @fileDate = CONVERT(VARCHAR(20),GETDATE(),113) SELECT name,flag=0 INTO #temp FROM master.dbo.sysdatabases WHERE name NOT IN (‘master’,’model’,’msdb’,’tempdb’) –according to requirement we can filter databases in where clause SET ROWCOUNT 1 WHILE (exists(SELECT * FROM #temp WHERE flag=0))

» Read more
, ,

SQL Server – Understanding the System Databases of SQL Server

SQL, SQL-Advanced, SQL-General, Varinder Sandhu

We all know there are some system databases available in SQL Server. But we should have understanding about system databases. Here just try to give you understanding of system databases very briefly. There are four system databases available in SQL Server 2008 Master Model msdb tempdb Master Database The master database records all the system-level information for a SQL Server system. The master is the database that records the existence of all other databases and the location of those database

» Read more
, , , , , , ,

SQL Server – Linked Server – Mapped all users with one statement

SQL, SQL-General, SQL-Linked Server, SQL-Scripts, SQL-Tips and Tricks, Varinder Sandhu

Hello Friends, I have setup the Linked server with the help of script here. My one of colleague helps me to write the script with we can map all user with one statement. This script will map all local SQL server users with remote user that you provide in the script. You don’t need to map all user manually. Script: EXEC master.dbo.sp_addlinkedserver @server = N‘dsql2k’, @srvproduct=N”, @provider=N‘SQLOLEDB’, @datasrc=N‘servername’ EXEC master.dbo.sp_addlinkedsrvlogin@rmtsrvname=N‘dsql2k’,@useself=N‘False’, @locallogin=NULL,@rmtuser=N‘sa’,@rmtpassword=‘XXXXXX’ if anybody have any other experience, please share as

» Read more
, ,

Transaction Isolation Level

Crystal Report, SQL, SQL-Advanced, Varinder Sandhu

What is default Isolation level for SQL Server 2008 or Crystal Report? Many people have same above question about Isolation Level, may we have same question. So here share the brief answers of this question. Transaction Isolation Level: In database systems, isolation is a property that defines how/when the changes made by one operation become visible to other concurrent operations. Default Isolation level for SQL Server 2008 is “Read Committed” SQL Server 2008 has following transaction isolation level Read Committed

» Read more
, , ,

SQL Server Editions

SQL, SQL-General, Varinder Sandhu

Dear friends Most of time we have a question about difference between the SQL server editions, Lot of detailed stuff available over the internet but here sharing with you the brief information about the each SQL server editions so that we can understand easily about all the editions. SQL server 2008 is available in the following editions Enterprise: Designed for largest organizations and those needing to leverage the full power of SQL server 2008 platform. Learn More Standard: Designed for

» Read more
, , , , , , ,
1 … 19 20 21 22 23 … 26