Feeds:
Posts
Comments

Archive for the ‘SQL Data Storage’ Category

SQLAuthority News – Data Compression Strategy Capacity Planning and Best Practices

Posted in Pinal Dave, SQL, SQL Authority, SQL Data Storage, SQL Query, SQL Server, SQL Tips and Tricks, SQL White Papers, SQLAuthority News, T SQL, Technology, tagged on November 7, 2009 | Leave a Comment »

The data compression feature in SQL Server 2008 helps compress the data inside a database, and it can help reduce the size of the database. Apart from the space savings, data compression provides another benefit: Because compressed data is stored in fewer pages, queries need to read fewer pages from the disk, thereby improving the [...]

Read Full Post »

SQL SERVER – Mirrored Backup and Restore and Split File Backup

Posted in Pinal Dave, SQL, SQL Authority, SQL Backup and Restore, SQL Data Storage, SQL Query, SQL Scripts, SQL Server, SQL Tips and Tricks, SQLServer, T SQL, Technology on September 2, 2009 | 9 Comments »

Introduction
This article is based on a real life experience of the author while working with database backup and restore during his consultancy work for various organizations. We will go over the following important concepts of database backup and restore.

Conventional Backup and Restore
Spilt File Backup and Restore
Mirror File Backup
Understanding FORMAT Clause
Miscellaneous details about Backup and Restore

Note: [...]

Read Full Post »

SQL SERVER – Introduction to SQL Azure

Posted in Pinal Dave, SQL, SQL Authority, SQL Data Storage, SQL Documentation, SQL Query, SQL Server, SQL Tips and Tricks, T SQL, Technology, tagged , on August 27, 2009 | 4 Comments »

What is SQL Azure?
In short, SQL Azure is simply a Microsoft branding change. SQL Services and SQL Data Services are now known as Microsoft SQL Azure and SQL Azure Database. There are a few changes, but fundamentally Microsoft’s plans to extend SQL server capabilities in cloud as web-based services remain intact. SQL Azure will continue [...]

Read Full Post »

SQL SERVER – SQL Server Express – A Complete Reference Guide

Posted in Pinal Dave, SQL, SQL Authority, SQL Data Storage, SQL Query, SQL Server, SQL Tips and Tricks, T SQL, Technology, tagged , on August 26, 2009 | 5 Comments »

SQL Server Express is one of the most valuable products of Microsoft. Very often, I face many questions with regard to SQL Server Express. Today, we will be covering some of the most commonly asked questions.
Q: What is the cost of SQL Server Express?
A: SQL Server Express is a FREE product from Microsoft.
Q: Where can [...]

Read Full Post »

SQL SERVER – Introduction to Change Data Capture (CDC) in SQL Server 2008

Posted in Database, Pinal Dave, SQL, SQL Authority, SQL Data Storage, SQL Query, SQL Scripts, SQL Server, SQL Tips and Tricks, SQL Utility, T SQL, Technology on August 15, 2009 | 5 Comments »

Simple-Talk.com has published my very first article on their site. This article is introducing Change Data Capture – the new concept introduced in SQL Server 2008. Change Data Capture records INSERTs, UPDATEs, and DELETEs applied to SQL Server tables, and makes a record available of what changed, where, and when, in simple relational ‘change tables’ [...]

Read Full Post »

SQL SERVER – Four Different Ways to Find Recovery Model for Database

Posted in Pinal Dave, SQL, SQL Authority, SQL Backup and Restore, SQL Data Storage, SQL Query, SQL Scripts, SQL Server, SQL Tips and Tricks, T SQL, Technology on July 16, 2009 | 7 Comments »

Perhaps, the best thing about technical domain is that most of the things can be executed in more than one ways. It is always useful to know about the various methods of performing a single task. Today, we will observe four different ways to find out recovery model for any database.
Method 1
Right Click on Database [...]

Read Full Post »

SQL SERVER – Restore Sequence and Understanding NORECOVERY and RECOVERY

Posted in Pinal Dave, Readers Question, SQL, SQL Authority, SQL Backup and Restore, SQL Data Storage, SQL Query, SQL Scripts, SQL Server, SQL Tips and Tricks, T SQL, Technology on July 15, 2009 | 4 Comments »

I maintain a spreadsheet of questions sent by users and from that I single out a topic to write and share my knowledge and opinion. Unless and until I find an issue appealing, I do not prefer to write about it, till the issue crosses the threshold. Today the question that crossed the threshold is [...]

Read Full Post »

SQL SERVER – BLOB – Pointer to Image, Image in Database, FILESTREAM Storage

Posted in Pinal Dave, SQL, SQL Authority, SQL Data Storage, SQL Query, SQL Server, SQL Tips and Tricks, SQLServer, T SQL, Technology on July 13, 2009 | 10 Comments »

When it comes to storing images in database there are two common methods. I had previously blogged about the same subject on my visit to Toronto. With SQL Server 2008, we have a new method of FILESTREAM storage. However, the answer on when to use FILESTREAM and when to use other methods is still vague [...]

Read Full Post »

SQL SERVER – Standby Servers and Types of Standby Servers

Posted in Pinal Dave, SQL, SQL Authority, SQL Backup and Restore, SQL Data Storage, SQL Query, SQL Server, SQL Tips and Tricks, T SQL, Technology on July 11, 2009 | 3 Comments »

Standby servers – Standby Server is a type of server that can be brought online in a situation when Primary Server goes offline and application needs continuous (high) availability of the server. There is always a need to set up a mechanism where data and objects from primary server are moved to secondary (standby) server. [...]

Read Full Post »

SQL SERVER – Restore or Attach Database Without .NDF or .MDF is Not Possible

Posted in Database, Pinal Dave, SQL, SQL Authority, SQL Backup and Restore, SQL Data Storage, SQL Error Messages, SQL Query, SQL Server, SQL Tips and Tricks, T SQL, Technology on April 10, 2009 | 3 Comments »

This article revolves around a trivial yet common issue. There might be a set of people for whom the current topic might appear to be insignificant. But I have been asked this question innumerable times, particularly from   people who are frequenting using forums or have blog related to storage and highly availability, which instigated me [...]

Read Full Post »

Older Posts »