SQL Server 2012- Sample Databases
I was not able to find the sample databases for SQL server 2012 as most of the sites I have
How to bring a database online which is in restoring mode ?
For Example, In log shipping the secondary or a stand-by database will be in restoring mode while applying the logs from
Configure SQL Server DBMAIL using T-SQL
Configuring dBMail involves 3 main steps Step 1: Creating Mail Profile Step2: Creating Mail Account Step3: Mapping Account to Profile. Below
How to list SQL Server Service Accounts using T-Sql?
There might be times for audit to list all the service accounts from all SQL Servers, In order get this
How to run a SQL Query on list of servers and save output to excel using power shell?
You will see how much is powershell is useful for DBA after using this script. Step 1: Create a text
What “Open Table “in SQL Server 2005 replaced with in SQL Server 2008? How to change this Edit top 200 to edit all?
Today, a customer asked me how to open a table in SQL Server 2008 to edit the rows in
HOW TO VERIFY IF A BACKUP FILE IS CORRUPTED?
There are times when we do a backup as a DBA, we come across problems when we restore the backup
