Browse by Tags

Free! Get 5GB online storage with SkyDrive‏

Published 27 March 8 4:35 PM | SSQA.net

Well I'm not promoting any product here, but amused to see the email I have got from Microsoft on using Windows Live services. I can say this is true offerring and easy to access your files wherever you are, your data - any time any place! . Forget...

Filed under: microsoft, data, services, windows, space, storage, free, disks, files, anywhere, live, skydrive

SQL Server 2000 and SQL Server 2005 support for mounted volumes

Published 5 October 7 7:30 AM | SSQA.net

The following pages were recently modified. Source: Knowledge Base Product: Microsoft SQL Server 2005 Enterprise Edition & SQL Server 2005 Standard Edition Notification Contents: New and Major Modifications SQL Server 2000 and SQL Server 2005 support...

Filed under: sql server, kba, standard, 2000, storage, clustering, 2005, mounted, volume

Dynamic formatting within the reports using TSQL?

Published 3 October 7 4:56 AM | SSQA.net

I felt this is more about SQL Storage engine related blog, but there is blend of TSQL involved in tasking the dynamic reporting within the Reporting Services. Here it goes, the task is to change/highlight the color of a row, based on its value. Therefore...

Filed under: sql server, report builder, storage, reporting services, tsql, results, iif

Determining the required capacity of an I/O subsystem before deploying the database

Published 17 September 7 8:49 AM | SSQA.net

It is a good practice to determine the required capacity for a database application before it is deployed on the Production environment. As it speaks the I/O system is "most" important to the performance of SQL Server, in the event of any performance...

Filed under: sql server, performance, microsoft, security, i/o, storage, throughput, vendor

VMware Enterprise Desktop Seminar Series - Storage and Capacity

Published 10 September 7 3:0 PM | SSQA.net

VMware Enterprise Desktop Seminar Series. Register now . Built on an enterprise-proven platform running in 100 of the Fortune 100, VMware desktop virtualization solutions transform how organizations deploy and manage their PCs. Attend a live seminar to...

Filed under: sql server, seminar, storage, virtual server, server consolidation, vmware

FAN - File Area Networks

Published 1 September 7 8:51 AM | SSQA.net

Gain control over the growing amount of file data in your enterprise. Learn how File Area Networks (FANs) can help you centralize file consolidation, migration, replication, and failover. Download this eBook and start streamlining your file management...

Filed under: sql server, windows, disaster recovery, storage, disks, fan

What is the difference between having a char vs varchar column as part of a primary key?

Published 16 August 7 3:11 AM | SSQA.net

As it sounds this is an interview question, but if you look at the logical level of nothing much changes. There are two major concerns using such way, Performance and Storage space. In this using fixed char fields can be queried faster than varchar fields...

Filed under: performance, space, storage, varchar, vs, difference, char

FIX: Error message when you use the Playback Capture Wizard (PCW) to capture a backup of a database that is larger than 2 terabytes: "Unable to obtain required information about the server"

Published 28 June 7 12:42 PM | SSQA.net

Source: Knowledge Base Product: Microsoft SQL Server 2005 Standard Edition & SQL Server 2005 Enterprise X64 Edition Notification Contents: New and All Modifications FIX: Error message when you use the Playback Capture Wizard (PCW) to capture a backup...

Filed under: sql server, backup, database, kba, storage

SQL Server 2005 Design Considerations for Migration

Published 28 June 7 12:26 PM | SSQA.net

Scalability is a major concern when preparing your SQL Server 2005 migration. With database growth, in size and number, common challenges revolve around meeting performance requirements and being able to complete business processes in time. Attend this...

Filed under: sql server, databases, webcast, storage, growth