Tags » SQL Server 2008 R2

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

Sql Server : Check trace flag status (DBCC TRACESTATUS)

Quick one today:

Trace Flags are a unique feature in Sql Server. They allow enabling certain features, that could change the way Sql Server behaves. Generally, these are helpful in troubleshooting any uncommon scenarios or identifying performance bottlenecks. 271 more words

DBA

Migration SharePoint 2010 to 2013 with RBS content database

1.     Live SharePoint 2010 environment with SQL 2008 R2

a.    Take back up from 2010 live server.

  1. i.      Open management studio on SQL server.
  2. ii.      Take back up of content database of live application.
  3. 1,914 more words
SharePoint