There are two different methods to retrieve the list of Primary Keys and Foreign Keys from the database.
SQL SERVER – Four Different Ways to Find Recovery Model for Database
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…
Read More
SQL SERVER – Restore Sequence and Understanding NORECOVERY and RECOVERY
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 – what is the difference between NORECOVERY and RECOVERY when restoring database and what is the restore sequence.
SQL SERVER – Backup Timeline and Understanding of Database Restore Process in Full Recovery Model
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. Let us learn about backup timeline.
SQL SERVER – BLOB – Pointer to Image, Image in Database, FILESTREAM Storage
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…
Read MoreSQLAuthority News – Big Thinkers – Robert Cain
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. Robert Cain and Pinal Dave On meeting Robert Cain earlier this year at SQL Server MVP Summit in Seattle I asked him a question…
Read MoreSQL SERVER – Standby Servers and Types of Standby Servers
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…
Read More