July « 2009 « SQL Server Journey with SQL Authority

Archive for July, 2009

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 | 12 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 [...]

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 | 28 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 – Backup Timeline and Understanding of Database Restore Process in Full Recovery Model

Posted in Pinal Dave, SQL, SQL Authority, SQL Backup and Restore, SQL Query, SQL Server, SQL Tips and Tricks, SQLServer, T SQL, Technology on July 14, 2009 | 38 Comments »

I assume you all know that there are three types of Database Backup Models, so we will not discuss on this commonly known topic today. In fact, we will just talk about how to restore database that is in full recovery model. In general, databases backup in full recovery mode are taken in three different [...]

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 | 19 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 »

SQLAuthority News – Big Thinkers – Robert Cain

Posted in About Me, MVP, Pinal Dave, SQL, SQL Authority, SQL Query, SQL Server, SQL Tips and Tricks, SQLAuthority News, SQLAuthority Website Review, T SQL, Technology on July 12, 2009 | 2 Comments »

I am exceedingly impressed and inspired by an on-going series of Big Thinkers by Robert Cain – A SQL Server MVP and a genial, whole-souled person. On meeting Robert Cain earlier this year at SQL Server MVP Summit in Seattle I asked him a question – Where do you get so many innovative ideas to [...]

Read Full Post »

« Newer Posts - Older Posts »