How to Use Dedicated Administrator Connection in SQL Server

How to Use Dedicated Administrator Connection in SQL Server In this post we will explain How to Use Dedicated Administrator Connection in SQL Server.Microsoft SQL Server provides a dedicated administrator connection (DAC). The DAC allows an administrator to access a running instance of SQL Server Database Engine to troubleshoot problems on the server—even when the server is

SQL Server Interview Questions & Answers 2

SQL Server Interview Questions & Answers 2 Question 6: How is a point in time recovery performed independent of a server down situation? Ans. It depends on which backup types are issued.  In this example let’s assume that full, differential and transaction log backups are issued. 1. Restore the most recent full backup with the NORECOVERY

SQL Server Interview Questions & Answers

SQL Server Interview Questions & Answers Question 1: How does the database recovery model impact database backups? Ans. Database recovery model is responsible for the retention of the transaction log entries.So the setting determines if transaction log backups need to be issued on a regular or not. SQL Server database recovery models: Simple – Committed transactions

How To Insert Values Into An Identity Column In SQL Server

How To Insert Values Into An Identity Column In SQL Server In this tutorial i will explain you How To Insert Values Into An Identity Column In SQL Server.Identity columns are mostly used as primary keys in tables.These columns automatically assign a value for each new row.But if you want to insert your own value into the

How To Disable Searching Online With Bing In Windows 8

How To Disable Searching Online With Bing In Windows 8 In this tutorial i will guide you through How To Disable Searching Online With Bing In Windows 8.In Windows 8, when users search for files in there system, Windows 8 also search for online information. The results are provided by Bing. If you want to keep

How to Encrypt and Password Protect Your Gmail Messages

In light of the currently en vogue privacy debate raging all around the world and given the flippant stance of many of our often used communication platforms with regards to securing its users’ privacy, it is becoming more and more evident that if the user wants privacy online, he’ll have to snatch it, for it

How To Create Dynamic Drop Down Menu In PHP

How To Create Dynamic Drop Down Menu In PHP In this tutorial i will teach you How To Create Dynamic Drop Down Menu In PHP.We are using MySQL as back-end. CSS: .bdy { margin: 0px auto; width:800px; font-family:Calibri; font-size:14px; padding-top:100px; } ul { font-family:Calibri; font-size:14px; margin: 0; padding: 0; list-style: none; } ul li { display: