Tags » SQL Server 2008 R2

How to recover sysadmin access to SQL Server 2005/2008 R2 when sa password is lost

 

  1. Open the SQL Server Configuration Manager tool
  2. Navigate to SQL Server Services and Stop the SQL Server Instance that needs a sa password reset …
  3. 161 more words
Microsoft

Sql Server : Active/Active, Active/Passive what do they mean? Terminology confusion.

Quick one today:

For many years, we’ve heard Active/Active & Active/Passive terms in the context of Failover Clustering; They have an implied understanding of what each means. 146 more words

DBA

Timing your SQL Server Maintenance Jobs

Maintenance in General is a necessity for SQL Server.  No different than changing the oil in your car or going to the Doctor for the annual exam.  425 more words

Powershell : Kick off or Spawn multiple PowerShell windows running scripts from one script

Quick one today:

To continue the trend of volume testing posts in the last few days, lets add another tip that allows us to simulate database traffic as if its coming from multiple webservers. 258 more words

DBA

Stopping your SQL Server Job

Maintenance in General is a necessity for SQL Server.  No different than changing the oil in your car or going to the Doctor for the annual exam.  434 more words

Powershell : Invoke one ps1 script from another ps1 script file

Quick one today:

In our lab, as part of load testing, we simulate large database traffic. There are many ways to accomplish this, but as a DBA we need the most simplistic way; That obviously means PowerShell or DOS or SSMS. 273 more words

DBA

Sql Server : Ignore locked records when updating or deleting or selecting (READPAST)

Interesting topic today:

On a busy production environment there are always several processing reading, updating, deleting & inserting records into different sections of the same table’s… 551 more words

DBA